APPS.BOM_OPEN_INTERFACE_UTL dependencies on MTL_ITEM_REVISIONS_INTERFACE

Line 363: INSERT into mtl_item_revisions_interface

359:
360: stmt_num := 10;
361: /* Load rows from bill interface into revisions interface*/
362:
363: INSERT into mtl_item_revisions_interface
364: (ITEM_NUMBER,
365: ORGANIZATION_CODE,
366: REVISION,
367: EFFECTIVITY_DATE,

Line 1988: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

1984:
1985: /* Update Organization Code using Organization_id
1986: this also needed if Organization_id is given and code is not given*/
1987:
1988: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
1989: SET organization_code = (SELECT organization_code
1990: FROM MTL_PARAMETERS MP1
1991: WHERE mp1.organization_id = MIRI.organization_id)
1992: WHERE process_flag = 1

Line 2007: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

2003: stmt_num := 2;
2004: /* Update Organization_ids if organization code is given org id is null.
2005: Orgnaization_id information is needed in the next steps */
2006:
2007: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
2008: SET organization_id = (SELECT organization_id
2009: FROM MTL_PARAMETERS mp1
2010: WHERE mp1.organization_code = MIRI.organization_code)
2011: WHERE process_flag = 1

Line 2023: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

2019:
2020: stmt_num := 3;
2021: /* Update Assembly Item name */
2022:
2023: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
2024: SET item_number = (SELECT concatenated_segments
2025: FROM MTL_SYSTEM_ITEMS_KFV mvl1
2026: WHERE mvl1.inventory_item_id = MIRI.inventory_item_id
2027: and mvl1.organization_id = MIRI.organization_id)

Line 2044: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

2040:
2041: stmt_num := 5;
2042: /* Assign transaction ids */
2043:
2044: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
2045: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
2046: transaction_type = upper(transaction_type)
2047: WHERE transaction_id is null
2048: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)

Line 2094: 'MTL_ITEM_REVISIONS_INTERFACE',

2090: MIRI.transaction_id,
2091: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
2092: Null,
2093: null,
2094: 'MTL_ITEM_REVISIONS_INTERFACE',
2095: decode ( MIRI.Organization_code, null, msg_name1,msg_name2),
2096: decode ( MIRI.Organization_code, null, msg_text1,msg_text2),
2097: NVL(LAST_UPDATE_DATE, SYSDATE),
2098: NVL(LAST_UPDATED_BY, user_id),

Line 2106: from MTL_ITEM_REVISIONS_INTERFACE MIRI

2102: req_id,
2103: NVL(PROGRAM_APPLICATION_ID, prog_appid),
2104: NVL(PROGRAM_ID, prog_id),
2105: NVL(PROGRAM_UPDATE_DATE, sysdate)
2106: from MTL_ITEM_REVISIONS_INTERFACE MIRI
2107: where (organization_code is null or item_number is null)
2108: and transaction_id is not null
2109: and process_flag =1
2110: AND change_notice is null --added for bug 9673701

Line 2115: Update MTL_ITEM_REVISIONS_INTERFACE MIRI

2111: and (all_org = 1 OR (all_org = 2 AND organization_id = org_id))
2112: and MIRI.set_process_id = l_set_process_id;
2113:
2114:
2115: Update MTL_ITEM_REVISIONS_INTERFACE MIRI
2116: set process_flag = 3
2117: where (item_number is null or Organization_code is null)
2118: and transaction_id is not null
2119: and process_flag =1