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 1950: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

1946:
1947: /* Update Organization Code using Organization_id
1948: this also needed if Organization_id is given and code is not given*/
1949:
1950: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
1951: SET organization_code = (SELECT organization_code
1952: FROM MTL_PARAMETERS MP1
1953: WHERE mp1.organization_id = MIRI.organization_id)
1954: WHERE process_flag = 1

Line 1968: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

1964: stmt_num := 2;
1965: /* Update Organization_ids if organization code is given org id is null.
1966: Orgnaization_id information is needed in the next steps */
1967:
1968: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
1969: SET organization_id = (SELECT organization_id
1970: FROM MTL_PARAMETERS mp1
1971: WHERE mp1.organization_code = MIRI.organization_code)
1972: WHERE process_flag = 1

Line 1983: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

1979:
1980: stmt_num := 3;
1981: /* Update Assembly Item name */
1982:
1983: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
1984: SET item_number = (SELECT concatenated_segments
1985: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1986: WHERE mvl1.inventory_item_id = MIRI.inventory_item_id
1987: and mvl1.organization_id = MIRI.organization_id)

Line 2003: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

1999:
2000: stmt_num := 5;
2001: /* Assign transaction ids */
2002:
2003: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
2004: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
2005: transaction_type = upper(transaction_type)
2006: WHERE transaction_id is null
2007: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)

Line 2052: 'MTL_ITEM_REVISIONS_INTERFACE',

2048: MIRI.transaction_id,
2049: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
2050: Null,
2051: null,
2052: 'MTL_ITEM_REVISIONS_INTERFACE',
2053: decode ( MIRI.Organization_code, null, msg_name1,msg_name2),
2054: decode ( MIRI.Organization_code, null, msg_text1,msg_text2),
2055: NVL(LAST_UPDATE_DATE, SYSDATE),
2056: NVL(LAST_UPDATED_BY, user_id),

Line 2064: from MTL_ITEM_REVISIONS_INTERFACE MIRI

2060: req_id,
2061: NVL(PROGRAM_APPLICATION_ID, prog_appid),
2062: NVL(PROGRAM_ID, prog_id),
2063: NVL(PROGRAM_UPDATE_DATE, sysdate)
2064: from MTL_ITEM_REVISIONS_INTERFACE MIRI
2065: where (organization_code is null or item_number is null)
2066: and transaction_id is not null
2067: and process_flag =1
2068: and (all_org = 1 OR (all_org = 2 AND organization_id = org_id))

Line 2072: Update MTL_ITEM_REVISIONS_INTERFACE MIRI

2068: and (all_org = 1 OR (all_org = 2 AND organization_id = org_id))
2069: and MIRI.set_process_id = l_set_process_id;
2070:
2071:
2072: Update MTL_ITEM_REVISIONS_INTERFACE MIRI
2073: set process_flag = 3
2074: where (item_number is null or Organization_code is null)
2075: and transaction_id is not null
2076: and process_flag =1