APPS.AHL_MM_CANNIBALIZATION_PVT dependencies on AHL_VISITS_B

Line 61: FROM ahl_schedule_materials asm,ahl_workorders awo, ahl_visits_b vst

57: IS
58: SELECT asm.inventory_item_id, asm.visit_id, asm.visit_task_id,
59: asm.requested_quantity, awo.workorder_id, awo.wip_entity_id, awo.workorder_name
60: , vst.item_instance_id,asm.organization_id
61: FROM ahl_schedule_materials asm,ahl_workorders awo, ahl_visits_b vst
62: WHERE asm.status = 'ACTIVE'
63: AND asm.AOG_FLAG = 'Y'
64: AND asm.visit_task_id = awo.visit_task_id
65: AND awo.status_code in ('1','3','6')

Line 78: (SELECT item_instance_id FROM ahl_visits_b

74: AND cir.relationship_type_code = 'COMPONENT-OF'
75: AND cis.instance_id = c_instance_id
76: AND NVL(cir.active_end_date,sysdate) >= sysdate
77: START WITH cir.object_id IN
78: (SELECT item_instance_id FROM ahl_visits_b
79: WHERE visit_id = c_visit_id)
80: CONNECT BY cir.object_id = PRIOR cir.subject_id
81: UNION
82: SELECT cis.inventory_item_id

Line 661: SELECT START_DATE_TIME FROM AHL_VISITS_B WHERE VISIT_ID = C_VISIT_ID;

657:
658: -- Bug#14033321 ARUNJK
659: CURSOR C_VISIT_START_DATE(C_VISIT_ID NUMBER)
660: IS
661: SELECT START_DATE_TIME FROM AHL_VISITS_B WHERE VISIT_ID = C_VISIT_ID;
662: L_VISIT_DATE DATE;
663: -- Bug#14033321 ARUNJK End
664:
665: BEGIN