APPS.EGO_ITEM_OPEN_INTERFACE_PVT dependencies on MTL_PARAMETERS

Line 220: FROM mtl_parameters param

216: AND intf.transaction_type = 'CREATE'
217: AND intf.request_id = p_request_id
218: AND intf.process_flag = 7
219: AND NOT EXISTS (SELECT NULL
220: FROM mtl_parameters param
221: WHERE param.organization_id = intf.organization_id
222: AND param.starting_revision = intf.revision);
223:
224: CURSOR c_get_effective_revision(cp_inventory_item_id NUMBER

Line 742: FROM MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp

738: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
739: FND_FILE.put_line(FND_FILE.LOG, 'TRANSACTION TYPE ORGANIZATION CODE ITEM NUMBER');
740: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
741: FOR i IN (SELECT msii.TRANSACTION_TYPE, msii.ITEM_NUMBER, NVL(msii.ORGANIZATION_CODE, mp.ORGANIZATION_CODE) AS ORGANIZATION_CODE
742: FROM MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp
743: WHERE msii.SET_PROCESS_ID = p_batch_id
744: AND msii.REQUEST_ID = l_request_id
745: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID
746: AND mp.MASTER_ORGANIZATION_ID = mp.ORGANIZATION_ID