DBA Data[Home] [Help]

APPS.INV_PICK_RELEASE_PUB dependencies on MTL_RESERVATIONS

Line 2842: from mtl_reservations mr

2838: l_shipping_attr(1).released_status := l_released_status;
2839: l_shipping_attr(1).delivery_detail_id := l_delivery_detail_id;
2840:
2841: select count(1) INTO l_reservation_exists
2842: from mtl_reservations mr
2843: WHERE MR.DEMAND_SOURCE_LINE_ID = l_source_line_id
2844: and MR.DEMAND_SOURCE_HEADER_ID =
2845: inv_salesorder.get_salesorder_for_oeheader(l_source_header_id)
2846: and MR.demand_source_type_id = decode(INV_CACHE.wdd_rec.source_document_type_id, 10, 8, 2)