DBA Data[Home] [Help]

APPS.OE_BULK_PROCESS_LINE dependencies on MTL_SUBINVENTORIES_TRK_VAL_V

Line 781: FROM MTL_SUBINVENTORIES_TRK_VAL_V

777:
778: BEGIN
779: SELECT 'VALID'
780: INTO l_dummy
781: FROM MTL_SUBINVENTORIES_TRK_VAL_V
782: WHERE organization_id = p_ship_from_org_id
783: AND secondary_inventory_name = p_subinventory;
784: EXCEPTION
785: WHEN OTHERS THEN

Line 815: from mtl_subinventories_trk_val_v sub

811: BEGIN
812:
813: select 'Y'
814: into l_dummy
815: from mtl_subinventories_trk_val_v sub
816: where sub.organization_id = p_ship_from_org_id
817: and sub.secondary_inventory_name = p_subinventory
818: and (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') = 1
819: OR