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

Line 249: mtl_material_transactions_temp mmtt

245: IS
246: SELECT wdd.delivery_detail_id,
247: wdd.move_order_line_id
248: FROM wsh_delivery_details wdd,
249: mtl_material_transactions_temp mmtt
250: WHERE wdd.move_order_line_id=mmtt.move_order_line_id
251: AND wdd.organization_id =mmtt.organization_id
252: AND (mmtt.transfer_lpn_id =c_lpn_id
253: OR mmtt.cartonization_id = c_lpn_id);

Line 261: mtl_material_transactions_temp mmtt

257: IS
258: SELECT wdd.delivery_detail_id,
259: wdd.move_order_line_id
260: FROM wsh_delivery_details wdd,
261: mtl_material_transactions_temp mmtt
262: WHERE wdd.move_order_line_id=mmtt.move_order_line_id
263: AND wdd.organization_id =mmtt.organization_id
264: AND mmtt.cartonization_id = c_lpn_id
265: AND ROWNUM = 1;*/

Line 274: FROM mtl_material_transactions_temp

270: WHERE delivery_detail_id = p_delivery_detail_id;
271: CURSOR c_bulk_task(p_transaction_number NUMBER)
272: IS
273: SELECT '1'
274: FROM mtl_material_transactions_temp
275: WHERE parent_line_id = p_transaction_number
276: AND rownum = 1;
277:
278: l_carton_lpn_ctx NUMBER;

Line 402: mtl_material_transactions_temp mmtt

398: wdd.move_order_line_id
399: INTO l_temp_del_detail_id,
400: l_move_order_line_id
401: FROM wsh_delivery_details wdd,
402: mtl_material_transactions_temp mmtt
403: WHERE wdd.move_order_line_id = mmtt.move_order_line_id
404: AND mmtt.transaction_temp_id = p_task_table(i).transaction_number;
405: EXCEPTION
406: WHEN OTHERS THEN

Line 593: FROM mtl_material_transactions_temp

589: SELECT STATUS FROM wms_op_plan_instances
590: WHERE ((
591: source_task_id in
592: (SELECT parent_line_id
593: FROM mtl_material_transactions_temp
594: WHERE transaction_temp_id =v_source_task_id
595: )) OR (source_task_id =v_source_task_id )); ---contains parent only
596:
597: l_op_plan_b_rec C_OP_PLANS_B%ROWTYPE;

Line 656: FROM mtl_material_transactions_temp mmtt,

652: Updating such dispatched tasks to pending/unreleased status SHOULD NOT be allowed. */
653: BEGIN
654: SELECT COUNT(*)
655: INTO l_count
656: FROM mtl_material_transactions_temp mmtt,
657: WMS_DISPATCHED_TASKS wdt
658: WHERE mmtt.transaction_temp_id = wdt.transaction_temp_id
659: AND wdt.transaction_temp_id =p_task_rec.TRANSACTION_NUMBER
660: AND wdt.status = 3

Line 669: FROM mtl_material_transactions_temp mmtt1

665: AND wdt2.status = 9
666: AND wdt2.task_method IS NOT NULL
667: AND wdt2.transaction_temp_id IN
668: (SELECT transaction_temp_id
669: FROM mtl_material_transactions_temp mmtt1
670: WHERE
671: DECODE(wdt.TASK_METHOD, 'CARTON', mmtt1.cartonization_id, 'PICK_SLIP', mmtt1.pick_slip_number, 'DISCRETE', mmtt1.pick_slip_number, mmtt1.transaction_source_id) =
672: DECODE(wdt.TASK_METHOD, 'CARTON', mmtt.cartonization_id, 'PICK_SLIP', mmtt.pick_slip_number, 'DISCRETE', mmtt.pick_slip_number, mmtt.transaction_source_id)
673: )

Line 930: FROM mtl_material_transactions_temp

926: ACTIVITY_TYPE_ID =l_op_plan_b_rec.ACTIVITY_TYPE_ID ,
927: PLAN_TYPE_ID =l_op_plan_b_rec.PLAN_TYPE_ID
928: WHERE ((source_task_id IN
929: (SELECT parent_line_id
930: FROM mtl_material_transactions_temp
931: WHERE transaction_temp_id=p_task_rec.transaction_number
932: ))
933: OR (source_task_id = p_task_rec.transaction_number)); --update parent records only
934: OPEN c_plan_detail(p_new_operation_plan_id);

Line 962: FROM mtl_material_transactions_temp

958: --ACTIVITY_TYPE=l_operation_plan_detail_rec.ACTIVITY_TYPE ,
959: IS_IN_INVENTORY =l_operation_plan_detail_rec.IS_IN_INVENTORY
960: WHERE ((source_task_id IN
961: (SELECT TRANSACTION_TEMP_ID
962: FROM mtl_material_transactions_temp
963: WHERE parent_line_id=p_task_rec.transaction_number
964: ))
965: OR ( source_task_id =p_task_rec.transaction_number));--update all the children records only
966: END IF;

Line 984: FROM mtl_material_transactions_temp

980: END IF; -- l_op_operation_status_rec.STATUS end
981:
982: SELECT parent_line_id
983: INTO l_src_parent_id
984: FROM mtl_material_transactions_temp
985: WHERE TRANSACTION_TEMP_ID=p_task_rec.transaction_number;
986: IF (l_src_parent_id IS NULL) THEN
987: l_src_tran_id :=p_task_rec.transaction_number;
988: UPDATE mtl_material_transactions_temp mmtt

Line 988: UPDATE mtl_material_transactions_temp mmtt

984: FROM mtl_material_transactions_temp
985: WHERE TRANSACTION_TEMP_ID=p_task_rec.transaction_number;
986: IF (l_src_parent_id IS NULL) THEN
987: l_src_tran_id :=p_task_rec.transaction_number;
988: UPDATE mtl_material_transactions_temp mmtt
989: SET mmtt.OPERATION_PLAN_ID=p_new_operation_plan_id
990: WHERE mmtt.PARENT_LINE_ID = l_src_tran_id;--update child record
991: ELSE
992: l_src_tran_id:=l_src_parent_id;

Line 993: UPDATE mtl_material_transactions_temp mmtt

989: SET mmtt.OPERATION_PLAN_ID=p_new_operation_plan_id
990: WHERE mmtt.PARENT_LINE_ID = l_src_tran_id;--update child record
991: ELSE
992: l_src_tran_id:=l_src_parent_id;
993: UPDATE mtl_material_transactions_temp mmtt
994: SET mmtt.OPERATION_PLAN_ID =p_new_operation_plan_id
995: WHERE mmtt.TRANSACTION_TEMP_ID = l_src_tran_id;--update parent record
996: END IF; --parent if end
997: p_output_task_rec.operation_plan_id := p_new_operation_plan_id;

Line 1024: /*UPDATE mtl_material_transactions_temp

1020: p_output_task_rec.RESULT := 'E';
1021: p_output_task_rec.ERROR := l_err_msg;
1022: RETURN;
1023: ELSE --update the mmtt with new plan
1024: /*UPDATE mtl_material_transactions_temp
1025: SET operation_plan_id = p_new_operation_plan_id
1026: WHERE transaction_temp_id = p_task_rec.transaction_number;*/
1027: p_output_task_rec.operation_plan_id := p_new_operation_plan_id;
1028: END IF;

Line 1080: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt

1076: parent_line_id
1077: INTO l_task_exists ,
1078: l_task_type ,
1079: l_parent_line_id
1080: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt
1081: WHERE mmtt.transaction_temp_id=p_transaction_number;
1082: EXCEPTION
1083: WHEN NO_DATA_FOUND THEN
1084: null;

Line 1122: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt

1118: INTO l_wdt_status
1119: FROM Wms_Dispatched_Tasks wdt
1120: WHERE wdt.transaction_temp_id in
1121: (SELECT transaction_temp_id --To check the child tasks
1122: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt
1123: WHERE mmtt.parent_line_id = p_transaction_number
1124: UNION SELECT mmtt2.transaction_temp_id --To check the siblings
1125: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt1 ,
1126: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt2

Line 1125: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt1 ,

1121: (SELECT transaction_temp_id --To check the child tasks
1122: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt
1123: WHERE mmtt.parent_line_id = p_transaction_number
1124: UNION SELECT mmtt2.transaction_temp_id --To check the siblings
1125: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt1 ,
1126: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt2
1127: WHERE mmtt1.transaction_temp_id = p_transaction_number
1128: AND mmtt2.parent_line_id = mmtt1.parent_line_id
1129: UNION SELECT mmtt2.transaction_temp_id ---To check the parent task.

Line 1126: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt2

1122: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt
1123: WHERE mmtt.parent_line_id = p_transaction_number
1124: UNION SELECT mmtt2.transaction_temp_id --To check the siblings
1125: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt1 ,
1126: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt2
1127: WHERE mmtt1.transaction_temp_id = p_transaction_number
1128: AND mmtt2.parent_line_id = mmtt1.parent_line_id
1129: UNION SELECT mmtt2.transaction_temp_id ---To check the parent task.
1130: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt1 ,

Line 1130: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt1 ,

1126: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt2
1127: WHERE mmtt1.transaction_temp_id = p_transaction_number
1128: AND mmtt2.parent_line_id = mmtt1.parent_line_id
1129: UNION SELECT mmtt2.transaction_temp_id ---To check the parent task.
1130: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt1 ,
1131: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt2
1132: WHERE mmtt1.transaction_temp_id = p_transaction_number
1133: AND mmtt2.transaction_temp_id = mmtt1.parent_line_id
1134: ) ;

Line 1131: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt2

1127: WHERE mmtt1.transaction_temp_id = p_transaction_number
1128: AND mmtt2.parent_line_id = mmtt1.parent_line_id
1129: UNION SELECT mmtt2.transaction_temp_id ---To check the parent task.
1130: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt1 ,
1131: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt2
1132: WHERE mmtt1.transaction_temp_id = p_transaction_number
1133: AND mmtt2.transaction_temp_id = mmtt1.parent_line_id
1134: ) ;
1135: END IF;

Line 1222: mtl_material_transactions_temp mmtt

1218: IS
1219: SELECT wdd.delivery_detail_id,
1220: wdd.move_order_line_id
1221: FROM wsh_delivery_details wdd,
1222: mtl_material_transactions_temp mmtt
1223: WHERE wdd.move_order_line_id=mmtt.move_order_line_id
1224: AND wdd.organization_id =mmtt.organization_id
1225: AND mmtt.transfer_lpn_id =c_lpn_id
1226: AND ROWNUM < 2;

Line 1232: mtl_material_transactions_temp mmtt

1228: IS
1229: SELECT wdd.delivery_detail_id,
1230: wdd.move_order_line_id
1231: FROM wsh_delivery_details wdd,
1232: mtl_material_transactions_temp mmtt
1233: WHERE wdd.move_order_line_id=mmtt.move_order_line_id
1234: AND wdd.organization_id =mmtt.organization_id
1235: AND mmtt.cartonization_id = c_lpn_id
1236: AND ROWNUM = 1;

Line 1245: FROM mtl_material_transactions_temp

1241: WHERE delivery_detail_id = p_delivery_detail_id;
1242: CURSOR c_bulk_task(p_transaction_number NUMBER)
1243: IS
1244: SELECT '1'
1245: FROM mtl_material_transactions_temp
1246: WHERE parent_line_id = p_transaction_number
1247: AND rownum = 1;
1248: l_carton_lpn_ctx NUMBER;
1249: l_carton_lpn_org NUMBER;

Line 1342: mtl_material_transactions_temp mmtt

1338: wdd.move_order_line_id
1339: INTO l_temp_del_detail_id,
1340: l_move_order_line_id
1341: FROM wsh_delivery_details wdd,
1342: mtl_material_transactions_temp mmtt
1343: WHERE wdd.move_order_line_id = mmtt.move_order_line_id
1344: AND mmtt.transaction_temp_id = p_task_table(i).transaction_number;
1345: EXCEPTION
1346: WHEN OTHERS THEN

Line 1509: FROM mtl_material_transactions_temp

1505: l_mmtt_transaction_uom ,
1506: l_mmtt_organization_id ,
1507: l_mmtt_secondary_uom , -- Added for Bug 16099247
1508: l_mmtt_sec_transaction_qty -- Added for Bug 16099247
1509: FROM mtl_material_transactions_temp
1510: WHERE transaction_temp_id = p_transaction_temp_id;
1511: SELECT lot_control_code ,
1512: serial_number_control_code,
1513: tracking_quantity_ind -- Added for Bug 16099247

Line 1901: FROM mtl_material_transactions_temp

1897: l_mmtt_organization_id ,
1898: l_task_type ,
1899: l_parent_line_id ,
1900: l_mmtt_sec_transaction_qty -- Added for Bug 16099247
1901: FROM mtl_material_transactions_temp
1902: WHERE transaction_temp_id = p_transaction_temp_id FOR UPDATE NOWAIT;
1903: IF l_mmtt_allocated_lpn_id IS NOT NULL THEN
1904: x_return_status := 'E';
1905: IF g_debug = 1 THEN

Line 2531: This procedure performs the split for the Pending task record in mtl_material_transactions_temp table

2527: END split_wdt;
2528:
2529: -------------------------------------------------------------------------------------------------------------------
2530: /*PROCEDURE split_mmtt()
2531: This procedure performs the split for the Pending task record in mtl_material_transactions_temp table
2532: */
2533: -------------------------------------------------------------------------------------------------------------------
2534: PROCEDURE split_mmtt( p_orig_transaction_temp_id IN NUMBER ,
2535: p_new_transaction_temp_id IN NUMBER ,

Line 2553: INTO mtl_material_transactions_temp

2549: IF g_debug = 1 THEN
2550: print_msg(l_procedure_name, ' Entered ');
2551: END IF;
2552: INSERT
2553: INTO mtl_material_transactions_temp
2554: (
2555: currency_conversion_date ,
2556: shipment_number ,
2557: org_cost_group_id ,

Line 3036: FROM mtl_material_transactions_temp

3032: common_bom_seq_id ,
3033: common_routing_seq_id ,
3034: ussgl_transaction_code ,
3035: fulfillment_base --16662319
3036: FROM mtl_material_transactions_temp
3037: WHERE transaction_temp_id = p_orig_transaction_temp_id;
3038: x_return_status := 'S';
3039: EXCEPTION
3040: WHEN OTHERS THEN

Line 3292: mtl_material_transactions_temp mmtt

3288: msi.lot_control_code ,
3289: msi.serial_number_control_code,
3290: mmtt.parent_line_id
3291: FROM mtl_system_items msi,
3292: mtl_material_transactions_temp mmtt
3293: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
3294: AND msi.inventory_item_id = mmtt.inventory_item_id
3295: AND msi.organization_id = mmtt.organization_id;
3296: BEGIN

Line 3454: DELETE mtl_material_transactions_temp

3450: RAISE exc_not_deleted;
3451: END IF;
3452: END IF;
3453: -- Deleting the Transaction
3454: DELETE mtl_material_transactions_temp
3455: WHERE transaction_temp_id = p_transaction_temp_id;
3456: IF SQL%ROWCOUNT = 0 THEN
3457: IF l_debug = 1 THEN
3458: debug_print ( 'Error deleting MMTT ');

Line 3867: mtl_material_transactions_temp mmtt

3863: FROM DUAL
3864: WHERE EXISTS
3865: (SELECT 1
3866: FROM wms_dispatched_tasks wdt,
3867: mtl_material_transactions_temp mmtt
3868: WHERE mmtt.move_order_line_id = l_mo_line_rec.line_id
3869: AND wdt.transaction_temp_id = nvl(mmtt.parent_line_id, mmtt.transaction_temp_id)
3870: AND wdt.status IN (4,9)
3871: );

Line 3885: FROM mtl_material_transactions_temp mmtt

3881: SELECT mmtt.transaction_temp_id ,
3882: ABS(mmtt.primary_quantity) primary_quantity ,
3883: ABS(mmtt.transaction_quantity) transaction_quantity ,
3884: mmtt.reservation_id
3885: FROM mtl_material_transactions_temp mmtt
3886: WHERE mmtt.move_order_line_id = p_line_id
3887: AND NOT EXISTS
3888: (SELECT 1
3889: FROM mtl_material_transactions_temp t

Line 3889: FROM mtl_material_transactions_temp t

3885: FROM mtl_material_transactions_temp mmtt
3886: WHERE mmtt.move_order_line_id = p_line_id
3887: AND NOT EXISTS
3888: (SELECT 1
3889: FROM mtl_material_transactions_temp t
3890: WHERE t.parent_line_id = mmtt.transaction_temp_id
3891: )
3892: FOR UPDATE NOWAIT;
3893: BEGIN

Line 3920: FROM mtl_material_transactions_temp

3916: debug_print('p_transaction_temp_id' || p_transaction_temp_id);
3917: END IF;
3918: SELECT transaction_quantity
3919: INTO l_transaction_quantity
3920: FROM mtl_material_transactions_temp
3921: WHERE transaction_temp_id = p_transaction_temp_id;
3922: IF l_debug = 1 THEN
3923: debug_print('l_transaction_quantity' || l_transaction_quantity);
3924: END IF;

Line 4073: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec

4069: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4070: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4071: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4072: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
4073: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4074: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4075: l_mo_line_rec inv_move_order_pub.trolin_rec_type;
4076: l_mo_type NUMBER;
4077: l_wdt_count NUMBER;

Line 4091: FROM mtl_material_transactions_temp mmtt

4087: mmtt.transaction_uom ,
4088: mmtt.primary_quantity ,
4089: mmtt.transaction_quantity ,
4090: mmtt.wms_task_type
4091: FROM mtl_material_transactions_temp mmtt
4092: WHERE mmtt.transaction_temp_id = l_transaction_number
4093: AND NOT EXISTS
4094: (SELECT 1
4095: FROM mtl_material_transactions_temp t1

Line 4095: FROM mtl_material_transactions_temp t1

4091: FROM mtl_material_transactions_temp mmtt
4092: WHERE mmtt.transaction_temp_id = l_transaction_number
4093: AND NOT EXISTS
4094: (SELECT 1
4095: FROM mtl_material_transactions_temp t1
4096: WHERE t1.parent_line_id = mmtt.transaction_temp_id
4097: )
4098: UNION ALL
4099: SELECT mmtt.transaction_temp_id ,

Line 4108: FROM mtl_material_transactions_temp mmtt

4104: mmtt.transaction_uom ,
4105: mmtt.primary_quantity ,
4106: mmtt.transaction_quantity ,
4107: mmtt.wms_task_type
4108: FROM mtl_material_transactions_temp mmtt
4109: WHERE mmtt.parent_line_id = l_transaction_number
4110: AND mmtt.parent_line_id <> mmtt.transaction_temp_id;
4111: -- This union by will end up getting all PARENTS too *****
4112: CURSOR c_mo_line_info

Line 4122: FROM mtl_material_transactions_temp mmtt

4118: WHERE mtrl.line_id = l_transaction_record.move_order_line_id;
4119: CURSOR c_get_other_mmtt
4120: IS
4121: SELECT COUNT(*)
4122: FROM mtl_material_transactions_temp mmtt
4123: WHERE mmtt.move_order_line_id = l_transaction_record.move_order_line_id
4124: AND mmtt.transaction_temp_id <> l_transaction_record.transaction_temp_id
4125: AND NOT EXISTS
4126: (SELECT 1

Line 4127: FROM mtl_material_transactions_temp t1

4123: WHERE mmtt.move_order_line_id = l_transaction_record.move_order_line_id
4124: AND mmtt.transaction_temp_id <> l_transaction_record.transaction_temp_id
4125: AND NOT EXISTS
4126: (SELECT 1
4127: FROM mtl_material_transactions_temp t1
4128: WHERE t1.parent_line_id = mmtt.transaction_temp_id
4129: );
4130: CURSOR c_mo_type
4131: IS

Line 4216: FROM mtl_material_transactions_temp mmtt ,

4212: l_pri_rsv_qty ,
4213: l_rsv_qty ,
4214: l_pri_rsv_uom ,
4215: l_rsv_uom
4216: FROM mtl_material_transactions_temp mmtt ,
4217: mtl_reservations mr
4218: WHERE mmtt.transaction_temp_id = l_transaction_record.transaction_temp_id
4219: AND mr.reservation_id = mmtt.reservation_id ;
4220: IF (l_debug = 1) THEN

Line 4465: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec

4461: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4462: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4463: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4464: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
4465: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4466: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4467: l_debug NUMBER;
4468: exc_not_deleted EXCEPTION;
4469: CURSOR c_mmtt_info

Line 4479: FROM mtl_material_transactions_temp mmtt

4475: mmtt.move_order_line_id ,
4476: mmtt.transaction_uom ,
4477: mmtt.primary_quantity ,
4478: mmtt.wms_task_type
4479: FROM mtl_material_transactions_temp mmtt
4480: WHERE mmtt.transaction_temp_id = l_transaction_number
4481: AND NOT EXISTS
4482: (SELECT 1
4483: FROM mtl_material_transactions_temp t1

Line 4483: FROM mtl_material_transactions_temp t1

4479: FROM mtl_material_transactions_temp mmtt
4480: WHERE mmtt.transaction_temp_id = l_transaction_number
4481: AND NOT EXISTS
4482: (SELECT 1
4483: FROM mtl_material_transactions_temp t1
4484: WHERE t1.parent_line_id = mmtt.transaction_temp_id
4485: )
4486: UNION ALL
4487: SELECT mmtt.transaction_temp_id ,

Line 4495: FROM mtl_material_transactions_temp mmtt

4491: mmtt.move_order_line_id ,
4492: mmtt.transaction_uom ,
4493: mmtt.primary_quantity ,
4494: mmtt.wms_task_type
4495: FROM mtl_material_transactions_temp mmtt
4496: WHERE mmtt.parent_line_id = l_transaction_number
4497: AND mmtt.parent_line_id <> mmtt.transaction_temp_id;
4498: -- This union by will end up getting all PARENTS too *****
4499: CURSOR c_mo_line_info

Line 4509: FROM mtl_material_transactions_temp mmtt

4505: WHERE mtrl.line_id = l_transaction_record.move_order_line_id;
4506: CURSOR c_get_other_mmtt
4507: IS
4508: SELECT COUNT(*)
4509: FROM mtl_material_transactions_temp mmtt
4510: WHERE mmtt.move_order_line_id = l_transaction_record.move_order_line_id
4511: AND mmtt.transaction_temp_id <> l_transaction_record.transaction_temp_id
4512: AND NOT EXISTS
4513: (SELECT 1

Line 4514: FROM mtl_material_transactions_temp t1

4510: WHERE mmtt.move_order_line_id = l_transaction_record.move_order_line_id
4511: AND mmtt.transaction_temp_id <> l_transaction_record.transaction_temp_id
4512: AND NOT EXISTS
4513: (SELECT 1
4514: FROM mtl_material_transactions_temp t1
4515: WHERE t1.parent_line_id = mmtt.transaction_temp_id
4516: );
4517: BEGIN
4518: x_return_status := fnd_api.g_ret_sts_success;

Line 4689: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec

4685: x_msg_count NUMBER;
4686: x_msg_data VARCHAR2(50);
4687: l_return_status VARCHAR2(1);
4688: l_transaction_number NUMBER ;
4689: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4690: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4691: l_op_plan_rec wms_op_plan_instances%rowtype ; --WOPI rec
4692: exc_not_deleted EXCEPTION;
4693: l_op_plan_status NUMBER ;

Line 4707: FROM mtl_material_transactions_temp mmtt

4703: mmtt.move_order_line_id ,
4704: mmtt.transaction_uom ,
4705: mmtt.primary_quantity ,
4706: mmtt.transaction_quantity
4707: FROM mtl_material_transactions_temp mmtt
4708: WHERE mmtt.transaction_temp_id = l_transaction_number
4709: AND NOT EXISTS
4710: (SELECT 1
4711: FROM mtl_material_transactions_temp t1

Line 4711: FROM mtl_material_transactions_temp t1

4707: FROM mtl_material_transactions_temp mmtt
4708: WHERE mmtt.transaction_temp_id = l_transaction_number
4709: AND NOT EXISTS
4710: (SELECT 1
4711: FROM mtl_material_transactions_temp t1
4712: WHERE t1.parent_line_id = mmtt.transaction_temp_id
4713: )
4714: UNION ALL
4715: SELECT mmtt.transaction_temp_id ,

Line 4723: FROM mtl_material_transactions_temp mmtt

4719: mmtt.move_order_line_id ,
4720: mmtt.transaction_uom ,
4721: mmtt.primary_quantity ,
4722: mmtt.transaction_quantity
4723: FROM mtl_material_transactions_temp mmtt
4724: WHERE mmtt.parent_line_id = l_transaction_number
4725: AND mmtt.parent_line_id <> mmtt.transaction_temp_id;
4726: CURSOR c_mo_line_info
4727: IS

Line 4737: FROM mtl_material_transactions_temp mmtt

4733: WHERE mtrl.line_id = l_transaction_record.move_order_line_id;
4734: CURSOR c_get_other_mmtt
4735: IS
4736: SELECT COUNT(*)
4737: FROM mtl_material_transactions_temp mmtt
4738: WHERE mmtt.move_order_line_id = l_transaction_record.move_order_line_id
4739: AND mmtt.transaction_temp_id <> l_transaction_record.transaction_temp_id
4740: AND NOT EXISTS
4741: (SELECT 1

Line 4742: FROM mtl_material_transactions_temp t1

4738: WHERE mmtt.move_order_line_id = l_transaction_record.move_order_line_id
4739: AND mmtt.transaction_temp_id <> l_transaction_record.transaction_temp_id
4740: AND NOT EXISTS
4741: (SELECT 1
4742: FROM mtl_material_transactions_temp t1
4743: WHERE t1.parent_line_id = mmtt.transaction_temp_id
4744: );
4745: CURSOR c_plan_instance
4746: IS

Line 4875: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

4871: END IF;
4872: l_progress := '370';
4873: --delete the parent mmtt
4874: DELETE
4875: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
4876: WHERE transaction_temp_id = l_transaction_record.parent_line_id ;
4877: IF SQL%ROWCOUNT =0 THEN
4878: IF l_debug =1 THEN
4879: debug_print('Count not delete the parent mmtt');

Line 5088: l_transaction_record mtl_material_transactions_temp%rowtype ;

5084: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
5085: l_task_rec task_record_type ;
5086: x_task_rec task_record_type ;
5087: l_transaction_number NUMBER;
5088: l_transaction_record mtl_material_transactions_temp%rowtype ;
5089: /*Local variable for the validate_task API*/
5090: l_ret_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
5091: l_val_ret_status VARCHAR2(30);
5092: l_task_type NUMBER ;

Line 5136: FROM mtl_material_transactions_temp

5132: SELECT 1,
5133: wms_task_type
5134: INTO l_task_exists,
5135: l_task_type
5136: FROM mtl_material_transactions_temp
5137: WHERE transaction_temp_id = l_ret_task_table(i).transaction_number FOR UPDATE NOWAIT;
5138: EXCEPTION
5139: WHEN NO_DATA_FOUND THEN
5140: null;

Line 5295: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;

5291: ,x_msg_data OUT NOCOPY VARCHAR2
5292: )
5293: IS
5294:
5295: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
5296: l_mcce_rec mtl_cycle_count_entries%ROWTYPE;
5297: l_query_tab query_tab_type;
5298:
5299:

Line 5321: SELECT 1 FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mtrl

5317:
5318: c_cd_exist number;
5319:
5320: CURSOR c_cd_task (p_transaction_number IN NUMBER) IS
5321: SELECT 1 FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mtrl
5322: WHERE mtrl.backorder_delivery_detail_id IS NOT NULL
5323: AND mtrl.line_id = mmtt.move_order_line_id
5324: AND transaction_temp_id = p_transaction_number;
5325: --added for completed tasks under bug 6854145

Line 5341: FROM mtl_material_transactions_temp

5337: IF(p_transaction_number IS NOT NULL) THEN
5338: BEGIN
5339: SELECT *
5340: INTO l_mmtt_rec
5341: FROM mtl_material_transactions_temp
5342: WHERE transaction_temp_id = p_transaction_number;
5343:
5344: IF(l_debug = 1) THEN
5345: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for task: '||p_transaction_number;

Line 6733: from mtl_material_transactions_temp

6729: --Bug 6766048
6730: CURSOR C_MMTT_ORG_ITM (p_txn_temp_id NUMBER)
6731: IS
6732: select inventory_item_id, organization_id
6733: from mtl_material_transactions_temp
6734: where transaction_temp_id = p_txn_temp_id;
6735:
6736: CURSOR C_LOT_DIVISIBLE (p_item_id NUMBER,p_organization_id NUMBER )
6737: IS

Line 6958: UPDATE mtl_material_transactions_temp

6954: END IF;
6955: END IF;
6956: -- Update the original row
6957: BEGIN
6958: UPDATE mtl_material_transactions_temp
6959: SET primary_quantity = primary_quantity - l_split_uom_quantities(i).primary_quantity ,
6960: transaction_quantity = transaction_quantity - l_split_uom_quantities(i).transaction_quantity ,
6961: secondary_transaction_quantity = secondary_transaction_quantity - l_split_uom_quantities(i).secondary_quantity , -- Added for Bug 16099247
6962: last_updated_by = FND_GLOBAL.USER_ID

Line 7309: FROM mtl_material_transactions_temp

7305: --Cursor to lock the mmtt record before updation.
7306: Cursor c_lock_mmtt (p_transaction_number NUMBER)
7307: IS
7308: SELECT '1'
7309: FROM mtl_material_transactions_temp
7310: WHERE transaction_temp_id = p_transaction_number FOR UPDATE NOWAIT;
7311: --Cursor to lock the mcce record before updation.
7312: Cursor c_lock_mcce (p_transaction_number NUMBER)
7313: IS

Line 7727: UPDATE mtl_material_transactions_temp

7723: END IF;
7724:
7725: IF (l_mmtt_transaction_num_table.COUNT > 0) THEN
7726: FORALL i in 1..l_mmtt_transaction_num_table.COUNT
7727: UPDATE mtl_material_transactions_temp
7728: SET wms_task_status = l_mmtt_status_id_table(i) ,
7729: operation_plan_id = l_mmtt_operation_plan_id_table(i),
7730: cartonization_id = l_mmtt_cartonization_id_table(i) ,
7731: task_priority = l_mmtt_priority_table(i) ,