[Home] [Help]
148: WO.visit_id = p_visit_id
149: AND WO.visit_id = VTS.visit_id
150: AND WO.visit_task_id = VTS.visit_task_id
151: AND VTS.instance_id IN(
152: SELECT instance_id FROM csi_item_instances WHERE INSTANCE_ID = p_root_instance_id
153: UNION
154: SELECT
155: SUBJECT_ID INSTANCE_ID
156: FROM CSI_II_RELATIONSHIPS
585: WO.visit_id = p_visit_id
586: AND WO.visit_id = VTS.visit_id
587: AND WO.visit_task_id = VTS.visit_task_id
588: AND VTS.instance_id IN(
589: SELECT instance_id FROM csi_item_instances WHERE INSTANCE_ID = p_root_instance_id
590: UNION
591: SELECT
592: SUBJECT_ID INSTANCE_ID
593: FROM CSI_II_RELATIONSHIPS
920: WO.visit_id = p_visit_id
921: AND WO.visit_id = VTS.visit_id
922: AND WO.visit_task_id = VTS.visit_task_id
923: AND VTS.instance_id IN(
924: SELECT instance_id FROM csi_item_instances WHERE INSTANCE_ID = p_item_instance_id
925: UNION
926: SELECT
927: SUBJECT_ID INSTANCE_ID
928: FROM CSI_II_RELATIONSHIPS
959: WO.visit_id = p_visit_id
960: AND WO.visit_id = VTS.visit_id
961: AND WO.visit_task_id = VTS.visit_task_id
962: AND VTS.instance_id IN(
963: SELECT instance_id FROM csi_item_instances WHERE INSTANCE_ID = p_item_instance_id
964: UNION
965: SELECT
966: SUBJECT_ID INSTANCE_ID
967: FROM CSI_II_RELATIONSHIPS
1076: WO.visit_id = p_visit_id
1077: AND WO.visit_id = VTS.visit_id
1078: AND WO.visit_task_id = VTS.visit_task_id
1079: AND VTS.instance_id IN(
1080: SELECT instance_id FROM csi_item_instances WHERE INSTANCE_ID = p_item_instance_id
1081: UNION
1082: SELECT
1083: SUBJECT_ID INSTANCE_ID
1084: FROM CSI_II_RELATIONSHIPS
1139: WO.visit_id = p_visit_id
1140: AND WO.visit_id = VTS.visit_id
1141: AND WO.visit_task_id = VTS.visit_task_id
1142: AND VTS.instance_id IN(
1143: SELECT instance_id FROM csi_item_instances WHERE INSTANCE_ID = p_item_instance_id
1144: UNION
1145: SELECT
1146: SUBJECT_ID INSTANCE_ID
1147: FROM CSI_II_RELATIONSHIPS
1219: WO.visit_id = p_visit_id
1220: AND WO.visit_id = VTS.visit_id
1221: AND WO.visit_task_id = VTS.visit_task_id
1222: AND VTS.instance_id IN(
1223: SELECT instance_id FROM csi_item_instances WHERE INSTANCE_ID = p_item_instance_id
1224: UNION
1225: SELECT
1226: SUBJECT_ID INSTANCE_ID
1227: FROM CSI_II_RELATIONSHIPS
1619:
1620: CURSOR get_part_info(c_instance_id NUMBER) IS
1621: SELECT M.inventory_item_id,M.concatenated_segments,C.serial_number,
1622: C.QUANTITY
1623: FROM mtl_system_items_kfv M, csi_item_instances C
1624: WHERE C.instance_id = c_instance_id
1625: AND C.inventory_item_id = M.inventory_item_id
1626: AND C.inv_master_organization_id = M.organization_id;
1627:
1641: reln.position_ref_code,
1642: csi.INVENTORY_ITEM_ID,
1643: csi.QUANTITY Inst_qty,
1644: csi.UNIT_OF_MEASURE Inst_uom_code
1645: FROM ahl_mc_relationships reln, ahl_item_associations_b iasso, csi_item_instances csi
1646: WHERE csi.INSTANCE_ID = c_instance_id
1647: AND reln.relationship_id = c_mc_relationship_id
1648: AND iasso.item_group_id = reln.item_group_id
1649: AND iasso.inventory_item_id = CSI.INVENTORY_ITEM_ID
1921:
1922: CURSOR get_part_info(c_instance_id NUMBER) IS
1923: SELECT M.inventory_item_id,M.concatenated_segments,C.serial_number,
1924: DECODE(M.serial_number_control_code,'1','N','Y') is_serial_cntld,C.quantity
1925: FROM mtl_system_items_kfv M, csi_item_instances C
1926: WHERE C.instance_id = c_instance_id
1927: AND C.inventory_item_id = M.inventory_item_id
1928: AND C.inv_master_organization_id = M.organization_id;
1929:
1927: AND C.inventory_item_id = M.inventory_item_id
1928: AND C.inv_master_organization_id = M.organization_id;
1929:
1930: CURSOR instance_tree_csr(p_root_instance_id NUMBER) IS
1931: SELECT instance_id,to_number(NULL) parent_instance_id FROM csi_item_instances WHERE INSTANCE_ID = p_root_instance_id
1932: UNION
1933: SELECT
1934: SUBJECT_ID INSTANCE_ID,
1935: OBJECT_ID PARENT_INSTANCE_ID