DBA Data[Home] [Help]

APPS.AHL_UTIL_PC_PKG dependencies on MTL_ITEM_STATUS

Line 154: MTL_ITEM_STATUS STAT,

150: SELECT DISTINCT
151: MTL.INVENTORY_ITEM_ID
152: FROM
153: MTL_SYSTEM_ITEMS_KFV MTL,
154: MTL_ITEM_STATUS STAT,
155: AHL_PC_HEADERS_VL HEADER
156: WHERE
157: STAT.INVENTORY_ITEM_STATUS_CODE = MTL.INVENTORY_ITEM_STATUS_CODE AND
158: MTL.ITEM_TYPE = HEADER.PRODUCT_TYPE_CODE AND

Line 179: MTL_ITEM_STATUS STAT,

175: SELECT DISTINCT
176: MTL.INVENTORY_ITEM_ID
177: FROM
178: MTL_SYSTEM_ITEMS_KFV MTL,
179: MTL_ITEM_STATUS STAT,
180: AHL_PC_HEADERS_B HEADER
181: WHERE
182: STAT.INVENTORY_ITEM_STATUS_CODE = MTL.INVENTORY_ITEM_STATUS_CODE AND
183: MTL.ITEM_TYPE = HEADER.PRODUCT_TYPE_CODE AND