APPS.BOM_BULKLOAD_PVT_PKG dependencies on BOM_BILL_OF_MTLS_INTERFACE

Line 253: FROM BOM_BILL_OF_MTLS_INTERFACE BMI

249: UPDATE EGO_BULKLOAD_INTF EBI
250: SET EBI.PROCESS_STATUS =
251: (
252: SELECT BMI.PROCESS_FLAG
253: FROM BOM_BILL_OF_MTLS_INTERFACE BMI
254: WHERE BMI.TRANSACTION_ID = EBI.TRANSACTION_ID
255: )
256: WHERE EXISTS
257: (

Line 259: FROM BOM_BILL_OF_MTLS_INTERFACE BMI

255: )
256: WHERE EXISTS
257: (
258: SELECT 'X'
259: FROM BOM_BILL_OF_MTLS_INTERFACE BMI
260: WHERE BMI.TRANSACTION_ID = EBI.TRANSACTION_ID
261: )
262: AND EBI.RESULTFMT_USAGE_ID = p_resultfmt_usage_id;
263:

Line 715: BOM_BILL_OF_MTLS_INTERFACE BMI

711: COMMON_ORG_CODE,
712: ITEM_NUMBER,
713: IMPLEMENTATION_DATE
714: FROM
715: BOM_BILL_OF_MTLS_INTERFACE BMI
716: WHERE
717: PROCESS_FLAG = 1
718: AND
719: REQUEST_ID = C_REQUEST_ID

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

1024: -- end Added by hgelli for supporting import formats
1025:
1026: -- Process The Rows for BOM BO Header For Create and Update.
1027: l_dyn_sql_insert := '';
1028: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_BILL_OF_MTLS_INTERFACE (BATCH_ID';
1029: l_dyn_sql_insert := l_dyn_sql_insert || ' , SOURCE_SYSTEM_REFERENCE ';
1030: l_dyn_sql_insert := l_dyn_sql_insert || ' , SOURCE_SYSTEM_REFERENCE_DESC ';
1031: l_dyn_sql_insert := l_dyn_sql_insert || ' , REQUEST_ID, Transaction_Type ';
1032: l_dyn_sql_insert := l_dyn_sql_insert || ' , Transaction_Id, Process_Flag, Item_Number ';

Line 1199: INSERT INTO BOM_BILL_OF_MTLS_INTERFACE (

1195: l_Inv_Item_Id := Component_Item(l_Org_Id,L_PARENT_NAME);
1196: l_Bill_Seq_Id := Bill_Sequence(l_Inv_Item_Id,L_STRUCTURE_NAME,l_Org_Id);
1197:
1198: IF(l_Bill_Seq_Id IS NULL) THEN
1199: INSERT INTO BOM_BILL_OF_MTLS_INTERFACE (
1200: BATCH_ID,
1201: REQUEST_ID,
1202: TRANSACTION_TYPE,
1203: TRANSACTION_ID,

Line 1230: (select 'X' from bom_bill_of_mtls_interface

1226: l_assemblytype,
1227: L_PARENT_REVISION,
1228: L_SRCSYS_PARENT from dual
1229: where not exists
1230: (select 'X' from bom_bill_of_mtls_interface
1231: where
1232: batch_id = p_batch_id
1233: and request_id = g_request_id
1234: and process_flag = 1

Line 1242: INSERT INTO BOM_BILL_OF_MTLS_INTERFACE (

1238: and nvl(STRUCTURE_TYPE_NAME,'000') = nvl(L_STR_TYPE_NAME,'000')
1239: and nvl(EFFECTIVITY_CONTROL,'000') = nvl(l_eff_ctrl,'000') );
1240:
1241: ELSE
1242: INSERT INTO BOM_BILL_OF_MTLS_INTERFACE (
1243: BATCH_ID,
1244: REQUEST_ID,
1245: TRANSACTION_TYPE,
1246: TRANSACTION_ID,

Line 1273: (select 'X' from bom_bill_of_mtls_interface

1269: l_assemblytype,
1270: L_PARENT_REVISION,
1271: L_SRCSYS_PARENT from dual
1272: where not exists
1273: (select 'X' from bom_bill_of_mtls_interface
1274: where
1275: batch_id = p_batch_id
1276: and request_id = g_request_id
1277: and process_flag = 1

Line 1522: UPDATE BOM_BILL_OF_MTLS_INTERFACE SET assembly_type = 2

1518: FND_FILE.PUT_LINE( FND_FILE.LOG,'Before UPdate of AssemblyType');
1519: END IF;
1520:
1521: -- Updateing the assembly_type to 2 for BOM_header
1522: UPDATE BOM_BILL_OF_MTLS_INTERFACE SET assembly_type = 2
1523: WHERE assembly_type IS NULL
1524: AND batch_id = p_batch_id;
1525:
1526: IF l_debug = 'Y' THEN

Line 1538: INSERT INTO BOM_BILL_OF_MTLS_INTERFACE

1534: (
1535: G_REQUEST_ID
1536: )
1537: LOOP
1538: INSERT INTO BOM_BILL_OF_MTLS_INTERFACE
1539: (
1540: ASSEMBLY_ITEM_ID,
1541: ORGANIZATION_ID,
1542: ASSEMBLY_TYPE,

Line 1567: UPDATE BOM_BILL_OF_MTLS_INTERFACE

1563: G_REQUEST_ID);
1564: END LOOP;
1565: */
1566:
1567: UPDATE BOM_BILL_OF_MTLS_INTERFACE
1568: SET Transaction_Id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
1569: WHERE REQUEST_ID = G_REQUEST_ID AND PROCESS_FLAG = 1
1570: AND Transaction_Id IS NULL;
1571: