APPS.BOMPPRCB dependencies on MTL_RTG_ITEM_REVISIONS

Line 529: table_name := 'MTL_RTG_ITEM_REVISIONS';

525: /*
526: ** Process routing revision interface table
527: */
528: stmt_num := 70;
529: table_name := 'MTL_RTG_ITEM_REVISIONS';
530: insert into MTL_RTG_ITEM_REVISIONS
531: (
532: INVENTORY_ITEM_ID,
533: ORGANIZATION_ID,

Line 530: insert into MTL_RTG_ITEM_REVISIONS

526: ** Process routing revision interface table
527: */
528: stmt_num := 70;
529: table_name := 'MTL_RTG_ITEM_REVISIONS';
530: insert into MTL_RTG_ITEM_REVISIONS
531: (
532: INVENTORY_ITEM_ID,
533: ORGANIZATION_ID,
534: PROCESS_REVISION,

Line 2286: table_name := 'MTL_RTG_ITEM_REVISIONS';

2282: /*
2283: ** process routing revision interface table
2284: */
2285: stmt_num := 50;
2286: table_name := 'MTL_RTG_ITEM_REVISIONS';
2287: loop
2288: insert into MTL_RTG_ITEM_REVISIONS(
2289: INVENTORY_ITEM_ID,
2290: ORGANIZATION_ID,

Line 2288: insert into MTL_RTG_ITEM_REVISIONS(

2284: */
2285: stmt_num := 50;
2286: table_name := 'MTL_RTG_ITEM_REVISIONS';
2287: loop
2288: insert into MTL_RTG_ITEM_REVISIONS(
2289: INVENTORY_ITEM_ID,
2290: ORGANIZATION_ID,
2291: PROCESS_REVISION,
2292: LAST_UPDATE_DATE,

Line 2360: and exists (select NULL from mtl_rtg_item_revisions mrr

2356:
2357: update mtl_rtg_item_revs_interface mri
2358: set process_flag = 7
2359: where process_flag = 4
2360: and exists (select NULL from mtl_rtg_item_revisions mrr
2361: where mrr.inventory_item_id = mri.inventory_item_id
2362: and mrr.organization_id = mri.organization_id
2363: and mrr.process_revision = mri.process_revision);
2364: commit;