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_CARTNZN_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 15: -- mtl_material_transactions_temp.

11: -- API name : cartonize
12: -- Type : group
13: -- Function : populates the cartonization_id, container_item_id columns,
14: -- of rows belonging to a particular move order header id in
15: -- mtl_material_transactions_temp.
16:
17: -- Pre-reqs : Those columns wouldn't be populated if the cartonization_id
18: -- for that row is already populated,
19: -- or if values for organization_id, inventory_item_id ,

Line 123: TABLE_NAME VARCHAR2(200) := 'mtl_material_transactions_temp';

119:
120: -- Sets the table on which we want to perform the operations insert,
121: -- delete, update etc
122:
123: TABLE_NAME VARCHAR2(200) := 'mtl_material_transactions_temp';
124:
125: -- mode in which cartonization is called, values 'Y' or 'N'
126:
127: OUTBOUND VARCHAR2(1) := 'N';

Line 141: orig_temp_id mtl_material_transactions_temp.transaction_temp_id%TYPE ,

137: -- split from it
138:
139: TYPE t_temp_id_rel_rec IS RECORD
140: (
141: orig_temp_id mtl_material_transactions_temp.transaction_temp_id%TYPE ,
142: splt_temp_id mtl_material_transactions_temp.transaction_temp_id%TYPE,
143: primary_quantity NUMBER,
144: secondary_quantity NUMBER,
145: processed VARCHAR2(1) := 'N');

Line 142: splt_temp_id mtl_material_transactions_temp.transaction_temp_id%TYPE,

138:
139: TYPE t_temp_id_rel_rec IS RECORD
140: (
141: orig_temp_id mtl_material_transactions_temp.transaction_temp_id%TYPE ,
142: splt_temp_id mtl_material_transactions_temp.transaction_temp_id%TYPE,
143: primary_quantity NUMBER,
144: secondary_quantity NUMBER,
145: processed VARCHAR2(1) := 'N');
146:

Line 163: SUBTYPE MMTT_ROW_TYPE IS MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE;

159:
160: --for device integration
161: SUBTYPE WDR_ROW IS WMS_DEVICE_REQUESTS%ROWTYPE;
162:
163: SUBTYPE MMTT_ROW_TYPE IS MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE;
164:
165: SUBTYPE WCT_ROW_TYPE IS WMS_CARTONIZATION_TEMP%ROWTYPE;
166:
167: TYPE lpn_alloc_flag_rec IS RECORD

Line 168: ( transaction_temp_id mtl_material_transactions_temp.transaction_temp_id%TYPE ,

164:
165: SUBTYPE WCT_ROW_TYPE IS WMS_CARTONIZATION_TEMP%ROWTYPE;
166:
167: TYPE lpn_alloc_flag_rec IS RECORD
168: ( transaction_temp_id mtl_material_transactions_temp.transaction_temp_id%TYPE ,
169: lpn_alloc_flag VARCHAR2(1)
170: );
171:
172: TYPE lpn_alloc_flag_tb IS TABLE OF lpn_alloc_flag_rec INDEX BY BINARY_INTEGER;

Line 485: mtl_material_transactions_temp mmtt, mtl_txn_request_lines

481:
482: CURSOR c1(mo_hdr_id NUMBER) IS
483: /* added the index hint with the suggestion of apps performance team */
484: SELECT /*+index (mmtt,mtl_material_trans_temp_n14)*/ mmtt.* FROM
485: mtl_material_transactions_temp mmtt, mtl_txn_request_lines
486: mtrl WHERE mtrl.header_id = mo_hdr_id AND
487: mmtt.move_order_line_id = mtrl.line_id AND
488: --2513907 fix
489: mmtt.container_item_id IS null;

Line 493: mtl_material_transactions_temp mmtt

489: mmtt.container_item_id IS null;
490:
491: CURSOR c2(txn_hdr_id NUMBER) IS
492: SELECT mmtt.* FROM
493: mtl_material_transactions_temp mmtt
494: WHERE
495: mmtt.transaction_header_id = txn_hdr_id;
496:
497: -- following cursors added for patchset J bulk picking ---------------

Line 501: mtl_material_transactions_temp mmtt,mtl_allocations_gtmp mag

497: -- following cursors added for patchset J bulk picking ---------------
498:
499: CURSOR c11_bulk_all_fast(p_organization_id NUMBER) IS
500: SELECT mmtt.* FROM
501: mtl_material_transactions_temp mmtt,mtl_allocations_gtmp mag
502: WHERE mmtt.wms_task_status = 8 -- unreleased
503: And mmtt.cartonization_id IS null -- not cartonized
504: And mmtt.organization_id = p_organization_id
505: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation

Line 522: mtl_material_transactions_temp mmtt,mtl_allocations_gtmp mag

518: for update of mmtt.transaction_temp_id; -- to lock the records
519:
520: CURSOR c11_bulk_only_sub_item_fast(p_organization_id NUMBER) IS
521: SELECT mmtt.* FROM
522: mtl_material_transactions_temp mmtt,mtl_allocations_gtmp mag
523: WHERE mmtt.wms_task_status = 8 -- unreleased
524: And mmtt.cartonization_id IS null -- not cartonized
525: And mmtt.organization_id = p_organization_id
526: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation

Line 554: mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,

550:
551:
552: CURSOR c11_bulk_all(p_organization_id NUMBER) IS
553: SELECT mmtt.* FROM
554: mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
555: wsh_pick_grouping_rules spg
556: WHERE mmtt.wms_task_status = 8 -- unreleased
557: And mmtt.cartonization_id IS null -- not cartonized
558: And mmtt.organization_id = p_organization_id

Line 583: mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,

579: for update of mmtt.transaction_temp_id; -- to lock the records
580:
581: CURSOR c11_bulk_only_sub_item(p_organization_id NUMBER) IS
582: SELECT mmtt.* FROM
583: mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
584: wsh_pick_grouping_rules spg
585: WHERE mmtt.wms_task_status = 8 -- unreleased
586: And mmtt.cartonization_id IS null -- not cartonized
587: And mmtt.organization_id = p_organization_id

Line 624: wsh_trip_stops wts, mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,

620:
621: CURSOR c11_bulk_trip(p_organization_id NUMBER) IS
622: select mmtt.*
623: from wsh_delivery_legs wdl,wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
624: wsh_trip_stops wts, mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
625: wsh_pick_grouping_rules spg
626: where wts.trip_id = p_input_for_bulk.trip_id
627: and wdl.pick_up_stop_id = wts.stop_id
628: and wdl.delivery_id = wda.delivery_id

Line 660: wsh_trip_stops wts, mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,

656:
657: CURSOR c11_bulk_trip_sub_item(p_organization_id NUMBER) IS
658: select mmtt.*
659: from wsh_delivery_legs wdl,wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
660: wsh_trip_stops wts, mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
661: wsh_pick_grouping_rules spg
662: where wts.trip_id = p_input_for_bulk.trip_id
663: and wdl.pick_up_stop_id = wts.stop_id
664: and wdl.delivery_id = wda.delivery_id

Line 841: from mtl_system_items_b msi, mtl_material_transactions_temp mmtt

837: if (g_trace_on = 1) then -- log_event('PATCHSET J-- BULK PICKING -- START');
838: log_event('checking the lot and serial control code'); end if;
839: select lot_control_code,serial_number_control_code
840: into l_lot_control_code,l_serial_control_code
841: from mtl_system_items_b msi, mtl_material_transactions_temp mmtt
842: where mmtt.transaction_temp_id = mmtt_rec.transaction_Temp_id
843: and mmtt.organization_id = msi.organization_id
844: and msi.inventory_item_id = mmtt.inventory_item_id;
845: if (g_trace_on = 1) then log_event('transaction_temp_id:'|| mmtt_rec.transaction_Temp_id ||

Line 851: update mtl_material_transactions_temp

847: ' serial control code :'||l_serial_control_code);
848: end if;
849: if (g_trace_on = 1) then log_event('nullify the parent_line_id for the child task '); end if;
850:
851: update mtl_material_transactions_temp
852: set parent_line_id = null
853: where transaction_temp_id = mmtt_rec.transaction_Temp_id;
854:
855: -- call update_parent_mmtt to change the qty or delete the parent line --------

Line 3110: -- This procedure loops through mtl_material_transactions_temp table, assign

3106: -- Current version 1.0
3107: --
3108: -- Notes : calls AssignTT(p_task_id NUMBER)
3109: --
3110: -- This procedure loops through mtl_material_transactions_temp table, assign
3111: -- user defined task type to tasks that have not been assigned a task type
3112: -- for the given Move Order Header.
3113: -- This API is created when doing patchset J bulk picking
3114: -- ****************************************

Line 3245: curr_temp_id mtl_material_transactions_temp.transaction_temp_id%TYPE ;

3241: v_prev_move_order_line_id NUMBER := 0;
3242: space_avail_for NUMBER := 0;
3243: tr_space_avail_for NUMBER := 0;
3244: sec_tr_space_avail_for NUMBER := 0; --invconv kkillams
3245: curr_temp_id mtl_material_transactions_temp.transaction_temp_id%TYPE ;
3246: v_lot_control_code NUMBER := NULL;
3247: v_serial_control_code NUMBER := NULL;
3248: api_table_index NUMBER := 0;
3249: l_current_header_id NUMBER := NULL;

Line 3317: --mtl_material_transactions_temp mmtt,

3313: CURSOR OB_LBPRT IS
3314: SELECT DISTINCT mmtt.cartonization_id FROM
3315: --2513907 fix
3316: wms_cartonization_temp mmtt,
3317: --mtl_material_transactions_temp mmtt,
3318: mtl_txn_request_lines mtrl WHERE
3319: mmtt.move_order_line_id = mtrl.line_id
3320: AND mtrl.header_id = p_move_order_header_id
3321: AND mmtt.cartonization_id IS NOT NULL

Line 3328: --mtl_material_transactions_temp mmtt

3324: CURSOR IB_LBPRT IS
3325: SELECT DISTINCT mmtt.cartonization_id FROM
3326: --2513907 fix
3327: wms_cartonization_temp mmtt
3328: --mtl_material_transactions_temp mmtt
3329: WHERE
3330: mmtt.transaction_header_id = p_transaction_header_id
3331: AND mmtt.cartonization_id IS NOT NULL
3332: ORDER BY mmtt.cartonization_id;

Line 3717: --mtl_material_transactions_temp mmtt, mtl_txn_request_lines

3713: p_transaction_header_id => NULL,
3714: p_input_for_bulk =>p_input_for_bulk);
3715:
3716: --INSERT INTO wms_cartonization_temp SELECT mmtt.* FROM
3717: --mtl_material_transactions_temp mmtt, mtl_txn_request_lines
3718: --mtrl WHERE mtrl.header_id = p_move_order_header_id AND
3719: --mmtt.move_order_line_id = mtrl.line_id;
3720:
3721: ELSE --outbound = 'N'

Line 3734: --mtl_material_transactions_temp mmtt

3730: );
3731:
3732: --INSERT INTO wms_cartonization_temp
3733: --SELECT mmtt.* FROM
3734: --mtl_material_transactions_temp mmtt
3735: --WHERE
3736: --mmtt.transaction_header_id = p_transaction_header_id;
3737:
3738: END IF;

Line 5054: IF table_name = 'mtl_material_transactions_temp' THEN

5050: --GET PRIMARY QUANTITY
5051: END IF;
5052:
5053:
5054: IF table_name = 'mtl_material_transactions_temp' THEN
5055:
5056: if (g_trace_on = 1) then log_event(' table_name = mtl_material_transactions_temp'); END IF;
5057:
5058:

Line 5056: if (g_trace_on = 1) then log_event(' table_name = mtl_material_transactions_temp'); END IF;

5052:
5053:
5054: IF table_name = 'mtl_material_transactions_temp' THEN
5055:
5056: if (g_trace_on = 1) then log_event(' table_name = mtl_material_transactions_temp'); END IF;
5057:
5058:
5059: IF p_parent_line_id = -99999 THEN
5060: SELECT parent_line_id INTO par_line_id FROM

Line 5061: mtl_material_transactions_temp WHERE transaction_temp_id =

5057:
5058:
5059: IF p_parent_line_id = -99999 THEN
5060: SELECT parent_line_id INTO par_line_id FROM
5061: mtl_material_transactions_temp WHERE transaction_temp_id =
5062: p_transaction_temp_id;
5063: ELSE
5064: par_line_id := p_parent_line_id;
5065: END IF;

Line 5073: UPDATE mtl_material_transactions_temp SET

5069:
5070: IF( p_upd_qty_flag = 'Y') THEN
5071:
5072:
5073: UPDATE mtl_material_transactions_temp SET
5074: primary_quantity = p_primary_quantity,
5075: transaction_quantity = p_transaction_quantity,
5076: secondary_transaction_quantity = p_secondary_quantity, --invconv kkillams
5077: cartonization_id = l_LPN,

Line 5085: UPDATE mtl_material_transactions_temp SET

5081: last_updated_by = fnd_global.user_id
5082: WHERE
5083: transaction_temp_id = p_transaction_temp_id;
5084: ELSE
5085: UPDATE mtl_material_transactions_temp SET
5086: cartonization_id = l_LPN,
5087: container_item_id = p_container_item_id,
5088: parent_line_id = par_line_id,
5089: last_update_date = Sysdate,

Line 5197: if (g_trace_on = 1) THEN log_event('ERROR:INS_MMTT with mtl_material_transactions_temp'); end if;

5193: transaction_temp_id = p_transaction_temp_id AND ROWNUM < 2;
5194:
5195: ELSE
5196: --Bug 3296177 code should never come here
5197: if (g_trace_on = 1) THEN log_event('ERROR:INS_MMTT with mtl_material_transactions_temp'); end if;
5198: RAISE fnd_api.g_exc_error;
5199: --SELECT * INTO v1 FROM mtl_material_transactions_temp WHERE
5200: --transaction_temp_id = p_transaction_temp_id;
5201:

Line 5199: --SELECT * INTO v1 FROM mtl_material_transactions_temp WHERE

5195: ELSE
5196: --Bug 3296177 code should never come here
5197: if (g_trace_on = 1) THEN log_event('ERROR:INS_MMTT with mtl_material_transactions_temp'); end if;
5198: RAISE fnd_api.g_exc_error;
5199: --SELECT * INTO v1 FROM mtl_material_transactions_temp WHERE
5200: --transaction_temp_id = p_transaction_temp_id;
5201:
5202: END IF;
5203:

Line 5252: IF (table_name = 'mtl_material_transactions_temp') THEN

5248: v1.inventory_item_id := p_item_id;
5249: END IF;
5250:
5251:
5252: IF (table_name = 'mtl_material_transactions_temp') THEN
5253:
5254: RAISE fnd_api.g_exc_error;
5255: --wms_task_dispatch_engine.insert_mmtt
5256: --(l_mmtt_rec => v1);

Line 5381: FROM mtl_material_transactions_temp mmtt,

5377: SELECT
5378: mtlt.lot_number lot_num,
5379: mtlt.transaction_quantity lot_qty,
5380: msnt.fm_serial_number ser_num
5381: FROM mtl_material_transactions_temp mmtt,
5382: mtl_transaction_lots_temp mtlt,
5383: mtl_serial_numbers_temp msnt
5384: WHERE
5385: mmtt.transaction_temp_id = p_transaction_temp_id

Line 5655: FROM mtl_material_transactions_temp mmtt,

5651: SELECT
5652: mtlt.lot_number lot_num,
5653: mtlt.transaction_quantity lot_qty,
5654: msnt.fm_serial_number ser_num
5655: FROM mtl_material_transactions_temp mmtt,
5656: mtl_transaction_lots_temp mtlt,
5657: mtl_serial_numbers_temp msnt
5658: WHERE
5659: mmtt.transaction_temp_id = p_transaction_temp_id

Line 5747: exists ( SELECT transaction_temp_id FROM mtl_material_transactions_temp

5743:
5744: BEGIN
5745: SELECT 'Y' INTO v_exist FROM dual
5746: WHERE
5747: exists ( SELECT transaction_temp_id FROM mtl_material_transactions_temp
5748: WHERE transaction_temp_id = v1.transaction_temp_id);
5749: EXCEPTION
5750: WHEN no_data_found THEN
5751: v_exist := 'N';

Line 5772: table_name := 'mtl_material_transactions_temp';

5768: END IF;
5769:
5770: if (g_trace_on = 1) then log_event(' After the cartonization id condition '); END IF;
5771:
5772: table_name := 'mtl_material_transactions_temp';
5773:
5774:
5775: IF v_exist = 'Y' THEN
5776:

Line 5919: curr_temp_id mtl_material_transactions_temp.transaction_temp_id%TYPE ;

5915: v_prev_move_order_line_id NUMBER := -999;
5916: space_avail_for NUMBER := 0;
5917: tr_space_avail_for NUMBER := 0;
5918: sec_tr_space_avail_for NUMBER := 0; --invconv kkillams
5919: curr_temp_id mtl_material_transactions_temp.transaction_temp_id%TYPE ;
5920: v_lot_control_code NUMBER := NULL;
5921: v_serial_control_code NUMBER := NULL;
5922: api_table_index NUMBER := 0;
5923: l_current_header_id NUMBER := NULL;

Line 6006: --mtl_material_transactions_temp mmtt,

6002: CURSOR OB_LBPRT IS
6003: SELECT DISTINCT mmtt.cartonization_id FROM
6004: --2513907 fix
6005: wms_cartonization_temp mmtt,
6006: --mtl_material_transactions_temp mmtt,
6007: mtl_txn_request_lines mtrl WHERE
6008: mmtt.move_order_line_id = mtrl.line_id
6009: AND mtrl.header_id = p_move_order_header_id
6010: AND mmtt.cartonization_id IS NOT NULL

Line 6745: --mtl_material_transactions_temp mmtt,

6741: CURSOR OB_LBPRT IS
6742: SELECT DISTINCT mmtt.cartonization_id FROM
6743: --2513907 fix
6744: wms_cartonization_temp mmtt,
6745: --mtl_material_transactions_temp mmtt,
6746: mtl_txn_request_lines mtrl WHERE
6747: mmtt.move_order_line_id = mtrl.line_id
6748: AND mtrl.header_id = p_move_order_header_id
6749: AND mmtt.cartonization_id IS NOT NULL

Line 7213: curr_temp_id mtl_material_transactions_temp.transaction_temp_id%TYPE ;

7209: v_prev_move_order_line_id NUMBER := 0;
7210: space_avail_for NUMBER := 0;
7211: tr_space_avail_for NUMBER := 0;
7212: sec_tr_space_avail_for NUMBER := 0; --invconv kkillams
7213: curr_temp_id mtl_material_transactions_temp.transaction_temp_id%TYPE ;
7214: v_lot_control_code NUMBER := NULL;
7215: v_serial_control_code NUMBER := NULL;
7216: api_table_index NUMBER := 0;
7217: l_current_header_id NUMBER := NULL;

Line 7280: --mtl_material_transactions_temp mmtt,

7276: CURSOR OB_LBPRT IS
7277: SELECT DISTINCT mmtt.cartonization_id FROM
7278: --2513907 fix
7279: wms_cartonization_temp mmtt,
7280: --mtl_material_transactions_temp mmtt,
7281: mtl_txn_request_lines mtrl WHERE
7282: mmtt.move_order_line_id = mtrl.line_id
7283: AND mtrl.header_id = p_move_order_header_id
7284: AND mmtt.cartonization_id IS NOT NULL

Line 8014: TYPE l_cart_tab_type IS TABLE OF mtl_material_transactions_temp.cartonization_id%TYPE INDEX BY BINARY_INTEGER;

8010: , x_return_status OUT NOCOPY VARCHAR2
8011: )
8012: IS
8013:
8014: TYPE l_cart_tab_type IS TABLE OF mtl_material_transactions_temp.cartonization_id%TYPE INDEX BY BINARY_INTEGER;
8015: TYPE l_trans_temp_tab_type IS TABLE OF mtl_material_transactions_temp.transaction_temp_id%TYPE INDEX BY BINARY_INTEGER;
8016:
8017: l_mmtt_table WMS_CARTONIZATION_USER_PUB.mmtt_type;
8018: l_out_mmtt_table WMS_CARTONIZATION_USER_PUB.mmtt_type;

Line 8015: TYPE l_trans_temp_tab_type IS TABLE OF mtl_material_transactions_temp.transaction_temp_id%TYPE INDEX BY BINARY_INTEGER;

8011: )
8012: IS
8013:
8014: TYPE l_cart_tab_type IS TABLE OF mtl_material_transactions_temp.cartonization_id%TYPE INDEX BY BINARY_INTEGER;
8015: TYPE l_trans_temp_tab_type IS TABLE OF mtl_material_transactions_temp.transaction_temp_id%TYPE INDEX BY BINARY_INTEGER;
8016:
8017: l_mmtt_table WMS_CARTONIZATION_USER_PUB.mmtt_type;
8018: l_out_mmtt_table WMS_CARTONIZATION_USER_PUB.mmtt_type;
8019: