DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 2516: FROM mtl_onhand_quantities_detail

2512: ,v_sub_code VARCHAR2
2513: ,v_revision VARCHAR2)
2514: IS
2515: SELECT NVL (SUM (primary_transaction_quantity), 0) onhand
2516: FROM mtl_onhand_quantities_detail
2517: WHERE organization_id = v_org_id
2518: AND inventory_item_id = v_inventory_item_id
2519: AND (v_revision IS NULL OR revision = v_revision)
2520: AND (p_invoke_mode = 'O' OR (subinventory_code = v_sub_code) )