APPS.BOM_BULKLOAD_PVT_PKG dependencies on BOM_BILL_OF_MTLS_INTERFACE

Line 265: FROM BOM_BILL_OF_MTLS_INTERFACE BMI

261: UPDATE EGO_BULKLOAD_INTF EBI
262: SET EBI.PROCESS_STATUS =
263: (
264: SELECT BMI.PROCESS_FLAG
265: FROM BOM_BILL_OF_MTLS_INTERFACE BMI
266: WHERE BMI.TRANSACTION_ID = EBI.TRANSACTION_ID
267: )
268: WHERE EXISTS
269: (

Line 271: FROM BOM_BILL_OF_MTLS_INTERFACE BMI

267: )
268: WHERE EXISTS
269: (
270: SELECT 'X'
271: FROM BOM_BILL_OF_MTLS_INTERFACE BMI
272: WHERE BMI.TRANSACTION_ID = EBI.TRANSACTION_ID
273: )
274: AND EBI.RESULTFMT_USAGE_ID = p_resultfmt_usage_id;
275:

Line 729: BOM_BILL_OF_MTLS_INTERFACE BMI

725: COMMON_ORG_CODE,
726: ITEM_NUMBER,
727: IMPLEMENTATION_DATE
728: FROM
729: BOM_BILL_OF_MTLS_INTERFACE BMI
730: WHERE
731: PROCESS_FLAG = 1
732: AND
733: REQUEST_ID = C_REQUEST_ID

Line 1067: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_BILL_OF_MTLS_INTERFACE (BATCH_ID';

1063: -- end Added by hgelli for supporting import formats
1064:
1065: -- Process The Rows for BOM BO Header For Create and Update.
1066: l_dyn_sql_insert := '';
1067: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_BILL_OF_MTLS_INTERFACE (BATCH_ID';
1068: l_dyn_sql_insert := l_dyn_sql_insert || ' , SOURCE_SYSTEM_REFERENCE ';
1069: l_dyn_sql_insert := l_dyn_sql_insert || ' , SOURCE_SYSTEM_REFERENCE_DESC ';
1070: l_dyn_sql_insert := l_dyn_sql_insert || ' , REQUEST_ID, Transaction_Type ';
1071: l_dyn_sql_insert := l_dyn_sql_insert || ' , Transaction_Id, Process_Flag, Item_Number ';

Line 1238: INSERT INTO BOM_BILL_OF_MTLS_INTERFACE (

1234: l_Inv_Item_Id := Component_Item(l_Org_Id,L_PARENT_NAME);
1235: l_Bill_Seq_Id := Bill_Sequence(l_Inv_Item_Id,L_STRUCTURE_NAME,l_Org_Id);
1236:
1237: IF(l_Bill_Seq_Id IS NULL) THEN
1238: INSERT INTO BOM_BILL_OF_MTLS_INTERFACE (
1239: BATCH_ID,
1240: REQUEST_ID,
1241: TRANSACTION_TYPE,
1242: TRANSACTION_ID,

Line 1269: (select 'X' from bom_bill_of_mtls_interface

1265: l_assemblytype,
1266: L_PARENT_REVISION,
1267: L_SRCSYS_PARENT from dual
1268: where not exists
1269: (select 'X' from bom_bill_of_mtls_interface
1270: where
1271: batch_id = p_batch_id
1272: and request_id = g_request_id
1273: and process_flag = 1

Line 1281: INSERT INTO BOM_BILL_OF_MTLS_INTERFACE (

1277: and nvl(STRUCTURE_TYPE_NAME,'000') = nvl(L_STR_TYPE_NAME,'000')
1278: and nvl(EFFECTIVITY_CONTROL,'000') = nvl(l_eff_ctrl,'000') );
1279:
1280: ELSE
1281: INSERT INTO BOM_BILL_OF_MTLS_INTERFACE (
1282: BATCH_ID,
1283: REQUEST_ID,
1284: TRANSACTION_TYPE,
1285: TRANSACTION_ID,

Line 1312: (select 'X' from bom_bill_of_mtls_interface

1308: l_assemblytype,
1309: L_PARENT_REVISION,
1310: L_SRCSYS_PARENT from dual
1311: where not exists
1312: (select 'X' from bom_bill_of_mtls_interface
1313: where
1314: batch_id = p_batch_id
1315: and request_id = g_request_id
1316: and process_flag = 1

Line 1579: UPDATE BOM_BILL_OF_MTLS_INTERFACE SET assembly_type = 2

1575: FND_FILE.PUT_LINE( FND_FILE.LOG,'Before UPdate of AssemblyType');
1576: END IF;
1577:
1578: -- Updateing the assembly_type to 2 for BOM_header
1579: UPDATE BOM_BILL_OF_MTLS_INTERFACE SET assembly_type = 2
1580: WHERE assembly_type IS NULL
1581: AND batch_id = p_batch_id;
1582:
1583: IF l_debug = 'Y' THEN

Line 1595: INSERT INTO BOM_BILL_OF_MTLS_INTERFACE

1591: (
1592: G_REQUEST_ID
1593: )
1594: LOOP
1595: INSERT INTO BOM_BILL_OF_MTLS_INTERFACE
1596: (
1597: ASSEMBLY_ITEM_ID,
1598: ORGANIZATION_ID,
1599: ASSEMBLY_TYPE,

Line 1624: UPDATE BOM_BILL_OF_MTLS_INTERFACE

1620: G_REQUEST_ID);
1621: END LOOP;
1622: */
1623:
1624: UPDATE BOM_BILL_OF_MTLS_INTERFACE
1625: SET Transaction_Id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
1626: WHERE REQUEST_ID = G_REQUEST_ID AND PROCESS_FLAG = 1
1627: AND Transaction_Id IS NULL;
1628: