DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PUB dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 3817: FROM mtl_onhand_quantities_detail

3813: END IF;
3814:
3815: SELECT COUNT(1)
3816: INTO l_valid
3817: FROM mtl_onhand_quantities_detail
3818: WHERE organization_id = l_organization_id
3819: AND lpn_id = p_lpn_id;
3820:
3821: IF l_valid > 0 THEN

Line 3825: l_table_name := 'MTL_ONHAND_QUANTITIES_DETAIL';

3821: IF l_valid > 0 THEN
3822: IF l_debug = 1 THEN
3823: mdebug('LPN : '||p_lpn_id||' is currently present in MOQD, cannot reuse');
3824: END IF;
3825: l_table_name := 'MTL_ONHAND_QUANTITIES_DETAIL';
3826: RAISE l_transactions_pending;
3827: END IF;
3828:
3829: SELECT COUNT(1)