APPS.AHL_UA_UNIT_SCHEDULES_PVT dependencies on CSI_ITEM_INSTANCES

Line 149: csi_item_instances c

145: u.name uc_name
146: from
147: ahl_unit_config_headers u,
148: mtl_system_items_kfv i,
149: csi_item_instances c
150: where
151: --priyan Bug# 5303188
152: --ahl_util_uc_pkg.get_uc_status_code (u.unit_config_header_id) IN ('COMPLETE', 'INCOMPLETE') and
153: -- fix for bug number 5528416

Line 791: CSI_ITEM_INSTANCES C,

787: I.CONCATENATED_SEGMENTS ITEM_NUMBER,
788: C.SERIAL_NUMBER
789: FROM
790: AHL_UNIT_CONFIG_HEADERS U,
791: CSI_ITEM_INSTANCES C,
792: MTL_SYSTEM_ITEMS_KFV I
793: WHERE
794: U.CSI_ITEM_INSTANCE_ID = C.INSTANCE_ID
795: AND C.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID