APPS.PO_WF_PO_CHARGE_ACC dependencies on MTL_SECONDARY_INVENTORIES

Line 223: from mtl_secondary_inventories

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

Line 287: from mtl_secondary_inventories

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

Line 315: from mtl_secondary_inventories

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

Line 440: from mtl_secondary_inventories

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