DBA Data[Home] [Help]

APPS.INV_LABEL_PVT4 dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 2156: FROM mtl_onhand_quantities_detail moqd

2152: trace('Transaction action id = '||l_transaction_action_id||' so need to check source status');
2153: END IF;
2154: BEGIN --querying for source status
2155: SELECT moqd.status_id into l_src_status_id
2156: FROM mtl_onhand_quantities_detail moqd
2157: WHERE inventory_item_id = v_lpn_content.inventory_item_id
2158: AND organization_id = l_src_organization_id
2159: AND subinventory_code = l_src_subinventory_code
2160: AND NVL(lpn_id ,-999) = NVL(l_src_lpn_id,-999)