APPS.BOM_RTG_OI_UTIL dependencies on MTL_RTG_ITEM_REVS_INTERFACE

Line 299: INSERT into MTL_RTG_ITEM_REVS_INTERFACE

295: stmt_num := 11;
296: /* Load rows from routing interface into revisions interface*/
297: -- Bug 5970070. Adding 1 min to the effectivity date and implementation date
298: -- as the revision entered by user should be created after default revision.
299: INSERT into MTL_RTG_ITEM_REVS_INTERFACE
300: (INVENTORY_ITEM_NUMBER,
301: ORGANIZATION_CODE,
302: PROCESS_REVISION,
303: EFFECTIVITY_DATE,

Line 1832: MTL_RTG_ITEM_REVS_INTERFACE

1828: in the interface table
1829: REQUIRES
1830:
1831: MODIFIES
1832: MTL_RTG_ITEM_REVS_INTERFACE
1833: MTL_INTERFACE_ERRORS
1834: RETURNS
1835: 0 if successful
1836: SQLCODE if unsuccessful

Line 1862: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI

1858: stmt_num := 1;
1859: /* Update Organization Code using Organization_id
1860: this also needed if Organization_id is given and code is not given*/
1861:
1862: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI
1863: SET organization_code = (SELECT organization_code
1864: FROM MTL_PARAMETERS MP1
1865: WHERE mp1.organization_id = MRIRI.organization_id)
1866: WHERE process_flag = 1

Line 1884: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI

1880: stmt_num := 2;
1881: /* Update Organization_ids if organization code is given org id is null.
1882: Orgnaization_id information is needed in the next steps */
1883:
1884: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI
1885: SET organization_id = (SELECT organization_id
1886: FROM MTL_PARAMETERS mp1
1887: WHERE mp1.organization_code = MRIRI.organization_code)
1888: WHERE process_flag = 1

Line 1903: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI

1899:
1900: stmt_num := 3;
1901: /* Update Assembly Item name */
1902:
1903: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI
1904: SET inventory_item_number = (SELECT concatenated_segments
1905: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1906: WHERE mvl1.inventory_item_id = MRIRI.inventory_item_id
1907: and mvl1.organization_id = MRIRI.organization_id)

Line 1927: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI

1923:
1924: stmt_num := 4;
1925: /* Assign transaction ids */
1926:
1927: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI
1928: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1929: WHERE transaction_id is null
1930: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
1931: AND process_flag = 1

Line 1941: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI

1937: AND (all_org = 1
1938: OR
1939: (all_org = 2 AND organization_id = org_id));
1940:
1941: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI
1942: SET transaction_type = upper(transaction_type),
1943: process_revision = upper(process_revision) -- bug 3756121
1944: WHERE upper(transaction_type) in (G_Create, G_Update, G_Delete)
1945: AND process_flag = 1

Line 1992: 'MTL_RTG_ITEM_REVS_INTERFACE',

1988: MRIRI.transaction_id,
1989: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1990: Null,
1991: null,
1992: 'MTL_RTG_ITEM_REVS_INTERFACE',
1993: decode ( MRIRI.Organization_code, null, msg_name1,msg_name2),
1994: decode ( MRIRI.Organization_code, null, msg_text1,msg_text2),
1995: NVL(LAST_UPDATE_DATE, SYSDATE),
1996: NVL(LAST_UPDATED_BY, user_id),

Line 2004: from MTL_RTG_ITEM_REVS_INTERFACE MRIRI

2000: req_id,
2001: NVL(PROGRAM_APPLICATION_ID, prog_appid),
2002: NVL(PROGRAM_ID, prog_id),
2003: NVL(PROGRAM_UPDATE_DATE, sysdate)
2004: from MTL_RTG_ITEM_REVS_INTERFACE MRIRI
2005: where (organization_code is null or inventory_item_number is null)
2006: and transaction_id is not null
2007: and process_flag =1
2008: and

Line 2015: Update MTL_RTG_ITEM_REVS_INTERFACE MRIRI

2011: OR ( p_batch_id = batch_id )
2012: )
2013: and (all_org = 1 OR (all_org = 2 AND organization_id = org_id)) ;
2014:
2015: Update MTL_RTG_ITEM_REVS_INTERFACE MRIRI
2016: set process_flag = 3
2017: where (inventory_item_number is null or Organization_code is null)
2018: and transaction_id is not null
2019: and process_flag =1