eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOMPVALR dependencies on MTL_RTG_ITEM_REVS_INTERFACE

Line 1859: from mtl_rtg_item_revs_interface

1855: IS
1856: cursor c0 is
1857: select inventory_item_id AII, organization_id OI,
1858: process_revision PR, transaction_id TI
1859: from mtl_rtg_item_revs_interface
1860: where process_flag = 2
1861: and rownum < 500;
1862:
1863: cursor c1 is

Line 1865: from mtl_rtg_item_revs_interface

1861: and rownum < 500;
1862:
1863: cursor c1 is
1864: select inventory_item_id AII, organization_id OI
1865: from mtl_rtg_item_revs_interface
1866: where process_flag = 99
1867: and rownum < 500
1868: group by organization_id, inventory_item_id;
1869:

Line 1872: from mtl_rtg_item_revs_interface

1868: group by organization_id, inventory_item_id;
1869:
1870: cursor c2 is
1871: select 'x'
1872: from mtl_rtg_item_revs_interface
1873: where process_flag = 99
1874: group by organization_id, inventory_item_id;
1875:
1876: ret_code NUMBER;

Line 1904: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',

1900: prog_id => prog_id,
1901: req_id => req_id,
1902: trans_id => c0rec.TI,
1903: error_text => err_text,
1904: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',
1905: msg_name => 'BOM_NULL_RTG_REV',
1906: err_text => err_text);
1907: update mtl_rtg_item_revs_interface set
1908: process_flag = 3

Line 1907: update mtl_rtg_item_revs_interface set

1903: error_text => err_text,
1904: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',
1905: msg_name => 'BOM_NULL_RTG_REV',
1906: err_text => err_text);
1907: update mtl_rtg_item_revs_interface set
1908: process_flag = 3
1909: where transaction_id = c0rec.TI;
1910:
1911: if (ret_code <> 0) then

Line 1936: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',

1932: prog_id => prog_id,
1933: req_id => req_id,
1934: trans_id => c0rec.TI,
1935: error_text => err_text,
1936: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',
1937: msg_name => 'BOM_INVALID_ORG_ID',
1938: err_text => err_text);
1939: update mtl_rtg_item_revs_interface set
1940: process_flag = 3

Line 1939: update mtl_rtg_item_revs_interface set

1935: error_text => err_text,
1936: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',
1937: msg_name => 'BOM_INVALID_ORG_ID',
1938: err_text => err_text);
1939: update mtl_rtg_item_revs_interface set
1940: process_flag = 3
1941: where transaction_id = c0rec.TI;
1942: if (ret_code <> 0) then
1943: return(ret_code);

Line 1964: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',

1960: prog_id => prog_id,
1961: req_id => req_id,
1962: trans_id => c0rec.TI,
1963: error_text => err_text,
1964: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',
1965: msg_name => 'BOM_INV_ITEM_INVALID',
1966: err_text => err_text);
1967: update mtl_rtg_item_revs_interface set
1968: process_flag = 3

Line 1967: update mtl_rtg_item_revs_interface set

1963: error_text => err_text,
1964: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',
1965: msg_name => 'BOM_INV_ITEM_INVALID',
1966: err_text => err_text);
1967: update mtl_rtg_item_revs_interface set
1968: process_flag = 3
1969: where transaction_id = c0rec.TI;
1970:
1971: if (ret_code <> 0) then

Line 2005: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',

2001: prog_id => prog_id,
2002: req_id => req_id,
2003: trans_id => c0rec.TI,
2004: error_text => err_text,
2005: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',
2006: msg_name => 'BOM_RTG_DOES_NOT_EXIST',
2007: err_text => err_text);
2008: update mtl_rtg_item_revs_interface set
2009: process_flag = 3

Line 2008: update mtl_rtg_item_revs_interface set

2004: error_text => err_text,
2005: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',
2006: msg_name => 'BOM_RTG_DOES_NOT_EXIST',
2007: err_text => err_text);
2008: update mtl_rtg_item_revs_interface set
2009: process_flag = 3
2010: where transaction_id = c0rec.TI;
2011:
2012: if (ret_code <> 0) then

Line 2019: update mtl_rtg_item_revs_interface set

2015: goto continue_loop;
2016: end if;
2017: end if;
2018:
2019: update mtl_rtg_item_revs_interface set
2020: process_flag = 99
2021: where transaction_id = c0rec.TI;
2022:
2023: <>

Line 2112: from mtl_rtg_item_revs_interface

2108: IS
2109: cursor c1 is
2110: select process_revision PR, effectivity_date ED,
2111: transaction_id TI
2112: from mtl_rtg_item_revs_interface
2113: where organization_id = org_id
2114: and inventory_item_id = assy_id
2115: and process_flag = 99;
2116: ret_code NUMBER;

Line 2129: from mtl_rtg_item_revs_interface a

2125: ** check for ascending order and identical revs
2126: */
2127: select count(*)
2128: into err_cnt
2129: from mtl_rtg_item_revs_interface a
2130: where transaction_id <> c1rec.TI
2131: and inventory_item_id = assy_id
2132: and organization_id = org_id
2133: and process_flag = 4

Line 2167: update mtl_rtg_item_revs_interface set

2163: goto write_error;
2164: end if;
2165:
2166: stmt_num := 3;
2167: update mtl_rtg_item_revs_interface set
2168: process_flag = 4
2169: where transaction_id = c1rec.TI;
2170: goto continue_loop;
2171:

Line 2182: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',

2178: prog_id => prog_id,
2179: req_id => req_id,
2180: trans_id => c1rec.TI,
2181: error_text => err_text,
2182: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',
2183: msg_name => 'BOM_REV_INVALID',
2184: err_text => err_text);
2185: update mtl_rtg_item_revs_interface set
2186: process_flag = 3

Line 2185: update mtl_rtg_item_revs_interface set

2181: error_text => err_text,
2182: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',
2183: msg_name => 'BOM_REV_INVALID',
2184: err_text => err_text);
2185: update mtl_rtg_item_revs_interface set
2186: process_flag = 3
2187: where transaction_id = c1rec.TI;
2188: <>
2189: null;