DBA Data[Home] [Help]

APPS.BOMPPRCB dependencies on MTL_ITEM_REVISIONS_INTERFACE

Line 1941: from mtl_item_revisions_interface

1937: PROGRAM_ID,
1938: PROGRAM_UPDATE_DATE,
1939: REQUEST_ID,
1940: DESCRIPTION
1941: from mtl_item_revisions_interface
1942: where process_flag = 4
1943: and rownum < 500;
1944:
1945: EXIT when SQL%NOTFOUND;

Line 1947: update mtl_item_revisions_interface mri

1943: and rownum < 500;
1944:
1945: EXIT when SQL%NOTFOUND;
1946:
1947: update mtl_item_revisions_interface mri
1948: set process_flag = 7
1949: where process_flag = 4
1950: and exists (select NULL from mtl_item_revisions mir
1951: where mir.inventory_item_id = mri.inventory_item_id