DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 2401: FROM mtl_onhand_quantities_detail

2397: ,v_sub_code VARCHAR2
2398: ,v_revision VARCHAR2)
2399: IS
2400: SELECT NVL (SUM (primary_transaction_quantity), 0) onhand
2401: FROM mtl_onhand_quantities_detail
2402: WHERE organization_id = v_org_id
2403: AND inventory_item_id = v_inventory_item_id
2404: AND (v_revision IS NULL OR revision = v_revision)
2405: AND (p_invoke_mode = 'O' OR (subinventory_code = v_sub_code) )