DBA Data[Home] [Help]

APPS.AHL_PRD_PRINT_PVT dependencies on AHL_ITEM_GROUPS_B

Line 2164: AHL_ITEM_GROUPS_B IG, AHL_WORKORDERS WO, MTL_SYSTEM_ITEMS_KFV MSI

2160: (SELECT f.meaning from fnd_lookup_values_vl f
2161: WHERE f.lookup_type = 'ITEM_TYPE' and f.lookup_code = msi.item_type) item_type
2162: FROM --AHL_JOB_OPER_MATERIALS_V JM,
2163: WIP_REQUIREMENT_OPERATIONS WRO, AHL_SCHEDULE_MATERIALS ASM,
2164: AHL_ITEM_GROUPS_B IG, AHL_WORKORDERS WO, MTL_SYSTEM_ITEMS_KFV MSI
2165: WHERE WO.wip_entity_id = WRO.wip_entity_id
2166: AND WO.visit_task_id = ASM.visit_task_id
2167: AND ASM.operation_sequence = WRO.operation_seq_num
2168: AND ASM.inventory_item_id = WRO.inventory_item_id

Line 7948: AHL_ITEM_GROUPS_B IG, AHL_WORKORDERS WO, MTL_SYSTEM_ITEMS_KFV MSI,AHL_WORKORDER_OPERATIONS AWOP

7944: (SELECT f.meaning from fnd_lookup_values_vl f
7945: WHERE f.lookup_type = 'ITEM_TYPE' and f.lookup_code = msi.item_type) item_type
7946: FROM --AHL_JOB_OPER_MATERIALS_V JM,
7947: WIP_REQUIREMENT_OPERATIONS WRO, AHL_SCHEDULE_MATERIALS ASM,
7948: AHL_ITEM_GROUPS_B IG, AHL_WORKORDERS WO, MTL_SYSTEM_ITEMS_KFV MSI,AHL_WORKORDER_OPERATIONS AWOP
7949: WHERE WO.wip_entity_id = WRO.wip_entity_id
7950: AND WO.visit_task_id = ASM.visit_task_id
7951: AND ASM.operation_sequence = WRO.operation_seq_num
7952: AND ASM.inventory_item_id = WRO.inventory_item_id