[Home] [Help]
67: FROM ahl_mc_relationships
68: WHERE relationship_id = p_uc_parent_rec.relationship_id;
69: CURSOR check_instance IS
70: SELECT 'x'
71: FROM csi_item_instances
72: WHERE instance_id = p_uc_parent_rec.instance_id;
73: CURSOR get_top_position(c_instance_id number) IS
74: SELECT B.relationship_id
75: FROM ahl_unit_config_headers A,
389: to_number(R.position_reference) relationship_id,
390: M.concatenated_segments||'-'||NVL(C.serial_number, C.instance_number) part_info,
391: 'N'
392: FROM csi_ii_relationships R,
393: csi_item_instances C,
394: mtl_system_items_kfv M
395: WHERE R.object_id = c_instance_id
396: AND R.subject_id = C.instance_id
397: AND C.inventory_item_id = M.inventory_item_id
622: l_part_info VARCHAR2(80);
623: CURSOR get_part_info(c_instance_id NUMBER) IS
624: SELECT M.concatenated_segments||'-'||NVL(C.serial_number, C.instance_number) part_info
625: FROM mtl_system_items_kfv M,
626: csi_item_instances C
627: WHERE C.instance_id = c_instance_id
628: AND C.inventory_item_id = M.inventory_item_id
629: AND C.inv_master_organization_id = M.organization_id;
630: BEGIN
1184: C.inventory_revision,
1185: C.quantity,
1186: C.unit_of_measure
1187: FROM ahl_unit_config_headers U,
1188: csi_item_instances C
1189: WHERE U.unit_config_header_id = p_uc_header_id
1190: AND trunc(nvl(U.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
1191: AND U.csi_item_instance_id = C.instance_id;
1192: l_uc_header_attr check_uc_header%ROWTYPE;
1236: I.quantity,
1237: I.unit_of_measure
1238: FROM csi_ii_relationships C,
1239: ahl_mc_relationships M,
1240: csi_item_instances I
1241: WHERE to_number(C.position_reference) = M.relationship_id (+)
1242: AND C.subject_id = I.instance_id
1243: AND C.object_id = c_instance_id
1244: AND C.relationship_type_code = 'COMPONENT-OF'
1958: C.inventory_revision,
1959: C.quantity,
1960: C.unit_of_measure
1961: FROM csi_ii_relationships R,
1962: csi_item_instances C
1963: WHERE R.object_id = p_instance_id
1964: AND R.object_id = C.instance_id
1965: AND R.relationship_type_code = 'COMPONENT-OF'
1966: AND trunc(nvl(R.active_start_date,SYSDATE)) <= trunc(SYSDATE)
2006: I.quantity,
2007: I.unit_of_measure
2008: FROM csi_ii_relationships C,
2009: ahl_mc_relationships M,
2010: csi_item_instances I
2011: WHERE to_number(C.position_reference) = M.relationship_id (+)
2012: AND C.subject_id = I.instance_id
2013: AND C.object_id = c_instance_id
2014: AND C.relationship_type_code = 'COMPONENT-OF'
2537: inv_master_organization_id,
2538: inventory_revision,
2539: quantity,
2540: unit_of_measure
2541: FROM csi_item_instances
2542: WHERE instance_id = c_instance_id;
2543:
2544: CURSOR get_ii_rel_dtls_csr(c_instance_id NUMBER) IS
2545: SELECT C.relationship_id,