DBA Data[Home] [Help]

APPS.PO_PDOI_DIST_PROCESS_PVT dependencies on MTL_ITEM_SUB_INVENTORIES

Line 4458: -- first try to get it from mtl_item_sub_inventories, then mtl_secondary_

4454: ELSE -- p_destination_type_code = 'INVENTORY'
4455:
4456: d_position := 70;
4457:
4458: -- first try to get it from mtl_item_sub_inventories, then mtl_secondary_
4459: -- inventories, then mtl_system_items and finally mtl_parameters
4460: -- Bug6811980 (including the exception block)
4461: BEGIN
4462: SELECT NVL(misi.encumbrance_account, msci.encumbrance_account)

Line 4464: FROM mtl_item_sub_inventories misi,

4460: -- Bug6811980 (including the exception block)
4461: BEGIN
4462: SELECT NVL(misi.encumbrance_account, msci.encumbrance_account)
4463: INTO x_budget_account_id
4464: FROM mtl_item_sub_inventories misi,
4465: mtl_secondary_inventories msci
4466: WHERE misi.organization_id = p_dest_org_id
4467: AND misi.inventory_item_id = p_item_id
4468: AND misi.secondary_inventory = p_dest_subinventory