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 1501: FROM mtl_material_transactions_temp

1497: l_mmtt_transaction_quantity ,
1498: l_mmtt_item_primary_uom_code ,
1499: l_mmtt_transaction_uom ,
1500: l_mmtt_organization_id
1501: FROM mtl_material_transactions_temp
1502: WHERE transaction_temp_id = p_transaction_temp_id;
1503: SELECT lot_control_code ,
1504: serial_number_control_code
1505: INTO l_lot_control_code ,

Line 1825: FROM mtl_material_transactions_temp

1821: l_mmtt_transaction_uom ,
1822: l_mmtt_organization_id ,
1823: l_task_type ,
1824: l_parent_line_id
1825: FROM mtl_material_transactions_temp
1826: WHERE transaction_temp_id = p_transaction_temp_id FOR UPDATE NOWAIT;
1827: IF l_mmtt_allocated_lpn_id IS NOT NULL THEN
1828: x_return_status := 'E';
1829: IF g_debug = 1 THEN

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

2441: END split_wdt;
2442:
2443: -------------------------------------------------------------------------------------------------------------------
2444: /*PROCEDURE split_mmtt()
2445: This procedure performs the split for the Pending task record in mtl_material_transactions_temp table
2446: */
2447: -------------------------------------------------------------------------------------------------------------------
2448: PROCEDURE split_mmtt( p_orig_transaction_temp_id IN NUMBER ,
2449: p_new_transaction_temp_id IN NUMBER ,

Line 2466: INTO mtl_material_transactions_temp

2462: IF g_debug = 1 THEN
2463: print_msg(l_procedure_name, ' Entered ');
2464: END IF;
2465: INSERT
2466: INTO mtl_material_transactions_temp
2467: (
2468: currency_conversion_date ,
2469: shipment_number ,
2470: org_cost_group_id ,

Line 2947: FROM mtl_material_transactions_temp

2943: reservation_id ,
2944: common_bom_seq_id ,
2945: common_routing_seq_id ,
2946: ussgl_transaction_code
2947: FROM mtl_material_transactions_temp
2948: WHERE transaction_temp_id = p_orig_transaction_temp_id;
2949: x_return_status := 'S';
2950: EXCEPTION
2951: WHEN OTHERS THEN

Line 3203: mtl_material_transactions_temp mmtt

3199: msi.lot_control_code ,
3200: msi.serial_number_control_code,
3201: mmtt.parent_line_id
3202: FROM mtl_system_items msi,
3203: mtl_material_transactions_temp mmtt
3204: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
3205: AND msi.inventory_item_id = mmtt.inventory_item_id
3206: AND msi.organization_id = mmtt.organization_id;
3207: BEGIN

Line 3365: DELETE mtl_material_transactions_temp

3361: RAISE exc_not_deleted;
3362: END IF;
3363: END IF;
3364: -- Deleting the Transaction
3365: DELETE mtl_material_transactions_temp
3366: WHERE transaction_temp_id = p_transaction_temp_id;
3367: IF SQL%ROWCOUNT = 0 THEN
3368: IF l_debug = 1 THEN
3369: debug_print ( 'Error deleting MMTT ');

Line 3778: mtl_material_transactions_temp mmtt

3774: FROM DUAL
3775: WHERE EXISTS
3776: (SELECT 1
3777: FROM wms_dispatched_tasks wdt,
3778: mtl_material_transactions_temp mmtt
3779: WHERE mmtt.move_order_line_id = l_mo_line_rec.line_id
3780: AND wdt.transaction_temp_id = nvl(mmtt.parent_line_id, mmtt.transaction_temp_id)
3781: AND wdt.status IN (4,9)
3782: );

Line 3796: FROM mtl_material_transactions_temp mmtt

3792: SELECT mmtt.transaction_temp_id ,
3793: ABS(mmtt.primary_quantity) primary_quantity ,
3794: ABS(mmtt.transaction_quantity) transaction_quantity ,
3795: mmtt.reservation_id
3796: FROM mtl_material_transactions_temp mmtt
3797: WHERE mmtt.move_order_line_id = p_line_id
3798: AND NOT EXISTS
3799: (SELECT 1
3800: FROM mtl_material_transactions_temp t

Line 3800: FROM mtl_material_transactions_temp t

3796: FROM mtl_material_transactions_temp mmtt
3797: WHERE mmtt.move_order_line_id = p_line_id
3798: AND NOT EXISTS
3799: (SELECT 1
3800: FROM mtl_material_transactions_temp t
3801: WHERE t.parent_line_id = mmtt.transaction_temp_id
3802: )
3803: FOR UPDATE NOWAIT;
3804: BEGIN

Line 3831: FROM mtl_material_transactions_temp

3827: debug_print('p_transaction_temp_id' || p_transaction_temp_id);
3828: END IF;
3829: SELECT transaction_quantity
3830: INTO l_transaction_quantity
3831: FROM mtl_material_transactions_temp
3832: WHERE transaction_temp_id = p_transaction_temp_id;
3833: IF l_debug = 1 THEN
3834: debug_print('l_transaction_quantity' || l_transaction_quantity);
3835: END IF;

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

3980: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
3981: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
3982: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
3983: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
3984: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
3985: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
3986: l_mo_line_rec inv_move_order_pub.trolin_rec_type;
3987: l_mo_type NUMBER;
3988: l_wdt_count NUMBER;

Line 4002: FROM mtl_material_transactions_temp mmtt

3998: mmtt.transaction_uom ,
3999: mmtt.primary_quantity ,
4000: mmtt.transaction_quantity ,
4001: mmtt.wms_task_type
4002: FROM mtl_material_transactions_temp mmtt
4003: WHERE mmtt.transaction_temp_id = l_transaction_number
4004: AND NOT EXISTS
4005: (SELECT 1
4006: FROM mtl_material_transactions_temp t1

Line 4006: FROM mtl_material_transactions_temp t1

4002: FROM mtl_material_transactions_temp mmtt
4003: WHERE mmtt.transaction_temp_id = l_transaction_number
4004: AND NOT EXISTS
4005: (SELECT 1
4006: FROM mtl_material_transactions_temp t1
4007: WHERE t1.parent_line_id = mmtt.transaction_temp_id
4008: )
4009: UNION ALL
4010: SELECT mmtt.transaction_temp_id ,

Line 4019: FROM mtl_material_transactions_temp mmtt

4015: mmtt.transaction_uom ,
4016: mmtt.primary_quantity ,
4017: mmtt.transaction_quantity ,
4018: mmtt.wms_task_type
4019: FROM mtl_material_transactions_temp mmtt
4020: WHERE mmtt.parent_line_id = l_transaction_number
4021: AND mmtt.parent_line_id <> mmtt.transaction_temp_id;
4022: -- This union by will end up getting all PARENTS too *****
4023: CURSOR c_mo_line_info

Line 4033: FROM mtl_material_transactions_temp mmtt

4029: WHERE mtrl.line_id = l_transaction_record.move_order_line_id;
4030: CURSOR c_get_other_mmtt
4031: IS
4032: SELECT COUNT(*)
4033: FROM mtl_material_transactions_temp mmtt
4034: WHERE mmtt.move_order_line_id = l_transaction_record.move_order_line_id
4035: AND mmtt.transaction_temp_id <> l_transaction_record.transaction_temp_id
4036: AND NOT EXISTS
4037: (SELECT 1

Line 4038: FROM mtl_material_transactions_temp t1

4034: WHERE mmtt.move_order_line_id = l_transaction_record.move_order_line_id
4035: AND mmtt.transaction_temp_id <> l_transaction_record.transaction_temp_id
4036: AND NOT EXISTS
4037: (SELECT 1
4038: FROM mtl_material_transactions_temp t1
4039: WHERE t1.parent_line_id = mmtt.transaction_temp_id
4040: );
4041: CURSOR c_mo_type
4042: IS

Line 4127: FROM mtl_material_transactions_temp mmtt ,

4123: l_pri_rsv_qty ,
4124: l_rsv_qty ,
4125: l_pri_rsv_uom ,
4126: l_rsv_uom
4127: FROM mtl_material_transactions_temp mmtt ,
4128: mtl_reservations mr
4129: WHERE mmtt.transaction_temp_id = l_transaction_record.transaction_temp_id
4130: AND mr.reservation_id = mmtt.reservation_id ;
4131: IF (l_debug = 1) THEN

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

4372: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4373: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4374: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4375: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
4376: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4377: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4378: l_debug NUMBER;
4379: exc_not_deleted EXCEPTION;
4380: CURSOR c_mmtt_info

Line 4390: FROM mtl_material_transactions_temp mmtt

4386: mmtt.move_order_line_id ,
4387: mmtt.transaction_uom ,
4388: mmtt.primary_quantity ,
4389: mmtt.wms_task_type
4390: FROM mtl_material_transactions_temp mmtt
4391: WHERE mmtt.transaction_temp_id = l_transaction_number
4392: AND NOT EXISTS
4393: (SELECT 1
4394: FROM mtl_material_transactions_temp t1

Line 4394: FROM mtl_material_transactions_temp t1

4390: FROM mtl_material_transactions_temp mmtt
4391: WHERE mmtt.transaction_temp_id = l_transaction_number
4392: AND NOT EXISTS
4393: (SELECT 1
4394: FROM mtl_material_transactions_temp t1
4395: WHERE t1.parent_line_id = mmtt.transaction_temp_id
4396: )
4397: UNION ALL
4398: SELECT mmtt.transaction_temp_id ,

Line 4406: FROM mtl_material_transactions_temp mmtt

4402: mmtt.move_order_line_id ,
4403: mmtt.transaction_uom ,
4404: mmtt.primary_quantity ,
4405: mmtt.wms_task_type
4406: FROM mtl_material_transactions_temp mmtt
4407: WHERE mmtt.parent_line_id = l_transaction_number
4408: AND mmtt.parent_line_id <> mmtt.transaction_temp_id;
4409: -- This union by will end up getting all PARENTS too *****
4410: CURSOR c_mo_line_info

Line 4420: FROM mtl_material_transactions_temp mmtt

4416: WHERE mtrl.line_id = l_transaction_record.move_order_line_id;
4417: CURSOR c_get_other_mmtt
4418: IS
4419: SELECT COUNT(*)
4420: FROM mtl_material_transactions_temp mmtt
4421: WHERE mmtt.move_order_line_id = l_transaction_record.move_order_line_id
4422: AND mmtt.transaction_temp_id <> l_transaction_record.transaction_temp_id
4423: AND NOT EXISTS
4424: (SELECT 1

Line 4425: FROM mtl_material_transactions_temp t1

4421: WHERE mmtt.move_order_line_id = l_transaction_record.move_order_line_id
4422: AND mmtt.transaction_temp_id <> l_transaction_record.transaction_temp_id
4423: AND NOT EXISTS
4424: (SELECT 1
4425: FROM mtl_material_transactions_temp t1
4426: WHERE t1.parent_line_id = mmtt.transaction_temp_id
4427: );
4428: BEGIN
4429: x_return_status := fnd_api.g_ret_sts_success;

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

4596: x_msg_count NUMBER;
4597: x_msg_data VARCHAR2(50);
4598: l_return_status VARCHAR2(1);
4599: l_transaction_number NUMBER ;
4600: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4601: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4602: l_op_plan_rec wms_op_plan_instances%rowtype ; --WOPI rec
4603: exc_not_deleted EXCEPTION;
4604: l_op_plan_status NUMBER ;

Line 4618: FROM mtl_material_transactions_temp mmtt

4614: mmtt.move_order_line_id ,
4615: mmtt.transaction_uom ,
4616: mmtt.primary_quantity ,
4617: mmtt.transaction_quantity
4618: FROM mtl_material_transactions_temp mmtt
4619: WHERE mmtt.transaction_temp_id = l_transaction_number
4620: AND NOT EXISTS
4621: (SELECT 1
4622: FROM mtl_material_transactions_temp t1

Line 4622: FROM mtl_material_transactions_temp t1

4618: FROM mtl_material_transactions_temp mmtt
4619: WHERE mmtt.transaction_temp_id = l_transaction_number
4620: AND NOT EXISTS
4621: (SELECT 1
4622: FROM mtl_material_transactions_temp t1
4623: WHERE t1.parent_line_id = mmtt.transaction_temp_id
4624: )
4625: UNION ALL
4626: SELECT mmtt.transaction_temp_id ,

Line 4634: FROM mtl_material_transactions_temp mmtt

4630: mmtt.move_order_line_id ,
4631: mmtt.transaction_uom ,
4632: mmtt.primary_quantity ,
4633: mmtt.transaction_quantity
4634: FROM mtl_material_transactions_temp mmtt
4635: WHERE mmtt.parent_line_id = l_transaction_number
4636: AND mmtt.parent_line_id <> mmtt.transaction_temp_id;
4637: CURSOR c_mo_line_info
4638: IS

Line 4648: FROM mtl_material_transactions_temp mmtt

4644: WHERE mtrl.line_id = l_transaction_record.move_order_line_id;
4645: CURSOR c_get_other_mmtt
4646: IS
4647: SELECT COUNT(*)
4648: FROM mtl_material_transactions_temp mmtt
4649: WHERE mmtt.move_order_line_id = l_transaction_record.move_order_line_id
4650: AND mmtt.transaction_temp_id <> l_transaction_record.transaction_temp_id
4651: AND NOT EXISTS
4652: (SELECT 1

Line 4653: FROM mtl_material_transactions_temp t1

4649: WHERE mmtt.move_order_line_id = l_transaction_record.move_order_line_id
4650: AND mmtt.transaction_temp_id <> l_transaction_record.transaction_temp_id
4651: AND NOT EXISTS
4652: (SELECT 1
4653: FROM mtl_material_transactions_temp t1
4654: WHERE t1.parent_line_id = mmtt.transaction_temp_id
4655: );
4656: CURSOR c_plan_instance
4657: IS

Line 4786: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

4782: END IF;
4783: l_progress := '370';
4784: --delete the parent mmtt
4785: DELETE
4786: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
4787: WHERE transaction_temp_id = l_transaction_record.parent_line_id ;
4788: IF SQL%ROWCOUNT =0 THEN
4789: IF l_debug =1 THEN
4790: debug_print('Count not delete the parent mmtt');

Line 4999: l_transaction_record mtl_material_transactions_temp%rowtype ;

4995: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4996: l_task_rec task_record_type ;
4997: x_task_rec task_record_type ;
4998: l_transaction_number NUMBER;
4999: l_transaction_record mtl_material_transactions_temp%rowtype ;
5000: /*Local variable for the validate_task API*/
5001: l_ret_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
5002: l_val_ret_status VARCHAR2(30);
5003: l_task_type NUMBER ;

Line 5047: FROM mtl_material_transactions_temp

5043: SELECT 1,
5044: wms_task_type
5045: INTO l_task_exists,
5046: l_task_type
5047: FROM mtl_material_transactions_temp
5048: WHERE transaction_temp_id = l_ret_task_table(i).transaction_number FOR UPDATE NOWAIT;
5049: EXCEPTION
5050: WHEN NO_DATA_FOUND THEN
5051: null;

Line 5206: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;

5202: ,x_msg_data OUT NOCOPY VARCHAR2
5203: )
5204: IS
5205:
5206: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
5207: l_mcce_rec mtl_cycle_count_entries%ROWTYPE;
5208: l_query_tab query_tab_type;
5209:
5210:

Line 5232: SELECT 1 FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mtrl

5228:
5229: c_cd_exist number;
5230:
5231: CURSOR c_cd_task (p_transaction_number IN NUMBER) IS
5232: SELECT 1 FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mtrl
5233: WHERE mtrl.backorder_delivery_detail_id IS NOT NULL
5234: AND mtrl.line_id = mmtt.move_order_line_id
5235: AND transaction_temp_id = p_transaction_number;
5236: --added for completed tasks under bug 6854145

Line 5252: FROM mtl_material_transactions_temp

5248: IF(p_transaction_number IS NOT NULL) THEN
5249: BEGIN
5250: SELECT *
5251: INTO l_mmtt_rec
5252: FROM mtl_material_transactions_temp
5253: WHERE transaction_temp_id = p_transaction_number;
5254:
5255: IF(l_debug = 1) THEN
5256: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for task: '||p_transaction_number;

Line 6638: from mtl_material_transactions_temp

6634: --Bug 6766048
6635: CURSOR C_MMTT_ORG_ITM (p_txn_temp_id NUMBER)
6636: IS
6637: select inventory_item_id, organization_id
6638: from mtl_material_transactions_temp
6639: where transaction_temp_id = p_txn_temp_id;
6640:
6641: CURSOR C_LOT_DIVISIBLE (p_item_id NUMBER,p_organization_id NUMBER )
6642: IS

Line 6861: UPDATE mtl_material_transactions_temp

6857: END IF;
6858: END IF;
6859: -- Update the original row
6860: BEGIN
6861: UPDATE mtl_material_transactions_temp
6862: SET primary_quantity = primary_quantity - l_split_uom_quantities(i).primary_quantity ,
6863: transaction_quantity = transaction_quantity - l_split_uom_quantities(i).transaction_quantity ,
6864: last_updated_by = FND_GLOBAL.USER_ID
6865: WHERE transaction_temp_id = p_source_transaction_number;

Line 7210: FROM mtl_material_transactions_temp

7206: --Cursor to lock the mmtt record before updation.
7207: Cursor c_lock_mmtt (p_transaction_number NUMBER)
7208: IS
7209: SELECT '1'
7210: FROM mtl_material_transactions_temp
7211: WHERE transaction_temp_id = p_transaction_number FOR UPDATE NOWAIT;
7212: --Cursor to lock the mcce record before updation.
7213: Cursor c_lock_mcce (p_transaction_number NUMBER)
7214: IS

Line 7628: UPDATE mtl_material_transactions_temp

7624: END IF;
7625:
7626: IF (l_mmtt_transaction_num_table.COUNT > 0) THEN
7627: FORALL i in 1..l_mmtt_transaction_num_table.COUNT
7628: UPDATE mtl_material_transactions_temp
7629: SET wms_task_status = l_mmtt_status_id_table(i) ,
7630: operation_plan_id = l_mmtt_operation_plan_id_table(i),
7631: cartonization_id = l_mmtt_cartonization_id_table(i) ,
7632: task_priority = l_mmtt_priority_table(i) ,