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

Line 23: -- Pre-reqs : 1. For each record in MTL_MATERIAL_TRANSACTIONS_TEMP, user

19: -- methodology and pick slip number. This group of tasks includes
20: -- the most optimal task based on priority, locator picking
21: -- sequence, coordinates approximation, etc.
22: -- or reservation input parameters and creates recommendations
23: -- Pre-reqs : 1. For each record in MTL_MATERIAL_TRANSACTIONS_TEMP, user
24: -- defined task type (standard_operation_id column ) has been
25: -- assigned,
26: -- 2. System task type (wms_task_type column) has been assigned
27: -- 3. Pick slip

Line 310: FROM mtl_material_transactions_temp mmtt

306: transaction_type_id,
307: transaction_action_id,
308: transaction_source_id,
309: transaction_source_type_id
310: FROM mtl_material_transactions_temp mmtt
311: WHERE wms_task_type IS NOT NULL
312: AND transaction_temp_id = Decode(p_task_method, 'BULK',
313: parent_line_id, transaction_temp_id)
314: AND Decode(transaction_source_type_id,

Line 325: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

321: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
322: --7169220: USERS LOCKED
323: AND (mmtt.cartonization_id is null
324: or not exists
325: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
326: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
327: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
328: and wdt1.status = 9
329: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 417: FROM mtl_material_transactions_temp mmtt

413: transaction_type_id,
414: transaction_action_id,
415: transaction_source_id,
416: transaction_source_type_id
417: FROM mtl_material_transactions_temp mmtt
418: WHERE wms_task_type IS NOT NULL
419: AND transaction_status = 2
420: AND(wms_task_status IS NULL OR wms_task_status = 1) --Added for task planning WB. bug#2651318
421: AND transaction_temp_id = Decode(p_task_method, 'BULK',

Line 434: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

430: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
431: --7169220: USERS LOCKED
432: AND (mmtt.cartonization_id is null
433: or not exists
434: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
435: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
436: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
437: and wdt1.status = 9
438: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 556: FROM mtl_material_transactions_temp mmtt

552: )
553: -- bug 4358107
554: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
555: (SELECT NULL
556: FROM mtl_material_transactions_temp mmtt
557: WHERE mmtt.transaction_temp_id = wdtv.task_id
558: AND mmtt.parent_line_id IS NOT NULL
559: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
560: AND mmtt.wms_task_type = wdtv.wms_task_type_id)

Line 633: FROM mtl_material_transactions_temp mmtt

629: transaction_type_id,
630: transaction_action_id,
631: transaction_source_id,
632: transaction_source_type_id
633: FROM mtl_material_transactions_temp mmtt
634: WHERE wms_task_type IS NOT NULL
635: AND transaction_temp_id = Decode(p_task_method, 'BULK',
636: parent_line_id, transaction_temp_id)
637: AND Decode(transaction_source_type_id,

Line 648: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

644: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
645: --7169220: USERS LOCKED
646: AND (mmtt.cartonization_id is null
647: or not exists
648: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
649: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
650: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
651: and wdt1.status = 9
652: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 711: FROM mtl_material_transactions_temp mmtt

707: transaction_type_id,
708: transaction_action_id,
709: transaction_source_id,
710: transaction_source_type_id
711: FROM mtl_material_transactions_temp mmtt
712: WHERE wms_task_type IS NOT NULL
713: AND transaction_temp_id = Decode(p_task_method, 'BULK',
714: parent_line_id, transaction_temp_id)
715: AND Decode(transaction_source_type_id,

Line 726: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

722: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
723: --7169220: USERS LOCKED
724: AND (mmtt.cartonization_id is null
725: or not exists
726: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
727: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
728: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
729: and wdt1.status = 9
730: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 803: FROM mtl_material_transactions_temp mmtt

799: transaction_type_id,
800: transaction_action_id,
801: transaction_source_id,
802: transaction_source_type_id
803: FROM mtl_material_transactions_temp mmtt
804: WHERE wms_task_type IS NOT NULL
805: AND transaction_status = 2
806: AND(wms_task_status IS NULL OR wms_task_status = 1) --Added for task planning WB. bug#2651318
807: AND transaction_temp_id = Decode(p_task_method, 'BULK',

Line 820: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

816: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
817: --7169220: USERS LOCKED
818: AND (mmtt.cartonization_id is null
819: or not exists
820: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
821: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
822: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
823: and wdt1.status = 9
824: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 905: FROM mtl_material_transactions_temp mmtt

901: )
902: -- bug 4358107
903: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
904: (SELECT NULL
905: FROM mtl_material_transactions_temp mmtt
906: WHERE mmtt.transaction_temp_id = wdtv.task_id
907: AND mmtt.parent_line_id IS NOT NULL
908: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
909: AND mmtt.wms_task_type = wdtv.wms_task_type_id)

Line 1137: FROM mtl_material_transactions_temp mmtt

1133: )
1134: -- bug 4358107
1135: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
1136: (SELECT NULL
1137: FROM mtl_material_transactions_temp mmtt
1138: WHERE mmtt.transaction_temp_id = wdtv.task_id
1139: AND mmtt.parent_line_id IS NOT NULL
1140: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
1141: AND mmtt.wms_task_type = wdtv.wms_task_type_id)

Line 1213: FROM mtl_material_transactions_temp mmtt

1209: transaction_type_id,
1210: transaction_action_id,
1211: transaction_source_id,
1212: transaction_source_type_id
1213: FROM mtl_material_transactions_temp mmtt
1214: WHERE wms_task_type IS NOT NULL
1215: AND transaction_temp_id = Decode(p_task_method, 'BULK',
1216: parent_line_id, transaction_temp_id)
1217: AND Decode(transaction_source_type_id,

Line 1228: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

1224: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1225: --7169220: USERS LOCKED
1226: AND (mmtt.cartonization_id is null
1227: or not exists
1228: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1229: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1230: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1231: and wdt1.status = 9
1232: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 1324: FROM mtl_material_transactions_temp mmtt

1320: transaction_type_id,
1321: transaction_action_id,
1322: transaction_source_id,
1323: transaction_source_type_id
1324: FROM mtl_material_transactions_temp mmtt
1325: WHERE wms_task_type IS NOT NULL
1326: AND transaction_status = 2
1327: AND(wms_task_status IS NULL OR wms_task_status = 1) --Added for task planning WB. bug#2651318
1328: AND transaction_temp_id = Decode(p_task_method, 'BULK',

Line 1341: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

1337: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1338: --7169220: USERS LOCKED
1339: AND (mmtt.cartonization_id is null
1340: or not exists
1341: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1342: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1343: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1344: and wdt1.status = 9
1345: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 1462: FROM mtl_material_transactions_temp mmtt

1458: )
1459: -- bug 4358107
1460: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
1461: (SELECT NULL
1462: FROM mtl_material_transactions_temp mmtt
1463: WHERE mmtt.transaction_temp_id = wdtv.task_id
1464: AND mmtt.parent_line_id IS NOT NULL
1465: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
1466: AND mmtt.wms_task_type = wdtv.wms_task_type_id)

Line 1540: FROM mtl_material_transactions_temp mmtt

1536: transaction_type_id,
1537: transaction_action_id,
1538: transaction_source_id,
1539: transaction_source_type_id
1540: FROM mtl_material_transactions_temp mmtt
1541: WHERE wms_task_type IS NOT NULL
1542: AND transaction_temp_id = Decode(p_task_method, 'BULK',
1543: parent_line_id, transaction_temp_id)
1544: AND Decode(transaction_source_type_id,

Line 1555: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

1551: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1552: --7169220: USERS LOCKED
1553: AND (mmtt.cartonization_id is null
1554: or not exists
1555: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1556: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1557: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1558: and wdt1.status = 9
1559: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 1617: FROM mtl_material_transactions_temp mmtt

1613: transaction_type_id,
1614: transaction_action_id,
1615: transaction_source_id,
1616: transaction_source_type_id
1617: FROM mtl_material_transactions_temp mmtt
1618: WHERE wms_task_type IS NOT NULL
1619: AND transaction_temp_id = Decode(p_task_method, 'BULK',
1620: parent_line_id, transaction_temp_id)
1621: AND Decode(transaction_source_type_id,

Line 1632: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

1628: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1629: --7169220: USERS LOCKED
1630: AND (mmtt.cartonization_id is null
1631: or not exists
1632: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1633: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1634: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1635: and wdt1.status = 9
1636: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 1708: FROM mtl_material_transactions_temp mmtt

1704: transaction_type_id,
1705: transaction_action_id,
1706: transaction_source_id,
1707: transaction_source_type_id
1708: FROM mtl_material_transactions_temp mmtt
1709: WHERE wms_task_type IS NOT NULL
1710: AND transaction_status = 2
1711: AND(wms_task_status IS NULL OR wms_task_status = 1) --Added for task planning WB. bug#2651318
1712: AND transaction_temp_id = Decode(p_task_method, 'BULK',

Line 1725: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

1721: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1722: --7169220: USERS LOCKED
1723: AND (mmtt.cartonization_id is null
1724: or not exists
1725: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1726: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1727: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1728: and wdt1.status = 9
1729: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 1809: FROM mtl_material_transactions_temp mmtt

1805: )
1806: -- bug 4358107
1807: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
1808: (SELECT NULL
1809: FROM mtl_material_transactions_temp mmtt
1810: WHERE mmtt.transaction_temp_id = wdtv.task_id
1811: AND mmtt.parent_line_id IS NOT NULL
1812: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
1813: AND mmtt.wms_task_type = wdtv.wms_task_type_id)

Line 2033: FROM mtl_material_transactions_temp mmtt

2029: )
2030: -- bug 4358107
2031: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
2032: (SELECT NULL
2033: FROM mtl_material_transactions_temp mmtt
2034: WHERE mmtt.transaction_temp_id = wdtv.task_id
2035: AND mmtt.parent_line_id IS NOT NULL
2036: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
2037: AND mmtt.wms_task_type = wdtv.wms_task_type_id)

Line 2131: FROM mtl_material_transactions_temp mmtt

2127: transaction_type_id,
2128: transaction_action_id,
2129: transaction_source_id,
2130: transaction_source_type_id
2131: FROM mtl_material_transactions_temp mmtt
2132: WHERE wms_task_type IS NOT NULL
2133: AND transaction_temp_id = Decode(p_task_method, 'BULK',
2134: parent_line_id, transaction_temp_id)
2135: AND Decode(transaction_source_type_id,

Line 2146: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

2142: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2143: --7169220: USERS LOCKED
2144: AND (mmtt.cartonization_id is null
2145: or not exists
2146: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2147: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2148: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2149: and wdt1.status = 9
2150: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 2279: FROM mtl_material_transactions_temp mmtt

2275: transaction_action_id,
2276: transaction_source_id,
2277: transaction_source_type_id,
2278: operation_plan_id
2279: FROM mtl_material_transactions_temp mmtt
2280: WHERE wms_task_type IS NOT NULL
2281: AND transaction_status = 2
2282: AND(wms_task_status IS NULL OR wms_task_status = 1) --Added for task planning WB. bug#2651318
2283: AND transaction_temp_id = Decode(p_task_method, 'BULK',

Line 2296: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

2292: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2293: --7169220: USERS LOCKED
2294: AND (mmtt.cartonization_id is null
2295: or not exists
2296: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2297: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2298: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2299: and wdt1.status = 9
2300: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 2405: FROM mtl_material_transactions_temp mmtt

2401: -1, 1,
2402: 1) = 1
2403: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
2404: (SELECT NULL
2405: FROM mtl_material_transactions_temp mmtt
2406: WHERE mmtt.transaction_temp_id = wdtv.task_id
2407: AND mmtt.parent_line_id IS NOT NULL
2408: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
2409: AND mmtt.wms_task_type = wdtv.wms_task_type_id)

Line 2511: FROM mtl_material_transactions_temp mmtt

2507: transaction_type_id,
2508: transaction_action_id,
2509: transaction_source_id,
2510: transaction_source_type_id
2511: FROM mtl_material_transactions_temp mmtt
2512: WHERE wms_task_type IS NOT NULL
2513: AND transaction_temp_id = Decode(p_task_method, 'BULK',
2514: parent_line_id, transaction_temp_id)
2515: AND Decode(transaction_source_type_id,

Line 2526: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

2522: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2523: --7169220: USERS LOCKED
2524: AND (mmtt.cartonization_id is null
2525: or not exists
2526: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2527: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2528: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2529: and wdt1.status = 9
2530: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 2620: FROM mtl_material_transactions_temp mmtt

2616: transaction_type_id,
2617: transaction_action_id,
2618: transaction_source_id,
2619: transaction_source_type_id
2620: FROM mtl_material_transactions_temp mmtt
2621: WHERE wms_task_type IS NOT NULL
2622: AND transaction_temp_id = Decode(p_task_method, 'BULK',
2623: parent_line_id, transaction_temp_id)
2624: AND Decode(transaction_source_type_id,

Line 2635: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

2631: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2632: --7169220: USERS LOCKED
2633: AND (mmtt.cartonization_id is null
2634: or not exists
2635: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2636: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2637: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2638: and wdt1.status = 9
2639: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 2737: FROM mtl_material_transactions_temp mmtt

2733: transaction_action_id,
2734: transaction_source_id,
2735: transaction_source_type_id,
2736: operation_plan_id
2737: FROM mtl_material_transactions_temp mmtt
2738: WHERE wms_task_type IS NOT NULL
2739: AND transaction_status = 2
2740: AND(wms_task_status IS NULL OR wms_task_status = 1) --Added for task planning WB. bug#2651318
2741: AND transaction_temp_id = Decode(p_task_method, 'BULK',

Line 2754: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

2750: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2751: --7169220: USERS LOCKED
2752: AND (mmtt.cartonization_id is null
2753: or not exists
2754: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2755: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2756: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2757: and wdt1.status = 9
2758: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 2826: FROM mtl_material_transactions_temp mmtt

2822: -1, 1,
2823: 1) = 1
2824: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
2825: (SELECT NULL
2826: FROM mtl_material_transactions_temp mmtt
2827: WHERE mmtt.transaction_temp_id = wdtv.task_id
2828: AND mmtt.parent_line_id IS NOT NULL
2829: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
2830: AND mmtt.wms_task_type = wdtv.wms_task_type_id)

Line 3077: FROM mtl_material_transactions_temp mmtt

3073: AND wdtv.subinventory_code = sub.secondary_inventory_name
3074: AND wdtv.organization_id = sub.organization_id
3075: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
3076: (SELECT NULL
3077: FROM mtl_material_transactions_temp mmtt
3078: WHERE mmtt.transaction_temp_id = wdtv.task_id
3079: AND mmtt.parent_line_id IS NOT NULL
3080: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
3081: AND mmtt.wms_task_type = wdtv.wms_task_type_id)

Line 3122: FROM mtl_material_transactions_temp

3118: task_num;
3119:
3120: CURSOR c_task_lock_check(v_transaction_temp_id NUMBER) IS
3121: SELECT transaction_temp_id
3122: FROM mtl_material_transactions_temp
3123: WHERE transaction_temp_id = v_transaction_temp_id
3124: FOR UPDATE nowait;
3125:
3126: CURSOR c_pick_slip_lock_check(v_pick_slip_number NUMBER) IS

Line 3128: FROM mtl_material_transactions_temp

3124: FOR UPDATE nowait;
3125:
3126: CURSOR c_pick_slip_lock_check(v_pick_slip_number NUMBER) IS
3127: SELECT transaction_temp_id
3128: FROM mtl_material_transactions_temp
3129: WHERE pick_slip_number = v_pick_slip_number
3130: AND NVL(subinventory_code, '@@@') = NVL(p_sign_on_zone, NVL(subinventory_code, '@@@'))
3131: FOR UPDATE nowait;
3132:

Line 3138: FROM mtl_material_transactions_temp

3134: v_transaction_source_type_id NUMBER,
3135: v_transaction_action_id NUMBER,
3136: v_transaction_type_id NUMBER) IS
3137: SELECT transaction_temp_id
3138: FROM mtl_material_transactions_temp
3139: WHERE transaction_source_id = v_order_header_id
3140: AND transaction_source_type_id = v_transaction_source_type_id
3141: AND transaction_action_id = v_transaction_action_id
3142: AND transaction_type_id = v_transaction_type_id

Line 3148: FROM mtl_material_transactions_temp

3144: FOR UPDATE nowait;
3145:
3146: CURSOR c_carton_lock_check(v_cartonization_id NUMBER) IS
3147: SELECT transaction_temp_id
3148: FROM mtl_material_transactions_temp
3149: WHERE cartonization_id = v_cartonization_id
3150: AND NVL(subinventory_code, '@@@') = NVL(p_sign_on_zone, NVL(subinventory_code, '@@@'))
3151: FOR UPDATE nowait;
3152:

Line 3387: FROM mtl_material_transactions_temp

3383: pick_slip_number pick_slip_number,
3384: cartonization_id cartonization_id,
3385: inventory_item_id,
3386: move_order_line_id
3387: FROM mtl_material_transactions_temp
3388: WHERE wms_task_type IS NOT NULL
3389: AND transaction_status = 2
3390: UNION ALL
3391: SELECT

Line 3926: FROM mtl_material_transactions_temp mmtt

3922: END IF;
3923: /*Take the LPN_ID from MMTT*/
3924: l_lpn_id := NULL;
3925: SELECT cartonization_id INTO l_lpn_id
3926: FROM mtl_material_transactions_temp mmtt
3927: WHERE mmtt.transaction_temp_id= l_task_id;
3928:
3929:
3930:

Line 3939: SELECT count(1) INTO l_wdt_count FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt

3935:
3936: /*Check if any task has been dispatched to other users for the same LPN*/
3937: IF l_lpn_id IS NOT NULL THEN
3938: l_wdt_count := 0 ;
3939: SELECT count(1) INTO l_wdt_count FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt
3940: WHERE mmtt.cartonization_id = l_lpn_id
3941: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
3942: AND wdt.status in(3,9) AND wdt.person_id <> p_sign_on_emp_id ;
3943:

Line 4441: FROM mtl_material_transactions_temp

4437: , pick_slip_number pick_slip_number
4438: , cartonization_id cartonization_id
4439: , inventory_item_id
4440: , move_order_line_id
4441: FROM mtl_material_transactions_temp
4442: WHERE wms_task_type IS NOT NULL
4443: AND transaction_status = 2
4444: AND(wms_task_status IS NULL
4445: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 4513: FROM mtl_material_transactions_temp mmtt

4509: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
4510: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
4511: (
4512: SELECT NULL
4513: FROM mtl_material_transactions_temp mmtt
4514: WHERE mmtt.transaction_temp_id = wdtv.task_id
4515: AND mmtt.parent_line_id IS NOT NULL
4516: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
4517: AND NOT EXISTS -- exclude tasks already dispatched

Line 4595: FROM mtl_material_transactions_temp

4591: , pick_slip_number pick_slip_number
4592: , cartonization_id cartonization_id
4593: , inventory_item_id
4594: , move_order_line_id
4595: FROM mtl_material_transactions_temp
4596: WHERE wms_task_type IS NOT NULL
4597: AND transaction_status = 2
4598: AND(wms_task_status IS NULL
4599: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 4669: FROM mtl_material_transactions_temp mmtt

4665: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'
4666: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
4667: (
4668: SELECT NULL
4669: FROM mtl_material_transactions_temp mmtt
4670: WHERE mmtt.transaction_temp_id = wdtv.task_id
4671: AND mmtt.parent_line_id IS NOT NULL
4672: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
4673: AND NOT EXISTS -- exclude tasks already dispatched

Line 4751: FROM mtl_material_transactions_temp

4747: , pick_slip_number pick_slip_number
4748: , cartonization_id cartonization_id
4749: , inventory_item_id
4750: , move_order_line_id
4751: FROM mtl_material_transactions_temp
4752: WHERE wms_task_type IS NOT NULL
4753: AND transaction_status = 2
4754: AND(wms_task_status IS NULL
4755: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 4822: FROM mtl_material_transactions_temp mmtt

4818: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
4819: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
4820: (
4821: SELECT NULL
4822: FROM mtl_material_transactions_temp mmtt
4823: WHERE mmtt.transaction_temp_id = wdtv.task_id
4824: AND mmtt.parent_line_id IS NOT NULL
4825: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
4826: AND NOT EXISTS -- exclude tasks already dispatched

Line 4904: FROM mtl_material_transactions_temp

4900: , pick_slip_number pick_slip_number
4901: , cartonization_id cartonization_id
4902: , inventory_item_id
4903: , move_order_line_id
4904: FROM mtl_material_transactions_temp
4905: WHERE wms_task_type IS NOT NULL
4906: AND transaction_status = 2
4907: AND(wms_task_status IS NULL
4908: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 4976: FROM mtl_material_transactions_temp mmtt

4972: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
4973: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
4974: (
4975: SELECT NULL
4976: FROM mtl_material_transactions_temp mmtt
4977: WHERE mmtt.transaction_temp_id = wdtv.task_id
4978: AND mmtt.parent_line_id IS NOT NULL
4979: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
4980: AND NOT EXISTS -- exclude tasks already dispatched

Line 5057: FROM mtl_material_transactions_temp

5053: , pick_slip_number pick_slip_number
5054: , cartonization_id cartonization_id
5055: , inventory_item_id
5056: , move_order_line_id
5057: FROM mtl_material_transactions_temp
5058: WHERE wms_task_type IS NOT NULL
5059: AND transaction_status = 2
5060: AND(wms_task_status IS NULL
5061: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 5131: FROM mtl_material_transactions_temp mmtt

5127: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
5128: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5129: (
5130: SELECT NULL
5131: FROM mtl_material_transactions_temp mmtt
5132: WHERE mmtt.transaction_temp_id = wdtv.task_id
5133: AND mmtt.parent_line_id IS NOT NULL
5134: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5135: AND NOT EXISTS -- exclude tasks already dispatched

Line 5211: FROM mtl_material_transactions_temp

5207: , pick_slip_number pick_slip_number
5208: , cartonization_id cartonization_id
5209: , inventory_item_id
5210: , move_order_line_id
5211: FROM mtl_material_transactions_temp
5212: WHERE wms_task_type IS NOT NULL
5213: AND transaction_status = 2
5214: AND(wms_task_status IS NULL
5215: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 5284: FROM mtl_material_transactions_temp mmtt

5280: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
5281: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5282: (
5283: SELECT NULL
5284: FROM mtl_material_transactions_temp mmtt
5285: WHERE mmtt.transaction_temp_id = wdtv.task_id
5286: AND mmtt.parent_line_id IS NOT NULL
5287: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5288: AND NOT EXISTS -- exclude tasks already dispatched

Line 5364: FROM mtl_material_transactions_temp

5360: , pick_slip_number pick_slip_number
5361: , cartonization_id cartonization_id
5362: , inventory_item_id
5363: , move_order_line_id
5364: FROM mtl_material_transactions_temp
5365: WHERE wms_task_type IS NOT NULL
5366: AND transaction_status = 2
5367: AND(wms_task_status IS NULL
5368: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 5435: FROM mtl_material_transactions_temp mmtt

5431: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
5432: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5433: (
5434: SELECT NULL
5435: FROM mtl_material_transactions_temp mmtt
5436: WHERE mmtt.transaction_temp_id = wdtv.task_id
5437: AND mmtt.parent_line_id IS NOT NULL
5438: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5439: AND NOT EXISTS -- exclude tasks already dispatched

Line 5515: FROM mtl_material_transactions_temp

5511: , pick_slip_number pick_slip_number
5512: , cartonization_id cartonization_id
5513: , inventory_item_id
5514: , move_order_line_id
5515: FROM mtl_material_transactions_temp
5516: WHERE wms_task_type IS NOT NULL
5517: AND transaction_status = 2
5518: AND(wms_task_status IS NULL
5519: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 5587: FROM mtl_material_transactions_temp mmtt

5583: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
5584: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5585: (
5586: SELECT NULL
5587: FROM mtl_material_transactions_temp mmtt
5588: WHERE mmtt.transaction_temp_id = wdtv.task_id
5589: AND mmtt.parent_line_id IS NOT NULL
5590: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5591: AND NOT EXISTS -- exclude tasks already dispatched

Line 5663: FROM mtl_material_transactions_temp

5659: , pick_slip_number pick_slip_number
5660: , cartonization_id cartonization_id
5661: , inventory_item_id
5662: , move_order_line_id
5663: FROM mtl_material_transactions_temp
5664: WHERE wms_task_type IS NOT NULL
5665: AND transaction_status = 2
5666: AND(wms_task_status IS NULL
5667: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 5737: FROM mtl_material_transactions_temp mmtt

5733: AND wdtv.move_order_line_id = mol.line_id(+) -- join task to MOL, outer join for tasks do not have MOL
5734: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5735: (
5736: SELECT NULL
5737: FROM mtl_material_transactions_temp mmtt
5738: WHERE mmtt.transaction_temp_id = wdtv.task_id
5739: AND mmtt.parent_line_id IS NOT NULL
5740: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5741: AND NOT EXISTS -- exclude tasks already dispatched

Line 5814: FROM mtl_material_transactions_temp

5810: , pick_slip_number pick_slip_number
5811: , cartonization_id cartonization_id
5812: , inventory_item_id
5813: , move_order_line_id
5814: FROM mtl_material_transactions_temp
5815: WHERE wms_task_type IS NOT NULL
5816: AND transaction_status = 2
5817: AND(wms_task_status IS NULL
5818: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 5891: FROM mtl_material_transactions_temp mmtt

5887: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'
5888: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5889: (
5890: SELECT NULL
5891: FROM mtl_material_transactions_temp mmtt
5892: WHERE mmtt.transaction_temp_id = wdtv.task_id
5893: AND mmtt.parent_line_id IS NOT NULL
5894: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5895: AND NOT EXISTS -- exclude tasks already dispatched

Line 5967: FROM mtl_material_transactions_temp

5963: , pick_slip_number pick_slip_number
5964: , cartonization_id cartonization_id
5965: , inventory_item_id
5966: , move_order_line_id
5967: FROM mtl_material_transactions_temp
5968: WHERE wms_task_type IS NOT NULL
5969: AND transaction_status = 2
5970: AND(wms_task_status IS NULL
5971: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 6039: FROM mtl_material_transactions_temp mmtt

6035: AND wdtv.move_order_line_id = mol.line_id(+) -- join task to MOL, outer join for tasks do not have MOL
6036: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
6037: (
6038: SELECT NULL
6039: FROM mtl_material_transactions_temp mmtt
6040: WHERE mmtt.transaction_temp_id = wdtv.task_id
6041: AND mmtt.parent_line_id IS NOT NULL
6042: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
6043: AND NOT EXISTS -- exclude tasks already dispatched

Line 6115: FROM mtl_material_transactions_temp

6111: , pick_slip_number pick_slip_number
6112: , cartonization_id cartonization_id
6113: , inventory_item_id
6114: , move_order_line_id
6115: FROM mtl_material_transactions_temp
6116: WHERE wms_task_type IS NOT NULL
6117: AND transaction_status = 2
6118: AND(wms_task_status IS NULL
6119: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 6190: FROM mtl_material_transactions_temp mmtt

6186: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'
6187: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
6188: (
6189: SELECT NULL
6190: FROM mtl_material_transactions_temp mmtt
6191: WHERE mmtt.transaction_temp_id = wdtv.task_id
6192: AND mmtt.parent_line_id IS NOT NULL
6193: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
6194: AND NOT EXISTS -- exclude tasks already dispatched

Line 6241: FROM mtl_material_transactions_temp mmtt

6237:
6238: CURSOR c_lock_check(v_pick_slip_number NUMBER) IS
6239:
6240: SELECT transaction_temp_id
6241: FROM mtl_material_transactions_temp mmtt
6242: WHERE mmtt.pick_slip_number = v_pick_slip_number
6243: FOR UPDATE nowait;
6244:
6245:

Line 6469: FROM mtl_material_transactions_temp

6465: , pick_slip_number pick_slip_number
6466: , cartonization_id cartonization_id
6467: , inventory_item_id
6468: , move_order_line_id
6469: FROM mtl_material_transactions_temp
6470: WHERE wms_task_type IS NOT NULL
6471: AND transaction_status = 2
6472: UNION ALL
6473: SELECT MIN(cycle_count_entry_id) task_id

Line 6912: FROM mtl_material_transactions_temp mmtt

6908: IF l_opt_task_pick_slip IS NULL THEN -- bug 2832818
6909: BEGIN
6910: SELECT mmtt.transaction_temp_id
6911: INTO l_opt_task_id
6912: FROM mtl_material_transactions_temp mmtt
6913: WHERE mmtt.transaction_temp_id = l_opt_task_id
6914: FOR UPDATE NOWAIT;
6915: EXCEPTION
6916: WHEN OTHERS THEN

Line 6978: FROM mtl_material_transactions_temp mmtt

6974: IF l_opt_task_pick_slip IS NULL THEN -- bug 2832818
6975: BEGIN
6976: SELECT mmtt.transaction_temp_id
6977: INTO l_opt_task_id
6978: FROM mtl_material_transactions_temp mmtt
6979: WHERE mmtt.transaction_temp_id = l_opt_task_id
6980: FOR UPDATE NOWAIT;
6981: EXCEPTION
6982: WHEN OTHERS THEN

Line 7097: FROM mtl_material_transactions_temp mmtt, wms_ordered_tasks wot

7093: , mmtt.transaction_quantity transaction_quantity
7094: , '' lot_number
7095: , mmtt.wms_task_type wms_task_type_id
7096: , mmtt.task_priority task_priority
7097: FROM mtl_material_transactions_temp mmtt, wms_ordered_tasks wot
7098: WHERE mmtt.wms_task_type IS NOT NULL
7099: AND mmtt.transaction_status = 2
7100: AND mmtt.transaction_temp_id = wot.task_id
7101: AND mmtt.transaction_temp_id > 0

Line 7341: FROM mtl_material_transactions_temp

7337: , pick_slip_number pick_slip_number
7338: , cartonization_id cartonization_id
7339: , inventory_item_id
7340: , move_order_line_id
7341: FROM mtl_material_transactions_temp
7342: WHERE wms_task_type IS NOT NULL
7343: AND transaction_status = 2
7344: AND(
7345: wms_task_status IS NULL

Line 7428: FROM mtl_material_transactions_temp mmtt

7424: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
7425: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
7426: (
7427: SELECT NULL
7428: FROM mtl_material_transactions_temp mmtt
7429: WHERE mmtt.transaction_temp_id = wdtv.task_id
7430: AND mmtt.parent_line_id IS NOT NULL
7431: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
7432: AND NOT EXISTS -- exclude tasks already dispatched

Line 7502: FROM mtl_material_transactions_temp

7498: , pick_slip_number pick_slip_number
7499: , cartonization_id cartonization_id
7500: , inventory_item_id
7501: , move_order_line_id
7502: FROM mtl_material_transactions_temp
7503: WHERE wms_task_type IS NOT NULL
7504: AND transaction_status = 2
7505: AND(
7506: wms_task_status IS NULL

Line 7585: FROM mtl_material_transactions_temp mmtt

7581: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
7582: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
7583: (
7584: SELECT NULL
7585: FROM mtl_material_transactions_temp mmtt
7586: WHERE mmtt.transaction_temp_id = wdtv.task_id
7587: AND mmtt.parent_line_id IS NOT NULL
7588: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
7589: AND NOT EXISTS -- exclude tasks already dispatched

Line 7662: FROM mtl_material_transactions_temp

7658: , pick_slip_number pick_slip_number
7659: , cartonization_id cartonization_id
7660: , inventory_item_id
7661: , move_order_line_id
7662: FROM mtl_material_transactions_temp
7663: WHERE wms_task_type IS NOT NULL
7664: AND transaction_status = 2
7665: AND(
7666: wms_task_status IS NULL

Line 7748: FROM mtl_material_transactions_temp mmtt

7744: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
7745: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
7746: (
7747: SELECT NULL
7748: FROM mtl_material_transactions_temp mmtt
7749: WHERE mmtt.transaction_temp_id = wdtv.task_id
7750: AND mmtt.parent_line_id IS NOT NULL
7751: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
7752: AND NOT EXISTS -- exclude tasks already dispatched

Line 7822: FROM mtl_material_transactions_temp

7818: , pick_slip_number pick_slip_number
7819: , cartonization_id cartonization_id
7820: , inventory_item_id
7821: , move_order_line_id
7822: FROM mtl_material_transactions_temp
7823: WHERE wms_task_type IS NOT NULL
7824: AND transaction_status = 2
7825: AND(
7826: wms_task_status IS NULL

Line 7904: FROM mtl_material_transactions_temp mmtt

7900: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
7901: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
7902: (
7903: SELECT NULL
7904: FROM mtl_material_transactions_temp mmtt
7905: WHERE mmtt.transaction_temp_id = wdtv.task_id
7906: AND mmtt.parent_line_id IS NOT NULL
7907: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
7908: AND NOT EXISTS -- exclude tasks already dispatched

Line 7990: FROM mtl_material_transactions_temp

7986: , pick_slip_number pick_slip_number
7987: , cartonization_id cartonization_id
7988: , inventory_item_id
7989: , move_order_line_id
7990: FROM mtl_material_transactions_temp
7991: WHERE wms_task_type IS NOT NULL
7992: AND transaction_status = 2
7993: AND Decode(transaction_source_type_id, 2, l_so_allowed,
7994: 8, l_io_allowed) = 1 -- filter out the request so or io

Line 8077: FROM mtl_material_transactions_temp

8073: , pick_slip_number pick_slip_number
8074: , cartonization_id cartonization_id
8075: , inventory_item_id
8076: , move_order_line_id
8077: FROM mtl_material_transactions_temp
8078: WHERE wms_task_type IS NOT NULL
8079: AND transaction_status = 2
8080: AND Decode(transaction_source_type_id, 2, l_so_allowed,
8081: 8, l_io_allowed) = 1 -- filter out the request so or io

Line 8145: FROM mtl_material_transactions_temp mmtt

8141: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
8142: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
8143: (
8144: SELECT NULL
8145: FROM mtl_material_transactions_temp mmtt
8146: WHERE mmtt.transaction_temp_id = wdtv.task_id
8147: AND mmtt.parent_line_id IS NOT NULL
8148: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
8149: AND NOT EXISTS -- exclude tasks already dispatched

Line 8234: FROM mtl_material_transactions_temp

8230: , pick_slip_number pick_slip_number
8231: , cartonization_id cartonization_id
8232: , inventory_item_id
8233: , move_order_line_id
8234: FROM mtl_material_transactions_temp
8235: WHERE wms_task_type IS NOT NULL
8236: AND transaction_status = 2
8237: AND(
8238: wms_task_status IS NULL

Line 8311: FROM mtl_material_transactions_temp

8307: , pick_slip_number pick_slip_number
8308: , cartonization_id cartonization_id
8309: , inventory_item_id
8310: , move_order_line_id
8311: FROM mtl_material_transactions_temp
8312: WHERE wms_task_type IS NOT NULL
8313: AND transaction_status = 2
8314: AND(
8315: wms_task_status IS NULL

Line 8373: FROM mtl_material_transactions_temp mmtt

8369: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
8370: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
8371: (
8372: SELECT NULL
8373: FROM mtl_material_transactions_temp mmtt
8374: WHERE mmtt.transaction_temp_id = wdtv.task_id
8375: AND mmtt.parent_line_id IS NOT NULL
8376: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
8377: AND NOT EXISTS -- exclude tasks already dispatched

Line 8462: FROM mtl_material_transactions_temp

8458: , pick_slip_number pick_slip_number
8459: , cartonization_id cartonization_id
8460: , inventory_item_id
8461: , move_order_line_id
8462: FROM mtl_material_transactions_temp
8463: WHERE wms_task_type IS NOT NULL
8464: AND transaction_status = 2
8465: AND Decode(transaction_source_type_id, 2, l_so_allowed,
8466: 8, l_io_allowed) = 1 -- filter out the request so or io

Line 8549: FROM mtl_material_transactions_temp

8545: , pick_slip_number pick_slip_number
8546: , cartonization_id cartonization_id
8547: , inventory_item_id
8548: , move_order_line_id
8549: FROM mtl_material_transactions_temp
8550: WHERE wms_task_type IS NOT NULL
8551: AND transaction_status = 2
8552: AND Decode(transaction_source_type_id, 2, l_so_allowed,
8553: 8, l_io_allowed) = 1 -- filter out the request so or io

Line 8617: FROM mtl_material_transactions_temp mmtt

8613: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
8614: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
8615: (
8616: SELECT NULL
8617: FROM mtl_material_transactions_temp mmtt
8618: WHERE mmtt.transaction_temp_id = wdtv.task_id
8619: AND mmtt.parent_line_id IS NOT NULL
8620: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
8621: AND NOT EXISTS -- exclude tasks already dispatched

Line 8696: FROM mtl_material_transactions_temp

8692: , pick_slip_number pick_slip_number
8693: , cartonization_id cartonization_id
8694: , inventory_item_id
8695: , move_order_line_id
8696: FROM mtl_material_transactions_temp
8697: WHERE wms_task_type IS NOT NULL
8698: AND transaction_status = 2
8699: AND(
8700: wms_task_status IS NULL

Line 8775: FROM mtl_material_transactions_temp

8771: , pick_slip_number pick_slip_number
8772: , cartonization_id cartonization_id
8773: , inventory_item_id
8774: , move_order_line_id
8775: FROM mtl_material_transactions_temp
8776: WHERE wms_task_type IS NOT NULL
8777: AND transaction_status = 2
8778: AND(
8779: wms_task_status IS NULL

Line 8837: FROM mtl_material_transactions_temp mmtt

8833: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
8834: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
8835: (
8836: SELECT NULL
8837: FROM mtl_material_transactions_temp mmtt
8838: WHERE mmtt.transaction_temp_id = wdtv.task_id
8839: AND mmtt.parent_line_id IS NOT NULL
8840: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
8841: AND NOT EXISTS -- exclude tasks already dispatched

Line 8926: FROM mtl_material_transactions_temp

8922: , pick_slip_number pick_slip_number
8923: , cartonization_id cartonization_id
8924: , inventory_item_id
8925: , move_order_line_id
8926: FROM mtl_material_transactions_temp
8927: WHERE wms_task_type IS NOT NULL
8928: AND transaction_status = 2
8929: AND Decode(transaction_source_type_id, 2, l_so_allowed,
8930: 8, l_io_allowed) = 1 -- filter out the request so or io

Line 9011: FROM mtl_material_transactions_temp

9007: , pick_slip_number pick_slip_number
9008: , cartonization_id cartonization_id
9009: , inventory_item_id
9010: , move_order_line_id
9011: FROM mtl_material_transactions_temp
9012: WHERE wms_task_type IS NOT NULL
9013: AND transaction_status = 2
9014: AND Decode(transaction_source_type_id, 2, l_so_allowed,
9015: 8, l_io_allowed) = 1 -- filter out the request so or io

Line 9077: FROM mtl_material_transactions_temp mmtt

9073: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
9074: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
9075: (
9076: SELECT NULL
9077: FROM mtl_material_transactions_temp mmtt
9078: WHERE mmtt.transaction_temp_id = wdtv.task_id
9079: AND mmtt.parent_line_id IS NOT NULL
9080: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
9081: AND NOT EXISTS -- exclude tasks already dispatched

Line 9165: FROM mtl_material_transactions_temp

9161: , pick_slip_number pick_slip_number
9162: , cartonization_id cartonization_id
9163: , inventory_item_id
9164: , move_order_line_id
9165: FROM mtl_material_transactions_temp
9166: WHERE wms_task_type IS NOT NULL
9167: AND transaction_status = 2
9168: AND(
9169: wms_task_status IS NULL

Line 9243: FROM mtl_material_transactions_temp

9239: , pick_slip_number pick_slip_number
9240: , cartonization_id cartonization_id
9241: , inventory_item_id
9242: , move_order_line_id
9243: FROM mtl_material_transactions_temp
9244: WHERE wms_task_type IS NOT NULL
9245: AND transaction_status = 2
9246: AND(
9247: wms_task_status IS NULL

Line 9304: FROM mtl_material_transactions_temp mmtt

9300: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
9301: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
9302: (
9303: SELECT NULL
9304: FROM mtl_material_transactions_temp mmtt
9305: WHERE mmtt.transaction_temp_id = wdtv.task_id
9306: AND mmtt.parent_line_id IS NOT NULL
9307: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
9308: AND NOT EXISTS -- exclude tasks already dispatched

Line 9390: FROM mtl_material_transactions_temp

9386: , pick_slip_number pick_slip_number
9387: , cartonization_id cartonization_id
9388: , inventory_item_id
9389: , move_order_line_id
9390: FROM mtl_material_transactions_temp
9391: WHERE wms_task_type IS NOT NULL
9392: AND transaction_status = 2
9393: AND Decode(transaction_source_type_id, 2, l_so_allowed,
9394: 8, l_io_allowed) = 1 -- filter out the request so or io

Line 9475: FROM mtl_material_transactions_temp

9471: , pick_slip_number pick_slip_number
9472: , cartonization_id cartonization_id
9473: , inventory_item_id
9474: , move_order_line_id
9475: FROM mtl_material_transactions_temp
9476: WHERE wms_task_type IS NOT NULL
9477: AND transaction_status = 2
9478: AND Decode(transaction_source_type_id, 2, l_so_allowed,
9479: 8, l_io_allowed) = 1 -- filter out the request so or io

Line 9542: FROM mtl_material_transactions_temp mmtt

9538: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
9539: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
9540: (
9541: SELECT NULL
9542: FROM mtl_material_transactions_temp mmtt
9543: WHERE mmtt.transaction_temp_id = wdtv.task_id
9544: AND mmtt.parent_line_id IS NOT NULL
9545: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
9546: AND NOT EXISTS -- exclude tasks already dispatched

Line 9621: FROM mtl_material_transactions_temp

9617: , pick_slip_number pick_slip_number
9618: , cartonization_id cartonization_id
9619: , inventory_item_id
9620: , move_order_line_id
9621: FROM mtl_material_transactions_temp
9622: WHERE wms_task_type IS NOT NULL
9623: AND transaction_status = 2
9624: AND(
9625: wms_task_status IS NULL

Line 9699: FROM mtl_material_transactions_temp

9695: , pick_slip_number pick_slip_number
9696: , cartonization_id cartonization_id
9697: , inventory_item_id
9698: , move_order_line_id
9699: FROM mtl_material_transactions_temp
9700: WHERE wms_task_type IS NOT NULL
9701: AND transaction_status = 2
9702: AND(
9703: wms_task_status IS NULL

Line 9760: FROM mtl_material_transactions_temp mmtt

9756: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
9757: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
9758: (
9759: SELECT NULL
9760: FROM mtl_material_transactions_temp mmtt
9761: WHERE mmtt.transaction_temp_id = wdtv.task_id
9762: AND mmtt.parent_line_id IS NOT NULL
9763: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
9764: AND NOT EXISTS -- exclude tasks already dispatched

Line 10388: FROM mtl_material_transactions_temp mmtt

10384: -- Test if this task is locked by any other user
10385: BEGIN
10386: SELECT mmtt.transaction_temp_id
10387: INTO t_opt_task_id(idx)
10388: FROM mtl_material_transactions_temp mmtt
10389: WHERE mmtt.transaction_temp_id = t_opt_task_id(idx)
10390: FOR UPDATE NOWAIT;
10391: EXCEPTION
10392: WHEN OTHERS THEN

Line 10467: FROM mtl_material_transactions_temp mmtt

10463: -- Test if this task is locked by any other user
10464: BEGIN
10465: SELECT mmtt.transaction_temp_id
10466: INTO t_opt_task_id(idx)
10467: FROM mtl_material_transactions_temp mmtt
10468: WHERE mmtt.transaction_temp_id = t_opt_task_id(idx)
10469: FOR UPDATE NOWAIT;
10470: EXCEPTION
10471: WHEN OTHERS THEN

Line 10665: FROM mtl_material_transactions_temp mmtt, wms_ordered_tasks wot

10661: wot.effective_end_date,
10662: wot.person_resource_id,
10663: wot.machine_resource_id,
10664: mmtt.move_order_line_id
10665: FROM mtl_material_transactions_temp mmtt, wms_ordered_tasks wot
10666: WHERE mmtt.wms_task_type IS NOT NULL
10667: AND mmtt.transaction_status = 2
10668: AND mmtt.transaction_temp_id = wot.task_id
10669: AND mmtt.transaction_temp_id > 0

Line 12402: from mtl_system_items_b msi,mtl_material_transactions_temp mmtt

12398:
12399: -- to get the serial control code
12400: select serial_number_control_code,lot_control_code
12401: into l_serial_number_control_code,l_lot_control_code
12402: from mtl_system_items_b msi,mtl_material_transactions_temp mmtt
12403: where mmtt.transaction_temp_id = p_parent_transaction_temp_id
12404: and mmtt.inventory_item_id = msi.inventory_item_id
12405: and mmtt.organization_id = msi.organization_id;
12406:

Line 12435: FROM mtl_transaction_lots_temp mtlt,mtl_material_transactions_temp mmtt

12431: ,g_user_id
12432: ,SYSDATE
12433: ,g_user_id
12434: ,null
12435: FROM mtl_transaction_lots_temp mtlt,mtl_material_transactions_temp mmtt
12436: WHERE
12437: mtlt.transaction_temp_id = mmtt.transaction_temp_id
12438: and mmtt.parent_line_id = p_parent_transaction_temp_id -- child task
12439: and mmtt.transaction_temp_id <> p_parent_transaction_temp_id -- not parent task

Line 12490: l_task_rec_old_mmtt mtl_material_transactions_temp%ROWTYPE;

12486: l_eq_it_v_uom_ratio NUMBER := 1; -- conversion rate between equipment volume capacity and item unit volume UOM
12487: l_eq_it_w_uom_ratio NUMBER := 1; -- conversion rate between equipment weight capacity and item weight UOM
12488: l_task_rec_old_wct wms_cartonization_temp%ROWTYPE;
12489: l_task_rec_new_wct wms_cartonization_temp%ROWTYPE;
12490: l_task_rec_old_mmtt mtl_material_transactions_temp%ROWTYPE;
12491: l_task_rec_new_mmtt mtl_material_transactions_temp%ROWTYPE;
12492: l_child_rec_new mtl_material_transactions_temp%ROWTYPE;
12493: l_lot_split_rec inv_rcv_common_apis.trans_rec_tb_tp;
12494: l_min_cap NUMBER := -1; -- minimum equipment capacity for a task

Line 12491: l_task_rec_new_mmtt mtl_material_transactions_temp%ROWTYPE;

12487: l_eq_it_w_uom_ratio NUMBER := 1; -- conversion rate between equipment weight capacity and item weight UOM
12488: l_task_rec_old_wct wms_cartonization_temp%ROWTYPE;
12489: l_task_rec_new_wct wms_cartonization_temp%ROWTYPE;
12490: l_task_rec_old_mmtt mtl_material_transactions_temp%ROWTYPE;
12491: l_task_rec_new_mmtt mtl_material_transactions_temp%ROWTYPE;
12492: l_child_rec_new mtl_material_transactions_temp%ROWTYPE;
12493: l_lot_split_rec inv_rcv_common_apis.trans_rec_tb_tp;
12494: l_min_cap NUMBER := -1; -- minimum equipment capacity for a task
12495: l_min_cap_temp NUMBER;

Line 12492: l_child_rec_new mtl_material_transactions_temp%ROWTYPE;

12488: l_task_rec_old_wct wms_cartonization_temp%ROWTYPE;
12489: l_task_rec_new_wct wms_cartonization_temp%ROWTYPE;
12490: l_task_rec_old_mmtt mtl_material_transactions_temp%ROWTYPE;
12491: l_task_rec_new_mmtt mtl_material_transactions_temp%ROWTYPE;
12492: l_child_rec_new mtl_material_transactions_temp%ROWTYPE;
12493: l_lot_split_rec inv_rcv_common_apis.trans_rec_tb_tp;
12494: l_min_cap NUMBER := -1; -- minimum equipment capacity for a task
12495: l_min_cap_temp NUMBER;
12496: l_split_factor NUMBER; -- split task to this size

Line 12563: , mtl_material_transactions_temp mmtt

12559: , -- item volume UOM code
12560: item.weight_uom_code item_w_uom -- item weight UOM code
12561: FROM mtl_system_items equip
12562: , mtl_system_items item
12563: , mtl_material_transactions_temp mmtt
12564: , bom_resource_equipments res_equip
12565: , bom_resources res
12566: , bom_std_op_resources tt_x_res
12567: WHERE mmtt.transaction_temp_id = p_task_id -- the task in question

Line 12622: FROM mtl_material_transactions_temp

12618:
12619: -- get the mmtt rec too, will be used later on, the reason why both wct and mmtt are here is for branching
12620: SELECT *
12621: INTO l_task_rec_old_mmtt
12622: FROM mtl_material_transactions_temp
12623: WHERE transaction_temp_id = p_task_id;
12624:
12625: IF (l_task_rec_old_wct.parent_line_id is null) THEN -- not bulk task
12626: -- cache the move order header info first

Line 13036: update mtl_material_transactions_temp

13032: print_debug('l_child_total_qty '||l_child_total_qty,4);
13033: END IF;
13034: if l_child_total_qty <= l_new_qty then
13035: -- update the child records with the new parent line id
13036: update mtl_material_transactions_temp
13037: set parent_line_id = l_new_temp_id
13038: where transaction_Temp_id = l_child_rec.transaction_temp_id;
13039: l_child_remaining_qty := 0;
13040: -- if = which means fully satisfied the new parent, can exit

Line 13051: update mtl_material_transactions_temp

13047: print_debug('update transaction temp id '||l_child_rec.transaction_temp_id
13048: || ' with the remaining qty '||l_child_remaining_qty,4);
13049: END IF;
13050: -- update the child line with the remaining qty
13051: update mtl_material_transactions_temp
13052: set transaction_quantity = l_child_remaining_qty
13053: , primary_quantity = l_child_remaining_qty * l_txn_pri_uom_ratio
13054: where transaction_temp_id = l_child_rec.transaction_temp_id;
13055:

Line 13066: from mtl_material_transactions_temp

13062: l_progress := '140.1';
13063: select *
13064: into
13065: l_child_rec_new
13066: from mtl_material_transactions_temp
13067: where transaction_temp_id = l_child_rec.transaction_temp_id;
13068:
13069: /* Is it necessary to change transaction UOM to locator UOM here ???*/
13070: l_child_rec_new.transaction_temp_id := l_new_child_temp_id;

Line 13158: UPDATE mtl_material_transactions_temp

13154: -- the lot and serial info still need to be duplicated since consolidation didn't do it
13155: if G_CURRENT_RELEASE_LEVEL >= G_J_RELEASE_LEVEL AND
13156: l_move_order_type = G_MOVE_ORDER_PICK_WAVE THEN
13157: -- IF (l_debug = 1) THEN print_debug('PATCHSET J -- BULK PICKING --- START',4); END IF;
13158: UPDATE mtl_material_transactions_temp
13159: SET transaction_quantity = l_init_qty
13160: , primary_quantity = l_init_qty * l_txn_pri_uom_ratio
13161: WHERE transaction_temp_id = p_task_id;
13162: IF l_task_rec_old_mmtt.transaction_temp_id = l_task_rec_old_mmtt.parent_line_id THEN

Line 13248: PROCEDURE insert_mmtt(l_mmtt_rec mtl_material_transactions_temp%ROWTYPE) IS

13244: print_debug('split_task: Other exception ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
13245: END IF;
13246: END split_task;
13247:
13248: PROCEDURE insert_mmtt(l_mmtt_rec mtl_material_transactions_temp%ROWTYPE) IS
13249: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
13250: BEGIN
13251: INSERT INTO mtl_material_transactions_temp
13252: (

Line 13251: INSERT INTO mtl_material_transactions_temp

13247:
13248: PROCEDURE insert_mmtt(l_mmtt_rec mtl_material_transactions_temp%ROWTYPE) IS
13249: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
13250: BEGIN
13251: INSERT INTO mtl_material_transactions_temp
13252: (
13253: transaction_header_id
13254: , transaction_temp_id
13255: , source_code