DBA Data[Home] [Help]

APPS.INV_LABEL dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 4002: FROM mtl_onhand_quantities_detail moqd

3998: trace ('source locator_id = '||l_mmtt_cur.locator_id, TRACE_PROMPT, TRACE_LEVEL);
3999: trace ('source lpn is = '||l_mmtt_cur.lpn_id, TRACE_PROMPT, TRACE_LEVEL);
4000: END IF;
4001: SELECT moqd.status_id into l_src_status
4002: FROM mtl_onhand_quantities_detail moqd
4003: WHERE moqd.inventory_item_id = l_wlc_cur.inventory_item_id
4004: AND moqd.organization_id = l_mmtt_cur.organization_id
4005: AND nvl(moqd.lpn_id,-9999) = Nvl(l_mmtt_cur.lpn_id,-9999)
4006: AND moqd.subinventory_code = l_mmtt_cur.subinventory_code