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

Line 267: FROM mtl_material_transactions_temp

263: l_mmtt_hid tbl_num;
264:
265: CURSOR c_mmtt_cursor (p_txn_batch_id NUMBER) IS
266: SELECT transaction_temp_id
267: FROM mtl_material_transactions_temp
268: WHERE transaction_batch_id = p_txn_batch_id;
269:
270: BEGIN
271: -- Initialize API return status to success

Line 347: UPDATE mtl_material_transactions_temp

343: END LOOP; --}
344:
345: -- Bulk update operation_plan_id in all the MMTTs with cached values
346: FORALL kk IN l_mmtt_temp_id.FIRST .. l_mmtt_temp_id.LAST
347: UPDATE mtl_material_transactions_temp
348: SET operation_plan_id = l_mmtt_hid(kk)
349: WHERE transaction_temp_id = l_mmtt_temp_id(kk);
350:
351: END LOOP; --}

Line 374: UPDATE mtl_material_transactions_temp

370: print_debug ('No operation plan rules defined', l_api_name);
371: print_debug ('l_op_plan_id value: ' || l_op_plan_id, l_api_name);
372: END IF;
373:
374: UPDATE mtl_material_transactions_temp
375: SET operation_plan_id = l_op_plan_id
376: WHERE transaction_batch_id = p_transaction_batch_id;
377: END IF; --}
378:

Line 1004: FROM mtl_material_transactions_temp mmtt

1000: , mmtt.original_transaction_temp_id
1001: , mmtt.serial_allocated_flag
1002: , mmtt.trx_flow_header_id
1003: , mmtt.fulfillment_base
1004: FROM mtl_material_transactions_temp mmtt
1005: WHERE mmtt.move_order_header_id = p_move_order_header_id;
1006: -- AND mmtt.container_item_id IS NULL;
1007: --}
1008: ELSE

Line 1486: FROM mtl_material_transactions_temp mmtt

1482: , mmtt.original_transaction_temp_id
1483: , mmtt.serial_allocated_flag
1484: , mmtt.trx_flow_header_id
1485: , mmtt.fulfillment_base
1486: FROM mtl_material_transactions_temp mmtt
1487: WHERE mmtt.move_order_header_id = p_move_order_header_id
1488: AND mmtt.container_item_id IS NULL;
1489: --}
1490: END IF;

Line 1531: MERGE INTO mtl_material_transactions_temp mmtt

1527: x_return_status := fnd_api.g_ret_sts_success;
1528:
1529: SAVEPOINT merge_wct_sp;
1530:
1531: MERGE INTO mtl_material_transactions_temp mmtt
1532: USING ( SELECT * FROM wms_cartonization_temp ) wct
1533: ON ( mmtt.transaction_temp_id = wct.transaction_temp_id )
1534: WHEN MATCHED THEN
1535: UPDATE SET

Line 3710: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol

3706: , mmtt.item_lot_control_code
3707: , mmtt.item_serial_control_code
3708: , mmtt.serial_allocated_flag
3709: , mmtt.transaction_batch_id
3710: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
3711: , wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda
3712: WHERE mmtt.move_order_line_id = mol.line_id
3713: AND mol.header_id = p_move_order_header_id
3714: AND mol.line_id = wdd.move_order_line_id

Line 3791: FROM mtl_material_transactions_temp mmtt

3787: , mmtt.item_lot_control_code
3788: , mmtt.item_serial_control_code
3789: , mmtt.serial_allocated_flag
3790: , mmtt.transaction_batch_id
3791: FROM mtl_material_transactions_temp mmtt
3792: WHERE mmtt.wms_task_type NOT IN(5, 6)
3793: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
3794: AND mmtt.cartonization_id IS NULL -- only bulk non_cartonized lines
3795: AND mmtt.move_order_header_id = p_move_order_header_id

Line 3973: INSERT INTO mtl_material_transactions_temp

3969: END IF;
3970:
3971: -- Bulk insert parent rows directly into MMTT
3972: FORALL jj IN l_transaction_header_id.FIRST .. l_transaction_header_id.LAST
3973: INSERT INTO mtl_material_transactions_temp
3974: ( transaction_header_id
3975: , transaction_temp_id
3976: , posting_flag
3977: , transaction_status

Line 4057: UPDATE mtl_material_transactions_temp mmtt

4053: -- Bulk update the child MMTTs for setting parent_line_id
4054: -- and nulling out transaction_batch_id and pick_slip_number
4055: IF l_delivery_flag = 'Y' THEN
4056: FORALL kk IN tbl_transaction_temp_id.FIRST .. tbl_transaction_temp_id.LAST
4057: UPDATE mtl_material_transactions_temp mmtt
4058: SET parent_line_id = tbl_transaction_temp_id(kk)
4059: , transaction_batch_id = NULL
4060: , pick_slip_number = NULL
4061: WHERE transaction_temp_id <> tbl_transaction_temp_id(kk)

Line 4084: UPDATE mtl_material_transactions_temp

4080: AND allocated_lpn_id IS NULL -- Bug: 9309619 Added below condition
4081: AND cartonization_id is NULL;--added for bug 9446937
4082: ELSE
4083: FORALL kk IN tbl_transaction_temp_id.FIRST .. tbl_transaction_temp_id.LAST
4084: UPDATE mtl_material_transactions_temp
4085: SET parent_line_id = tbl_transaction_temp_id(kk)
4086: , transaction_batch_id = NULL
4087: , pick_slip_number = NULL --newly added
4088: WHERE transaction_temp_id <> tbl_transaction_temp_id(kk)

Line 4134: FROM mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt

4130: , g_user_id
4131: , SYSDATE
4132: , g_user_id
4133: , NULL
4134: FROM mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt
4135: WHERE mtlt.transaction_temp_id = mmtt.transaction_temp_id
4136: AND mmtt.parent_line_id = tbl_transaction_temp_id(ii) -- child task
4137: AND mmtt.transaction_temp_id <> tbl_transaction_temp_id(ii) -- not parent task
4138: AND l_lot_control_code(ii) = 2

Line 4208: l_task_new_rec mtl_material_transactions_temp%ROWTYPE;

4204:
4205: l_hash_split_fac_value NUMBER;
4206: l_hash_split_fac_string VARCHAR2(2000) := NULL;
4207:
4208: l_task_new_rec mtl_material_transactions_temp%ROWTYPE;
4209: l_child_new_rec mtl_material_transactions_temp%ROWTYPE;
4210: l_lot_split_rec inv_rcv_common_apis.trans_rec_tb_tp;
4211:
4212: l_organization_id NUMBER;

Line 4209: l_child_new_rec mtl_material_transactions_temp%ROWTYPE;

4205: l_hash_split_fac_value NUMBER;
4206: l_hash_split_fac_string VARCHAR2(2000) := NULL;
4207:
4208: l_task_new_rec mtl_material_transactions_temp%ROWTYPE;
4209: l_child_new_rec mtl_material_transactions_temp%ROWTYPE;
4210: l_lot_split_rec inv_rcv_common_apis.trans_rec_tb_tp;
4211:
4212: l_organization_id NUMBER;
4213: l_parent_line_id NUMBER;

Line 4267: FROM mtl_material_transactions_temp mmtt

4263:
4264: CURSOR c_child_tasks(p_parent_line_id NUMBER) IS
4265: SELECT mmtt.transaction_temp_id
4266: , mmtt.transaction_quantity
4267: FROM mtl_material_transactions_temp mmtt
4268: , mtl_txn_request_lines mol
4269: , wsh_delivery_details_ob_grp_v wdd
4270: , wsh_delivery_assignments_v wda
4271: WHERE mmtt.parent_line_id = p_parent_line_id

Line 4281: FROM mtl_material_transactions_temp mmtt

4277: , mmtt.transaction_quantity DESC;
4278:
4279: CURSOR c_eqp_capacity(p_task_id NUMBER) IS
4280: SELECT res_equip.inventory_item_id
4281: FROM mtl_material_transactions_temp mmtt
4282: , bom_std_op_resources tt_x_res
4283: , bom_resources res
4284: , bom_resource_equipments res_equip
4285: WHERE mmtt.transaction_temp_id = p_task_id

Line 4332: FROM mtl_material_transactions_temp mmtt

4328: , l_sec_uom_code
4329: , l_item_prim_uom_code
4330: , l_lot_control_code
4331: , l_serial_number_control_code
4332: FROM mtl_material_transactions_temp mmtt
4333: , mtl_item_locations mil
4334: , mtl_secondary_inventories msi
4335: , mtl_system_items item
4336: WHERE mmtt.transaction_temp_id = p_mmtt_temp_id

Line 4751: FROM mtl_material_transactions_temp

4747:
4748: BEGIN
4749: SELECT *
4750: INTO l_task_new_rec
4751: FROM mtl_material_transactions_temp
4752: WHERE transaction_temp_id = p_mmtt_temp_id;
4753: EXCEPTION
4754: WHEN OTHERS THEN
4755: IF g_debug = 1 THEN

Line 4798: UPDATE mtl_material_transactions_temp

4794: END IF;
4795:
4796: IF l_child_total_qty <= l_new_qty THEN
4797: -- Update the child records with the new parent line id
4798: UPDATE mtl_material_transactions_temp
4799: SET parent_line_id = l_new_temp_id
4800: WHERE transaction_temp_id = l_child_rec.transaction_temp_id;
4801:
4802: l_child_remaining_qty := 0;

Line 4811: UPDATE mtl_material_transactions_temp

4807: l_child_remaining_qty := l_child_total_qty - l_new_qty;
4808: l_new_child_qty := l_child_rec.transaction_quantity - l_child_remaining_qty;
4809:
4810: -- Update the child line with the remaining qty
4811: UPDATE mtl_material_transactions_temp
4812: SET transaction_quantity = l_child_remaining_qty
4813: , primary_quantity = l_child_remaining_qty * l_txn_pri_uom_ratio
4814: , secondary_transaction_quantity
4815: = DECODE( secondary_uom_code

Line 4827: FROM mtl_material_transactions_temp

4823: FROM DUAL;
4824:
4825: SELECT *
4826: INTO l_child_new_rec
4827: FROM mtl_material_transactions_temp
4828: WHERE transaction_temp_id = l_child_rec.transaction_temp_id;
4829:
4830: l_child_new_rec.transaction_temp_id := l_new_child_temp_id;
4831: l_child_new_rec.transaction_quantity := l_new_child_qty;

Line 4893: UPDATE mtl_material_transactions_temp

4889: print_debug('Update original MMTT row with remaining qty: '
4890: || l_init_qty, l_api_name);
4891: END IF;
4892:
4893: UPDATE mtl_material_transactions_temp
4894: SET transaction_quantity = l_init_qty
4895: , primary_quantity = l_init_qty * l_txn_pri_uom_ratio
4896: , secondary_transaction_quantity
4897: = DECODE( secondary_uom_code

Line 4993: FROM mtl_material_transactions_temp

4989: l_wpr_rec wms_pr_workers%ROWTYPE;
4990:
4991: CURSOR c_split_tasks (p_txn_batch_id NUMBER) IS
4992: SELECT transaction_temp_id
4993: FROM mtl_material_transactions_temp
4994: WHERE transaction_batch_id = p_txn_batch_id
4995: AND standard_operation_id IS NOT NULL; -- skip rows without task types
4996:
4997: BEGIN

Line 5119: FROM mtl_material_transactions_temp

5115: l_mmtt_hid tbl_num;
5116:
5117: CURSOR c_mmtt_cursor (p_batch_id NUMBER) IS
5118: SELECT transaction_temp_id
5119: FROM mtl_material_transactions_temp
5120: WHERE transaction_batch_id = p_batch_id;
5121:
5122: BEGIN
5123: -- Initialize API return status to success

Line 5199: UPDATE mtl_material_transactions_temp

5195: END LOOP; --}
5196:
5197: -- Bulk update task_type_id in all the MMTTs with cached values
5198: FORALL kk IN l_mmtt_temp_id.FIRST .. l_mmtt_temp_id.LAST
5199: UPDATE mtl_material_transactions_temp
5200: SET standard_operation_id = l_mmtt_hid(kk)
5201: WHERE transaction_temp_id = l_mmtt_temp_id(kk);
5202: END LOOP; --}
5203:

Line 5224: UPDATE mtl_material_transactions_temp

5220: IF g_debug = 1 THEN
5221: print_debug('l_task_type_id value: ' || l_task_type_id, l_api_name);
5222: END IF;
5223:
5224: UPDATE mtl_material_transactions_temp
5225: SET standard_operation_id = l_task_type_id
5226: WHERE transaction_batch_id = p_transaction_batch_id;
5227: END IF; --}
5228:

Line 5568: FROM mtl_material_transactions_temp mmtt

5564: , get_device_id( mmtt.organization_id
5565: , mmtt.subinventory_code
5566: , mmtt.locator_id
5567: ) dev_id
5568: FROM mtl_material_transactions_temp mmtt
5569: WHERE mmtt.move_order_header_id = p_mo_hdr_id
5570: AND mmtt.parent_line_id IS NULL
5571: ) x
5572: , wms_devices_b dev

Line 5597: FROM mtl_material_transactions_temp mmtt

5593: , get_device_id( mmtt.organization_id
5594: , mmtt.subinventory_code
5595: , mmtt.locator_id
5596: ) dev_id
5597: FROM mtl_material_transactions_temp mmtt
5598: WHERE mmtt.move_order_header_id = p_mo_hdr_id
5599: AND mmtt.parent_line_id IS NOT NULL;
5600:
5601: -- Cursor for parent task records

Line 5641: FROM mtl_material_transactions_temp mmtt

5637: , get_device_id( mmtt.organization_id
5638: , mmtt.subinventory_code
5639: , mmtt.locator_id
5640: ) dev_id
5641: FROM mtl_material_transactions_temp mmtt
5642: WHERE mmtt.transaction_temp_id IN
5643: ( SELECT DISTINCT parent_line_id
5644: FROM mtl_material_transactions_temp mmtt1
5645: WHERE mmtt1.move_order_header_id = p_mo_hdr_id

Line 5644: FROM mtl_material_transactions_temp mmtt1

5640: ) dev_id
5641: FROM mtl_material_transactions_temp mmtt
5642: WHERE mmtt.transaction_temp_id IN
5643: ( SELECT DISTINCT parent_line_id
5644: FROM mtl_material_transactions_temp mmtt1
5645: WHERE mmtt1.move_order_header_id = p_mo_hdr_id
5646: AND mmtt1.parent_line_id IS NOT NULL
5647: )
5648: ) x,

Line 6361: l_pickslip_base VARCHAR2(2000) := ' FROM mtl_material_transactions_temp mmtt'

6357:
6358: l_api_name VARCHAR2(30) := 'CreateDynSelSQL';
6359: l_count NUMBER := 0;
6360: l_pick_slip_sql VARCHAR2(2000) := 'SELECT ';
6361: l_pickslip_base VARCHAR2(2000) := ' FROM mtl_material_transactions_temp mmtt'
6362: || ' , mtl_txn_request_lines mtrl'
6363: || ' , wsh_inv_delivery_details_v wdd'
6364: || ' WHERE mtrl.header_id = :mo_header_id'
6365: || ' AND mmtt.move_order_line_id = mtrl.line_id'

Line 6373: || ' FROM mtl_material_transactions_temp mmtt'

6369: l_mmtt_sql_where VARCHAR2(2000) := '';
6370: l_mmtt_sql_base VARCHAR2(2000) := 'SELECT mmtt.transaction_temp_id'
6371: || ' , inv_salesorder.get_salesorder_for_oeheader(wdd.oe_header_id)'
6372: || ' , wdd.oe_line_id'
6373: || ' FROM mtl_material_transactions_temp mmtt'
6374: || ' , mtl_txn_request_lines mtrl'
6375: || ' , wsh_inv_delivery_details_v wdd '
6376: || ' WHERE mtrl.header_id = :mo_header_id'
6377: || ' AND mmtt.move_order_line_id = mtrl.line_id'

Line 6675: FROM mtl_material_transactions_temp mmtt

6671: CURSOR c_mold IS
6672: SELECT mmtt.transaction_temp_id
6673: , inv_salesorder.get_salesorder_for_oeheader(wdd.oe_header_id)
6674: , wdd.oe_line_id
6675: FROM mtl_material_transactions_temp mmtt
6676: , mtl_txn_request_lines mol
6677: , wsh_inv_delivery_details_v wdd
6678: WHERE mmtt.move_order_line_id = mol.line_id
6679: AND mol.header_id = p_mo_header_id

Line 6703: FROM mtl_material_transactions_temp mmtt1

6699: SELECT 'x' INTO l_dummy
6700: FROM dual
6701: WHERE EXISTS
6702: ( SELECT 'x'
6703: FROM mtl_material_transactions_temp mmtt1
6704: WHERE mmtt1.move_order_header_id = p_mo_header_id
6705: AND mmtt1.parent_line_id IS NULL
6706: AND mmtt1.pick_slip_number IS NULL
6707: );

Line 7147: -- Assign the pick slip number to the records in MTL_MATERIAL_TRANSACTIONS_TEMP

7143: , tbl_sales_order_id
7144: , tbl_oe_line_id LIMIT g_bulk_fetch_limit;
7145: EXIT WHEN tbl_transaction_temp_id.COUNT = 0;
7146:
7147: -- Assign the pick slip number to the records in MTL_MATERIAL_TRANSACTIONS_TEMP
7148: FORALL jj IN tbl_transaction_temp_id.FIRST .. tbl_transaction_temp_id.LAST
7149: UPDATE mtl_material_transactions_temp
7150: SET pick_slip_number = l_pick_slip_number
7151: , transaction_source_id = tbl_sales_order_id(jj)

Line 7149: UPDATE mtl_material_transactions_temp

7145: EXIT WHEN tbl_transaction_temp_id.COUNT = 0;
7146:
7147: -- Assign the pick slip number to the records in MTL_MATERIAL_TRANSACTIONS_TEMP
7148: FORALL jj IN tbl_transaction_temp_id.FIRST .. tbl_transaction_temp_id.LAST
7149: UPDATE mtl_material_transactions_temp
7150: SET pick_slip_number = l_pick_slip_number
7151: , transaction_source_id = tbl_sales_order_id(jj)
7152: , trx_source_line_id = tbl_oe_line_id(jj)
7153: , demand_source_header_id = tbl_sales_order_id(jj)

Line 7178: UPDATE mtl_material_transactions_temp

7174: , tbl_oe_line_id LIMIT g_bulk_fetch_limit;
7175: EXIT WHEN tbl_transaction_temp_id.COUNT = 0;
7176:
7177: FORALL jj IN tbl_transaction_temp_id.FIRST .. tbl_transaction_temp_id.LAST
7178: UPDATE mtl_material_transactions_temp
7179: SET pick_slip_number = wsh_pick_slip_numbers_s.NEXTVAL
7180: , transaction_source_id = tbl_sales_order_id(jj)
7181: , trx_source_line_id = tbl_oe_line_id(jj)
7182: , demand_source_header_id = tbl_sales_order_id(jj)

Line 7250: FROM mtl_material_transactions_temp

7246: t_txn_batch_id tbl_num;
7247:
7248: CURSOR c_lblprnt (p_batch_id NUMBER) IS
7249: SELECT transaction_temp_id
7250: FROM mtl_material_transactions_temp
7251: WHERE transaction_batch_id = p_batch_id;
7252:
7253: BEGIN
7254: x_return_status := fnd_api.g_ret_sts_success;

Line 7411: UPDATE mtl_material_transactions_temp

7407: END LOOP; --}
7408:
7409: IF t_txn_batch_id.COUNT > 0 THEN
7410: FORALL kk IN t_txn_batch_id.FIRST .. t_txn_batch_id.LAST
7411: UPDATE mtl_material_transactions_temp
7412: SET transaction_batch_id = NULL
7413: WHERE transaction_batch_id = t_txn_batch_id(kk);
7414:
7415: FORALL mm IN t_txn_batch_id.FIRST .. t_txn_batch_id.LAST

Line 7444: UPDATE mtl_material_transactions_temp

7440: COMMIT;
7441: END IF;
7442: IF t_txn_batch_id.COUNT > 0 THEN
7443: FORALL kk IN t_txn_batch_id.FIRST .. t_txn_batch_id.LAST
7444: UPDATE mtl_material_transactions_temp
7445: SET transaction_batch_id = NULL
7446: WHERE transaction_batch_id = t_txn_batch_id(kk);
7447: FORALL mm IN t_txn_batch_id.FIRST .. t_txn_batch_id.LAST
7448: DELETE FROM wms_pr_workers

Line 7469: UPDATE mtl_material_transactions_temp

7465: COMMIT;
7466: END IF;
7467: IF t_txn_batch_id.COUNT > 0 THEN
7468: FORALL kk IN t_txn_batch_id.FIRST .. t_txn_batch_id.LAST
7469: UPDATE mtl_material_transactions_temp
7470: SET transaction_batch_id = NULL
7471: WHERE transaction_batch_id = t_txn_batch_id(kk);
7472: FORALL mm IN t_txn_batch_id.FIRST .. t_txn_batch_id.LAST
7473: DELETE FROM wms_pr_workers