-
编辑 删除
onhand with serial number
as the user request, need the onhand with serial number, also need the last po informatin, so i used the following query:select distinct msib.segment1, ...
-
编辑 删除
no data in wsh_locations
our customer run pick release report, when he got the output file in pdf, but can't open the file. as we checked, there is no data return in the report: select wdd.source_line_id ...
-
编辑 删除
多阶bom查询
select LPad('.', level*2-2, ' ') || level 层次, msib1.segment1 &n...
-
编辑 删除
cancel por
PO_REQ_LINES_SV.UPDATE_REQS_LINES_STATUS(P_POR_HEADER_ID, &nbs...
-
编辑 删除
item attribute update to null
item attribute update to nullthe IOI update feature. See notes: 1076412.6 and 2121870.6 Updating Item Attributes to NULL The method to update these columns to NULL is to use the following values:1. f...
-
编辑 删除
query
begindbms_application_info.set_client_info('84');end;select * from hr_operating_units where name='OU_ID';select * from org_organization_definitions where operating_unit='XX';
-
编辑 删除
MRP release
MRP:Requisition Load Group OptionIndicates the group by option used when loading requisitions using thePlanner Workbench form. Available values are listed below:Create one purchase requisition for al...
-
编辑 删除
Fulfillment Sets
so line with field fulfillment sets. BackgroundOrder Management provides the functionality required to recognize fulfillment of anorder or order line. One of the key features of fulfillment is ...
-
编辑 删除
WIP Neg Comp Issue
if someone added the component to the BOM with -ve quantity as requirement it gets issued as -ve component issue. You can also manually add to the material requirements (job's material requireme...
-
编辑 删除
Lot Attributes DFF
we’re trying to setup the Lot control attributes in INV for some item, but we’re facing some strange system behavior. while doing receiving in telnet. It seems the system does not accept the...
-
编辑 删除
Turorial_JTF_GRID
主要步骤 31创建数据源 3A.Headers中 3B.TAB页Database标签页 4C.TAB页Display标签页 5D. TAB页Alignments and Formatting标签页--对齐方式和显示格式 6E.TAB页Custom Format Masks and Mappings 6F.TAB页Query标签...
-
编辑 删除
frm-18108 form builder
open PL/SQL help/support information/registry: check form. FORMS60_PATH = D:\Dev6i\TOOLS\OPEN60\PLSQLLIB then put all the resource to that pathremember :)
-
编辑 删除
learn mark
Oracle Applications Documentation Resources, Release 12 [ID 394692.1]
-
编辑 删除
This value is already in use for this value set
Valueset Error: This value is already in use for this value set [ID 787827.1] CauseA translated value is missing from the FND_FLEX_VALUES_TL table. SolutionEnsure there is a corresponding r...
-
编辑 删除
global purchase
global purchaseA----> B-------->C-----VendorA: manufacturing companyB: finanical companyC: Taiwai purchange comanyA need material to production , but A company don't have the authority f...
-
编辑 删除
mark so pick
mark : in the pick rule, if to subinventory is non asset inventory, the pick from subinventory should also be non assent. (ussually set this rule as **** expense ) if to subinventory is a...
-
编辑 删除
websit for ebs learn
http://www.oracleappshub.com/category/ebs-suite/ a. Meta. link NO. 462383.1—— SQL Queries and Multi-Org Architecture in Release 12b. Meta. link NO. 732826.1 ——Discoverer 10g (10.1....
-
编辑 删除
Legal Entities(1)
In order to allow use of the system by multiple business units, accommodating differing requirements for functional currencies, accounting structures and security, whilst at the same time ensuring a ...
-
编辑 删除
Label Printing Strategies
EXECUTIVE SUMMARYOracle WMS and MSCA have robust label printing capabilities built into theproduct to easily produce compliance labels at any point in the business processand with any data. Oracle wor...
-
编辑 删除
Oracle Workflow Administrator's Guide
http://www.stanford.edu/dept/itss/docs/oracle/10gR2/workflow.102/b15852/T319398T319402.htm
