DBA Data[Home] [Help]

APPS.INV_RESERVATION_AVAIL_PVT dependencies on INV_RCV_AVAILABILITY

Line 525: debug_print('Receiving supply, before calling INV_RCV_availability.get_available_supply_demand');

521: END IF;
522:
523: -- call availability API for available quantity in receiving
524: IF (l_debug = 1) THEN
525: debug_print('Receiving supply, before calling INV_RCV_availability.get_available_supply_demand');
526: END IF;
527:
528: INV_RCV_availability.get_available_supply_demand
529: (

Line 528: INV_RCV_availability.get_available_supply_demand

524: IF (l_debug = 1) THEN
525: debug_print('Receiving supply, before calling INV_RCV_availability.get_available_supply_demand');
526: END IF;
527:
528: INV_RCV_availability.get_available_supply_demand
529: (
530: x_return_status => l_return_status
531: , x_msg_count => l_msg_count
532: , x_msg_data => l_msg_data

Line 605: -- which is being crossdocked to wip is already taken in to consideration (inv_rcv_availability.get_available_supply_demand)

601: WHERE supply_source_type_id = p_supply_source_type_id
602: AND organization_id = p_organization_id
603: AND inventory_item_id = p_item_id
604: AND demand_source_type_id <> 5;-- bug 9706800: Consider reservations only for Sales Order and not for WIP Jobs/OPM batches since MOL quantity
605: -- which is being crossdocked to wip is already taken in to consideration (inv_rcv_availability.get_available_supply_demand)
606: EXCEPTION
607: WHEN no_data_found THEN
608: IF (l_debug = 1) THEN
609: debug_print('No reservation found');