APPS.AHL_CMP_UTIL_PKG dependencies on CSI_ITEM_INSTANCES

Line 55: CSI_ITEM_INSTANCES CSI, MTL_ITEM_LOCATIONS MTL

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 (
59: MTL.physical_location_id = VST.comp_planning_loc_id

Line 152: FROM CSI_ITEM_INSTANCES

148:
149: -- cursor to validate that the instance location is INVENTORY
150: CURSOR validate_inst_loc_csr (c_instance_id NUMBER) IS
151: SELECT 'X'
152: FROM CSI_ITEM_INSTANCES
153: WHERE instance_id = c_instance_id
154: AND location_type_code = 'INVENTORY'
155: AND TRUNC(NVL(active_start_date, SYSDATE)) <= TRUNC(SYSDATE)
156: AND TRUNC(NVL(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE);

Line 517: FROM CSI_ITEM_INSTANCES CII,

513: -- pdoki modified for Bug 14068468
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

Line 537: FROM CSI_ITEM_INSTANCES CII,

533: -- pdoki modified for Bug 14068468
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

Line 596: FROM CSI_ITEM_INSTANCES CII,

592:
593: CURSOR Get_Ins_Qty(C_VISIT_TASK_ID NUMBER)
594: IS
595: SELECT CII.QUANTITY
596: FROM CSI_ITEM_INSTANCES CII,
597: AHL_WORKORDERS WO
598: where WO.visit_task_id = c_visit_task_id
599: AND CII.location_type_code = 'WIP'
600: and CII.wip_job_id = WO.wip_entity_id