[Home] [Help]
56: FROM ahl_mc_relationships
57: WHERE relationship_id = p_uc_parent_rec.relationship_id;
58: CURSOR check_instance IS
59: SELECT 'x'
60: FROM csi_item_instances
61: WHERE instance_id = p_uc_parent_rec.instance_id;
62: CURSOR get_top_position(c_instance_id number) IS
63: SELECT B.relationship_id
64: FROM ahl_unit_config_headers A,
375: to_number(R.position_reference) relationship_id,
376: M.concatenated_segments||'-'||NVL(C.serial_number, C.instance_number) part_info,
377: 'N'
378: FROM csi_ii_relationships R,
379: csi_item_instances C,
380: mtl_system_items_kfv M
381: WHERE R.object_id = c_instance_id
382: AND R.subject_id = C.instance_id
383: AND C.inventory_item_id = M.inventory_item_id
608: l_part_info VARCHAR2(80);
609: CURSOR get_part_info(c_instance_id NUMBER) IS
610: SELECT M.concatenated_segments||'-'||NVL(C.serial_number, C.instance_number) part_info
611: FROM mtl_system_items_kfv M,
612: csi_item_instances C
613: WHERE C.instance_id = c_instance_id
614: AND C.inventory_item_id = M.inventory_item_id
615: AND C.inv_master_organization_id = M.organization_id;
616: BEGIN
1142: C.inventory_revision,
1143: C.quantity,
1144: C.unit_of_measure
1145: FROM ahl_unit_config_headers U,
1146: csi_item_instances C
1147: WHERE U.unit_config_header_id = p_uc_header_id
1148: AND trunc(nvl(U.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
1149: AND U.csi_item_instance_id = C.instance_id;
1150: l_uc_header_attr check_uc_header%ROWTYPE;
1194: I.quantity,
1195: I.unit_of_measure
1196: FROM csi_ii_relationships C,
1197: ahl_mc_relationships M,
1198: csi_item_instances I
1199: WHERE to_number(C.position_reference) = M.relationship_id (+)
1200: AND C.subject_id = I.instance_id
1201: AND C.object_id = c_instance_id
1202: AND C.relationship_type_code = 'COMPONENT-OF'
1895: C.inventory_revision,
1896: C.quantity,
1897: C.unit_of_measure
1898: FROM csi_ii_relationships R,
1899: csi_item_instances C
1900: WHERE R.object_id = p_instance_id
1901: AND R.object_id = C.instance_id
1902: AND R.relationship_type_code = 'COMPONENT-OF'
1903: AND trunc(nvl(R.active_start_date,SYSDATE)) <= trunc(SYSDATE)
1943: I.quantity,
1944: I.unit_of_measure
1945: FROM csi_ii_relationships C,
1946: ahl_mc_relationships M,
1947: csi_item_instances I
1948: WHERE to_number(C.position_reference) = M.relationship_id (+)
1949: AND C.subject_id = I.instance_id
1950: AND C.object_id = c_instance_id
1951: AND C.relationship_type_code = 'COMPONENT-OF'
2474: inv_master_organization_id,
2475: inventory_revision,
2476: quantity,
2477: unit_of_measure
2478: FROM csi_item_instances
2479: WHERE instance_id = c_instance_id;
2480:
2481: CURSOR get_ii_rel_dtls_csr(c_instance_id NUMBER) IS
2482: SELECT C.relationship_id,