APPS.AHL_COMPLEX_MX_RWSC_PVT dependencies on CSI_ITEM_INSTANCES

Line 639: FROM MTL_SYSTEM_ITEMS_VL MTL, CSI_ITEM_INSTANCES CSI

635: SELECT 'U' FROM AHL_UNIT_CONFIG_HEADERS WHERE csi_item_instance_id = c_instance_id;
636:
637: CURSOR get_part_info(c_instance_id NUMBER) IS
638: SELECT MTL.inventory_item_id,MTL.concatenated_segments,CSI.instance_number,CSI.serial_number, CSI.quantity
639: FROM MTL_SYSTEM_ITEMS_VL MTL, CSI_ITEM_INSTANCES CSI
640: WHERE CSI.instance_id = c_instance_id
641: AND CSI.inventory_item_id = MTL.inventory_item_id
642: AND CSI.inv_master_organization_id = MTL.organization_id;
643:

Line 1018: FROM MTL_SYSTEM_ITEMS_VL MTL, CSI_ITEM_INSTANCES CSI

1014: SELECT (NVL(MAX(visit_ir_uc_id),0) + 1) from ahl_visit_ir_uc_details;
1015:
1016: CURSOR get_part_info(c_instance_id NUMBER) IS
1017: SELECT MTL.inventory_item_id,MTL.concatenated_segments,CSI.instance_number,CSI.serial_number, CSI.quantity
1018: FROM MTL_SYSTEM_ITEMS_VL MTL, CSI_ITEM_INSTANCES CSI
1019: WHERE CSI.instance_id = c_instance_id
1020: AND CSI.inventory_item_id = MTL.inventory_item_id
1021: AND CSI.inv_master_organization_id = MTL.organization_id;
1022:

Line 1170: FROM CSI_ITEM_INSTANCES

1166:
1167: -- cursor to validate the given instance id
1168: CURSOR validate_instance_csr (c_item_instance_id NUMBER) IS
1169: SELECT 'X'
1170: FROM CSI_ITEM_INSTANCES
1171: WHERE INSTANCE_ID = c_item_instance_id;
1172:
1173: -- cursor to validate the given visit id
1174: CURSOR validate_visit_csr (c_visit_id NUMBER) IS

Line 1545: FROM CSI_ITEM_INSTANCES CII , MTL_ITEM_LOCATIONS_KFV MIL, AHL_WORKORDERS WO

1541: SELECT CII.instance_id, CII.location_type_code,
1542: CII.instance_usage_code, CII.wip_job_id, CII.inv_locator_id,
1543: MIL.segment19, MIL.segment20, MIL.concatenated_segments inv_locator_name,
1544: MIL.subinventory_code, WO.workorder_name
1545: FROM CSI_ITEM_INSTANCES CII , MTL_ITEM_LOCATIONS_KFV MIL, AHL_WORKORDERS WO
1546: WHERE CII.instance_id = c_instance_id
1547: AND CII.inv_locator_id = MIL.inventory_location_id (+)
1548: AND CII.wip_job_id = WO.wip_entity_id(+);*/
1549:

Line 1555: FROM CSI_ITEM_INSTANCES CII , MTL_ITEM_LOCATIONS MIL, MTL_ITEM_LOCATIONS_KFV MIL_kfv, AHL_WORKORDERS WO

1551: SELECT CII.instance_id, CII.location_type_code,
1552: CII.instance_usage_code, CII.wip_job_id, CII.inv_locator_id,
1553: MIL.segment19, MIL.segment20, MIL_kfv.concatenated_segments inv_locator_name,
1554: MIL.subinventory_code, WO.workorder_name
1555: FROM CSI_ITEM_INSTANCES CII , MTL_ITEM_LOCATIONS MIL, MTL_ITEM_LOCATIONS_KFV MIL_kfv, AHL_WORKORDERS WO
1556: WHERE CII.instance_id = c_instance_id
1557: AND CII.inv_locator_id = MIL.inventory_location_id (+)
1558: AND MIL_kfv.INVENTORY_LOCATION_ID(+) = MIL.INVENTORY_LOCATION_ID
1559: AND MIL_kfv.ORGANIZATION_ID(+) = MIL.ORGANIZATION_ID

Line 1601: from CSI_ITEM_INSTANCES CII , ahl_osp_orders_b osph, ahl_osp_order_lines ospl

1597: CURSOR Get_OSP_Number(c_instance_id IN NUMBER) IS
1598: select OSP_ORDER_NUMBER from
1599: (
1600: select OSP_ORDER_NUMBER
1601: from CSI_ITEM_INSTANCES CII , ahl_osp_orders_b osph, ahl_osp_order_lines ospl
1602: WHERE CII.instance_id = c_instance_id
1603: and CII.inventory_item_id = ospl.inventory_item_id
1604: and CII.serial_number = ospl.serial_number
1605: and ospl.osp_order_id = osph.osp_order_id (+)

Line 1731: CSI_ITEM_INSTANCES CSI

1727: /* STHILAK bug #13641891 : commented the query and framed the modified query
1728: SELECT 1 quantity
1729: FROM AHL_PRD_DISPOSITIONS_B DISP,
1730: AHL_WORKORDERS WO,
1731: CSI_ITEM_INSTANCES CSI
1732: WHERE DISP.workorder_id = WO.workorder_id
1733: AND DISP.instance_id = CSI.instance_id
1734: AND CSI.wip_job_id = WO.wip_entity_id
1735: AND DISP.status_code NOT IN ('TERMINATED','COMPLETED')

Line 1746: CSI_ITEM_INSTANCES CSI

1742: -- For non serial controlled items
1743: SELECT DISP.quantity quantity
1744: FROM AHL_PRD_DISPOSITIONS_B DISP,
1745: AHL_WORKORDERS WO,
1746: CSI_ITEM_INSTANCES CSI
1747: WHERE DISP.workorder_id = WO.workorder_id
1748: AND DISP.inventory_item_id = CSI.inventory_item_id
1749: AND CSI.wip_job_id = WO.wip_entity_id
1750: AND DISP.status_code NOT IN ('TERMINATED','COMPLETED')

Line 1759: CSI_ITEM_INSTANCES CSI

1755: AND CSI.instance_id = c_instance_id */
1756:
1757: SELECT 1 quantity
1758: FROM AHL_PRD_DISPOSITIONS_B DISP,
1759: CSI_ITEM_INSTANCES CSI
1760: WHERE DISP.instance_id = CSI.instance_id
1761: AND CSI.instance_id = c_instance_id
1762: AND CSI.location_type_code = 'WIP'
1763: AND CSI.serial_number IS NOT NULL

Line 1773: CSI_ITEM_INSTANCES CSI

1769: UNION ALL
1770:
1771: SELECT DISP.quantity quantity
1772: FROM AHL_PRD_DISPOSITIONS_B DISP,
1773: CSI_ITEM_INSTANCES CSI
1774: WHERE DISP.inventory_item_id = CSI.inventory_item_id
1775: AND CSI.location_type_code = 'WIP'
1776: AND CSI.serial_number IS NULL
1777: AND CSI.instance_id = c_instance_id