APPS.AHL_CMP_UTIL_PKG dependencies on AHL_VISITS_B

Line 43: FROM AHL_VISITS_B VST, AHL_VISIT_TYPES_B VTB

39:
40: -- cursor to get the component visit id for a given org
41: CURSOR get_comp_visit_csr (c_org_id NUMBER) IS
42: SELECT VST.visit_id
43: FROM AHL_VISITS_B VST, AHL_VISIT_TYPES_B VTB
44: WHERE VST.organization_id = c_org_id
45: AND VST.visit_type_code = VTB.visit_type_code
46: AND NVL(VTB.component_visit_flag, 'N') = 'Y'
47: AND VTB.status_code = 'COMPLETE';

Line 54: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,

50: -- cursor to get the repair batch name in the given visit, whose locator holds the given instance
51: CURSOR get_rpr_batch_csr (c_visit_id NUMBER,
52: c_instance_id NUMBER) IS
53: SELECT TSK.repair_batch_name
54: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,
55: CSI_ITEM_INSTANCES CSI, MTL_ITEM_LOCATIONS MTL
56: WHERE TSK.visit_id = c_visit_id
57: AND VST.visit_id = TSK.visit_id
58: AND (

Line 244: FROM AHL_VISITS_B AVB,

240: CURSOR get_comp_visit_csr (c_org_id NUMBER) IS
241: SELECT AVB.visit_id,
242: AVB.status_code
243:
244: FROM AHL_VISITS_B AVB,
245: AHL_VISIT_TYPES_B AVTB
246:
247: WHERE AVB.organization_id = c_org_id
248: AND AVB.visit_type_code = AVTB.visit_type_code

Line 266: FROM AHL_VISITS_B

262: close_date_time,
263: comp_planning_loc_id,
264: comp_inrepair_loc_id,
265: firmed_flag
266: FROM AHL_VISITS_B
267: WHERE visit_id = c_visit_id;
268:
269: --
270: l_api_name CONSTANT VARCHAR2(30) := 'Get_Comp_Visit_For_Org';

Line 384: FROM AHL_VISITS_B AVB,

380:
381: -- cursor to check whether the given Visit is a Component Visit
382: CURSOR chk_comp_visit_csr (c_visit_id NUMBER) IS
383: SELECT 'Y'
384: FROM AHL_VISITS_B AVB,
385: AHL_VISIT_TYPES_B AVTB
386: WHERE AVB.visit_id = c_visit_id
387: AND AVB.visit_type_code = AVTB.visit_type_code
388: AND AVTB.status_code = 'COMPLETE'

Line 518: AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,

514: -- Retrieves Planning Locator Quantity
515: SELECT NVL(SUM(CII.quantity),0)
516: INTO l_planning_qty
517: FROM CSI_ITEM_INSTANCES CII,
518: AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,
519: MTL_ITEM_LOCATIONS MTL
520: WHERE TSK.repair_batch_name = p_repair_batch
521: AND VST.visit_id = TSK.visit_id
522: AND MTL.physical_location_id = VST.comp_planning_loc_id

Line 538: AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,

534: -- Retrieves In-Repair Locator Quantity
535: SELECT NVL(SUM(CII.quantity),0)
536: INTO l_inrepair_qty
537: FROM CSI_ITEM_INSTANCES CII,
538: AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,
539: MTL_ITEM_LOCATIONS MTL
540: WHERE TSK.repair_batch_name = p_repair_batch
541: AND VST.visit_id = TSK.visit_id
542: AND MTL.physical_location_id = VST.comp_inrepair_loc_id

Line 760: ahl_workorders wo,ahl_visits_b visit,WIP_DISCRETE_JOBS WDJ

756: p_start_date DATE,
757: p_end_date DATE,
758: p_comp_visit_flag VARCHAR2) IS
759: SELECT SUM(task.quantity) plan_qty, task.instance_id FROM ahl_visit_tasks_b task,
760: ahl_workorders wo,ahl_visits_b visit,WIP_DISCRETE_JOBS WDJ
761: WHERE
762: wo.VISIT_TASK_ID = task.VISIT_TASK_ID
763: AND WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
764: AND WO.STATUS_CODE IN (1,3,6,17,19,20)

Line 871: ahl_workorders wo,ahl_visits_b visit,WIP_DISCRETE_JOBS WDJ

867: p_start_date DATE,
868: p_end_date DATE,
869: p_comp_visit_flag VARCHAR2) IS
870: SELECT SUM(task.quantity) sched_qty FROM ahl_visit_tasks_b task,
871: ahl_workorders wo,ahl_visits_b visit,WIP_DISCRETE_JOBS WDJ
872: WHERE
873: wo.VISIT_TASK_ID = task.VISIT_TASK_ID
874: AND WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
875: AND WO.STATUS_CODE IN (1,3,6,17,19,20)