eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_ERES_INT_PKG dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 959: from mtl_system_items_b_kfv product_a,

955: ,nvl(instance.serial_number,sr.current_serial_number) Serial_Number
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

Line 965: from mtl_system_items_b_kfv product_b,

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
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

Line 1390: FROM mtl_system_items_b_kfv product_b,

1386: --:Component
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;

Line 1399: FROM mtl_system_items_b_kfv product_b

1395:
1396:
1397: CURSOR Get_Component (v_inv_component_id NUMBER, v_inv_organization_id NUMBER) IS
1398: SELECT product_b.concatenated_segments
1399: FROM mtl_system_items_b_kfv product_b
1400: WHERE product_b.inventory_item_id = v_inv_component_id
1401: AND product_b.organization_id = v_inv_organization_id;
1402:
1403: l_Component VARCHAR2(40);