DBA Data[Home] [Help]

APPS.BOMPPRCB dependencies on BOM_REFERENCE_DESIGNATORS

Line 238: table_name := 'BOM_REFERENCE_DESIGNATORS';

234: /*
235: ** Process reference designators interface table
236: */
237: stmt_num := 40;
238: table_name := 'BOM_REFERENCE_DESIGNATORS';
239: insert into BOM_REFERENCE_DESIGNATORS
240: (
241: COMPONENT_REFERENCE_DESIGNATOR,
242: LAST_UPDATE_DATE,

Line 239: insert into BOM_REFERENCE_DESIGNATORS

235: ** Process reference designators interface table
236: */
237: stmt_num := 40;
238: table_name := 'BOM_REFERENCE_DESIGNATORS';
239: insert into BOM_REFERENCE_DESIGNATORS
240: (
241: COMPONENT_REFERENCE_DESIGNATOR,
242: LAST_UPDATE_DATE,
243: LAST_UPDATED_BY,

Line 1699: table_name := 'BOM_REFERENCE_DESIGNATORS';

1695: /*
1696: ** Process reference designators interface table
1697: */
1698: stmt_num := 40;
1699: table_name := 'BOM_REFERENCE_DESIGNATORS';
1700: commit_cnt := 0;
1701: loop
1702: insert into BOM_REFERENCE_DESIGNATORS
1703: (

Line 1702: insert into BOM_REFERENCE_DESIGNATORS

1698: stmt_num := 40;
1699: table_name := 'BOM_REFERENCE_DESIGNATORS';
1700: commit_cnt := 0;
1701: loop
1702: insert into BOM_REFERENCE_DESIGNATORS
1703: (
1704: COMPONENT_REFERENCE_DESIGNATOR,
1705: LAST_UPDATE_DATE,
1706: LAST_UPDATED_BY,

Line 1775: and exists (select NULL from bom_reference_designators brd

1771:
1772: update bom_ref_desgs_interface bdi
1773: set process_flag = 7
1774: where process_flag = 4
1775: and exists (select NULL from bom_reference_designators brd
1776: where brd.component_sequence_id = bdi.component_sequence_id
1777: and brd.component_reference_designator = bdi.component_reference_designator
1778: and nvl(brd.acd_type,999) =nvl(bdi.acd_type,999));
1779: commit;