APPS.AHL_UTIL_PC_PKG dependencies on AHL_PC_HEADERS_B

Line 143: from ahl_pc_headers_b

139:
140: CURSOR get_pc_details
141: IS
142: select primary_flag, status, association_type_flag
143: from ahl_pc_headers_b
144: where pc_header_id = p_pc_header_id;
145:
146: CURSOR check_unassigned_parts
147: IS

Line 180: AHL_PC_HEADERS_B HEADER

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
184: -- SATHAPLI::Bug# 5576835, 17-Aug-2007

Line 216: AHL_PC_HEADERS_B HEADER

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
220: CSI.LAST_VLD_ORGANIZATION_ID = MTL.ORGANIZATION_ID AND

Line 247: AHL_PC_HEADERS_B HEADER

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
251: CSI.LAST_VLD_ORGANIZATION_ID = MTL.ORGANIZATION_ID AND