DBA Data[Home] [Help]

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))