DBA Data[Home] [Help]

APPS.AHL_PRD_PRINT_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 2163: WIP_REQUIREMENT_OPERATIONS WRO, AHL_SCHEDULE_MATERIALS ASM,

2159: ASM.SCHEDULED_MATERIAL_ID,
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

Line 7947: WIP_REQUIREMENT_OPERATIONS WRO, AHL_SCHEDULE_MATERIALS ASM,

7943: ASM.SCHEDULED_MATERIAL_ID,
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