eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSM_RESERVATIONS_PVT dependencies on MTL_RESERVATIONS

Line 9: --type r_mtl_rsv_rec_type is record of mtl_reservations%rowtype;

5: g_pkg_name VARCHAR2(20) := 'WSM_RESERVATIONS_PVT';
6:
7: type t_wsm_rsv_v_tbl_type is table of wsm_reservations_v%rowtype index by binary_integer;
8: type t_wsm_reservations is table of wsm_reservations%rowtype index by binary_integer;
9: --type r_mtl_rsv_rec_type is record of mtl_reservations%rowtype;
10: --MP: Sale order changes
11: l_mtl_rsv_rec inv_reservation_global.mtl_maintain_rsv_rec_type;
12:
13: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;

Line 799: --Check if demand exists by querying the mtl_reservations table. If yes, then query the corresponding demand and supply details from history table and call create_reservations( ) to create them again against the job.

795: END;
796: --If (entry exists in WSM_RESERVATIONS for this job) then
797: If l_wsm_rsvn_tbl.count > 0 then
798:
799: --Check if demand exists by querying the mtl_reservations table. If yes, then query the corresponding demand and supply details from history table and call create_reservations( ) to create them again against the job.
800:
801: -- Added for Bug 5286219. Temporarily changing the status type of the job to
802: -- Released status so that reservation can be transferred from inventory back to LBJ.
803:

Line 826: from mtl_reservations

822:
823: BEGIN
824: select primary_reservation_quantity
825: into l_reservation_quantity
826: from mtl_reservations
827: where reservation_id = l_wsm_rsvn_tbl(j).reservation_id;
828: EXCEPTION
829: when no_data_found then
830: l_reservation_quantity := -1;

Line 834: --Transfer_reservation to job A with l_rsv_new.reservation_qty = min (mtl_reservations.reservation_qty, wsm_reservations.reserved_qty)

830: l_reservation_quantity := -1;
831: END;
832:
833: If l_reservation_quantity <> -1 then
834: --Transfer_reservation to job A with l_rsv_new.reservation_qty = min (mtl_reservations.reservation_qty, wsm_reservations.reserved_qty)
835: --Call the API as below.
836:
837: --populate l_rsv_old record with reservation details against the inventory for this SO from mtl_reservations.
838: l_rsv_old.reservation_id := l_wsm_rsvn_tbl(j).reservation_id;

Line 837: --populate l_rsv_old record with reservation details against the inventory for this SO from mtl_reservations.

833: If l_reservation_quantity <> -1 then
834: --Transfer_reservation to job A with l_rsv_new.reservation_qty = min (mtl_reservations.reservation_qty, wsm_reservations.reserved_qty)
835: --Call the API as below.
836:
837: --populate l_rsv_old record with reservation details against the inventory for this SO from mtl_reservations.
838: l_rsv_old.reservation_id := l_wsm_rsvn_tbl(j).reservation_id;
839:
840: --populate l_rsv_new record with changed reservation details against this job for this SO from wsm_reservations.
841: l_rsv_new.supply_source_header_id := p_wip_entity_id;