APPS.BOMPPRCB dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 314: table_name := 'BOM_SUBSTITUTE_COMPONENTS';

310: /*
311: ** Process substitute components interface table
312: */
313: stmt_num := 50;
314: table_name := 'BOM_SUBSTITUTE_COMPONENTS';
315: insert into BOM_SUBSTITUTE_COMPONENTS
316: (
317: SUBSTITUTE_COMPONENT_ID,
318: LAST_UPDATE_DATE,

Line 315: insert into BOM_SUBSTITUTE_COMPONENTS

311: ** Process substitute components interface table
312: */
313: stmt_num := 50;
314: table_name := 'BOM_SUBSTITUTE_COMPONENTS';
315: insert into BOM_SUBSTITUTE_COMPONENTS
316: (
317: SUBSTITUTE_COMPONENT_ID,
318: LAST_UPDATE_DATE,
319: LAST_UPDATED_BY,

Line 1786: table_name := 'BOM_SUBSTITUTE_COMPONENTS';

1782: /*
1783: ** Process substitute components interface table
1784: */
1785: stmt_num := 50;
1786: table_name := 'BOM_SUBSTITUTE_COMPONENTS';
1787: commit_cnt := 0;
1788: loop
1789: insert into BOM_SUBSTITUTE_COMPONENTS
1790: (

Line 1789: insert into BOM_SUBSTITUTE_COMPONENTS

1785: stmt_num := 50;
1786: table_name := 'BOM_SUBSTITUTE_COMPONENTS';
1787: commit_cnt := 0;
1788: loop
1789: insert into BOM_SUBSTITUTE_COMPONENTS
1790: (
1791: SUBSTITUTE_COMPONENT_ID,
1792: LAST_UPDATE_DATE,
1793: LAST_UPDATED_BY,

Line 1860: and exists (select NULL from bom_substitute_components bsc

1856:
1857: update bom_sub_comps_interface bsi
1858: set process_flag = 7
1859: where process_flag = 4
1860: and exists (select NULL from bom_substitute_components bsc
1861: where bsc.component_sequence_id = bsi.component_sequence_id
1862: and bsc.substitute_component_id = bsi.substitute_component_id
1863: and nvl(bsc.acd_type,999) = nvl(bsi.acd_type,999));
1864: commit;