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 61: g_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;

57: g_locator INV_VALIDATE.locator;
58: g_transaction_type_id NUMBER;
59: g_organization_id NUMBER;
60: g_inventory_item_id NUMBER;
61: g_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
62: g_allowed VARCHAR2(1);
63: g_st_locator_id NUMBER;
64: g_lpn_controlled_flag NUMBER;
65:

Line 875: revision wms_transactions_temp.revision%TYPE

871: -- This records are stored in an array, but are accessed like linked
872: -- lists. Each record contains the index of the next record
873: -- that should be looked at (next_rec).
874: TYPE t_location_rec IS RECORD(
875: revision wms_transactions_temp.revision%TYPE
876: , lot_number wms_transactions_temp.lot_number%TYPE
877: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
878: , subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
879: , locator_id wms_transactions_temp.from_locator_id%TYPE

Line 876: , lot_number wms_transactions_temp.lot_number%TYPE

872: -- lists. Each record contains the index of the next record
873: -- that should be looked at (next_rec).
874: TYPE t_location_rec IS RECORD(
875: revision wms_transactions_temp.revision%TYPE
876: , lot_number wms_transactions_temp.lot_number%TYPE
877: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
878: , subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
879: , locator_id wms_transactions_temp.from_locator_id%TYPE
880: , cost_group_id wms_transactions_temp.from_cost_group_id%TYPE

Line 877: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE

873: -- that should be looked at (next_rec).
874: TYPE t_location_rec IS RECORD(
875: revision wms_transactions_temp.revision%TYPE
876: , lot_number wms_transactions_temp.lot_number%TYPE
877: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
878: , subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
879: , locator_id wms_transactions_temp.from_locator_id%TYPE
880: , cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
881: , uom_code VARCHAR2(3)

Line 878: , subinventory_code wms_transactions_temp.from_subinventory_code%TYPE

874: TYPE t_location_rec IS RECORD(
875: revision wms_transactions_temp.revision%TYPE
876: , lot_number wms_transactions_temp.lot_number%TYPE
877: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
878: , subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
879: , locator_id wms_transactions_temp.from_locator_id%TYPE
880: , cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
881: , uom_code VARCHAR2(3)
882: , lpn_id NUMBER

Line 879: , locator_id wms_transactions_temp.from_locator_id%TYPE

875: revision wms_transactions_temp.revision%TYPE
876: , lot_number wms_transactions_temp.lot_number%TYPE
877: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
878: , subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
879: , locator_id wms_transactions_temp.from_locator_id%TYPE
880: , cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
881: , uom_code VARCHAR2(3)
882: , lpn_id NUMBER
883: , serial_number VARCHAR2(30)

Line 880: , cost_group_id wms_transactions_temp.from_cost_group_id%TYPE

876: , lot_number wms_transactions_temp.lot_number%TYPE
877: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
878: , subinventory_code wms_transactions_temp.from_subinventory_code%TYPE
879: , locator_id wms_transactions_temp.from_locator_id%TYPE
880: , cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
881: , uom_code VARCHAR2(3)
882: , lpn_id NUMBER
883: , serial_number VARCHAR2(30)
884: , quantity wms_transactions_temp.primary_quantity%TYPE

Line 884: , quantity wms_transactions_temp.primary_quantity%TYPE

880: , cost_group_id wms_transactions_temp.from_cost_group_id%TYPE
881: , uom_code VARCHAR2(3)
882: , lpn_id NUMBER
883: , serial_number VARCHAR2(30)
884: , quantity wms_transactions_temp.primary_quantity%TYPE
885: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
886: , grade_code wms_transactions_temp.grade_code%TYPE
887: , secondary_uom_code VARCHAR2(3)
888: , consist_string VARCHAR2(1000)

Line 885: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE

881: , uom_code VARCHAR2(3)
882: , lpn_id NUMBER
883: , serial_number VARCHAR2(30)
884: , quantity wms_transactions_temp.primary_quantity%TYPE
885: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
886: , grade_code wms_transactions_temp.grade_code%TYPE
887: , secondary_uom_code VARCHAR2(3)
888: , consist_string VARCHAR2(1000)
889: , order_by_string VARCHAR2(1000)

Line 886: , grade_code wms_transactions_temp.grade_code%TYPE

882: , lpn_id NUMBER
883: , serial_number VARCHAR2(30)
884: , quantity wms_transactions_temp.primary_quantity%TYPE
885: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
886: , grade_code wms_transactions_temp.grade_code%TYPE
887: , secondary_uom_code VARCHAR2(3)
888: , consist_string VARCHAR2(1000)
889: , order_by_string VARCHAR2(1000)
890: , next_rec NUMBER);

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

1459: END IF;
1460: /* 2/21/02 - no longer need these args, since put and pick packages
1461: * are not build differently
1462: * else --put away
1463: * --for put, get cost group from wms_transactions_temp,
1464: * -- not input table (wms_trx_details_tmp_v)
1465: * g_base_select := g_base_select ||',NULL cost_group_id'
1466: * || g_line_feed;
1467: * g_base_select := g_base_select ||',NULL uom_code'

Line 4462: FROM wms_transactions_temp

4458: -- type_code 1 = put away; line_type_code 2 = output
4459: CURSOR l_output_lines IS
4460: SELECT to_locator_id
4461: , SUM(primary_quantity) quantity
4462: FROM wms_transactions_temp
4463: WHERE type_code = 1
4464: AND line_type_code = 2
4465: GROUP BY to_locator_id;
4466: BEGIN

Line 5888: FROM wms_transactions_temp

5884: l_already_allocated_pri_qty := 0;
5885: l_already_allocated_sec_qty := 0;
5886: SELECT SUM(primary_quantity), SUM(secondary_quantity)
5887: INTO l_already_allocated_pri_qty, l_already_allocated_sec_qty
5888: FROM wms_transactions_temp
5889: WHERE transaction_temp_id = p_transaction_temp_id
5890: AND type_code = 2
5891: AND line_type_code = 2 ;
5892:

Line 6310: INSERT INTO wms_transactions_temp

6306: OR l_lot_control_code = 1
6307: OR p_simulation_mode = wms_engine_pvt.g_no_simulation
6308: THEN
6309: -- insert temporary suggestion
6310: INSERT INTO wms_transactions_temp
6311: ( pp_transaction_temp_id
6312: , transaction_temp_id
6313: , type_code
6314: , line_type_code

Line 6333: VALUES ( wms_transactions_temp_s.NEXTVAL

6329: , from_cost_group_id
6330: , to_cost_group_id
6331: , lpn_id
6332: )
6333: VALUES ( wms_transactions_temp_s.NEXTVAL
6334: , p_transaction_temp_id
6335: , p_type_code
6336: , 2 -- line type code is output
6337: , l_possible_trx_qty

Line 6360: FROM wms_transactions_temp

6356: -- Start changes for 14699845 (Flexible lot allocation)
6357: BEGIN
6358: SELECT pp_transaction_temp_id
6359: INTO l_transaction_temp_id
6360: FROM wms_transactions_temp
6361: WHERE transaction_temp_id = p_transaction_temp_id
6362: AND type_code = p_type_code
6363: AND line_type_code = 2
6364: AND NVL(grade_code, '-9999') = NVL(g_locs(p_record_id).grade_code, '-9999')

Line 6380: UPDATE wms_transactions_temp

6376: AND NVL(to_cost_group_id, '-9999') = NVL(p_to_cost_group_id, '-9999')
6377: AND NVL(lpn_id, '-9999') = NVL(g_locs(p_record_id).lpn_id, '-9999')
6378: AND ROWNUM < 2;
6379:
6380: UPDATE wms_transactions_temp
6381: SET transaction_quantity = NVL(transaction_quantity, 0) + NVL(l_possible_trx_qty, 0),
6382: primary_quantity = NVL(primary_quantity, 0) + NVL(l_allocation_quantity, 0),
6383: secondary_quantity = NVL(secondary_quantity, 0) + NVL(l_sallocation_quantity, 0)
6384: WHERE pp_transaction_temp_id = l_transaction_temp_id;

Line 6387: INSERT INTO wms_transactions_temp

6383: secondary_quantity = NVL(secondary_quantity, 0) + NVL(l_sallocation_quantity, 0)
6384: WHERE pp_transaction_temp_id = l_transaction_temp_id;
6385: EXCEPTION
6386: WHEN NO_DATA_FOUND THEN
6387: INSERT INTO wms_transactions_temp
6388: ( pp_transaction_temp_id
6389: , transaction_temp_id
6390: , type_code
6391: , line_type_code

Line 6410: VALUES ( wms_transactions_temp_s.NEXTVAL

6406: , from_cost_group_id
6407: , to_cost_group_id
6408: , lpn_id
6409: )
6410: VALUES ( wms_transactions_temp_s.NEXTVAL
6411: , p_transaction_temp_id
6412: , p_type_code
6413: , 2 -- line type code is output
6414: , l_possible_trx_qty

Line 7045: INSERT INTO wms_transactions_temp

7041: IF l_debug = 1 THEN
7042: log_statement(l_api_name, 'insert_wtt_rec', 'Inserting wtt recs. Trx Qty: ' || l_possible_trx_qty);
7043: END IF;
7044: -- insert temporary suggestion
7045: INSERT INTO wms_transactions_temp
7046: (
7047: pp_transaction_temp_id
7048: , transaction_temp_id
7049: , type_code

Line 7068: wms_transactions_temp_s.NEXTVAL

7064: , to_cost_group_id
7065: , lpn_id
7066: )
7067: VALUES (
7068: wms_transactions_temp_s.NEXTVAL
7069: , p_transaction_temp_id
7070: , p_type_code
7071: , 2 -- line type code is output
7072: , l_possible_trx_qty

Line 7240: DELETE FROM wms_transactions_temp

7236: END IF ;
7237: END LOOP;
7238: END IF;
7239:
7240: DELETE FROM wms_transactions_temp
7241: WHERE line_type_code = 2
7242: AND type_code = p_type_code;
7243: IF l_debug = 1 THEN
7244: log_statement(l_api_name, 'finish_delete_sugs', 'Finished deleting suggestions and restored quantity tree');

Line 8432: -- WMS_TRANSACTIONS_TEMP, respectively );

8428: -- At least one transaction detail record in
8429: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
8430: -- and parameters p_transaction_temp_id and p_type_code
8431: -- ( base tables are MTL_MATERIAL_TRANSACTIONS_TEMP and
8432: -- WMS_TRANSACTIONS_TEMP, respectively );
8433: -- Rule record has to exist in WMS_RULES_B uniquely
8434: -- identified by parameter p_rule_id;
8435: -- Package WMS_RULE_(RULEID) must exist;
8436: -- If picking, quantity tree has to exist, created through

Line 8516: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;

8512: -- variables needed for dynamic SQL
8513: l_cursor INTEGER;
8514: l_rows INTEGER;
8515: -- rule dynamic SQL input variables
8516: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
8517: l_revision wms_transactions_temp.revision%TYPE;
8518: l_lot_number wms_transactions_temp.lot_number%TYPE;
8519: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
8520: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;

Line 8517: l_revision wms_transactions_temp.revision%TYPE;

8513: l_cursor INTEGER;
8514: l_rows INTEGER;
8515: -- rule dynamic SQL input variables
8516: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
8517: l_revision wms_transactions_temp.revision%TYPE;
8518: l_lot_number wms_transactions_temp.lot_number%TYPE;
8519: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
8520: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
8521: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

Line 8518: l_lot_number wms_transactions_temp.lot_number%TYPE;

8514: l_rows INTEGER;
8515: -- rule dynamic SQL input variables
8516: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
8517: l_revision wms_transactions_temp.revision%TYPE;
8518: l_lot_number wms_transactions_temp.lot_number%TYPE;
8519: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
8520: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
8521: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
8522: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

Line 8519: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;

8515: -- rule dynamic SQL input variables
8516: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
8517: l_revision wms_transactions_temp.revision%TYPE;
8518: l_lot_number wms_transactions_temp.lot_number%TYPE;
8519: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
8520: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
8521: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
8522: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
8523: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;

Line 8520: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;

8516: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
8517: l_revision wms_transactions_temp.revision%TYPE;
8518: l_lot_number wms_transactions_temp.lot_number%TYPE;
8519: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
8520: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
8521: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
8522: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
8523: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
8524: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;

Line 8521: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

8517: l_revision wms_transactions_temp.revision%TYPE;
8518: l_lot_number wms_transactions_temp.lot_number%TYPE;
8519: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
8520: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
8521: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
8522: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
8523: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
8524: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
8525: l_locator_id wms_transactions_temp.to_locator_id%TYPE;

Line 8522: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

8518: l_lot_number wms_transactions_temp.lot_number%TYPE;
8519: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
8520: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
8521: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
8522: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
8523: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
8524: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
8525: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
8526: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

Line 8523: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;

8519: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
8520: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
8521: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
8522: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
8523: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
8524: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
8525: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
8526: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
8527: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

Line 8524: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;

8520: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
8521: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
8522: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
8523: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
8524: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
8525: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
8526: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
8527: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
8528: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

Line 8525: l_locator_id wms_transactions_temp.to_locator_id%TYPE;

8521: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
8522: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
8523: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
8524: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
8525: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
8526: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
8527: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
8528: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
8529: l_lpn_id wms_transactions_temp.lpn_id%TYPE;

Line 8526: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

8522: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
8523: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
8524: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
8525: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
8526: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
8527: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
8528: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
8529: l_lpn_id wms_transactions_temp.lpn_id%TYPE;
8530: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;

Line 8527: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

8523: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
8524: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
8525: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
8526: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
8527: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
8528: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
8529: l_lpn_id wms_transactions_temp.lpn_id%TYPE;
8530: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
8531: l_initial_sec_quantity wms_transactions_temp.secondary_quantity%TYPE;

Line 8528: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

8524: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
8525: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
8526: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
8527: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
8528: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
8529: l_lpn_id wms_transactions_temp.lpn_id%TYPE;
8530: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
8531: l_initial_sec_quantity wms_transactions_temp.secondary_quantity%TYPE;
8532: -- rule dynamic SQL output variables

Line 8529: l_lpn_id wms_transactions_temp.lpn_id%TYPE;

8525: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
8526: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
8527: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
8528: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
8529: l_lpn_id wms_transactions_temp.lpn_id%TYPE;
8530: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
8531: l_initial_sec_quantity wms_transactions_temp.secondary_quantity%TYPE;
8532: -- rule dynamic SQL output variables
8533: l_orevision wms_transactions_temp.revision%TYPE;

Line 8530: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;

8526: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
8527: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
8528: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
8529: l_lpn_id wms_transactions_temp.lpn_id%TYPE;
8530: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
8531: l_initial_sec_quantity wms_transactions_temp.secondary_quantity%TYPE;
8532: -- rule dynamic SQL output variables
8533: l_orevision wms_transactions_temp.revision%TYPE;
8534: l_olot_number wms_transactions_temp.lot_number%TYPE;

Line 8531: l_initial_sec_quantity wms_transactions_temp.secondary_quantity%TYPE;

8527: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
8528: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
8529: l_lpn_id wms_transactions_temp.lpn_id%TYPE;
8530: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
8531: l_initial_sec_quantity wms_transactions_temp.secondary_quantity%TYPE;
8532: -- rule dynamic SQL output variables
8533: l_orevision wms_transactions_temp.revision%TYPE;
8534: l_olot_number wms_transactions_temp.lot_number%TYPE;
8535: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;

Line 8533: l_orevision wms_transactions_temp.revision%TYPE;

8529: l_lpn_id wms_transactions_temp.lpn_id%TYPE;
8530: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
8531: l_initial_sec_quantity wms_transactions_temp.secondary_quantity%TYPE;
8532: -- rule dynamic SQL output variables
8533: l_orevision wms_transactions_temp.revision%TYPE;
8534: l_olot_number wms_transactions_temp.lot_number%TYPE;
8535: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
8536: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
8537: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;

Line 8534: l_olot_number wms_transactions_temp.lot_number%TYPE;

8530: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
8531: l_initial_sec_quantity wms_transactions_temp.secondary_quantity%TYPE;
8532: -- rule dynamic SQL output variables
8533: l_orevision wms_transactions_temp.revision%TYPE;
8534: l_olot_number wms_transactions_temp.lot_number%TYPE;
8535: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
8536: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
8537: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
8538: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;

Line 8535: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;

8531: l_initial_sec_quantity wms_transactions_temp.secondary_quantity%TYPE;
8532: -- rule dynamic SQL output variables
8533: l_orevision wms_transactions_temp.revision%TYPE;
8534: l_olot_number wms_transactions_temp.lot_number%TYPE;
8535: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
8536: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
8537: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
8538: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
8539: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;

Line 8536: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;

8532: -- rule dynamic SQL output variables
8533: l_orevision wms_transactions_temp.revision%TYPE;
8534: l_olot_number wms_transactions_temp.lot_number%TYPE;
8535: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
8536: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
8537: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
8538: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
8539: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
8540: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

Line 8537: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;

8533: l_orevision wms_transactions_temp.revision%TYPE;
8534: l_olot_number wms_transactions_temp.lot_number%TYPE;
8535: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
8536: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
8537: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
8538: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
8539: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
8540: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
8541: l_olpn_id wms_transactions_temp.lpn_id%TYPE;

Line 8538: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;

8534: l_olot_number wms_transactions_temp.lot_number%TYPE;
8535: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
8536: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
8537: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
8538: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
8539: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
8540: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
8541: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
8542: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;

Line 8539: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;

8535: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
8536: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
8537: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
8538: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
8539: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
8540: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
8541: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
8542: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
8543: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;

Line 8540: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

8536: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
8537: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
8538: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
8539: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
8540: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
8541: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
8542: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
8543: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
8544: l_sec_possible_quantity wms_transactions_temp.secondary_quantity%TYPE;

Line 8541: l_olpn_id wms_transactions_temp.lpn_id%TYPE;

8537: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
8538: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
8539: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
8540: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
8541: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
8542: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
8543: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
8544: l_sec_possible_quantity wms_transactions_temp.secondary_quantity%TYPE;
8545: l_reservation_id wms_transactions_temp.reservation_id%TYPE;

Line 8542: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;

8538: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
8539: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
8540: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
8541: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
8542: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
8543: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
8544: l_sec_possible_quantity wms_transactions_temp.secondary_quantity%TYPE;
8545: l_reservation_id wms_transactions_temp.reservation_id%TYPE;
8546: -- variables needed for qty tree

Line 8543: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;

8539: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
8540: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
8541: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
8542: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
8543: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
8544: l_sec_possible_quantity wms_transactions_temp.secondary_quantity%TYPE;
8545: l_reservation_id wms_transactions_temp.reservation_id%TYPE;
8546: -- variables needed for qty tree
8547: l_qoh NUMBER;

Line 8544: l_sec_possible_quantity wms_transactions_temp.secondary_quantity%TYPE;

8540: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
8541: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
8542: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
8543: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
8544: l_sec_possible_quantity wms_transactions_temp.secondary_quantity%TYPE;
8545: l_reservation_id wms_transactions_temp.reservation_id%TYPE;
8546: -- variables needed for qty tree
8547: l_qoh NUMBER;
8548: l_rqoh NUMBER;

Line 8545: l_reservation_id wms_transactions_temp.reservation_id%TYPE;

8541: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
8542: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
8543: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
8544: l_sec_possible_quantity wms_transactions_temp.secondary_quantity%TYPE;
8545: l_reservation_id wms_transactions_temp.reservation_id%TYPE;
8546: -- variables needed for qty tree
8547: l_qoh NUMBER;
8548: l_rqoh NUMBER;
8549: l_qr NUMBER;

Line 8710: SELECT serial_number FROM wms_transactions_temp

8706: WHERE lpn_id = v_current_row.lpn_id;
8707:
8708: --Bug 5251221, cursor to get the serials which are allocated for the current rule
8709: CURSOR l_get_serial IS
8710: SELECT serial_number FROM wms_transactions_temp
8711: WHERE rule_id = l_rule_id;
8712:
8713:
8714: BEGIN

Line 10015: DELETE FROM wms_transactions_temp

10011: RAISE fnd_api.g_exc_error;
10012: END IF;
10013:
10014: -- delete allocations
10015: DELETE FROM wms_transactions_temp
10016: WHERE line_type_code = 2
10017: AND type_code = p_type_code;
10018:
10019: IF l_debug_on THEN

Line 10302: DELETE FROM wms_transactions_temp

10298: -- no need to call invalidate, since we'll never see this
10299: -- LPN record again
10300:
10301: -- delete allocations
10302: DELETE FROM wms_transactions_temp
10303: WHERE line_type_code = 2
10304: AND type_code = p_type_code;
10305:
10306: IF l_debug_on THEN

Line 11015: DELETE FROM wms_transactions_temp

11011: END IF;
11012:
11013: -- delete allocations
11014: -- is this okay?? what if multiple input lines?
11015: DELETE FROM wms_transactions_temp
11016: WHERE line_type_code = 2
11017: AND type_code = p_type_code;
11018:
11019: IF l_debug_on THEN

Line 13019: INSERT INTO wms_transactions_temp

13015: IF l_debug = 1 THEN
13016: log_statement(l_api_name, 'insert_put_wtt_recs', 'Inserting putaway records in wtt');
13017: END IF;
13018: -- insert temporary suggestion
13019: INSERT INTO wms_transactions_temp
13020: (
13021: pp_transaction_temp_id
13022: , transaction_temp_id
13023: , type_code

Line 13043: wms_transactions_temp_s.NEXTVAL

13039: , to_cost_group_id
13040: , lpn_id
13041: )
13042: VALUES (
13043: wms_transactions_temp_s.NEXTVAL
13044: , p_transaction_temp_id
13045: , p_type_code
13046: , 2 -- line type code is output
13047: , l_possible_trx_qty

Line 13344: UPDATE wms_transactions_temp

13340: END IF;
13341:
13342: l_needed_quantity := l_needed_quantity - l_max_tolerance;
13343: l_sec_needed_quantity := l_sec_needed_quantity - l_max_sec_tolerance;
13344: UPDATE wms_transactions_temp
13345: SET primary_quantity = l_needed_quantity
13346: , secondary_quantity = l_sec_needed_quantity
13347: WHERE pp_transaction_temp_id = l_pp_transaction_temp_id;
13348:

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

13352: --}
13353: ELSE --{
13354: x_finished := fnd_api.g_true;
13355: -- if input line could get satisfied
13356: -- delete the input line in the wms_transactions_temp table
13357: IF l_debug = 1 THEN
13358: log_statement(l_api_name, 'deleting_input_rec',
13359: 'Deleting the input line in WTT and pl/sql table');
13360: END IF;

Line 13362: DELETE FROM wms_transactions_temp

13358: log_statement(l_api_name, 'deleting_input_rec',
13359: 'Deleting the input line in WTT and pl/sql table');
13360: END IF;
13361:
13362: DELETE FROM wms_transactions_temp
13363: WHERE pp_transaction_temp_id = l_pp_transaction_temp_id;
13364:
13365: --
13366: -- and delete input record in PL/SQL table, too

Line 13987: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%TYPE;

13983: l_cursor integer;
13984: l_rows integer;
13985: -- rule dynamic SQL input variables
13986: l_pp_transaction_temp_id
13987: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%TYPE;
13988: l_revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE;
13989: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE;
13990: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE;
13991: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;

Line 13988: l_revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE;

13984: l_rows integer;
13985: -- rule dynamic SQL input variables
13986: l_pp_transaction_temp_id
13987: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%TYPE;
13988: l_revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE;
13989: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE;
13990: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE;
13991: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
13992: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;

Line 13989: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE;

13985: -- rule dynamic SQL input variables
13986: l_pp_transaction_temp_id
13987: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%TYPE;
13988: l_revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE;
13989: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE;
13990: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE;
13991: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
13992: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;
13993: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

Line 13990: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE;

13986: l_pp_transaction_temp_id
13987: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%TYPE;
13988: l_revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE;
13989: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE;
13990: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE;
13991: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
13992: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;
13993: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
13994: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;

Line 13991: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;

13987: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%TYPE;
13988: l_revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE;
13989: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE;
13990: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE;
13991: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
13992: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;
13993: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
13994: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;
13995: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;

Line 13992: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;

13988: l_revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE;
13989: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE;
13990: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE;
13991: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
13992: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;
13993: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
13994: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;
13995: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
13996: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%TYPE;

Line 13993: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

13989: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE;
13990: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE;
13991: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
13992: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;
13993: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
13994: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;
13995: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
13996: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%TYPE;
13997: l_lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE;

Line 13994: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;

13990: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE;
13991: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
13992: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;
13993: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
13994: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;
13995: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
13996: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%TYPE;
13997: l_lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE;
13998: l_initial_pri_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;

Line 13995: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;

13991: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
13992: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;
13993: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
13994: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;
13995: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
13996: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%TYPE;
13997: l_lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE;
13998: l_initial_pri_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
13999: -- rule dynamic SQL output variables

Line 13996: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%TYPE;

13992: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%TYPE;
13993: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
13994: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;
13995: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
13996: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%TYPE;
13997: l_lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE;
13998: l_initial_pri_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
13999: -- rule dynamic SQL output variables
14000: l_osubinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;

Line 13997: l_lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE;

13993: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
13994: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;
13995: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
13996: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%TYPE;
13997: l_lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE;
13998: l_initial_pri_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
13999: -- rule dynamic SQL output variables
14000: l_osubinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
14001: l_olocator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

Line 13998: l_initial_pri_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;

13994: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%TYPE;
13995: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
13996: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%TYPE;
13997: l_lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE;
13998: l_initial_pri_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
13999: -- rule dynamic SQL output variables
14000: l_osubinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
14001: l_olocator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14002: l_olocator_id_prev WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

Line 14000: l_osubinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;

13996: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%TYPE;
13997: l_lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE;
13998: l_initial_pri_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
13999: -- rule dynamic SQL output variables
14000: l_osubinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
14001: l_olocator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14002: l_olocator_id_prev WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14003: l_olocator_id_new WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14004: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

Line 14001: l_olocator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

13997: l_lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE;
13998: l_initial_pri_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
13999: -- rule dynamic SQL output variables
14000: l_osubinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
14001: l_olocator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14002: l_olocator_id_prev WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14003: l_olocator_id_new WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14004: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14005: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;

Line 14002: l_olocator_id_prev WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

13998: l_initial_pri_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
13999: -- rule dynamic SQL output variables
14000: l_osubinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
14001: l_olocator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14002: l_olocator_id_prev WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14003: l_olocator_id_new WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14004: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14005: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
14006: l_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;

Line 14003: l_olocator_id_new WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

13999: -- rule dynamic SQL output variables
14000: l_osubinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
14001: l_olocator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14002: l_olocator_id_prev WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14003: l_olocator_id_new WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14004: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14005: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
14006: l_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
14007: l_sec_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;

Line 14004: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

14000: l_osubinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
14001: l_olocator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14002: l_olocator_id_prev WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14003: l_olocator_id_new WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14004: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14005: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
14006: l_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
14007: l_sec_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
14008: l_sec_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;

Line 14005: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;

14001: l_olocator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14002: l_olocator_id_prev WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14003: l_olocator_id_new WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14004: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14005: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
14006: l_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
14007: l_sec_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
14008: l_sec_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
14009: l_reservation_id WMS_TRANSACTIONS_TEMP.RESERVATION_ID%TYPE;

Line 14006: l_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;

14002: l_olocator_id_prev WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14003: l_olocator_id_new WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14004: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14005: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
14006: l_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
14007: l_sec_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
14008: l_sec_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
14009: l_reservation_id WMS_TRANSACTIONS_TEMP.RESERVATION_ID%TYPE;
14010: l_grade_code VARCHAR2(150);

Line 14007: l_sec_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;

14003: l_olocator_id_new WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14004: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14005: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
14006: l_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
14007: l_sec_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
14008: l_sec_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
14009: l_reservation_id WMS_TRANSACTIONS_TEMP.RESERVATION_ID%TYPE;
14010: l_grade_code VARCHAR2(150);
14011:

Line 14008: l_sec_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;

14004: l_olocator_id_exist WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14005: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
14006: l_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
14007: l_sec_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
14008: l_sec_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
14009: l_reservation_id WMS_TRANSACTIONS_TEMP.RESERVATION_ID%TYPE;
14010: l_grade_code VARCHAR2(150);
14011:
14012: l_needed_quantity NUMBER;

Line 14009: l_reservation_id WMS_TRANSACTIONS_TEMP.RESERVATION_ID%TYPE;

14005: l_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
14006: l_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
14007: l_sec_possible_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE;
14008: l_sec_possible_trx_qty WMS_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE;
14009: l_reservation_id WMS_TRANSACTIONS_TEMP.RESERVATION_ID%TYPE;
14010: l_grade_code VARCHAR2(150);
14011:
14012: l_needed_quantity NUMBER;
14013: l_sec_needed_quantity NUMBER;

Line 14032: x_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;

14028: l_serial_number NUMBER; -- [ new code ]
14029: use_supplied_loc BOOLEAN;
14030:
14031: l_locator_type NUMBER;
14032: x_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
14033: x_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14034: x_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
14035: l_to_cg_id NUMBER ; --10244350
14036:

Line 14033: x_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;

14029: use_supplied_loc BOOLEAN;
14030:
14031: l_locator_type NUMBER;
14032: x_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
14033: x_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14034: x_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
14035: l_to_cg_id NUMBER ; --10244350
14036:
14037: --cursor to get lpn controlled flag from subinventory

Line 14034: x_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;

14030:
14031: l_locator_type NUMBER;
14032: x_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;
14033: x_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE;
14034: x_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE;
14035: l_to_cg_id NUMBER ; --10244350
14036:
14037: --cursor to get lpn controlled flag from subinventory
14038: CURSOR l_lpn_controlled IS

Line 14602: INTO WMS_TRANSACTIONS_TEMP

14598: 'Inserting putaway records in wtt');
14599: End if;
14600: -- insert temporary suggestion
14601: INSERT
14602: INTO WMS_TRANSACTIONS_TEMP
14603: ( PP_TRANSACTION_TEMP_ID
14604: ,TRANSACTION_TEMP_ID
14605: ,TYPE_CODE
14606: ,LINE_TYPE_CODE

Line 14624: ( wms_transactions_temp_s.NEXTVAL

14620: ,FROM_COST_GROUP_ID
14621: ,TO_COST_GROUP_ID
14622: ,LPN_ID
14623: ) VALUES
14624: ( wms_transactions_temp_s.NEXTVAL
14625: ,p_transaction_temp_id
14626: ,1 -- p_type_code
14627: ,2 -- line type code is output
14628: ,l_possible_trx_qty

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

14665:
14666: ELSE
14667: x_finished := fnd_api.g_true;
14668: -- if input line could get satisfied
14669: -- delete the input line in the wms_transactions_temp table
14670: If (l_debug = 1) then
14671: log_statement(l_api_name, 'deleting_input_rec',
14672: 'Deleting the input line in WTT and pl/sql table');
14673: End if;

Line 14675: FROM WMS_TRANSACTIONS_TEMP

14671: log_statement(l_api_name, 'deleting_input_rec',
14672: 'Deleting the input line in WTT and pl/sql table');
14673: End if;
14674: DELETE
14675: FROM WMS_TRANSACTIONS_TEMP
14676: WHERE pp_transaction_temp_id = l_pp_transaction_temp_id;
14677: --
14678: -- and delete input record in PL/SQL table, too
14679: wms_re_common_pvt.DeleteInputLine;

Line 15152: l_revision wms_transactions_temp.revision%TYPE;

15148: l_cursor INTEGER;
15149: l_rows INTEGER;
15150: --
15151: -- rule dynamic SQL output variables
15152: l_revision wms_transactions_temp.revision%TYPE;
15153: l_lot_number wms_transactions_temp.lot_number%TYPE;
15154: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15155: l_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15156: l_locator_id wms_transactions_temp.from_locator_id%TYPE;

Line 15153: l_lot_number wms_transactions_temp.lot_number%TYPE;

15149: l_rows INTEGER;
15150: --
15151: -- rule dynamic SQL output variables
15152: l_revision wms_transactions_temp.revision%TYPE;
15153: l_lot_number wms_transactions_temp.lot_number%TYPE;
15154: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15155: l_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15156: l_locator_id wms_transactions_temp.from_locator_id%TYPE;
15157: l_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

Line 15154: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;

15150: --
15151: -- rule dynamic SQL output variables
15152: l_revision wms_transactions_temp.revision%TYPE;
15153: l_lot_number wms_transactions_temp.lot_number%TYPE;
15154: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15155: l_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15156: l_locator_id wms_transactions_temp.from_locator_id%TYPE;
15157: l_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15158: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;

Line 15155: l_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;

15151: -- rule dynamic SQL output variables
15152: l_revision wms_transactions_temp.revision%TYPE;
15153: l_lot_number wms_transactions_temp.lot_number%TYPE;
15154: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15155: l_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15156: l_locator_id wms_transactions_temp.from_locator_id%TYPE;
15157: l_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15158: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
15159: --

Line 15156: l_locator_id wms_transactions_temp.from_locator_id%TYPE;

15152: l_revision wms_transactions_temp.revision%TYPE;
15153: l_lot_number wms_transactions_temp.lot_number%TYPE;
15154: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15155: l_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15156: l_locator_id wms_transactions_temp.from_locator_id%TYPE;
15157: l_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15158: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
15159: --
15160: -- other variables

Line 15157: l_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

15153: l_lot_number wms_transactions_temp.lot_number%TYPE;
15154: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15155: l_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15156: l_locator_id wms_transactions_temp.from_locator_id%TYPE;
15157: l_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15158: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
15159: --
15160: -- other variables
15161: l_type_code wms_rules_b.type_code%TYPE;

Line 15158: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;

15154: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
15155: l_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
15156: l_locator_id wms_transactions_temp.from_locator_id%TYPE;
15157: l_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
15158: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
15159: --
15160: -- other variables
15161: l_type_code wms_rules_b.type_code%TYPE;
15162: l_package_name VARCHAR2(128);

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

17679: l_debug_on BOOLEAN;
17680:
17681: -- input variables
17682:
17683: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE; --
17684: l_revision wms_transactions_temp.revision%TYPE; --
17685: l_lot_number wms_transactions_temp.lot_number%TYPE; --
17686: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE; --
17687: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE; --

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

17680:
17681: -- input variables
17682:
17683: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE; --
17684: l_revision wms_transactions_temp.revision%TYPE; --
17685: l_lot_number wms_transactions_temp.lot_number%TYPE; --
17686: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE; --
17687: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE; --
17688: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE; --

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

17681: -- input variables
17682:
17683: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE; --
17684: l_revision wms_transactions_temp.revision%TYPE; --
17685: l_lot_number wms_transactions_temp.lot_number%TYPE; --
17686: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE; --
17687: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE; --
17688: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE; --
17689: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

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

17682:
17683: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE; --
17684: l_revision wms_transactions_temp.revision%TYPE; --
17685: l_lot_number wms_transactions_temp.lot_number%TYPE; --
17686: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE; --
17687: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE; --
17688: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE; --
17689: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
17690: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE; --

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

17683: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE; --
17684: l_revision wms_transactions_temp.revision%TYPE; --
17685: l_lot_number wms_transactions_temp.lot_number%TYPE; --
17686: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE; --
17687: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE; --
17688: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE; --
17689: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
17690: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE; --
17691: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE; --

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

17684: l_revision wms_transactions_temp.revision%TYPE; --
17685: l_lot_number wms_transactions_temp.lot_number%TYPE; --
17686: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE; --
17687: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE; --
17688: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE; --
17689: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
17690: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE; --
17691: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE; --
17692: l_locator_id wms_transactions_temp.to_locator_id%TYPE;

Line 17689: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

17685: l_lot_number wms_transactions_temp.lot_number%TYPE; --
17686: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE; --
17687: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE; --
17688: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE; --
17689: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
17690: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE; --
17691: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE; --
17692: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
17693: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE; --

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

17686: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE; --
17687: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE; --
17688: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE; --
17689: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
17690: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE; --
17691: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE; --
17692: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
17693: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE; --
17694: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE; --

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

17687: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE; --
17688: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE; --
17689: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
17690: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE; --
17691: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE; --
17692: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
17693: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE; --
17694: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE; --
17695: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

Line 17692: l_locator_id wms_transactions_temp.to_locator_id%TYPE;

17688: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE; --
17689: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
17690: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE; --
17691: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE; --
17692: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
17693: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE; --
17694: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE; --
17695: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
17696: l_lpn_id wms_transactions_temp.lpn_id%TYPE; --

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

17689: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
17690: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE; --
17691: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE; --
17692: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
17693: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE; --
17694: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE; --
17695: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
17696: l_lpn_id wms_transactions_temp.lpn_id%TYPE; --
17697: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;

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

17690: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE; --
17691: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE; --
17692: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
17693: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE; --
17694: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE; --
17695: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
17696: l_lpn_id wms_transactions_temp.lpn_id%TYPE; --
17697: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
17698:

Line 17695: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

17691: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE; --
17692: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
17693: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE; --
17694: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE; --
17695: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
17696: l_lpn_id wms_transactions_temp.lpn_id%TYPE; --
17697: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
17698:
17699: l_reservation_id NUMBER; --

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

17692: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
17693: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE; --
17694: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE; --
17695: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
17696: l_lpn_id wms_transactions_temp.lpn_id%TYPE; --
17697: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
17698:
17699: l_reservation_id NUMBER; --
17700: l_needed_quantity NUMBER; --

Line 17697: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;

17693: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE; --
17694: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE; --
17695: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
17696: l_lpn_id wms_transactions_temp.lpn_id%TYPE; --
17697: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
17698:
17699: l_reservation_id NUMBER; --
17700: l_needed_quantity NUMBER; --
17701: l_sec_needed_quantity NUMBER; -- -- new

Line 18322: -- WMS_TRANSACTIONS_TEMP, respectively );

18318: -- At least one transaction detail record in
18319: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
18320: -- and parameters p_transaction_temp_id and p_type_code
18321: -- ( base tables are MTL_MATERIAL_TRANSACTIONS_TEMP and
18322: -- WMS_TRANSACTIONS_TEMP, respectively );
18323: -- Rule record has to exist in WMS_RULES_B uniquely
18324: -- identified by parameter p_rule_id;
18325: -- Package WMS_RULE_(RULEID) must exist;
18326: -- If picking, quantity tree has to exist, created through

Line 18403: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;

18399: -- variables needed for dynamic SQL
18400: l_cursor INTEGER;
18401: l_rows INTEGER;
18402: -- rule dynamic SQL input variables
18403: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
18404: l_revision wms_transactions_temp.revision%TYPE := null;
18405: l_lot_number wms_transactions_temp.lot_number%TYPE := null;
18406: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
18407: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;

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

18400: l_cursor INTEGER;
18401: l_rows INTEGER;
18402: -- rule dynamic SQL input variables
18403: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
18404: l_revision wms_transactions_temp.revision%TYPE := null;
18405: l_lot_number wms_transactions_temp.lot_number%TYPE := null;
18406: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
18407: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
18408: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

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

18401: l_rows INTEGER;
18402: -- rule dynamic SQL input variables
18403: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
18404: l_revision wms_transactions_temp.revision%TYPE := null;
18405: l_lot_number wms_transactions_temp.lot_number%TYPE := null;
18406: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
18407: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
18408: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
18409: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

Line 18406: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;

18402: -- rule dynamic SQL input variables
18403: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
18404: l_revision wms_transactions_temp.revision%TYPE := null;
18405: l_lot_number wms_transactions_temp.lot_number%TYPE := null;
18406: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
18407: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
18408: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
18409: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
18410: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;

Line 18407: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;

18403: l_pp_transaction_temp_id wms_transactions_temp.pp_transaction_temp_id%TYPE;
18404: l_revision wms_transactions_temp.revision%TYPE := null;
18405: l_lot_number wms_transactions_temp.lot_number%TYPE := null;
18406: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
18407: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
18408: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
18409: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
18410: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
18411: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;

Line 18408: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

18404: l_revision wms_transactions_temp.revision%TYPE := null;
18405: l_lot_number wms_transactions_temp.lot_number%TYPE := null;
18406: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
18407: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
18408: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
18409: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
18410: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
18411: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
18412: l_locator_id wms_transactions_temp.to_locator_id%TYPE;

Line 18409: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;

18405: l_lot_number wms_transactions_temp.lot_number%TYPE := null;
18406: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
18407: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
18408: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
18409: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
18410: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
18411: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
18412: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
18413: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

Line 18410: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;

18406: l_lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
18407: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
18408: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
18409: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
18410: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
18411: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
18412: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
18413: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
18414: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

Line 18411: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;

18407: l_from_subinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
18408: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
18409: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
18410: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
18411: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
18412: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
18413: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
18414: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
18415: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

Line 18412: l_locator_id wms_transactions_temp.to_locator_id%TYPE;

18408: l_to_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
18409: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
18410: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
18411: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
18412: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
18413: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
18414: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
18415: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
18416: l_lpn_id wms_transactions_temp.lpn_id%TYPE := null;

Line 18413: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

18409: l_subinventory_code wms_transactions_temp.to_subinventory_code%TYPE;
18410: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
18411: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
18412: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
18413: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
18414: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
18415: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
18416: l_lpn_id wms_transactions_temp.lpn_id%TYPE := null;
18417: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;

Line 18414: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

18410: l_from_locator_id wms_transactions_temp.from_locator_id%TYPE;
18411: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
18412: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
18413: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
18414: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
18415: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
18416: l_lpn_id wms_transactions_temp.lpn_id%TYPE := null;
18417: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
18418: -- rule dynamic SQL output variables

Line 18415: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;

18411: l_to_locator_id wms_transactions_temp.to_locator_id%TYPE;
18412: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
18413: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
18414: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
18415: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
18416: l_lpn_id wms_transactions_temp.lpn_id%TYPE := null;
18417: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
18418: -- rule dynamic SQL output variables
18419: l_orevision wms_transactions_temp.revision%TYPE;

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

18412: l_locator_id wms_transactions_temp.to_locator_id%TYPE;
18413: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
18414: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
18415: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
18416: l_lpn_id wms_transactions_temp.lpn_id%TYPE := null;
18417: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
18418: -- rule dynamic SQL output variables
18419: l_orevision wms_transactions_temp.revision%TYPE;
18420: l_olot_number wms_transactions_temp.lot_number%TYPE;

Line 18417: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;

18413: l_from_cost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
18414: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
18415: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
18416: l_lpn_id wms_transactions_temp.lpn_id%TYPE := null;
18417: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
18418: -- rule dynamic SQL output variables
18419: l_orevision wms_transactions_temp.revision%TYPE;
18420: l_olot_number wms_transactions_temp.lot_number%TYPE;
18421: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;

Line 18419: l_orevision wms_transactions_temp.revision%TYPE;

18415: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
18416: l_lpn_id wms_transactions_temp.lpn_id%TYPE := null;
18417: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
18418: -- rule dynamic SQL output variables
18419: l_orevision wms_transactions_temp.revision%TYPE;
18420: l_olot_number wms_transactions_temp.lot_number%TYPE;
18421: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
18422: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
18423: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;

Line 18420: l_olot_number wms_transactions_temp.lot_number%TYPE;

18416: l_lpn_id wms_transactions_temp.lpn_id%TYPE := null;
18417: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
18418: -- rule dynamic SQL output variables
18419: l_orevision wms_transactions_temp.revision%TYPE;
18420: l_olot_number wms_transactions_temp.lot_number%TYPE;
18421: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
18422: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
18423: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
18424: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;

Line 18421: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;

18417: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
18418: -- rule dynamic SQL output variables
18419: l_orevision wms_transactions_temp.revision%TYPE;
18420: l_olot_number wms_transactions_temp.lot_number%TYPE;
18421: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
18422: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
18423: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
18424: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
18425: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;

Line 18422: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;

18418: -- rule dynamic SQL output variables
18419: l_orevision wms_transactions_temp.revision%TYPE;
18420: l_olot_number wms_transactions_temp.lot_number%TYPE;
18421: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
18422: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
18423: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
18424: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
18425: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
18426: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

Line 18423: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;

18419: l_orevision wms_transactions_temp.revision%TYPE;
18420: l_olot_number wms_transactions_temp.lot_number%TYPE;
18421: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
18422: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
18423: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
18424: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
18425: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
18426: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
18427: l_olpn_id wms_transactions_temp.lpn_id%TYPE;

Line 18424: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;

18420: l_olot_number wms_transactions_temp.lot_number%TYPE;
18421: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
18422: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
18423: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
18424: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
18425: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
18426: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
18427: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
18428: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;

Line 18425: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;

18421: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;
18422: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
18423: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
18424: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
18425: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
18426: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
18427: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
18428: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
18429: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;

Line 18426: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;

18422: l_osubinventory_code wms_transactions_temp.from_subinventory_code%TYPE;
18423: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
18424: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
18425: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
18426: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
18427: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
18428: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
18429: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
18430: l_reservation_id wms_transactions_temp.reservation_id%TYPE;

Line 18427: l_olpn_id wms_transactions_temp.lpn_id%TYPE;

18423: l_olocator_id wms_transactions_temp.from_locator_id%TYPE;
18424: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
18425: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
18426: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
18427: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
18428: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
18429: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
18430: l_reservation_id wms_transactions_temp.reservation_id%TYPE;
18431: -- variables needed for qty tree

Line 18428: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;

18424: l_olocator_id_prev wms_transactions_temp.from_locator_id%TYPE;
18425: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
18426: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
18427: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
18428: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
18429: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
18430: l_reservation_id wms_transactions_temp.reservation_id%TYPE;
18431: -- variables needed for qty tree
18432: l_qoh NUMBER;

Line 18429: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;

18425: l_olocator_id_new wms_transactions_temp.from_locator_id%TYPE;
18426: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
18427: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
18428: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
18429: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
18430: l_reservation_id wms_transactions_temp.reservation_id%TYPE;
18431: -- variables needed for qty tree
18432: l_qoh NUMBER;
18433: l_rqoh NUMBER;

Line 18430: l_reservation_id wms_transactions_temp.reservation_id%TYPE;

18426: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
18427: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
18428: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
18429: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
18430: l_reservation_id wms_transactions_temp.reservation_id%TYPE;
18431: -- variables needed for qty tree
18432: l_qoh NUMBER;
18433: l_rqoh NUMBER;
18434: l_qr NUMBER;