DBA Data[Home] [Help]

APPS.BOMPPRCB dependencies on MTL_ITEM_REVISIONS

Line 1871: table_name := 'MTL_ITEM_REVISIONS';

1867: /*
1868: ** Process item revisions interface table
1869: */
1870: stmt_num := 60;
1871: table_name := 'MTL_ITEM_REVISIONS';
1872: commit_cnt := 0;
1873: loop
1874: insert into MTL_ITEM_REVISIONS
1875: (

Line 1874: insert into MTL_ITEM_REVISIONS

1870: stmt_num := 60;
1871: table_name := 'MTL_ITEM_REVISIONS';
1872: commit_cnt := 0;
1873: loop
1874: insert into MTL_ITEM_REVISIONS
1875: (
1876: INVENTORY_ITEM_ID,
1877: ORGANIZATION_ID,
1878: REVISION,

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

Line 1950: and exists (select NULL from mtl_item_revisions mir

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
1952: and mir.organization_id = mri.organization_id
1953: and mir.revision = mri.revision);
1954: commit;