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.ASO_UTILITY_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 4301: FROM mtl_system_items_kfv si, csi_item_instances cii

4297:
4298: -- changed cursor for bug 12839557
4299: CURSOR c_csi_line_details(p_instance_id IN NUMBER, p_cust_account_id NUMBER) IS
4300: SELECT si.concatenated_segments product, si.inventory_item_id, cii.quantity, cii.unit_of_measure
4301: FROM mtl_system_items_kfv si, csi_item_instances cii
4302: WHERE NVL(cii.active_end_date, (SYSDATE + 1)) > SYSDATE
4303: AND cii.inventory_item_id = si.inventory_item_id
4304: AND si.organization_id = cii.inv_master_organization_id
4305: AND cii.instance_id =p_instance_id;

Line 4850: FROM mtl_system_items_kfv si, csi_item_instances cii

4846: l_order_found BOOLEAN := FALSE;
4847:
4848: CURSOR c_csi_line_details(p_instance_id IN NUMBER, p_cust_account_id NUMBER) IS
4849: SELECT si.concatenated_segments product, si.inventory_item_id, cii.quantity, cii.unit_of_measure
4850: FROM mtl_system_items_kfv si, csi_item_instances cii
4851: WHERE NVL(cii.active_end_date, (SYSDATE + 1)) > SYSDATE
4852: AND cii.inventory_item_id = si.inventory_item_id
4853: AND si.organization_id = cii.inv_master_organization_id
4854: AND cii.instance_id =p_instance_id;