DBA Data[Home] [Help]

APPS.AHL_UTIL_PC_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 153: MTL_SYSTEM_ITEMS_KFV MTL,

149: /*
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

Line 178: MTL_SYSTEM_ITEMS_KFV MTL,

174: */
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

Line 215: MTL_SYSTEM_ITEMS_KFV MTL,

211: UNIT.UNIT_CONFIG_HEADER_ID
212: FROM
213: AHL_UNIT_CONFIG_HEADERS UNIT,
214: CSI_ITEM_INSTANCES CSI,
215: MTL_SYSTEM_ITEMS_KFV MTL,
216: AHL_PC_HEADERS_B HEADER
217: WHERE
218: UNIT.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID AND
219: CSI.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID AND

Line 246: MTL_SYSTEM_ITEMS_KFV MTL,

242: UNIT.UNIT_CONFIG_HEADER_ID
243: FROM
244: AHL_UNIT_CONFIG_HEADERS UNIT,
245: CSI_ITEM_INSTANCES CSI,
246: MTL_SYSTEM_ITEMS_KFV MTL,
247: AHL_PC_HEADERS_B HEADER
248: WHERE
249: UNIT.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID AND
250: CSI.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID AND