DBA Data[Home] [Help]

APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 546: FROM mtl_onhand_quantities_detail moqd

542: --8267628 Cursor c_distinct_lpn added as part of this bug
543: --8870624 Added NVL and ORDER BY below
544: CURSOR c_distinct_lpn IS
545: SELECT DISTINCT(NVL(lpn_id,-999))
546: FROM mtl_onhand_quantities_detail moqd
547: WHERE moqd.organization_id = l_organization_id
548: AND moqd.subinventory_code = p_subinventory_code
549: AND moqd.locator_id = p_locator_id
550: AND moqd.inventory_item_id = l_item_id

Line 556: FROM mtl_onhand_quantities_detail moqd

552:
553: /*9301174*/
554: CURSOR C_DISTINCT_LOT_LPN_CUR (l_lot VARCHAR2) IS
555: SELECT DISTINCT(NVL(moqd.lpn_id,-999))
556: FROM mtl_onhand_quantities_detail moqd
557: WHERE moqd.organization_id = l_organization_id
558: AND moqd.subinventory_code = p_subinventory_code
559: AND moqd.locator_id = p_locator_id
560: AND moqd.inventory_item_id = l_item_id