APPS.BOMPPRCB dependencies on MTL_RTG_ITEM_REVS_INTERFACE

Line 2351: from MTL_RTG_ITEM_REVS_INTERFACE

2347: REQUEST_ID,
2348: PROGRAM_APPLICATION_ID,
2349: PROGRAM_ID,
2350: PROGRAM_UPDATE_DATE
2351: from MTL_RTG_ITEM_REVS_INTERFACE
2352: where process_flag = 4
2353: and rownum < 500;
2354:
2355: EXIT when SQL%NOTFOUND;

Line 2357: update mtl_rtg_item_revs_interface mri

2353: and rownum < 500;
2354:
2355: EXIT when SQL%NOTFOUND;
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