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.WMS_ENGINE_PVT dependencies on WMS_TRANSACTIONS_TEMP

Line 20: SUBTYPE g_wms_txn_temp_rec_type IS wms_transactions_temp%ROWTYPE;

16: -- [g_use_rule VARCHAR2(1) := 'Y'; used to track if stg/rule
17: -- search API is required to be called or not ]
18:
19: --
20: SUBTYPE g_wms_txn_temp_rec_type IS wms_transactions_temp%ROWTYPE;
21:
22: TYPE g_wms_txn_temp_tbl_type IS TABLE OF g_wms_txn_temp_rec_type
23: INDEX BY BINARY_INTEGER;
24:

Line 27: revision wms_transactions_temp.revision%TYPE

23: INDEX BY BINARY_INTEGER;
24:
25: -- a record type used in the combine_transfer procedure
26: TYPE g_combine_rec_type IS RECORD(
27: revision wms_transactions_temp.revision%TYPE
28: , from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
29: , from_locator_id wms_transactions_temp.from_locator_id%TYPE
30: , from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
31: , to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE

Line 28: , from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE

24:
25: -- a record type used in the combine_transfer procedure
26: TYPE g_combine_rec_type IS RECORD(
27: revision wms_transactions_temp.revision%TYPE
28: , from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
29: , from_locator_id wms_transactions_temp.from_locator_id%TYPE
30: , from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
31: , to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE
32: , to_locator_id wms_transactions_temp.to_locator_id%TYPE

Line 29: , from_locator_id wms_transactions_temp.from_locator_id%TYPE

25: -- a record type used in the combine_transfer procedure
26: TYPE g_combine_rec_type IS RECORD(
27: revision wms_transactions_temp.revision%TYPE
28: , from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
29: , from_locator_id wms_transactions_temp.from_locator_id%TYPE
30: , from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
31: , to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE
32: , to_locator_id wms_transactions_temp.to_locator_id%TYPE
33: , to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE

Line 30: , from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE

26: TYPE g_combine_rec_type IS RECORD(
27: revision wms_transactions_temp.revision%TYPE
28: , from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
29: , from_locator_id wms_transactions_temp.from_locator_id%TYPE
30: , from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
31: , to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE
32: , to_locator_id wms_transactions_temp.to_locator_id%TYPE
33: , to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE
34: , lot_number wms_transactions_temp.lot_number%TYPE

Line 31: , to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE

27: revision wms_transactions_temp.revision%TYPE
28: , from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
29: , from_locator_id wms_transactions_temp.from_locator_id%TYPE
30: , from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
31: , to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE
32: , to_locator_id wms_transactions_temp.to_locator_id%TYPE
33: , to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE
34: , lot_number wms_transactions_temp.lot_number%TYPE
35: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE

Line 32: , to_locator_id wms_transactions_temp.to_locator_id%TYPE

28: , from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
29: , from_locator_id wms_transactions_temp.from_locator_id%TYPE
30: , from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
31: , to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE
32: , to_locator_id wms_transactions_temp.to_locator_id%TYPE
33: , to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE
34: , lot_number wms_transactions_temp.lot_number%TYPE
35: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
36: , serial_number wms_transactions_temp.serial_number%TYPE

Line 33: , to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE

29: , from_locator_id wms_transactions_temp.from_locator_id%TYPE
30: , from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
31: , to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE
32: , to_locator_id wms_transactions_temp.to_locator_id%TYPE
33: , to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE
34: , lot_number wms_transactions_temp.lot_number%TYPE
35: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
36: , serial_number wms_transactions_temp.serial_number%TYPE
37: , transaction_quantity wms_transactions_temp.transaction_quantity%TYPE

Line 34: , lot_number wms_transactions_temp.lot_number%TYPE

30: , from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
31: , to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE
32: , to_locator_id wms_transactions_temp.to_locator_id%TYPE
33: , to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE
34: , lot_number wms_transactions_temp.lot_number%TYPE
35: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
36: , serial_number wms_transactions_temp.serial_number%TYPE
37: , transaction_quantity wms_transactions_temp.transaction_quantity%TYPE
38: , primary_quantity wms_transactions_temp.primary_quantity%TYPE

Line 35: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE

31: , to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE
32: , to_locator_id wms_transactions_temp.to_locator_id%TYPE
33: , to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE
34: , lot_number wms_transactions_temp.lot_number%TYPE
35: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
36: , serial_number wms_transactions_temp.serial_number%TYPE
37: , transaction_quantity wms_transactions_temp.transaction_quantity%TYPE
38: , primary_quantity wms_transactions_temp.primary_quantity%TYPE
39: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE

Line 36: , serial_number wms_transactions_temp.serial_number%TYPE

32: , to_locator_id wms_transactions_temp.to_locator_id%TYPE
33: , to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE
34: , lot_number wms_transactions_temp.lot_number%TYPE
35: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
36: , serial_number wms_transactions_temp.serial_number%TYPE
37: , transaction_quantity wms_transactions_temp.transaction_quantity%TYPE
38: , primary_quantity wms_transactions_temp.primary_quantity%TYPE
39: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
40: , grade_code wms_transactions_temp.grade_code%TYPE

Line 37: , transaction_quantity wms_transactions_temp.transaction_quantity%TYPE

33: , to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE
34: , lot_number wms_transactions_temp.lot_number%TYPE
35: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
36: , serial_number wms_transactions_temp.serial_number%TYPE
37: , transaction_quantity wms_transactions_temp.transaction_quantity%TYPE
38: , primary_quantity wms_transactions_temp.primary_quantity%TYPE
39: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
40: , grade_code wms_transactions_temp.grade_code%TYPE
41: , rule_id wms_transactions_temp.rule_id%TYPE

Line 38: , primary_quantity wms_transactions_temp.primary_quantity%TYPE

34: , lot_number wms_transactions_temp.lot_number%TYPE
35: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
36: , serial_number wms_transactions_temp.serial_number%TYPE
37: , transaction_quantity wms_transactions_temp.transaction_quantity%TYPE
38: , primary_quantity wms_transactions_temp.primary_quantity%TYPE
39: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
40: , grade_code wms_transactions_temp.grade_code%TYPE
41: , rule_id wms_transactions_temp.rule_id%TYPE
42: , reservation_id wms_transactions_temp.reservation_id%TYPE

Line 39: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE

35: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
36: , serial_number wms_transactions_temp.serial_number%TYPE
37: , transaction_quantity wms_transactions_temp.transaction_quantity%TYPE
38: , primary_quantity wms_transactions_temp.primary_quantity%TYPE
39: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
40: , grade_code wms_transactions_temp.grade_code%TYPE
41: , rule_id wms_transactions_temp.rule_id%TYPE
42: , reservation_id wms_transactions_temp.reservation_id%TYPE
43: , lpn_id wms_transactions_temp.lpn_id%TYPE);

Line 40: , grade_code wms_transactions_temp.grade_code%TYPE

36: , serial_number wms_transactions_temp.serial_number%TYPE
37: , transaction_quantity wms_transactions_temp.transaction_quantity%TYPE
38: , primary_quantity wms_transactions_temp.primary_quantity%TYPE
39: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
40: , grade_code wms_transactions_temp.grade_code%TYPE
41: , rule_id wms_transactions_temp.rule_id%TYPE
42: , reservation_id wms_transactions_temp.reservation_id%TYPE
43: , lpn_id wms_transactions_temp.lpn_id%TYPE);
44:

Line 41: , rule_id wms_transactions_temp.rule_id%TYPE

37: , transaction_quantity wms_transactions_temp.transaction_quantity%TYPE
38: , primary_quantity wms_transactions_temp.primary_quantity%TYPE
39: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
40: , grade_code wms_transactions_temp.grade_code%TYPE
41: , rule_id wms_transactions_temp.rule_id%TYPE
42: , reservation_id wms_transactions_temp.reservation_id%TYPE
43: , lpn_id wms_transactions_temp.lpn_id%TYPE);
44:
45: TYPE g_combine_tbl_type IS TABLE OF g_combine_rec_type

Line 42: , reservation_id wms_transactions_temp.reservation_id%TYPE

38: , primary_quantity wms_transactions_temp.primary_quantity%TYPE
39: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
40: , grade_code wms_transactions_temp.grade_code%TYPE
41: , rule_id wms_transactions_temp.rule_id%TYPE
42: , reservation_id wms_transactions_temp.reservation_id%TYPE
43: , lpn_id wms_transactions_temp.lpn_id%TYPE);
44:
45: TYPE g_combine_tbl_type IS TABLE OF g_combine_rec_type
46: INDEX BY BINARY_INTEGER;

Line 43: , lpn_id wms_transactions_temp.lpn_id%TYPE);

39: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
40: , grade_code wms_transactions_temp.grade_code%TYPE
41: , rule_id wms_transactions_temp.rule_id%TYPE
42: , reservation_id wms_transactions_temp.reservation_id%TYPE
43: , lpn_id wms_transactions_temp.lpn_id%TYPE);
44:
45: TYPE g_combine_tbl_type IS TABLE OF g_combine_rec_type
46: INDEX BY BINARY_INTEGER;
47:

Line 117: -- Insert all records in p_wms_txn_temp_tbl into wms_transactions_temp.

113: END log_statement;
114:
115:
116: -- Description
117: -- Insert all records in p_wms_txn_temp_tbl into wms_transactions_temp.
118: -- Value for column pp_transaction_temp_id will be derived in the
119: -- procedure
120: --
121: PROCEDURE insert_detail_temp_records

Line 131: SELECT wms_transactions_temp_s.NEXTVAL

127:
128: --
129: /* Bug 5265024
130: CURSOR l_wms_txn_temp_id_csr IS
131: SELECT wms_transactions_temp_s.NEXTVAL
132: FROM DUAL;
133: */
134:
135: l_wms_txn_temp_tbl_size NUMBER;

Line 174: INSERT INTO wms_transactions_temp

170: */
171:
172: -- insert to the table
173: FOR l_counter IN 1 .. l_wms_txn_temp_tbl_size LOOP
174: INSERT INTO wms_transactions_temp
175: (
176: pp_transaction_temp_id
177: , transaction_temp_id
178: , type_code

Line 201: wms_transactions_temp_s.NEXTVAL

197: , to_cost_group_id
198: , lpn_id
199: )
200: VALUES (
201: wms_transactions_temp_s.NEXTVAL
202: -- l_temp_id_tbl(l_counter)
203: , p_wms_txn_temp_tbl(l_counter).transaction_temp_id
204: , p_wms_txn_temp_tbl(l_counter).type_code
205: , p_wms_txn_temp_tbl(l_counter).line_type_code

Line 281: -- Purges all records from WMS_TRANSACTIONS_TEMP for the move

277: END insert_detail_temp_records;
278:
279: --
280: -- Description
281: -- Purges all records from WMS_TRANSACTIONS_TEMP for the move
282: -- order line
283: PROCEDURE purge_detail_temp_records
284: ( x_return_status OUT NOCOPY VARCHAR2
285: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type

Line 302: DELETE FROM wms_transactions_temp

298: -- Initialisize API return status to success
299: x_return_status := fnd_api.g_ret_sts_success;
300:
301: --
302: DELETE FROM wms_transactions_temp
303: WHERE transaction_temp_id = p_request_line_rec.line_id;
304:
305: --
306: DELETE FROM wms_txn_context_temp

Line 392: -- Insert record for single serial number into wms_transactions_temp

388: END LOOP;
389:
390: l_wms_txn_temp_tbl_size := l_to_num - l_fm_num + 1;
391: ELSE
392: -- Insert record for single serial number into wms_transactions_temp
393: l_wms_txn_temp_tbl(1).serial_number := p_request_line_rec.serial_number_start;
394: l_wms_txn_temp_tbl_size := 1;
395: END IF;
396:

Line 451: -- FUNCTION : Creates records in WMS_TRANSACTIONS_TEMP for

447: END resolve_serials;
448:
449: --
450: -- Procedure : Prepare
451: -- FUNCTION : Creates records in WMS_TRANSACTIONS_TEMP for
452: -- each single lot and/or serial number and splits
453: -- transfer transactions into issue and receipt
454: -- transaction
455: PROCEDURE prepare(

Line 730: -- Pre-reqs : Record(s) exist(s) in WMS_TRANSACTIONS_TEMP with

726:
727: --
728: --
729: -- Procedure : Prepare_Transfer_Receipt
730: -- Pre-reqs : Record(s) exist(s) in WMS_TRANSACTIONS_TEMP with
731: -- p_transaction_temp_id = the move order line id
732: -- and type_code = 2 (pick) and
733: -- line_type_code = 2 (output line)
734: -- Function : Copies issue output record(s) into

Line 735: -- WMS_TRANSACTIONS_TEMP as input records

731: -- p_transaction_temp_id = the move order line id
732: -- and type_code = 2 (pick) and
733: -- line_type_code = 2 (output line)
734: -- Function : Copies issue output record(s) into
735: -- WMS_TRANSACTIONS_TEMP as input records
736: -- for receipt portion within transfer transactions
737: --
738: PROCEDURE prepare_transfer_receipt
739: (

Line 762: FROM wms_transactions_temp wtt

758: , wtt.from_subinventory_code from_subinventory_code
759: , wtt.from_locator_id from_locator_id
760: , wtt.from_cost_group_id from_cost_group_id
761: , wtt.lpn_id lpn_id
762: FROM wms_transactions_temp wtt
763: WHERE wtt.transaction_temp_id = p_request_line_rec.line_id
764: AND wtt.line_type_code = 2 -- output line
765: AND wtt.type_code = 2 -- pick
766: GROUP BY wtt.lot_number

Line 817: -- wms_transactions_temp for put away since the more records

813: EXIT WHEN l_put_input_csr%NOTFOUND;
814: -- Note: serial number here is ignored here. The assumption
815: -- is that the put away side will not care about the serial number.
816: -- The purpose is to reduce the number of records as input in
817: -- wms_transactions_temp for put away since the more records
818: -- it is, the more runs the engine has to run, and thus the slower.
819: -- The assumption stated might not be valid for some situations.
820: -- So this might need to be enhanced later.
821: l_wms_txn_temp_tbl_size := l_wms_txn_temp_tbl_size + 1;

Line 936: -- display the output records in wms_transactions_temp

932: END prepare_transfer_receipt;
933:
934: --
935: -- debugging routine
936: -- display the output records in wms_transactions_temp
937: -- when called
938: PROCEDURE display_temp_records IS
939: CURSOR l_cur IS
940: SELECT transaction_temp_id

Line 956: FROM wms_transactions_temp

952: , reservation_id
953: , to_subinventory_code
954: , to_locator_id
955: , lpn_id
956: FROM wms_transactions_temp
957: ORDER BY transaction_temp_id
958: , line_type_code
959: , type_code
960: , revision

Line 1061: -- read from the table wms_transactions_temp by the order of

1057: END display_temp_records;
1058:
1059: --
1060: -- create output suggestion records for issue or receipt but not transfer
1061: -- read from the table wms_transactions_temp by the order of
1062: -- revision, from_sub, to_sub, from_loc, to_loc, lot_number, serial_number
1063: PROCEDURE output_issue_or_receipt(
1064: x_return_status OUT NOCOPY VARCHAR2
1065: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type

Line 1114: FROM wms_transactions_temp wtt

1110: , wtt.pp_transaction_temp_id
1111: , wtt.from_cost_group_id
1112: , wtt.to_cost_group_id
1113: , wtt.lpn_id
1114: FROM wms_transactions_temp wtt
1115: WHERE wtt.transaction_temp_id = l_transaction_temp_id
1116: AND wtt.line_type_code = 2 -- output line
1117: ) x
1118: GROUP BY x.revision

Line 1259: FROM wms_transactions_temp

1255: , grade_code
1256: , MIN(rule_id) pick_rule_id
1257: , reservation_id
1258: , lpn_id
1259: FROM wms_transactions_temp
1260: WHERE transaction_temp_id = l_transaction_temp_id
1261: AND line_type_code = 2 -- output line
1262: AND type_code = 2 -- pick
1263: GROUP BY serial_number

Line 1307: FROM wms_transactions_temp

1303: , grade_code
1304: , MIN(rule_id) put_away_rule_id
1305: , NULL reservation_id
1306: , lpn_id lpn_id
1307: FROM wms_transactions_temp
1308: WHERE transaction_temp_id = l_transaction_temp_id
1309: AND line_type_code = 2 -- output line
1310: AND type_code = 1 -- put away
1311: GROUP BY serial_number

Line 1786: SELECT wms_transactions_temp_s.NEXTVAL

1782: WHERE organization_id = l_request_line_rec.organization_id;
1783:
1784: /* Bug # 5265024
1785: CURSOR l_wms_txn_temp_id_csr IS
1786: SELECT wms_transactions_temp_s.NEXTVAL
1787: FROM DUAL;
1788: */
1789:
1790: BEGIN

Line 2209: DELETE FROM wms_transactions_temp

2205: log_event(l_api_name, 'start_pick', 'getting the context ');
2206: END IF;
2207:
2208: -- clean up the input records first
2209: DELETE FROM wms_transactions_temp
2210: WHERE transaction_temp_id = p_transaction_temp_id
2211: AND line_type_code = 1;
2212:
2213: --

Line 2230: -- WMS_TRANSACTIONS_TEMP as new input records for receipt part

2226: RAISE fnd_api.g_exc_error;
2227: END IF;
2228: ELSE
2229: -- Treat receipt for transfers, ie. copy the issue output data in
2230: -- WMS_TRANSACTIONS_TEMP as new input records for receipt part
2231: prepare_transfer_receipt(l_return_status
2232: , l_request_line_rec
2233: , l_request_context);
2234: --

Line 2242: -- so insert fake data into wms_transactions_temp

2238: END IF;
2239: END IF;
2240: -- LG convergence add
2241: -- Since we may not have a reservation when p_simulation_mode is 10 for all move order types
2242: -- so insert fake data into wms_transactions_temp
2243: IF p_simulation_mode = g_available_inventory
2244: THEN
2245: /* 5265024
2246: OPEN l_wms_txn_temp_id_csr;

Line 2251: INSERT INTO wms_transactions_temp

2247: FETCH l_wms_txn_temp_id_csr INTO l_pp_transaction_temp_id ;
2248: CLOSE l_wms_txn_temp_id_csr;
2249: */
2250: log_event(l_api_name, '','insert into wtt '||l_pp_transaction_temp_id);
2251: INSERT INTO wms_transactions_temp
2252: (
2253: pp_transaction_temp_id
2254: , transaction_temp_id -- mo_line_id
2255: , type_code -- mo

Line 2261: VALUES ( wms_transactions_temp_s.NEXTVAL

2257: , transaction_quantity
2258: , primary_quantity
2259: , secondary_quantity
2260: )
2261: VALUES ( wms_transactions_temp_s.NEXTVAL
2262: -- l_pp_transaction_temp_id
2263: , l_request_line_rec.line_id
2264: , 2
2265: , 1

Line 2631: -- Delete records from WMS_TRANSACTIONS_TEMP

2627: , p_insert_serial_flag => inv_detail_util_pvt.g_insert_serial_flag
2628: );
2629: END IF;
2630:
2631: -- Delete records from WMS_TRANSACTIONS_TEMP
2632: purge_detail_temp_records(l_return_status, l_request_line_rec);
2633:
2634: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2635: RAISE fnd_api.g_exc_error;