APPS.BOMPPRCB dependencies on BOM_BILL_OF_MTLS_INTERFACE

Line 92: from BOM_BILL_OF_MTLS_INTERFACE b

88: req_id, /* request_id */
89: prg_appid, /* program_application_id */
90: prg_id, /* program_id */
91: SYSDATE /* program_update_date */
92: from BOM_BILL_OF_MTLS_INTERFACE b
93: where b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
94:
95: /*
96: ** Process inventory components interface table

Line 227: BOM_BILL_OF_MTLS_INTERFACE b1

223: b.PICK_COMPONENTS,
224: i.BOM_ITEM_TYPE
225: from MTL_SYSTEM_ITEMS i,
226: BOM_INVENTORY_COMPS_INTERFACE b,
227: BOM_BILL_OF_MTLS_INTERFACE b1
228: where b.bill_sequence_id = b1.bill_sequence_id
229: and b1.organization_id = i.organization_id
230: and b.component_item_id = i.inventory_item_id
231: and b1.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));

Line 305: BOM_BILL_OF_MTLS_INTERFACE b3

301: b1.ATTRIBUTE14,
302: b1.ATTRIBUTE15
303: from BOM_REF_DESGS_INTERFACE b1,
304: BOM_INVENTORY_COMPS_INTERFACE b2,
305: BOM_BILL_OF_MTLS_INTERFACE b3
306: where b1.component_sequence_id = b2.component_sequence_id
307: and b2.bill_sequence_id = b3.bill_sequence_id
308: and b3.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
309:

Line 381: BOM_BILL_OF_MTLS_INTERFACE b3

377: prg_id, /* program_id */
378: SYSDATE /* program_update_date */
379: from BOM_SUB_COMPS_INTERFACE b1,
380: BOM_INVENTORY_COMPS_INTERFACE b2,
381: BOM_BILL_OF_MTLS_INTERFACE b3
382: where b1.component_sequence_id = b2.component_sequence_id
383: and b2.bill_sequence_id = b3.bill_sequence_id
384: and b3.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
385:

Line 1329: BOM_BILL_OF_MTLS_INTERFACE b2

1325: delete from BOM_INVENTORY_COMPS_INTERFACE i
1326: where i.rowid in
1327: ( select b1.rowid
1328: from bom_inventory_comps_interface b1,
1329: BOM_BILL_OF_MTLS_INTERFACE b2
1330: where b2.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1331: and b1.bill_sequence_id = b2.bill_sequence_id);
1332:
1333: /*

Line 1334: ** Remove rows from BOM_BILL_OF_MTLS_INTERFACE

1330: where b2.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1331: and b1.bill_sequence_id = b2.bill_sequence_id);
1332:
1333: /*
1334: ** Remove rows from BOM_BILL_OF_MTLS_INTERFACE
1335: */
1336: stmt_num := 180;
1337: table_name := 'BOM_BILL_OF_MTLS_INTERFACE';
1338: delete from BOM_BILL_OF_MTLS_INTERFACE b

Line 1337: table_name := 'BOM_BILL_OF_MTLS_INTERFACE';

1333: /*
1334: ** Remove rows from BOM_BILL_OF_MTLS_INTERFACE
1335: */
1336: stmt_num := 180;
1337: table_name := 'BOM_BILL_OF_MTLS_INTERFACE';
1338: delete from BOM_BILL_OF_MTLS_INTERFACE b
1339: where b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1340:
1341: /*

Line 1338: delete from BOM_BILL_OF_MTLS_INTERFACE b

1334: ** Remove rows from BOM_BILL_OF_MTLS_INTERFACE
1335: */
1336: stmt_num := 180;
1337: table_name := 'BOM_BILL_OF_MTLS_INTERFACE';
1338: delete from BOM_BILL_OF_MTLS_INTERFACE b
1339: where b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1340:
1341: /*
1342: ** Remove rows from BOM_OP_RESOURCES_INTERFACE

Line 1386: BOM_BILL_OF_MTLS_INTERFACE b3,

1382: delete from BOM_REF_DESGS_INTERFACE b1
1383: where b1.rowid in ( select b.rowid
1384: from BOM_REF_DESGS_INTERFACE b,
1385: BOM_INVENTORY_COMPS_INTERFACE b2,
1386: BOM_BILL_OF_MTLS_INTERFACE b3,
1387: MTL_SYSTEM_ITEMS_INTERFACE m
1388: where b.component_sequence_id = b2.component_sequence_id
1389: and b2.bill_sequence_id = b3.bill_sequence_id
1390: and b3.demand_source_line = m.demand_source_line

Line 1403: BOM_BILL_OF_MTLS_INTERFACE b3,

1399: delete from BOM_SUB_COMPS_INTERFACE b1
1400: where b1.rowid in ( select b.rowid
1401: from BOM_SUB_COMPS_INTERFACE b,
1402: BOM_INVENTORY_COMPS_INTERFACE b2,
1403: BOM_BILL_OF_MTLS_INTERFACE b3,
1404: MTL_SYSTEM_ITEMS_INTERFACE m
1405: where b.component_sequence_id = b2.component_sequence_id
1406: and b2.bill_sequence_id = b3.bill_sequence_id
1407: and b3.demand_source_line = m.demand_source_line

Line 1544: from BOM_BILL_OF_MTLS_INTERFACE

1540: program_id,
1541: program_update_date,
1542: common_organization_id,
1543: next_explode_date
1544: from BOM_BILL_OF_MTLS_INTERFACE
1545: where process_flag = 4
1546: and rownum < 500;
1547:
1548: EXIT when SQL%NOTFOUND;

Line 1550: update bom_bill_of_mtls_interface bi

1546: and rownum < 500;
1547:
1548: EXIT when SQL%NOTFOUND;
1549:
1550: update bom_bill_of_mtls_interface bi
1551: set process_flag = 7
1552: where process_flag = 4
1553: and exists (select NULL
1554: from bom_bill_of_materials bom