APPS.BOM_BOM_ISETUP_IMP dependencies on BOM_BILL_OF_MATERIALS_TEMP

Line 24: -- 23-DEC-05 MYERRAMS Added ImplementationDate to bom_bill_of_materials_temp table

20: -- 18-NOV-02 M V M P Tilak Initial Creation
21: -- 26-MAR-03 M V M P Tilak Modified for XSU utility work-around
22: -- 10-FEB-04 Anupam Jain Bug# 3349138, avoid redundant migration of
23: -- Item Revisions data.
24: -- 23-DEC-05 MYERRAMS Added ImplementationDate to bom_bill_of_materials_temp table
25: -- Added BasisType to bom_inventory_components_temp table
26: -- Bug: 4873339
27: -- 05-MAY-05 MYERRAMS Modified the ImplementationDate conversion.
28: -- Bug: 5141752

Line 111: FROM bom_bill_of_materials_temp tmp,

107: tmp.ImplementationDate , --myerrams, bug: 4873339. New Column added for R12.
108: NULL DeleteGroupName ,
109: NULL DGDescription ,
110: NULL RowIdentifier
111: FROM bom_bill_of_materials_temp tmp,
112: mtl_system_items_kfv item,
113: mtl_parameters org
114: WHERE org.organization_code = tmp.OrganizationCode
115: AND item.concatenated_segments = tmp.AssemblyItemName

Line 154: FROM bom_bill_of_materials_temp tmp,

150: tmp.ImplementationDate , --myerrams, bug: 4873339. New Column added for R12.
151: NULL DeleteGroupName ,
152: NULL DGDescription ,
153: NULL RowIdentifier
154: FROM bom_bill_of_materials_temp tmp,
155: mtl_system_items_kfv item,
156: mtl_parameters org
157: WHERE org.organization_code = tmp.OrganizationCode
158: AND item.concatenated_segments = tmp.AssemblyItemName

Line 771: insCtx := DBMS_XMLSave.newContext('BOM_BILL_OF_MATERIALS_TEMP');

767: BEGIN
768: -- Bom Header Record
769: IF (P_bom_header_XML IS NOT NULL) THEN
770: -- get the context handle
771: insCtx := DBMS_XMLSave.newContext('BOM_BILL_OF_MATERIALS_TEMP');
772: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
773: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
774: DBMS_XMLSave.setRowTag(insCtx , 'BillOfMaterialsVO');
775: -- this inserts the document