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 1830: MTL_RTG_ITEM_REVS_INTERFACE

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

Line 1860: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI

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

Line 1882: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI

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

Line 1901: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI

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

Line 1925: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI

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

Line 1939: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI

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

Line 1990: 'MTL_RTG_ITEM_REVS_INTERFACE',

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

Line 2002: from MTL_RTG_ITEM_REVS_INTERFACE MRIRI

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

Line 2013: Update MTL_RTG_ITEM_REVS_INTERFACE MRIRI

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