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_RE_COMMON_PVT dependencies on WMS_TRANSACTIONS_TEMP

Line 26: ( pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE

22: -- [Added the following columns(s) in 'TYPE inp_rec_type IS RECORD..'
23: -- to support serial allocation based on serial reservation ]
24:
25: TYPE inp_rec_type IS RECORD
26: ( pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE
27: ,revision wms_transactions_temp.revision%TYPE
28: ,lot_number wms_transactions_temp.lot_number%TYPE
29: ,lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
30: ,from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE

Line 27: ,revision wms_transactions_temp.revision%TYPE

23: -- to support serial allocation based on serial reservation ]
24:
25: TYPE inp_rec_type IS RECORD
26: ( pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE
27: ,revision wms_transactions_temp.revision%TYPE
28: ,lot_number wms_transactions_temp.lot_number%TYPE
29: ,lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
30: ,from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
31: ,from_locator_id wms_transactions_temp.from_locator_id%TYPE

Line 28: ,lot_number wms_transactions_temp.lot_number%TYPE

24:
25: TYPE inp_rec_type IS RECORD
26: ( pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE
27: ,revision wms_transactions_temp.revision%TYPE
28: ,lot_number wms_transactions_temp.lot_number%TYPE
29: ,lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
30: ,from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
31: ,from_locator_id wms_transactions_temp.from_locator_id%TYPE
32: ,from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE

Line 29: ,lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE

25: TYPE inp_rec_type IS RECORD
26: ( pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE
27: ,revision wms_transactions_temp.revision%TYPE
28: ,lot_number wms_transactions_temp.lot_number%TYPE
29: ,lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
30: ,from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
31: ,from_locator_id wms_transactions_temp.from_locator_id%TYPE
32: ,from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
33: ,to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE

Line 30: ,from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE

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

Line 31: ,from_locator_id wms_transactions_temp.from_locator_id%TYPE

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

Line 32: ,from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE

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

Line 33: ,to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE

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

Line 34: ,to_locator_id wms_transactions_temp.to_locator_id%TYPE

30: ,from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
31: ,from_locator_id wms_transactions_temp.from_locator_id%TYPE
32: ,from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
33: ,to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE
34: ,to_locator_id wms_transactions_temp.to_locator_id%TYPE
35: ,to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE
36: ,transaction_quantity wms_transactions_temp.transaction_quantity%TYPE
37: ,secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
38: ,grade_code wms_transactions_temp.grade_code%TYPE

Line 35: ,to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE

31: ,from_locator_id wms_transactions_temp.from_locator_id%TYPE
32: ,from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
33: ,to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE
34: ,to_locator_id wms_transactions_temp.to_locator_id%TYPE
35: ,to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE
36: ,transaction_quantity wms_transactions_temp.transaction_quantity%TYPE
37: ,secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
38: ,grade_code wms_transactions_temp.grade_code%TYPE
39: ,reservation_id wms_transactions_temp.RESERVATION_ID%TYPE

Line 36: ,transaction_quantity wms_transactions_temp.transaction_quantity%TYPE

32: ,from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
33: ,to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE
34: ,to_locator_id wms_transactions_temp.to_locator_id%TYPE
35: ,to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE
36: ,transaction_quantity wms_transactions_temp.transaction_quantity%TYPE
37: ,secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
38: ,grade_code wms_transactions_temp.grade_code%TYPE
39: ,reservation_id wms_transactions_temp.RESERVATION_ID%TYPE
40: ,serial_number wms_transactions_temp.serial_number%TYPE ---- [ added new column - serial_number]

Line 37: ,secondary_quantity wms_transactions_temp.secondary_quantity%TYPE

33: ,to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE
34: ,to_locator_id wms_transactions_temp.to_locator_id%TYPE
35: ,to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE
36: ,transaction_quantity wms_transactions_temp.transaction_quantity%TYPE
37: ,secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
38: ,grade_code wms_transactions_temp.grade_code%TYPE
39: ,reservation_id wms_transactions_temp.RESERVATION_ID%TYPE
40: ,serial_number wms_transactions_temp.serial_number%TYPE ---- [ added new column - serial_number]
41: ,lpn_id wms_transactions_temp.lpn_id%TYPE

Line 38: ,grade_code wms_transactions_temp.grade_code%TYPE

34: ,to_locator_id wms_transactions_temp.to_locator_id%TYPE
35: ,to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE
36: ,transaction_quantity wms_transactions_temp.transaction_quantity%TYPE
37: ,secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
38: ,grade_code wms_transactions_temp.grade_code%TYPE
39: ,reservation_id wms_transactions_temp.RESERVATION_ID%TYPE
40: ,serial_number wms_transactions_temp.serial_number%TYPE ---- [ added new column - serial_number]
41: ,lpn_id wms_transactions_temp.lpn_id%TYPE
42: ,next_pointer INTEGER

Line 39: ,reservation_id wms_transactions_temp.RESERVATION_ID%TYPE

35: ,to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE
36: ,transaction_quantity wms_transactions_temp.transaction_quantity%TYPE
37: ,secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
38: ,grade_code wms_transactions_temp.grade_code%TYPE
39: ,reservation_id wms_transactions_temp.RESERVATION_ID%TYPE
40: ,serial_number wms_transactions_temp.serial_number%TYPE ---- [ added new column - serial_number]
41: ,lpn_id wms_transactions_temp.lpn_id%TYPE
42: ,next_pointer INTEGER
43: );

Line 40: ,serial_number wms_transactions_temp.serial_number%TYPE ---- [ added new column - serial_number]

36: ,transaction_quantity wms_transactions_temp.transaction_quantity%TYPE
37: ,secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
38: ,grade_code wms_transactions_temp.grade_code%TYPE
39: ,reservation_id wms_transactions_temp.RESERVATION_ID%TYPE
40: ,serial_number wms_transactions_temp.serial_number%TYPE ---- [ added new column - serial_number]
41: ,lpn_id wms_transactions_temp.lpn_id%TYPE
42: ,next_pointer INTEGER
43: );
44: TYPE inp_tbl_type IS TABLE OF inp_rec_type INDEX BY BINARY_INTEGER;

Line 41: ,lpn_id wms_transactions_temp.lpn_id%TYPE

37: ,secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
38: ,grade_code wms_transactions_temp.grade_code%TYPE
39: ,reservation_id wms_transactions_temp.RESERVATION_ID%TYPE
40: ,serial_number wms_transactions_temp.serial_number%TYPE ---- [ added new column - serial_number]
41: ,lpn_id wms_transactions_temp.lpn_id%TYPE
42: ,next_pointer INTEGER
43: );
44: TYPE inp_tbl_type IS TABLE OF inp_rec_type INDEX BY BINARY_INTEGER;
45: g_inp_tbl inp_tbl_type;