APPS.BOMPPRCB dependencies on BOM_BILL_OF_MATERIALS

Line 22: table_name := 'BOM_BILL_OF_MATERIALS';

18: /*
19: ** process bom interface table
20: */
21: stmt_num := 10;
22: table_name := 'BOM_BILL_OF_MATERIALS';
23: insert into BOM_BILL_OF_MATERIALS(
24: assembly_item_id,
25: organization_id,
26: alternate_bom_designator,

Line 23: insert into BOM_BILL_OF_MATERIALS(

19: ** process bom interface table
20: */
21: stmt_num := 10;
22: table_name := 'BOM_BILL_OF_MATERIALS';
23: insert into BOM_BILL_OF_MATERIALS(
24: assembly_item_id,
25: organization_id,
26: alternate_bom_designator,
27: last_update_date,

Line 1253: from bom_bill_of_materials

1249: loop
1250:
1251: select common_bill_sequence_id
1252: into x_from_sequence_id
1253: from bom_bill_of_materials
1254: where assembly_item_id = nextconfig.copy_item_id
1255: and organization_id = nextconfig.organization_id
1256: and alternate_bom_designator is NULL;
1257:

Line 1261: from bom_bill_of_materials

1257:
1258:
1259: select common_bill_sequence_id
1260: into x_to_sequence_id
1261: from bom_bill_of_materials
1262: where assembly_item_id = nextconfig.inventory_item_id
1263: and organization_id = nextconfig.organization_id
1264: and alternate_bom_designator is NULL;
1265:

Line 1267: X_from_entity_name => 'BOM_BILL_OF_MATERIALS',

1263: and organization_id = nextconfig.organization_id
1264: and alternate_bom_designator is NULL;
1265:
1266: fnd_attached_documents2_pkg.copy_attachments(
1267: X_from_entity_name => 'BOM_BILL_OF_MATERIALS',
1268: X_from_pk1_value => x_from_sequence_id,
1269: X_from_pk2_value => '',
1270: X_from_pk3_value => '',
1271: X_from_pk4_value => '',

Line 1273: X_to_entity_name => 'BOM_BILL_OF_MATERIALS',

1269: X_from_pk2_value => '',
1270: X_from_pk3_value => '',
1271: X_from_pk4_value => '',
1272: X_from_pk5_value => '',
1273: X_to_entity_name => 'BOM_BILL_OF_MATERIALS',
1274: X_to_pk1_value => x_to_sequence_id,
1275: X_to_pk2_value => '',
1276: X_to_pk3_value => '',
1277: X_to_pk4_value => '',

Line 1468: table_name := 'BOM_BILL_OF_MATERIALS';

1464: /*
1465: ** process bill interface table
1466: */
1467: stmt_num := 10;
1468: table_name := 'BOM_BILL_OF_MATERIALS';
1469: commit_cnt := 0;
1470: loop
1471: insert into BOM_BILL_OF_MATERIALS(
1472: assembly_item_id,

Line 1471: insert into BOM_BILL_OF_MATERIALS(

1467: stmt_num := 10;
1468: table_name := 'BOM_BILL_OF_MATERIALS';
1469: commit_cnt := 0;
1470: loop
1471: insert into BOM_BILL_OF_MATERIALS(
1472: assembly_item_id,
1473: organization_id,
1474: alternate_bom_designator,
1475: last_update_date,

Line 1554: from bom_bill_of_materials bom

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
1555: where bom.bill_sequence_id = bi.bill_sequence_id);
1556: commit;
1557:
1558: end loop;