DBA Data[Home] [Help]

APPS.INV_LABEL_PVT4 dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 2893: FROM mtl_onhand_quantities_detail moqd

2889: trace('Transaction action id = '||l_transaction_action_id||' so need to check source status');
2890: END IF;
2891: BEGIN --querying for source status
2892: SELECT moqd.status_id into l_src_status_id
2893: FROM mtl_onhand_quantities_detail moqd
2894: WHERE inventory_item_id = v_lpn_content.inventory_item_id
2895: AND organization_id = l_src_organization_id
2896: AND subinventory_code = l_src_subinventory_code
2897: AND NVL(lpn_id ,-999) = NVL(l_src_lpn_id,-999)