DBA Data[Home] [Help]

APPS.AHL_MM_MTL_MGT_PVT dependencies on AHL_VISIT_TASKS_B

Line 1187: AHL_VISIT_TASKS_B TSK

1183: ASM.ATP_FLAG,
1184: WO.WORKORDER_NAME
1185: FROM AHL_SCHEDULE_MATERIALS ASM,
1186: AHL_WORKORDERS WO,
1187: AHL_VISIT_TASKS_B TSK
1188: WHERE (ASM.REQUESTED_QUANTITY - NVL(ASM.COMPLETED_QUANTITY,0) ) > 0
1189: AND ASM.STATUS = 'ACTIVE'
1190: AND ASM.VISIT_TASK_ID = WO.VISIT_TASK_ID
1191: AND WO.STATUS_CODE NOT IN (4, 5, 7, 12)

Line 5715: ahl_visit_tasks_b TSK

5711: l_pos_key,
5712: l_uc_header_id
5713: FROM ahl_schedule_materials ASM,
5714: ahl_visits_b VST,
5715: ahl_visit_tasks_b TSK
5716: WHERE ASM.visit_id = VST.visit_id
5717: AND ASM.visit_task_id = TSK.visit_task_id
5718: AND ASM.scheduled_material_id = p_demand_Record.Scheduled_Material_ID;
5719:

Line 5922: || ' AHL_VISIT_TASKS_B ATSK,'

5918: || ' MTL_SERIAL_NUMBERS MSN,'
5919: || ' (SELECT CSIII.serial_number,'
5920: || ' WO.WIP_ENTITY_ID'
5921: || ' FROM AHL_WORKORDERS WO,'
5922: || ' AHL_VISIT_TASKS_B ATSK,'
5923: || ' AHL_VISITS_B AVST,'
5924: || ' CSI_ITEM_INSTANCES CSIII'
5925: || ' WHERE WO.visit_task_id = ATSK.visit_task_id'
5926: || ' AND WO.STATUS_CODE NOT IN (7, 22, 17, 12, 18, 21, 4, 5)'

Line 5984: || ' FROM AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST'

5980: END IF;
5981:
5982: --Base criteria for Work Order Supply
5983: l_base_query := l_base_query || ' AND EXISTS (SELECT 1'
5984: || ' FROM AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST'
5985: || ' WHERE WO.visit_task_id = TSK.visit_task_id'
5986: || ' AND WO.STATUS_CODE NOT IN (7, 22, 17, 12, 18, 21, 4, 5)'
5987: || ' AND TSK.return_to_supply_flag = ''Y'' '
5988: || ' AND TSK.visit_id = VST.visit_id'