[Home] [Help]
885: ,nvl(instance.external_reference,sr.external_reference) Tag_Number
886: , nvl2(sr.customer_product_id, instance.inventory_revision, sr.inv_item_revision) Item_Revision
887: , nvl2(sr.customer_product_id, (select instance.inventory_revision
888: from mtl_system_items_b_kfv product_a,
889: csi_item_instances instance
890: where product_a.inventory_item_id = instance.inventory_item_id
891: and product_a.organization_id = sr.inv_organization_id
892: and sr.cp_component_id=instance.instance_id), sr.inv_component_version) Component_Revision
893: , nvl2(sr.customer_product_id, (select instance.inventory_revision
891: and product_a.organization_id = sr.inv_organization_id
892: and sr.cp_component_id=instance.instance_id), sr.inv_component_version) Component_Revision
893: , nvl2(sr.customer_product_id, (select instance.inventory_revision
894: from mtl_system_items_b_kfv product_b,
895: csi_item_instances instance
896: where product_b.inventory_item_id = instance.inventory_item_id
897: and product_b.organization_id = sr.inv_organization_id
898: and sr.cp_subcomponent_id = instance.instance_id ), sr.inv_subcomponent_version) Sub_Component_Revision
899: ,sr.incident_attribute_1 Attribute1
948: ,sr.inv_subcomponent_id
949: ,sr.incident_location_type
950: FROM cs_incidents_b_sec sr
951: ,cs_incidents_all_tl tl
952: ,csi_item_instances instance
953: WHERE sr.incident_id = tl.incident_id
954: AND tl.language = userenv('lang')
955: AND sr.incident_id = P_Incident_Id
956: AND sr.inventory_item_id = instance.inventory_item_id (+)
1316: --:Sub_Component
1317: CURSOR Get_Component_Instance (v_cp_component_id NUMBER, v_inv_organization_id NUMBER) IS
1318: SELECT product_b.concatenated_segments
1319: FROM mtl_system_items_b_kfv product_b,
1320: csi_item_instances instance
1321: WHERE product_b.inventory_item_id = instance.inventory_item_id
1322: AND product_b.organization_id = v_inv_organization_id
1323: AND instance.instance_id = v_cp_component_id;
1324: