APPS.AHL_UTIL_PC_PKG dependencies on MTL_PARAMETERS
Line 188: MTL.ORGANIZATION_ID IN (SELECT DISTINCT MASTER_ORGANIZATION_ID FROM MTL_PARAMETERS) AND
184: -- SATHAPLI::Bug# 5576835, 17-Aug-2007
185: /*
186: MTL.ORGANIZATION_ID = FND_PROFILE.VALUE('ORG_ID') AND
187: */ 188: MTL.ORGANIZATION_ID IN (SELECT DISTINCT MASTER_ORGANIZATION_ID FROM MTL_PARAMETERS) AND 189: HEADER.PC_HEADER_ID = p_pc_header_id AND
190: MTL.INVENTORY_ITEM_STATUS_CODE NOT IN ('Obsolete','Inactive') AND
191: TRUNC(SYSDATE) BETWEEN NVL(TRUNC(MTL.START_DATE_ACTIVE), TRUNC(SYSDATE)) AND
192: NVL(TRUNC(MTL.END_DATE_ACTIVE), TRUNC(SYSDATE))