APPS.EGO_BOM_BULKLOAD_PVT_PKG dependencies on BOM_BILL_OF_MTLS_INTERFACE

Line 174: FROM BOM_BILL_OF_MTLS_INTERFACE BMI

170: UPDATE EGO_BULKLOAD_INTF EBI
171: SET EBI.PROCESS_STATUS =
172: (
173: SELECT BMI.PROCESS_FLAG
174: FROM BOM_BILL_OF_MTLS_INTERFACE BMI
175: WHERE BMI.TRANSACTION_ID = EBI.TRANSACTION_ID
176: )
177: WHERE EXISTS
178: (

Line 180: FROM BOM_BILL_OF_MTLS_INTERFACE BMI

176: )
177: WHERE EXISTS
178: (
179: SELECT 'X'
180: FROM BOM_BILL_OF_MTLS_INTERFACE BMI
181: WHERE BMI.TRANSACTION_ID = EBI.TRANSACTION_ID
182: )
183: AND EBI.RESULTFMT_USAGE_ID = p_resultfmt_usage_id;
184:

Line 379: BOM_BILL_OF_MTLS_INTERFACE

375: COMMON_ORG_CODE,
376: ITEM_NUMBER,
377: IMPLEMENTATION_DATE
378: FROM
379: BOM_BILL_OF_MTLS_INTERFACE
380: WHERE
381: PROCESS_FLAG = 1
382: AND
383: REQUEST_ID = C_REQUEST_ID;

Line 471: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_BILL_OF_MTLS_INTERFACE (REQUEST_ID, Transaction_Type ';

467:
468:
469: -- Process The Rows for BOM BO Header For Create and Update.
470: l_dyn_sql_insert := '';
471: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_BILL_OF_MTLS_INTERFACE (REQUEST_ID, Transaction_Type ';
472: l_dyn_sql_insert := l_dyn_sql_insert || ', Transaction_Id, Process_Flag, Item_Number ';
473: l_dyn_sql_insert := l_dyn_sql_insert || ', Organization_Code, Alternate_Bom_Designator) ';
474:
475: l_dyn_sql_select := '';

Line 604: INSERT INTO BOM_BILL_OF_MTLS_INTERFACE (

600: l_Org_Id := ORGANIZATION(L_ORGANIZATION_CODE);
601: l_Inv_Item_Id := Component_Item(l_Org_Id,L_PARENT_NAME);
602: l_Bill_Seq_Id := Bill_Sequence(l_Inv_Item_Id,L_STRUCTURE_NAME,l_Org_Id);
603: IF(l_Bill_Seq_Id IS NULL) THEN
604: INSERT INTO BOM_BILL_OF_MTLS_INTERFACE (
605: REQUEST_ID,
606: TRANSACTION_TYPE,
607: TRANSACTION_ID,
608: PROCESS_FLAG,

Line 729: UPDATE BOM_BILL_OF_MTLS_INTERFACE set assembly_type = 2

725: FND_FILE.PUT_LINE( FND_FILE.LOG,'Before UPdate of AssemblyType');
726: END IF;
727:
728: -- Updateing the assembly_type to 2 for BOM_header
729: UPDATE BOM_BILL_OF_MTLS_INTERFACE set assembly_type = 2
730: where assembly_type is null;
731:
732: IF l_debug = 'Y' THEN
733: FND_FILE.PUT_LINE( FND_FILE.LOG,'After UPdate of AssemblyType');

Line 743: INSERT INTO BOM_BILL_OF_MTLS_INTERFACE

739: (
740: G_REQUEST_ID
741: )
742: LOOP
743: INSERT INTO BOM_BILL_OF_MTLS_INTERFACE
744: (
745: ASSEMBLY_ITEM_ID,
746: ORGANIZATION_ID,
747: ASSEMBLY_TYPE,

Line 772: UPDATE BOM_BILL_OF_MTLS_INTERFACE

768: G_REQUEST_ID);
769: END LOOP;
770:
771:
772: UPDATE BOM_BILL_OF_MTLS_INTERFACE
773: SET Transaction_Id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
774: WHERE REQUEST_ID = G_REQUEST_ID AND PROCESS_FLAG = 1
775: and Transaction_Id is null;
776: