APPS.EGO_GTIN_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 1774: FROM MTL_SYSTEM_ITEMS_INTERFACE

1770: weight_uom_code,
1771: volume_uom_code,
1772: shelf_life_days,
1773: trade_item_descriptor
1774: FROM MTL_SYSTEM_ITEMS_INTERFACE
1775: WHERE (SET_PROCESS_ID = p_set_id OR SET_PROCESS_ID = p_set_id + 1000000000000)
1776: AND TRANSACTION_TYPE IN ('UPDATE', 'AUTO_CHILD')
1777: AND PROCESS_FLAG = 4;
1778:

Line 2097: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

2093: x_msg_data => l_msg_text);
2094:
2095: write_debug_log('After calling EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES from IOI ... return_status, error = '||l_return_status||' , '||l_msg_text);
2096: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2097: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
2098: SET process_flag = 3
2099: WHERE rowid = i.rowid;
2100:
2101: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 2111: ,'MTL_SYSTEM_ITEMS_INTERFACE'

2107: ,P_Request_Id
2108: ,i.transaction_id
2109: ,l_msg_text
2110: ,'UCCnet'
2111: ,'MTL_SYSTEM_ITEMS_INTERFACE'
2112: ,'INV_IOI_ERR'
2113: ,err_text);
2114:
2115: END IF; -- if not success