DBA Data[Home] [Help]

APPS.PO_WF_PO_CHARGE_ACC dependencies on MTL_SECONDARY_INVENTORIES

Line 225: from mtl_secondary_inventories

221: Bug # 943948
222: Adding the organization_id condition to the select below.
223: */
224: select expense_account into x_account
225: from mtl_secondary_inventories
226: where secondary_inventory_name = x_dest_sub_inv
227: and organization_id = x_dest_org_id;
228: exception
229: when others then

Line 289: from mtl_secondary_inventories

285: ELSIF x_subinv_type = 'EXPENSE' then
286:
287: begin
288: select expense_account into x_account
289: from mtl_secondary_inventories
290: where secondary_inventory_name = x_dest_sub_inv
291: and organization_id = x_dest_org_id;
292: exception
293: when others then

Line 317: from mtl_secondary_inventories

313: ELSE -- destination sub inv type is ASSET
314:
315: begin
316: select material_account into x_account
317: from mtl_secondary_inventories
318: where secondary_inventory_name = x_dest_sub_inv
319: and organization_id = x_dest_org_id;
320: exception
321: when others then

Line 442: from mtl_secondary_inventories

438:
439: x_progress := 'PO_WF_PO_CHARGE_ACC.check_sub_inv_type: 01';
440:
441: select asset_inventory into x_asset_inventory
442: from mtl_secondary_inventories
443: where secondary_inventory_name = x_dest_sub_inv
444: and organization_id = x_dest_org_id;
445:
446: if (x_asset_inventory = 1) then