[Home] [Help]
956: ,nvl(instance.external_reference,sr.external_reference) Tag_Number
957: , nvl2(sr.customer_product_id, instance.inventory_revision, sr.inv_item_revision) Item_Revision
958: , nvl2(sr.customer_product_id, (select instance.inventory_revision
959: from mtl_system_items_b_kfv product_a,
960: csi_item_instances instance
961: where product_a.inventory_item_id = instance.inventory_item_id
962: and product_a.organization_id = sr.inv_organization_id
963: and sr.cp_component_id=instance.instance_id), sr.inv_component_version) Component_Revision
964: , nvl2(sr.customer_product_id, (select instance.inventory_revision
962: and product_a.organization_id = sr.inv_organization_id
963: and sr.cp_component_id=instance.instance_id), sr.inv_component_version) Component_Revision
964: , nvl2(sr.customer_product_id, (select instance.inventory_revision
965: from mtl_system_items_b_kfv product_b,
966: csi_item_instances instance
967: where product_b.inventory_item_id = instance.inventory_item_id
968: and product_b.organization_id = sr.inv_organization_id
969: and sr.cp_subcomponent_id = instance.instance_id ), sr.inv_subcomponent_version) Sub_Component_Revision
970: ,sr.incident_attribute_1 Attribute1
1019: ,sr.inv_subcomponent_id
1020: ,sr.incident_location_type
1021: FROM cs_incidents_b_sec sr
1022: ,cs_incidents_all_tl tl
1023: ,csi_item_instances instance
1024: WHERE sr.incident_id = tl.incident_id
1025: AND tl.language = userenv('lang')
1026: AND sr.incident_id = P_Incident_Id
1027: AND sr.inventory_item_id = instance.inventory_item_id (+)
1387: --:Sub_Component
1388: CURSOR Get_Component_Instance (v_cp_component_id NUMBER, v_inv_organization_id NUMBER) IS
1389: SELECT product_b.concatenated_segments
1390: FROM mtl_system_items_b_kfv product_b,
1391: csi_item_instances instance
1392: WHERE product_b.inventory_item_id = instance.inventory_item_id
1393: AND product_b.organization_id = v_inv_organization_id
1394: AND instance.instance_id = v_cp_component_id;
1395: