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

Line 44: g_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;

40: g_locator INV_VALIDATE.locator;
41: g_transaction_type_id NUMBER;
42: g_organization_id NUMBER;
43: g_inventory_item_id NUMBER;
44: g_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
45: g_allowed VARCHAR2(1);
46: g_st_locator_id NUMBER;
47: g_lpn_controlled_flag NUMBER;
48:

Line 840: revision wms_transactions_temp.revision%TYPE

836: -- This records are stored in an array, but are accessed like linked
837: -- lists. Each record contains the index of the next record
838: -- that should be looked at (next_rec).
839: TYPE t_location_rec IS RECORD(
840: revision wms_transactions_temp.revision%TYPE
841: , lot_number wms_transactions_temp.lot_number%TYPE
842: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
843: , subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
844: , locator_id wms_transactions_temp.from_locator_id%TYPE

Line 841: , lot_number wms_transactions_temp.lot_number%TYPE

837: -- lists. Each record contains the index of the next record
838: -- that should be looked at (next_rec).
839: TYPE t_location_rec IS RECORD(
840: revision wms_transactions_temp.revision%TYPE
841: , lot_number wms_transactions_temp.lot_number%TYPE
842: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
843: , subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
844: , locator_id wms_transactions_temp.from_locator_id%TYPE
845: , cost_group_id wms_transactions_temp.from_cost_group_id%TYPE

Line 842: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE

838: -- that should be looked at (next_rec).
839: TYPE t_location_rec IS RECORD(
840: revision wms_transactions_temp.revision%TYPE
841: , lot_number wms_transactions_temp.lot_number%TYPE
842: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
843: , subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
844: , locator_id wms_transactions_temp.from_locator_id%TYPE
845: , cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
846: , uom_code VARCHAR2(3)

Line 843: , subinventory_code wms_transactions_temp.from_subinventory_code%TYPE

839: TYPE t_location_rec IS RECORD(
840: revision wms_transactions_temp.revision%TYPE
841: , lot_number wms_transactions_temp.lot_number%TYPE
842: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
843: , subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
844: , locator_id wms_transactions_temp.from_locator_id%TYPE
845: , cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
846: , uom_code VARCHAR2(3)
847: , lpn_id NUMBER

Line 844: , locator_id wms_transactions_temp.from_locator_id%TYPE

840: revision wms_transactions_temp.revision%TYPE
841: , lot_number wms_transactions_temp.lot_number%TYPE
842: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
843: , subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
844: , locator_id wms_transactions_temp.from_locator_id%TYPE
845: , cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
846: , uom_code VARCHAR2(3)
847: , lpn_id NUMBER
848: , serial_number VARCHAR2(30)

Line 845: , cost_group_id wms_transactions_temp.from_cost_group_id%TYPE

841: , lot_number wms_transactions_temp.lot_number%TYPE
842: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
843: , subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
844: , locator_id wms_transactions_temp.from_locator_id%TYPE
845: , cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
846: , uom_code VARCHAR2(3)
847: , lpn_id NUMBER
848: , serial_number VARCHAR2(30)
849: , quantity wms_transactions_temp.primary_quantity%TYPE

Line 849: , quantity wms_transactions_temp.primary_quantity%TYPE

845: , cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
846: , uom_code VARCHAR2(3)
847: , lpn_id NUMBER
848: , serial_number VARCHAR2(30)
849: , quantity wms_transactions_temp.primary_quantity%TYPE
850: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
851: , grade_code wms_transactions_temp.grade_code%TYPE
852: , secondary_uom_code VARCHAR2(3)
853: , consist_string VARCHAR2(1000)

Line 850: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE

846: , uom_code VARCHAR2(3)
847: , lpn_id NUMBER
848: , serial_number VARCHAR2(30)
849: , quantity wms_transactions_temp.primary_quantity%TYPE
850: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
851: , grade_code wms_transactions_temp.grade_code%TYPE
852: , secondary_uom_code VARCHAR2(3)
853: , consist_string VARCHAR2(1000)
854: , order_by_string VARCHAR2(1000)

Line 851: , grade_code wms_transactions_temp.grade_code%TYPE

847: , lpn_id NUMBER
848: , serial_number VARCHAR2(30)
849: , quantity wms_transactions_temp.primary_quantity%TYPE
850: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
851: , grade_code wms_transactions_temp.grade_code%TYPE
852: , secondary_uom_code VARCHAR2(3)
853: , consist_string VARCHAR2(1000)
854: , order_by_string VARCHAR2(1000)
855: , next_rec NUMBER);

Line 1380: * --for put, get cost group from wms_transactions_temp,

1376: END IF;
1377: /* 2/21/02 - no longer need these args, since put and pick packages
1378: * are not build differently
1379: * else --put away
1380: * --for put, get cost group from wms_transactions_temp,
1381: * -- not input table (wms_trx_details_tmp_v)
1382: * g_base_select := g_base_select ||',NULL cost_group_id'
1383: * || g_line_feed;
1384: * g_base_select := g_base_select ||',NULL uom_code'

Line 4109: FROM wms_transactions_temp

4105: -- type_code 1 = put away; line_type_code 2 = output
4106: CURSOR l_output_lines IS
4107: SELECT to_locator_id
4108: , SUM(primary_quantity) quantity
4109: FROM wms_transactions_temp
4110: WHERE type_code = 1
4111: AND line_type_code = 2
4112: GROUP BY to_locator_id;
4113: BEGIN

Line 4740: INSERT INTO wms_transactions_temp

4736: log_statement(l_api_name, 'insert_wtt_rec', 'Inserting wtt recs. Trx Qty: ' || l_possible_trx_qty);
4737: log_statement(l_api_name, 'insert_wtt_rec', 'Inserting wtt recs. Sec Trx Qty: ' || l_sec_possible_trx_qty);
4738: END IF;
4739: -- insert temporary suggestion
4740: INSERT INTO wms_transactions_temp
4741: (
4742: pp_transaction_temp_id
4743: , transaction_temp_id
4744: , type_code

Line 4765: wms_transactions_temp_s.NEXTVAL

4761: , to_cost_group_id
4762: , lpn_id
4763: )
4764: VALUES (
4765: wms_transactions_temp_s.NEXTVAL
4766: , p_transaction_temp_id
4767: , p_type_code
4768: , 2 -- line type code is output
4769: , l_possible_trx_qty

Line 5314: INSERT INTO wms_transactions_temp

5310: IF l_debug = 1 THEN
5311: log_statement(l_api_name, 'insert_wtt_rec', 'Inserting wtt recs. Trx Qty: ' || l_possible_trx_qty);
5312: END IF;
5313: -- insert temporary suggestion
5314: INSERT INTO wms_transactions_temp
5315: (
5316: pp_transaction_temp_id
5317: , transaction_temp_id
5318: , type_code

Line 5337: wms_transactions_temp_s.NEXTVAL

5333: , to_cost_group_id
5334: , lpn_id
5335: )
5336: VALUES (
5337: wms_transactions_temp_s.NEXTVAL
5338: , p_transaction_temp_id
5339: , p_type_code
5340: , 2 -- line type code is output
5341: , l_possible_trx_qty

Line 5508: DELETE FROM wms_transactions_temp

5504: END IF ;
5505: END LOOP;
5506: END IF;
5507:
5508: DELETE FROM wms_transactions_temp
5509: WHERE line_type_code = 2
5510: AND type_code = p_type_code;
5511: IF l_debug = 1 THEN
5512: log_statement(l_api_name, 'finish_delete_sugs', 'Finished deleting suggestions and restored quantity tree');

Line 6469: -- WMS_TRANSACTIONS_TEMP, respectively );

6465: -- At least one transaction detail record in
6466: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
6467: -- and parameters p_transaction_temp_id and p_type_code
6468: -- ( base tables are MTL_MATERIAL_TRANSACTIONS_TEMP and
6469: -- WMS_TRANSACTIONS_TEMP, respectively );
6470: -- Rule record has to exist in WMS_RULES_B uniquely
6471: -- identified by parameter p_rule_id;
6472: -- Package WMS_RULE_(RULEID) must exist;
6473: -- If picking, quantity tree has to exist, created through

Line 6552: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;

6548: -- variables needed for dynamic SQL
6549: l_cursor INTEGER;
6550: l_rows INTEGER;
6551: -- rule dynamic SQL input variables
6552: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
6553: l_revision wms_transactions_temp.revision%TYPE;
6554: l_lot_number wms_transactions_temp.lot_number%TYPE;
6555: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
6556: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;

Line 6553: l_revision wms_transactions_temp.revision%TYPE;

6549: l_cursor INTEGER;
6550: l_rows INTEGER;
6551: -- rule dynamic SQL input variables
6552: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
6553: l_revision wms_transactions_temp.revision%TYPE;
6554: l_lot_number wms_transactions_temp.lot_number%TYPE;
6555: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
6556: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
6557: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

Line 6554: l_lot_number wms_transactions_temp.lot_number%TYPE;

6550: l_rows INTEGER;
6551: -- rule dynamic SQL input variables
6552: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
6553: l_revision wms_transactions_temp.revision%TYPE;
6554: l_lot_number wms_transactions_temp.lot_number%TYPE;
6555: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
6556: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
6557: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
6558: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

Line 6555: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;

6551: -- rule dynamic SQL input variables
6552: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
6553: l_revision wms_transactions_temp.revision%TYPE;
6554: l_lot_number wms_transactions_temp.lot_number%TYPE;
6555: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
6556: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
6557: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
6558: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
6559: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;

Line 6556: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;

6552: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
6553: l_revision wms_transactions_temp.revision%TYPE;
6554: l_lot_number wms_transactions_temp.lot_number%TYPE;
6555: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
6556: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
6557: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
6558: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
6559: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
6560: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;

Line 6557: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

6553: l_revision wms_transactions_temp.revision%TYPE;
6554: l_lot_number wms_transactions_temp.lot_number%TYPE;
6555: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
6556: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
6557: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
6558: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
6559: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
6560: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
6561: l_locator_id wms_transactions_temp.to_locator_id%TYPE;

Line 6558: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

6554: l_lot_number wms_transactions_temp.lot_number%TYPE;
6555: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
6556: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
6557: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
6558: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
6559: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
6560: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
6561: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
6562: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

Line 6559: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;

6555: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
6556: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
6557: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
6558: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
6559: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
6560: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
6561: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
6562: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
6563: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

Line 6560: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;

6556: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
6557: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
6558: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
6559: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
6560: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
6561: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
6562: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
6563: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
6564: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

Line 6561: l_locator_id wms_transactions_temp.to_locator_id%TYPE;

6557: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
6558: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
6559: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
6560: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
6561: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
6562: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
6563: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
6564: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
6565: l_lpn_id wms_transactions_temp.lpn_id%TYPE;

Line 6562: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

6558: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
6559: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
6560: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
6561: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
6562: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
6563: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
6564: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
6565: l_lpn_id wms_transactions_temp.lpn_id%TYPE;
6566: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;

Line 6563: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

6559: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
6560: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
6561: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
6562: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
6563: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
6564: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
6565: l_lpn_id wms_transactions_temp.lpn_id%TYPE;
6566: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
6567: -- rule dynamic SQL output variables

Line 6564: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

6560: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
6561: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
6562: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
6563: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
6564: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
6565: l_lpn_id wms_transactions_temp.lpn_id%TYPE;
6566: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
6567: -- rule dynamic SQL output variables
6568: l_orevision wms_transactions_temp.revision%TYPE;

Line 6565: l_lpn_id wms_transactions_temp.lpn_id%TYPE;

6561: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
6562: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
6563: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
6564: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
6565: l_lpn_id wms_transactions_temp.lpn_id%TYPE;
6566: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
6567: -- rule dynamic SQL output variables
6568: l_orevision wms_transactions_temp.revision%TYPE;
6569: l_olot_number wms_transactions_temp.lot_number%TYPE;

Line 6566: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;

6562: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
6563: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
6564: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
6565: l_lpn_id wms_transactions_temp.lpn_id%TYPE;
6566: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
6567: -- rule dynamic SQL output variables
6568: l_orevision wms_transactions_temp.revision%TYPE;
6569: l_olot_number wms_transactions_temp.lot_number%TYPE;
6570: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;

Line 6568: l_orevision wms_transactions_temp.revision%TYPE;

6564: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
6565: l_lpn_id wms_transactions_temp.lpn_id%TYPE;
6566: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
6567: -- rule dynamic SQL output variables
6568: l_orevision wms_transactions_temp.revision%TYPE;
6569: l_olot_number wms_transactions_temp.lot_number%TYPE;
6570: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
6571: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
6572: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;

Line 6569: l_olot_number wms_transactions_temp.lot_number%TYPE;

6565: l_lpn_id wms_transactions_temp.lpn_id%TYPE;
6566: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
6567: -- rule dynamic SQL output variables
6568: l_orevision wms_transactions_temp.revision%TYPE;
6569: l_olot_number wms_transactions_temp.lot_number%TYPE;
6570: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
6571: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
6572: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
6573: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;

Line 6570: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;

6566: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
6567: -- rule dynamic SQL output variables
6568: l_orevision wms_transactions_temp.revision%TYPE;
6569: l_olot_number wms_transactions_temp.lot_number%TYPE;
6570: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
6571: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
6572: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
6573: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
6574: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;

Line 6571: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;

6567: -- rule dynamic SQL output variables
6568: l_orevision wms_transactions_temp.revision%TYPE;
6569: l_olot_number wms_transactions_temp.lot_number%TYPE;
6570: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
6571: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
6572: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
6573: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
6574: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
6575: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

Line 6572: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;

6568: l_orevision wms_transactions_temp.revision%TYPE;
6569: l_olot_number wms_transactions_temp.lot_number%TYPE;
6570: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
6571: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
6572: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
6573: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
6574: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
6575: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
6576: l_olpn_id wms_transactions_temp.lpn_id%TYPE;

Line 6573: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;

6569: l_olot_number wms_transactions_temp.lot_number%TYPE;
6570: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
6571: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
6572: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
6573: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
6574: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
6575: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
6576: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
6577: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;

Line 6574: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;

6570: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
6571: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
6572: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
6573: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
6574: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
6575: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
6576: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
6577: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
6578: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;

Line 6575: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

6571: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
6572: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
6573: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
6574: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
6575: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
6576: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
6577: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
6578: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
6579: l_sec_possible_quantity wms_transactions_temp.secondary_quantity%TYPE;

Line 6576: l_olpn_id wms_transactions_temp.lpn_id%TYPE;

6572: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
6573: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
6574: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
6575: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
6576: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
6577: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
6578: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
6579: l_sec_possible_quantity wms_transactions_temp.secondary_quantity%TYPE;
6580: l_sec_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;

Line 6577: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;

6573: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
6574: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
6575: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
6576: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
6577: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
6578: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
6579: l_sec_possible_quantity wms_transactions_temp.secondary_quantity%TYPE;
6580: l_sec_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
6581: l_reservation_id wms_transactions_temp.reservation_id%TYPE;

Line 6578: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;

6574: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
6575: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
6576: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
6577: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
6578: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
6579: l_sec_possible_quantity wms_transactions_temp.secondary_quantity%TYPE;
6580: l_sec_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
6581: l_reservation_id wms_transactions_temp.reservation_id%TYPE;
6582: -- variables needed for qty tree

Line 6579: l_sec_possible_quantity wms_transactions_temp.secondary_quantity%TYPE;

6575: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
6576: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
6577: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
6578: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
6579: l_sec_possible_quantity wms_transactions_temp.secondary_quantity%TYPE;
6580: l_sec_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
6581: l_reservation_id wms_transactions_temp.reservation_id%TYPE;
6582: -- variables needed for qty tree
6583: l_qoh NUMBER;

Line 6580: l_sec_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;

6576: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
6577: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
6578: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
6579: l_sec_possible_quantity wms_transactions_temp.secondary_quantity%TYPE;
6580: l_sec_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
6581: l_reservation_id wms_transactions_temp.reservation_id%TYPE;
6582: -- variables needed for qty tree
6583: l_qoh NUMBER;
6584: l_rqoh NUMBER;

Line 6581: l_reservation_id wms_transactions_temp.reservation_id%TYPE;

6577: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
6578: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
6579: l_sec_possible_quantity wms_transactions_temp.secondary_quantity%TYPE;
6580: l_sec_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
6581: l_reservation_id wms_transactions_temp.reservation_id%TYPE;
6582: -- variables needed for qty tree
6583: l_qoh NUMBER;
6584: l_rqoh NUMBER;
6585: l_qr NUMBER;

Line 6771: SELECT serial_number FROM wms_transactions_temp

6767: WHERE lpn_id = v_current_row.lpn_id;
6768:
6769: --Bug 5251221, cursor to get the serials which are allocated for the current rule
6770: CURSOR l_get_serial IS
6771: SELECT serial_number FROM wms_transactions_temp
6772: WHERE rule_id = l_rule_id;
6773:
6774:
6775: BEGIN

Line 7956: DELETE FROM wms_transactions_temp

7952: END IF;
7953: RAISE fnd_api.g_exc_error;
7954: END IF;
7955: -- delete allocations
7956: DELETE FROM wms_transactions_temp
7957: WHERE line_type_code = 2
7958: AND type_code = p_type_code;
7959: IF l_debug_on THEN
7960: l_cur_rec := g_lpns(l_cur_lpn_group).first_rec;

Line 8158: DELETE FROM wms_transactions_temp

8154: --no need to call invalidate, since we'll never see this
8155: -- LPN record again
8156:
8157: -- delete allocations
8158: DELETE FROM wms_transactions_temp
8159: WHERE line_type_code = 2
8160: AND type_code = p_type_code;
8161:
8162: IF l_debug_on THEN

Line 8802: DELETE FROM wms_transactions_temp

8798: END IF;
8799:
8800: --delete allocations
8801: --is this okay?? what if multiple input lines?
8802: DELETE FROM wms_transactions_temp
8803: WHERE line_type_code = 2
8804: AND type_code = p_type_code;
8805:
8806: IF l_debug_on THEN

Line 10511: INSERT INTO wms_transactions_temp

10507: IF l_debug = 1 THEN
10508: log_statement(l_api_name, 'insert_put_wtt_recs', 'Inserting putaway records in wtt');
10509: END IF;
10510: -- insert temporary suggestion
10511: INSERT INTO wms_transactions_temp
10512: (
10513: pp_transaction_temp_id
10514: , transaction_temp_id
10515: , type_code

Line 10535: wms_transactions_temp_s.NEXTVAL

10531: , to_cost_group_id
10532: , lpn_id
10533: )
10534: VALUES (
10535: wms_transactions_temp_s.NEXTVAL
10536: , p_transaction_temp_id
10537: , p_type_code
10538: , 2 -- line type code is output
10539: , l_possible_trx_qty

Line 10805: UPDATE wms_transactions_temp

10801: log_statement(l_api_name, 'updating_input_rec', 'Updating the input line in WTT and pl/sql table');
10802: END IF;
10803:
10804: l_needed_quantity := l_needed_quantity - l_max_tolerance;
10805: UPDATE wms_transactions_temp
10806: SET primary_quantity = l_needed_quantity
10807: , secondary_quantity = l_sec_needed_quantity
10808: WHERE pp_transaction_temp_id = l_pp_transaction_temp_id;
10809:

Line 10816: -- delete the input line in the wms_transactions_temp table

10812: END IF;
10813: ELSE
10814: x_finished := fnd_api.g_true;
10815: -- if input line could get satisfied
10816: -- delete the input line in the wms_transactions_temp table
10817: IF l_debug = 1 THEN
10818: log_statement(l_api_name, 'deleting_input_rec', 'Deleting the input line in WTT and pl/sql table');
10819: END IF;
10820:

Line 10821: DELETE FROM wms_transactions_temp

10817: IF l_debug = 1 THEN
10818: log_statement(l_api_name, 'deleting_input_rec', 'Deleting the input line in WTT and pl/sql table');
10819: END IF;
10820:
10821: DELETE FROM wms_transactions_temp
10822: WHERE pp_transaction_temp_id = l_pp_transaction_temp_id;
10823:
10824: --
10825: -- and delete input record in PL/SQL table, too

Line 11404: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%TYPE;

11400: l_cursor integer;
11401: l_rows integer;
11402: -- rule dynamic SQL input variables
11403: l_pp_transaction_temp_id
11404: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%TYPE;
11405: l_revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE;
11406: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE;
11407: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE;
11408: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;

Line 11405: l_revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE;

11401: l_rows integer;
11402: -- rule dynamic SQL input variables
11403: l_pp_transaction_temp_id
11404: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%TYPE;
11405: l_revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE;
11406: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE;
11407: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE;
11408: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
11409: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;

Line 11406: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE;

11402: -- rule dynamic SQL input variables
11403: l_pp_transaction_temp_id
11404: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%TYPE;
11405: l_revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE;
11406: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE;
11407: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE;
11408: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
11409: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;
11410: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

Line 11407: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE;

11403: l_pp_transaction_temp_id
11404: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%TYPE;
11405: l_revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE;
11406: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE;
11407: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE;
11408: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
11409: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;
11410: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11411: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;

Line 11408: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;

11404: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%TYPE;
11405: l_revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE;
11406: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE;
11407: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE;
11408: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
11409: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;
11410: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11411: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;
11412: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;

Line 11409: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;

11405: l_revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE;
11406: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE;
11407: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE;
11408: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
11409: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;
11410: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11411: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;
11412: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
11413: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%TYPE;

Line 11410: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

11406: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE;
11407: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE;
11408: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
11409: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;
11410: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11411: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;
11412: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
11413: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%TYPE;
11414: l_lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE;

Line 11411: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;

11407: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE;
11408: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
11409: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;
11410: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11411: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;
11412: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
11413: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%TYPE;
11414: l_lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE;
11415: l_initial_pri_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;

Line 11412: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;

11408: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
11409: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;
11410: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11411: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;
11412: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
11413: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%TYPE;
11414: l_lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE;
11415: l_initial_pri_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11416: -- rule dynamic SQL output variables

Line 11413: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%TYPE;

11409: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;
11410: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11411: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;
11412: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
11413: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%TYPE;
11414: l_lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE;
11415: l_initial_pri_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11416: -- rule dynamic SQL output variables
11417: l_osubinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;

Line 11414: l_lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE;

11410: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11411: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;
11412: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
11413: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%TYPE;
11414: l_lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE;
11415: l_initial_pri_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11416: -- rule dynamic SQL output variables
11417: l_osubinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
11418: l_olocator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

Line 11415: l_initial_pri_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;

11411: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;
11412: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
11413: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%TYPE;
11414: l_lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE;
11415: l_initial_pri_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11416: -- rule dynamic SQL output variables
11417: l_osubinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
11418: l_olocator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11419: l_olocator_id_prev WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

Line 11417: l_osubinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;

11413: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%TYPE;
11414: l_lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE;
11415: l_initial_pri_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11416: -- rule dynamic SQL output variables
11417: l_osubinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
11418: l_olocator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11419: l_olocator_id_prev WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11420: l_olocator_id_new WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11421: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

Line 11418: l_olocator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

11414: l_lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE;
11415: l_initial_pri_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11416: -- rule dynamic SQL output variables
11417: l_osubinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
11418: l_olocator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11419: l_olocator_id_prev WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11420: l_olocator_id_new WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11421: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11422: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;

Line 11419: l_olocator_id_prev WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

11415: l_initial_pri_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11416: -- rule dynamic SQL output variables
11417: l_osubinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
11418: l_olocator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11419: l_olocator_id_prev WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11420: l_olocator_id_new WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11421: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11422: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11423: l_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;

Line 11420: l_olocator_id_new WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

11416: -- rule dynamic SQL output variables
11417: l_osubinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
11418: l_olocator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11419: l_olocator_id_prev WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11420: l_olocator_id_new WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11421: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11422: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11423: l_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
11424: l_sec_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;

Line 11421: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

11417: l_osubinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
11418: l_olocator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11419: l_olocator_id_prev WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11420: l_olocator_id_new WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11421: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11422: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11423: l_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
11424: l_sec_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11425: l_sec_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;

Line 11422: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;

11418: l_olocator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11419: l_olocator_id_prev WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11420: l_olocator_id_new WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11421: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11422: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11423: l_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
11424: l_sec_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11425: l_sec_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
11426: l_reservation_id WMS_TRANSACTIONS_TEMP.RESERVATION_ID%TYPE;

Line 11423: l_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;

11419: l_olocator_id_prev WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11420: l_olocator_id_new WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11421: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11422: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11423: l_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
11424: l_sec_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11425: l_sec_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
11426: l_reservation_id WMS_TRANSACTIONS_TEMP.RESERVATION_ID%TYPE;
11427: l_grade_code VARCHAR2(150);

Line 11424: l_sec_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;

11420: l_olocator_id_new WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11421: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11422: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11423: l_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
11424: l_sec_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11425: l_sec_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
11426: l_reservation_id WMS_TRANSACTIONS_TEMP.RESERVATION_ID%TYPE;
11427: l_grade_code VARCHAR2(150);
11428:

Line 11425: l_sec_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;

11421: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11422: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11423: l_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
11424: l_sec_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11425: l_sec_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
11426: l_reservation_id WMS_TRANSACTIONS_TEMP.RESERVATION_ID%TYPE;
11427: l_grade_code VARCHAR2(150);
11428:
11429: l_needed_quantity NUMBER;

Line 11426: l_reservation_id WMS_TRANSACTIONS_TEMP.RESERVATION_ID%TYPE;

11422: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11423: l_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
11424: l_sec_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
11425: l_sec_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
11426: l_reservation_id WMS_TRANSACTIONS_TEMP.RESERVATION_ID%TYPE;
11427: l_grade_code VARCHAR2(150);
11428:
11429: l_needed_quantity NUMBER;
11430: l_sec_needed_quantity NUMBER;

Line 11449: x_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;

11445: l_serial_number NUMBER; -- [ new code ]
11446: use_supplied_loc BOOLEAN;
11447:
11448: l_locator_type NUMBER;
11449: x_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
11450: x_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11451: x_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
11452:
11453: --cursor to get lpn controlled flag from subinventory

Line 11450: x_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

11446: use_supplied_loc BOOLEAN;
11447:
11448: l_locator_type NUMBER;
11449: x_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
11450: x_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11451: x_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
11452:
11453: --cursor to get lpn controlled flag from subinventory
11454: CURSOR l_lpn_controlled IS

Line 11451: x_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;

11447:
11448: l_locator_type NUMBER;
11449: x_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
11450: x_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
11451: x_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
11452:
11453: --cursor to get lpn controlled flag from subinventory
11454: CURSOR l_lpn_controlled IS
11455: SELECT lpn_controlled_flag

Line 12001: INTO WMS_TRANSACTIONS_TEMP

11997: 'Inserting putaway records in wtt');
11998: End if;
11999: -- insert temporary suggestion
12000: INSERT
12001: INTO WMS_TRANSACTIONS_TEMP
12002: ( PP_TRANSACTION_TEMP_ID
12003: ,TRANSACTION_TEMP_ID
12004: ,TYPE_CODE
12005: ,LINE_TYPE_CODE

Line 12023: ( wms_transactions_temp_s.NEXTVAL

12019: ,FROM_COST_GROUP_ID
12020: ,TO_COST_GROUP_ID
12021: ,LPN_ID
12022: ) VALUES
12023: ( wms_transactions_temp_s.NEXTVAL
12024: ,p_transaction_temp_id
12025: ,1 -- p_type_code
12026: ,2 -- line type code is output
12027: ,l_possible_trx_qty

Line 12068: -- delete the input line in the wms_transactions_temp table

12064:
12065: ELSE
12066: x_finished := fnd_api.g_true;
12067: -- if input line could get satisfied
12068: -- delete the input line in the wms_transactions_temp table
12069: If (l_debug = 1) then
12070: log_statement(l_api_name, 'deleting_input_rec',
12071: 'Deleting the input line in WTT and pl/sql table');
12072: End if;

Line 12074: FROM WMS_TRANSACTIONS_TEMP

12070: log_statement(l_api_name, 'deleting_input_rec',
12071: 'Deleting the input line in WTT and pl/sql table');
12072: End if;
12073: DELETE
12074: FROM WMS_TRANSACTIONS_TEMP
12075: WHERE pp_transaction_temp_id = l_pp_transaction_temp_id;
12076: --
12077: -- and delete input record in PL/SQL table, too
12078: wms_re_common_pvt.DeleteInputLine;

Line 12540: l_revision wms_transactions_temp.revision%TYPE;

12536: l_cursor INTEGER;
12537: l_rows INTEGER;
12538: --
12539: -- rule dynamic SQL output variables
12540: l_revision wms_transactions_temp.revision%TYPE;
12541: l_lot_number wms_transactions_temp.lot_number%TYPE;
12542: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
12543: l_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
12544: l_locator_id wms_transactions_temp.from_locator_id%TYPE;

Line 12541: l_lot_number wms_transactions_temp.lot_number%TYPE;

12537: l_rows INTEGER;
12538: --
12539: -- rule dynamic SQL output variables
12540: l_revision wms_transactions_temp.revision%TYPE;
12541: l_lot_number wms_transactions_temp.lot_number%TYPE;
12542: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
12543: l_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
12544: l_locator_id wms_transactions_temp.from_locator_id%TYPE;
12545: l_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

Line 12542: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;

12538: --
12539: -- rule dynamic SQL output variables
12540: l_revision wms_transactions_temp.revision%TYPE;
12541: l_lot_number wms_transactions_temp.lot_number%TYPE;
12542: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
12543: l_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
12544: l_locator_id wms_transactions_temp.from_locator_id%TYPE;
12545: l_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
12546: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;

Line 12543: l_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;

12539: -- rule dynamic SQL output variables
12540: l_revision wms_transactions_temp.revision%TYPE;
12541: l_lot_number wms_transactions_temp.lot_number%TYPE;
12542: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
12543: l_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
12544: l_locator_id wms_transactions_temp.from_locator_id%TYPE;
12545: l_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
12546: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
12547: --

Line 12544: l_locator_id wms_transactions_temp.from_locator_id%TYPE;

12540: l_revision wms_transactions_temp.revision%TYPE;
12541: l_lot_number wms_transactions_temp.lot_number%TYPE;
12542: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
12543: l_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
12544: l_locator_id wms_transactions_temp.from_locator_id%TYPE;
12545: l_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
12546: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
12547: --
12548: -- other variables

Line 12545: l_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

12541: l_lot_number wms_transactions_temp.lot_number%TYPE;
12542: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
12543: l_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
12544: l_locator_id wms_transactions_temp.from_locator_id%TYPE;
12545: l_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
12546: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
12547: --
12548: -- other variables
12549: l_type_code wms_rules_b.type_code%TYPE;

Line 12546: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;

12542: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
12543: l_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
12544: l_locator_id wms_transactions_temp.from_locator_id%TYPE;
12545: l_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
12546: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
12547: --
12548: -- other variables
12549: l_type_code wms_rules_b.type_code%TYPE;
12550: l_package_name VARCHAR2(128);

Line 15025: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE; --

15021: l_debug_on BOOLEAN;
15022:
15023: -- input variables
15024:
15025: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE; --
15026: l_revision wms_transactions_temp.revision%TYPE; --
15027: l_lot_number wms_transactions_temp.lot_number%TYPE; --
15028: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE; --
15029: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE; --

Line 15026: l_revision wms_transactions_temp.revision%TYPE; --

15022:
15023: -- input variables
15024:
15025: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE; --
15026: l_revision wms_transactions_temp.revision%TYPE; --
15027: l_lot_number wms_transactions_temp.lot_number%TYPE; --
15028: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE; --
15029: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE; --
15030: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE; --

Line 15027: l_lot_number wms_transactions_temp.lot_number%TYPE; --

15023: -- input variables
15024:
15025: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE; --
15026: l_revision wms_transactions_temp.revision%TYPE; --
15027: l_lot_number wms_transactions_temp.lot_number%TYPE; --
15028: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE; --
15029: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE; --
15030: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE; --
15031: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

Line 15028: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE; --

15024:
15025: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE; --
15026: l_revision wms_transactions_temp.revision%TYPE; --
15027: l_lot_number wms_transactions_temp.lot_number%TYPE; --
15028: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE; --
15029: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE; --
15030: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE; --
15031: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15032: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE; --

Line 15029: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE; --

15025: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE; --
15026: l_revision wms_transactions_temp.revision%TYPE; --
15027: l_lot_number wms_transactions_temp.lot_number%TYPE; --
15028: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE; --
15029: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE; --
15030: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE; --
15031: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15032: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE; --
15033: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE; --

Line 15030: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE; --

15026: l_revision wms_transactions_temp.revision%TYPE; --
15027: l_lot_number wms_transactions_temp.lot_number%TYPE; --
15028: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE; --
15029: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE; --
15030: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE; --
15031: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15032: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE; --
15033: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE; --
15034: l_locator_id wms_transactions_temp.to_locator_id%TYPE;

Line 15031: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

15027: l_lot_number wms_transactions_temp.lot_number%TYPE; --
15028: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE; --
15029: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE; --
15030: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE; --
15031: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15032: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE; --
15033: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE; --
15034: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
15035: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE; --

Line 15032: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE; --

15028: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE; --
15029: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE; --
15030: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE; --
15031: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15032: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE; --
15033: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE; --
15034: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
15035: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE; --
15036: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE; --

Line 15033: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE; --

15029: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE; --
15030: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE; --
15031: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15032: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE; --
15033: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE; --
15034: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
15035: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE; --
15036: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE; --
15037: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

Line 15034: l_locator_id wms_transactions_temp.to_locator_id%TYPE;

15030: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE; --
15031: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15032: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE; --
15033: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE; --
15034: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
15035: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE; --
15036: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE; --
15037: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15038: l_lpn_id wms_transactions_temp.lpn_id%TYPE; --

Line 15035: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE; --

15031: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15032: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE; --
15033: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE; --
15034: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
15035: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE; --
15036: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE; --
15037: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15038: l_lpn_id wms_transactions_temp.lpn_id%TYPE; --
15039: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;

Line 15036: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE; --

15032: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE; --
15033: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE; --
15034: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
15035: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE; --
15036: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE; --
15037: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15038: l_lpn_id wms_transactions_temp.lpn_id%TYPE; --
15039: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
15040:

Line 15037: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

15033: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE; --
15034: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
15035: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE; --
15036: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE; --
15037: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15038: l_lpn_id wms_transactions_temp.lpn_id%TYPE; --
15039: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
15040:
15041: l_reservation_id NUMBER; --

Line 15038: l_lpn_id wms_transactions_temp.lpn_id%TYPE; --

15034: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
15035: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE; --
15036: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE; --
15037: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15038: l_lpn_id wms_transactions_temp.lpn_id%TYPE; --
15039: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
15040:
15041: l_reservation_id NUMBER; --
15042: l_needed_quantity NUMBER; --

Line 15039: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;

15035: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE; --
15036: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE; --
15037: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15038: l_lpn_id wms_transactions_temp.lpn_id%TYPE; --
15039: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
15040:
15041: l_reservation_id NUMBER; --
15042: l_needed_quantity NUMBER; --
15043: l_sec_needed_quantity NUMBER; -- -- new

Line 15657: -- WMS_TRANSACTIONS_TEMP, respectively );

15653: -- At least one transaction detail record in
15654: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
15655: -- and parameters p_transaction_temp_id and p_type_code
15656: -- ( base tables are MTL_MATERIAL_TRANSACTIONS_TEMP and
15657: -- WMS_TRANSACTIONS_TEMP, respectively );
15658: -- Rule record has to exist in WMS_RULES_B uniquely
15659: -- identified by parameter p_rule_id;
15660: -- Package WMS_RULE_(RULEID) must exist;
15661: -- If picking, quantity tree has to exist, created through

Line 15738: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;

15734: -- variables needed for dynamic SQL
15735: l_cursor INTEGER;
15736: l_rows INTEGER;
15737: -- rule dynamic SQL input variables
15738: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
15739: l_revision wms_transactions_temp.revision%TYPE := null;
15740: l_lot_number wms_transactions_temp.lot_number%TYPE := null;
15741: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15742: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;

Line 15739: l_revision wms_transactions_temp.revision%TYPE := null;

15735: l_cursor INTEGER;
15736: l_rows INTEGER;
15737: -- rule dynamic SQL input variables
15738: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
15739: l_revision wms_transactions_temp.revision%TYPE := null;
15740: l_lot_number wms_transactions_temp.lot_number%TYPE := null;
15741: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15742: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15743: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

Line 15740: l_lot_number wms_transactions_temp.lot_number%TYPE := null;

15736: l_rows INTEGER;
15737: -- rule dynamic SQL input variables
15738: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
15739: l_revision wms_transactions_temp.revision%TYPE := null;
15740: l_lot_number wms_transactions_temp.lot_number%TYPE := null;
15741: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15742: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15743: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15744: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

Line 15741: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;

15737: -- rule dynamic SQL input variables
15738: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
15739: l_revision wms_transactions_temp.revision%TYPE := null;
15740: l_lot_number wms_transactions_temp.lot_number%TYPE := null;
15741: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15742: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15743: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15744: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15745: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;

Line 15742: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;

15738: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
15739: l_revision wms_transactions_temp.revision%TYPE := null;
15740: l_lot_number wms_transactions_temp.lot_number%TYPE := null;
15741: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15742: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15743: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15744: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15745: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
15746: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;

Line 15743: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

15739: l_revision wms_transactions_temp.revision%TYPE := null;
15740: l_lot_number wms_transactions_temp.lot_number%TYPE := null;
15741: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15742: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15743: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15744: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15745: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
15746: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
15747: l_locator_id wms_transactions_temp.to_locator_id%TYPE;

Line 15744: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

15740: l_lot_number wms_transactions_temp.lot_number%TYPE := null;
15741: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15742: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15743: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15744: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15745: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
15746: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
15747: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
15748: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

Line 15745: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;

15741: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15742: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15743: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15744: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15745: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
15746: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
15747: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
15748: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15749: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

Line 15746: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;

15742: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15743: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15744: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15745: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
15746: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
15747: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
15748: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15749: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15750: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

Line 15747: l_locator_id wms_transactions_temp.to_locator_id%TYPE;

15743: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15744: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15745: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
15746: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
15747: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
15748: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15749: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15750: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15751: l_lpn_id wms_transactions_temp.lpn_id%TYPE := null;

Line 15748: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

15744: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
15745: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
15746: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
15747: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
15748: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15749: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15750: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15751: l_lpn_id wms_transactions_temp.lpn_id%TYPE := null;
15752: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;

Line 15749: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

15745: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
15746: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
15747: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
15748: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15749: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15750: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15751: l_lpn_id wms_transactions_temp.lpn_id%TYPE := null;
15752: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
15753: -- rule dynamic SQL output variables

Line 15750: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

15746: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
15747: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
15748: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15749: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15750: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15751: l_lpn_id wms_transactions_temp.lpn_id%TYPE := null;
15752: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
15753: -- rule dynamic SQL output variables
15754: l_orevision wms_transactions_temp.revision%TYPE;

Line 15751: l_lpn_id wms_transactions_temp.lpn_id%TYPE := null;

15747: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
15748: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15749: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15750: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15751: l_lpn_id wms_transactions_temp.lpn_id%TYPE := null;
15752: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
15753: -- rule dynamic SQL output variables
15754: l_orevision wms_transactions_temp.revision%TYPE;
15755: l_olot_number wms_transactions_temp.lot_number%TYPE;

Line 15752: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;

15748: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15749: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15750: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15751: l_lpn_id wms_transactions_temp.lpn_id%TYPE := null;
15752: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
15753: -- rule dynamic SQL output variables
15754: l_orevision wms_transactions_temp.revision%TYPE;
15755: l_olot_number wms_transactions_temp.lot_number%TYPE;
15756: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;

Line 15754: l_orevision wms_transactions_temp.revision%TYPE;

15750: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
15751: l_lpn_id wms_transactions_temp.lpn_id%TYPE := null;
15752: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
15753: -- rule dynamic SQL output variables
15754: l_orevision wms_transactions_temp.revision%TYPE;
15755: l_olot_number wms_transactions_temp.lot_number%TYPE;
15756: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15757: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15758: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;

Line 15755: l_olot_number wms_transactions_temp.lot_number%TYPE;

15751: l_lpn_id wms_transactions_temp.lpn_id%TYPE := null;
15752: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
15753: -- rule dynamic SQL output variables
15754: l_orevision wms_transactions_temp.revision%TYPE;
15755: l_olot_number wms_transactions_temp.lot_number%TYPE;
15756: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15757: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15758: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
15759: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;

Line 15756: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;

15752: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
15753: -- rule dynamic SQL output variables
15754: l_orevision wms_transactions_temp.revision%TYPE;
15755: l_olot_number wms_transactions_temp.lot_number%TYPE;
15756: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15757: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15758: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
15759: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
15760: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;

Line 15757: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;

15753: -- rule dynamic SQL output variables
15754: l_orevision wms_transactions_temp.revision%TYPE;
15755: l_olot_number wms_transactions_temp.lot_number%TYPE;
15756: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15757: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15758: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
15759: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
15760: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
15761: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

Line 15758: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;

15754: l_orevision wms_transactions_temp.revision%TYPE;
15755: l_olot_number wms_transactions_temp.lot_number%TYPE;
15756: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15757: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15758: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
15759: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
15760: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
15761: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15762: l_olpn_id wms_transactions_temp.lpn_id%TYPE;

Line 15759: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;

15755: l_olot_number wms_transactions_temp.lot_number%TYPE;
15756: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15757: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15758: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
15759: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
15760: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
15761: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15762: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
15763: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;

Line 15760: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;

15756: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15757: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15758: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
15759: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
15760: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
15761: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15762: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
15763: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
15764: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;

Line 15761: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

15757: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15758: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
15759: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
15760: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
15761: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15762: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
15763: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
15764: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
15765: l_reservation_id wms_transactions_temp.reservation_id%TYPE;

Line 15762: l_olpn_id wms_transactions_temp.lpn_id%TYPE;

15758: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
15759: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
15760: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
15761: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15762: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
15763: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
15764: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
15765: l_reservation_id wms_transactions_temp.reservation_id%TYPE;
15766: -- variables needed for qty tree

Line 15763: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;

15759: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
15760: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
15761: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15762: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
15763: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
15764: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
15765: l_reservation_id wms_transactions_temp.reservation_id%TYPE;
15766: -- variables needed for qty tree
15767: l_qoh NUMBER;

Line 15764: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;

15760: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
15761: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15762: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
15763: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
15764: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
15765: l_reservation_id wms_transactions_temp.reservation_id%TYPE;
15766: -- variables needed for qty tree
15767: l_qoh NUMBER;
15768: l_rqoh NUMBER;

Line 15765: l_reservation_id wms_transactions_temp.reservation_id%TYPE;

15761: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15762: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
15763: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
15764: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
15765: l_reservation_id wms_transactions_temp.reservation_id%TYPE;
15766: -- variables needed for qty tree
15767: l_qoh NUMBER;
15768: l_rqoh NUMBER;
15769: l_qr NUMBER;