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.

[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 888: from mtl_system_items_b_kfv product_a,

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

Line 894: from mtl_system_items_b_kfv product_b,

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

Line 1319: FROM mtl_system_items_b_kfv product_b,

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

Line 1328: FROM mtl_system_items_b_kfv product_b

1324:
1325:
1326: CURSOR Get_Component (v_inv_component_id NUMBER, v_inv_organization_id NUMBER) IS
1327: SELECT product_b.concatenated_segments
1328: FROM mtl_system_items_b_kfv product_b
1329: WHERE product_b.inventory_item_id = v_inv_component_id
1330: AND product_b.organization_id = v_inv_organization_id;
1331:
1332: l_Component VARCHAR2(40);