DBA Data[Home] [Help]

APPS.PO_CREATE_REQUISITION_SV dependencies on MTL_SECONDARY_INVENTORIES

Line 204: FROM mtl_secondary_inventories

200: RETURN VARCHAR2 IS
201:
202: CURSOR asset_inventory_cur IS
203: SELECT asset_inventory
204: FROM mtl_secondary_inventories
205: WHERE secondary_inventory_name = NVL(p_destination_subinventory,'X')
206: AND organization_id = p_destination_organization_id;
207:
208: l_asset_inventory NUMBER;

Line 315: FROM mtl_secondary_inventories

311: BEGIN
312: d_progress := 50;
313: SELECT expense_account
314: INTO l_charge_account
315: FROM mtl_secondary_inventories
316: WHERE secondary_inventory_name = p_destination_subinventory
317: AND organization_id = p_destination_organization_id;
318: EXCEPTION
319: WHEN OTHERS THEN

Line 410: FROM mtl_secondary_inventories

406: BEGIN
407: d_progress := 160;
408: SELECT expense_account
409: INTO l_charge_account
410: FROM mtl_secondary_inventories
411: WHERE secondary_inventory_name = p_destination_subinventory
412: AND organization_id = p_destination_organization_id;
413: EXCEPTION
414: WHEN OTHERS THEN

Line 449: FROM mtl_secondary_inventories

445: BEGIN
446: d_progress := 200;
447: SELECT material_account
448: INTO l_charge_account
449: FROM mtl_secondary_inventories
450: WHERE secondary_inventory_name = p_destination_subinventory
451: AND organization_id = p_destination_organization_id;
452: EXCEPTION
453: WHEN OTHERS THEN