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.CSP_PARTS_ORDER dependencies on MTL_SECONDARY_INVENTORIES

Line 163: FROM mtl_secondary_inventories

159: RETURN VARCHAR2 IS
160:
161: CURSOR asset_inventory_cur IS
162: SELECT asset_inventory
163: FROM mtl_secondary_inventories
164: WHERE secondary_inventory_name = NVL(p_destination_subinventory,'X')
165: AND organization_id = p_destination_organization_id;
166:
167: l_asset_inventory NUMBER;

Line 254: FROM mtl_secondary_inventories

250: IF (p_destination_subinventory IS NOT NULL) THEN
251: BEGIN
252: SELECT expense_account
253: INTO l_charge_account
254: FROM mtl_secondary_inventories
255: WHERE secondary_inventory_name = p_destination_subinventory
256: AND organization_id = p_destination_organization_id;
257: EXCEPTION
258: WHEN OTHERS THEN

Line 320: FROM mtl_secondary_inventories

316: -- Get Expense Account for the Subinventory
317: BEGIN
318: SELECT expense_account
319: INTO l_charge_account
320: FROM mtl_secondary_inventories
321: WHERE secondary_inventory_name = p_destination_subinventory
322: AND organization_id = p_destination_organization_id;
323: EXCEPTION
324: WHEN OTHERS THEN

Line 347: FROM mtl_secondary_inventories

343: -- Get the Charge_Account for the Subinventory
344: BEGIN
345: SELECT material_account
346: INTO l_charge_account
347: FROM mtl_secondary_inventories
348: WHERE secondary_inventory_name = p_destination_subinventory
349: AND organization_id = p_destination_organization_id;
350: EXCEPTION
351: WHEN OTHERS THEN