APPS.EGO_ITEM_OPEN_INTERFACE_PVT dependencies on MTL_PARAMETERS

Line 273: FROM mtl_parameters param

269: AND intf.process_flag = 7
270: AND intf.revision_id is not null
271: /* Bug 7675166 added this validation as revision_id is passed as null in case new revision needs to be created with existing items for item effective AG from excel*/
272: AND NOT EXISTS (SELECT NULL
273: FROM mtl_parameters param
274: WHERE param.organization_id = intf.organization_id
275: AND param.starting_revision = intf.revision);
276:
277: CURSOR c_get_effective_revision(cp_inventory_item_id NUMBER

Line 810: FROM MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp

806: -- results only to master organization.
807: -- sreharih. Thu Mar 24 12:45:06 PDT 2011
808: --
809: FOR i IN (SELECT msii.TRANSACTION_TYPE, msii.ITEM_NUMBER, NVL(msii.ORGANIZATION_CODE, mp.ORGANIZATION_CODE) AS ORGANIZATION_CODE
810: FROM MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp
811: WHERE msii.SET_PROCESS_ID = p_batch_id
812: AND msii.REQUEST_ID = l_request_id
813: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID
814: --AND mp.MASTER_ORGANIZATION_ID = mp.ORGANIZATION_ID Bug 11901255