DBA Data[Home] [Help]

APPS.BOMPPRCB dependencies on BOM_INVENTORY_COMPONENTS

Line 100: table_name := 'BOM_INVENTORY_COMPONENTS';

96: ** Process inventory components interface table
97: */
98:
99: stmt_num := 20;
100: table_name := 'BOM_INVENTORY_COMPONENTS';
101: insert into BOM_INVENTORY_COMPONENTS
102: (
103: OPERATION_SEQ_NUM,
104: COMPONENT_ITEM_ID,

Line 101: insert into BOM_INVENTORY_COMPONENTS

97: */
98:
99: stmt_num := 20;
100: table_name := 'BOM_INVENTORY_COMPONENTS';
101: insert into BOM_INVENTORY_COMPONENTS
102: (
103: OPERATION_SEQ_NUM,
104: COMPONENT_ITEM_ID,
105: LAST_UPDATE_DATE,

Line 1563: table_name := 'BOM_INVENTORY_COMPONENTS';

1559: /*
1560: ** Process inventory components interface table
1561: */
1562: stmt_num := 20;
1563: table_name := 'BOM_INVENTORY_COMPONENTS';
1564: commit_cnt := 0;
1565: loop
1566: insert into BOM_INVENTORY_COMPONENTS
1567: (

Line 1566: insert into BOM_INVENTORY_COMPONENTS

1562: stmt_num := 20;
1563: table_name := 'BOM_INVENTORY_COMPONENTS';
1564: commit_cnt := 0;
1565: loop
1566: insert into BOM_INVENTORY_COMPONENTS
1567: (
1568: OPERATION_SEQ_NUM,
1569: COMPONENT_ITEM_ID,
1570: LAST_UPDATE_DATE,

Line 1688: from bom_inventory_components bic

1684: update bom_inventory_comps_interface bci
1685: set process_flag = 7
1686: where process_flag = 4
1687: and exists (select NULL
1688: from bom_inventory_components bic
1689: where bic.component_sequence_id = bci.component_sequence_id);
1690:
1691: commit;
1692: