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 176: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

172: DELETE FROM WMS_DISPATCH_TASKS_GTMP WHERE
173: GROUPING_DOCUMENT_NUMBER IN (
174: SELECT MMTT.TRANSACTION_SOURCE_ID
175: FROM MTL_SALES_ORDERS MSO ,
176: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
177: WHERE MMTT.TRANSACTION_SOURCE_ID = MSO.SALES_ORDER_ID
178: AND MSO.SEGMENT1 IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_ORDER_NUMBERS))
179: );
180: EXCEPTION

Line 346: FROM mtl_material_transactions_temp mmtt

342: transaction_type_id,
343: transaction_action_id,
344: transaction_source_id,
345: transaction_source_type_id
346: FROM mtl_material_transactions_temp mmtt
347: WHERE wms_task_type IS NOT NULL
348: AND transaction_temp_id = Decode(p_task_method, 'BULK',
349: parent_line_id, transaction_temp_id)
350: AND Decode(transaction_source_type_id,

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

357: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
358: --7169220: USERS LOCKED
359: AND (mmtt.cartonization_id is null
360: or not exists
361: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
362: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
363: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
364: and wdt1.status = 9
365: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 455: FROM mtl_material_transactions_temp mmtt

451: transaction_type_id,
452: transaction_action_id,
453: transaction_source_id,
454: transaction_source_type_id
455: FROM mtl_material_transactions_temp mmtt
456: WHERE wms_task_type IS NOT NULL
457: AND transaction_status = 2
458: AND(wms_task_status IS NULL OR wms_task_status = 1) --Added for task planning WB. bug#2651318
459: AND transaction_temp_id = Decode(p_task_method, 'BULK',

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

468: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
469: --7169220: USERS LOCKED
470: AND (mmtt.cartonization_id is null
471: or not exists
472: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
473: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
474: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
475: and wdt1.status = 9
476: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 594: FROM mtl_material_transactions_temp mmtt

590: )
591: -- bug 4358107
592: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
593: (SELECT NULL
594: FROM mtl_material_transactions_temp mmtt
595: WHERE mmtt.transaction_temp_id = wdtv.task_id
596: AND mmtt.parent_line_id IS NOT NULL
597: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
598: AND mmtt.wms_task_type = wdtv.wms_task_type_id)

Line 671: FROM mtl_material_transactions_temp mmtt

667: transaction_type_id,
668: transaction_action_id,
669: transaction_source_id,
670: transaction_source_type_id
671: FROM mtl_material_transactions_temp mmtt
672: WHERE wms_task_type IS NOT NULL
673: AND transaction_temp_id = Decode(p_task_method, 'BULK',
674: parent_line_id, transaction_temp_id)
675: AND Decode(transaction_source_type_id,

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

682: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
683: --7169220: USERS LOCKED
684: AND (mmtt.cartonization_id is null
685: or not exists
686: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
687: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
688: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
689: and wdt1.status = 9
690: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 749: FROM mtl_material_transactions_temp mmtt

745: transaction_type_id,
746: transaction_action_id,
747: transaction_source_id,
748: transaction_source_type_id
749: FROM mtl_material_transactions_temp mmtt
750: WHERE wms_task_type IS NOT NULL
751: AND transaction_temp_id = Decode(p_task_method, 'BULK',
752: parent_line_id, transaction_temp_id)
753: AND Decode(transaction_source_type_id,

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

760: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
761: --7169220: USERS LOCKED
762: AND (mmtt.cartonization_id is null
763: or not exists
764: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
765: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
766: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
767: and wdt1.status = 9
768: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 841: FROM mtl_material_transactions_temp mmtt

837: transaction_type_id,
838: transaction_action_id,
839: transaction_source_id,
840: transaction_source_type_id
841: FROM mtl_material_transactions_temp mmtt
842: WHERE wms_task_type IS NOT NULL
843: AND transaction_status = 2
844: AND(wms_task_status IS NULL OR wms_task_status = 1) --Added for task planning WB. bug#2651318
845: AND transaction_temp_id = Decode(p_task_method, 'BULK',

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

854: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
855: --7169220: USERS LOCKED
856: AND (mmtt.cartonization_id is null
857: or not exists
858: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
859: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
860: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
861: and wdt1.status = 9
862: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 943: FROM mtl_material_transactions_temp mmtt

939: )
940: -- bug 4358107
941: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
942: (SELECT NULL
943: FROM mtl_material_transactions_temp mmtt
944: WHERE mmtt.transaction_temp_id = wdtv.task_id
945: AND mmtt.parent_line_id IS NOT NULL
946: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
947: AND mmtt.wms_task_type = wdtv.wms_task_type_id)

Line 1175: FROM mtl_material_transactions_temp mmtt

1171: )
1172: -- bug 4358107
1173: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
1174: (SELECT NULL
1175: FROM mtl_material_transactions_temp mmtt
1176: WHERE mmtt.transaction_temp_id = wdtv.task_id
1177: AND mmtt.parent_line_id IS NOT NULL
1178: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
1179: AND mmtt.wms_task_type = wdtv.wms_task_type_id)

Line 1251: FROM mtl_material_transactions_temp mmtt

1247: transaction_type_id,
1248: transaction_action_id,
1249: transaction_source_id,
1250: transaction_source_type_id
1251: FROM mtl_material_transactions_temp mmtt
1252: WHERE wms_task_type IS NOT NULL
1253: AND transaction_temp_id = Decode(p_task_method, 'BULK',
1254: parent_line_id, transaction_temp_id)
1255: AND Decode(transaction_source_type_id,

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

1262: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1263: --7169220: USERS LOCKED
1264: AND (mmtt.cartonization_id is null
1265: or not exists
1266: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1267: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1268: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1269: and wdt1.status = 9
1270: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 1362: FROM mtl_material_transactions_temp mmtt

1358: transaction_type_id,
1359: transaction_action_id,
1360: transaction_source_id,
1361: transaction_source_type_id
1362: FROM mtl_material_transactions_temp mmtt
1363: WHERE wms_task_type IS NOT NULL
1364: AND transaction_status = 2
1365: AND(wms_task_status IS NULL OR wms_task_status = 1) --Added for task planning WB. bug#2651318
1366: AND transaction_temp_id = Decode(p_task_method, 'BULK',

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

1375: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1376: --7169220: USERS LOCKED
1377: AND (mmtt.cartonization_id is null
1378: or not exists
1379: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1380: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1381: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1382: and wdt1.status = 9
1383: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 1500: FROM mtl_material_transactions_temp mmtt

1496: )
1497: -- bug 4358107
1498: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
1499: (SELECT NULL
1500: FROM mtl_material_transactions_temp mmtt
1501: WHERE mmtt.transaction_temp_id = wdtv.task_id
1502: AND mmtt.parent_line_id IS NOT NULL
1503: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
1504: AND mmtt.wms_task_type = wdtv.wms_task_type_id)

Line 1578: FROM mtl_material_transactions_temp mmtt

1574: transaction_type_id,
1575: transaction_action_id,
1576: transaction_source_id,
1577: transaction_source_type_id
1578: FROM mtl_material_transactions_temp mmtt
1579: WHERE wms_task_type IS NOT NULL
1580: AND transaction_temp_id = Decode(p_task_method, 'BULK',
1581: parent_line_id, transaction_temp_id)
1582: AND Decode(transaction_source_type_id,

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

1589: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1590: --7169220: USERS LOCKED
1591: AND (mmtt.cartonization_id is null
1592: or not exists
1593: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1594: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1595: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1596: and wdt1.status = 9
1597: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 1655: FROM mtl_material_transactions_temp mmtt

1651: transaction_type_id,
1652: transaction_action_id,
1653: transaction_source_id,
1654: transaction_source_type_id
1655: FROM mtl_material_transactions_temp mmtt
1656: WHERE wms_task_type IS NOT NULL
1657: AND transaction_temp_id = Decode(p_task_method, 'BULK',
1658: parent_line_id, transaction_temp_id)
1659: AND Decode(transaction_source_type_id,

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

1666: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1667: --7169220: USERS LOCKED
1668: AND (mmtt.cartonization_id is null
1669: or not exists
1670: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1671: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1672: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1673: and wdt1.status = 9
1674: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 1746: FROM mtl_material_transactions_temp mmtt

1742: transaction_type_id,
1743: transaction_action_id,
1744: transaction_source_id,
1745: transaction_source_type_id
1746: FROM mtl_material_transactions_temp mmtt
1747: WHERE wms_task_type IS NOT NULL
1748: AND transaction_status = 2
1749: AND(wms_task_status IS NULL OR wms_task_status = 1) --Added for task planning WB. bug#2651318
1750: AND transaction_temp_id = Decode(p_task_method, 'BULK',

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

1759: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1760: --7169220: USERS LOCKED
1761: AND (mmtt.cartonization_id is null
1762: or not exists
1763: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1764: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1765: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1766: and wdt1.status = 9
1767: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 1847: FROM mtl_material_transactions_temp mmtt

1843: )
1844: -- bug 4358107
1845: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
1846: (SELECT NULL
1847: FROM mtl_material_transactions_temp mmtt
1848: WHERE mmtt.transaction_temp_id = wdtv.task_id
1849: AND mmtt.parent_line_id IS NOT NULL
1850: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
1851: AND mmtt.wms_task_type = wdtv.wms_task_type_id)

Line 2073: FROM mtl_material_transactions_temp mmtt

2069: )
2070: -- bug 4358107
2071: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
2072: (SELECT NULL
2073: FROM mtl_material_transactions_temp mmtt
2074: WHERE mmtt.transaction_temp_id = wdtv.task_id
2075: AND mmtt.parent_line_id IS NOT NULL
2076: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
2077: AND mmtt.wms_task_type = wdtv.wms_task_type_id)

Line 2172: FROM mtl_material_transactions_temp mmtt

2168: transaction_action_id,
2169: transaction_source_id,
2170: transaction_source_type_id,
2171: parent_line_id --Added for Case Picking Project (Bulk Task check)
2172: FROM mtl_material_transactions_temp mmtt
2173: WHERE wms_task_type IS NOT NULL
2174: AND transaction_temp_id = Decode(p_task_method, 'BULK',
2175: parent_line_id, transaction_temp_id)
2176: AND Decode(transaction_source_type_id,

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

2183: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2184: --7169220: USERS LOCKED
2185: AND (mmtt.cartonization_id is null
2186: or not exists
2187: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2188: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2189: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2190: and wdt1.status = 9
2191: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 2263: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

2259: OR ( p_task_method = 'MANIFESTORDER' AND
2260: qt.transaction_source_id IN (
2261: SELECT MMTT.TRANSACTION_SOURCE_ID
2262: FROM MTL_SALES_ORDERS MSO ,
2263: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
2264: WHERE MMTT.TRANSACTION_SOURCE_ID = MSO.SALES_ORDER_ID
2265: AND MSO.SEGMENT1 IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_ORDER_NUMBERS))
2266: )
2267: and qt.parent_line_id IS NULL -- Added for bulk task

Line 2339: FROM mtl_material_transactions_temp mmtt

2335: transaction_source_id,
2336: transaction_source_type_id,
2337: operation_plan_id,
2338: parent_line_id --Added for Case Picking Project (Bulk Task check)
2339: FROM mtl_material_transactions_temp mmtt
2340: WHERE wms_task_type IS NOT NULL
2341: AND transaction_status = 2
2342: AND(wms_task_status IS NULL OR wms_task_status = 1) --Added for task planning WB. bug#2651318
2343: AND transaction_temp_id = Decode(p_task_method, 'BULK',

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

2352: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2353: --7169220: USERS LOCKED
2354: AND (mmtt.cartonization_id is null
2355: or not exists
2356: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2357: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2358: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2359: and wdt1.status = 9
2360: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 2456: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

2452: OR ( p_task_method = 'MANIFESTORDER' AND
2453: wdtv.transaction_source_id IN (
2454: SELECT MMTT.TRANSACTION_SOURCE_ID
2455: FROM MTL_SALES_ORDERS MSO ,
2456: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
2457: WHERE MMTT.TRANSACTION_SOURCE_ID = MSO.SALES_ORDER_ID
2458: AND MSO.SEGMENT1 IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_ORDER_NUMBERS))
2459: )
2460: and wdtv.parent_line_id IS NULL -- Added for bulk task

Line 2485: FROM mtl_material_transactions_temp mmtt

2481: -1, 1,
2482: 1) = 1
2483: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
2484: (SELECT NULL
2485: FROM mtl_material_transactions_temp mmtt
2486: WHERE mmtt.transaction_temp_id = wdtv.task_id
2487: AND mmtt.parent_line_id IS NOT NULL
2488: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
2489: AND mmtt.wms_task_type = wdtv.wms_task_type_id)

Line 2604: FROM mtl_material_transactions_temp mmtt

2600: transaction_action_id,
2601: transaction_source_id,
2602: transaction_source_type_id,
2603: parent_line_id --Added for Case Picking Project (Bulk Task check)
2604: FROM mtl_material_transactions_temp mmtt
2605: WHERE wms_task_type IS NOT NULL
2606: AND transaction_temp_id = Decode(p_task_method, 'BULK',
2607: parent_line_id, transaction_temp_id)
2608: AND Decode(transaction_source_type_id,

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

2615: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2616: --7169220: USERS LOCKED
2617: AND (mmtt.cartonization_id is null
2618: or not exists
2619: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2620: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2621: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2622: and wdt1.status = 9
2623: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 2659: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

2655: OR ( p_task_method = 'MANIFESTORDER' AND
2656: qt.transaction_source_id IN (
2657: SELECT MMTT.TRANSACTION_SOURCE_ID
2658: FROM MTL_SALES_ORDERS MSO ,
2659: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
2660: WHERE MMTT.TRANSACTION_SOURCE_ID = MSO.SALES_ORDER_ID
2661: AND MSO.SEGMENT1 IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_ORDER_NUMBERS))
2662: )
2663: and qt.parent_line_id IS NULL -- Added for bulk task

Line 2731: FROM mtl_material_transactions_temp mmtt

2727: transaction_action_id,
2728: transaction_source_id,
2729: transaction_source_type_id,
2730: parent_line_id --Added for Case Picking Project (Bulk Task check)
2731: FROM mtl_material_transactions_temp mmtt
2732: WHERE wms_task_type IS NOT NULL
2733: AND transaction_temp_id = Decode(p_task_method, 'BULK',
2734: parent_line_id, transaction_temp_id)
2735: AND Decode(transaction_source_type_id,

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

2742: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2743: --7169220: USERS LOCKED
2744: AND (mmtt.cartonization_id is null
2745: or not exists
2746: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2747: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2748: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2749: and wdt1.status = 9
2750: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 2786: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

2782: OR ( p_task_method = 'MANIFESTORDER' AND
2783: qt.transaction_source_id IN (
2784: SELECT MMTT.TRANSACTION_SOURCE_ID
2785: FROM MTL_SALES_ORDERS MSO ,
2786: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
2787: WHERE MMTT.TRANSACTION_SOURCE_ID = MSO.SALES_ORDER_ID
2788: AND MSO.SEGMENT1 IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_ORDER_NUMBERS))
2789: )
2790: and qt.parent_line_id IS NULL -- Added for bulk task

Line 2866: FROM mtl_material_transactions_temp mmtt

2862: transaction_source_id,
2863: transaction_source_type_id,
2864: operation_plan_id,
2865: parent_line_id --Added for Case Picking Project (Bulk Task check)
2866: FROM mtl_material_transactions_temp mmtt
2867: WHERE wms_task_type IS NOT NULL
2868: AND transaction_status = 2
2869: AND(wms_task_status IS NULL OR wms_task_status = 1) --Added for task planning WB. bug#2651318
2870: AND transaction_temp_id = Decode(p_task_method, 'BULK',

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

2879: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2880: --7169220: USERS LOCKED
2881: AND (mmtt.cartonization_id is null
2882: or not exists
2883: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2884: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2885: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2886: and wdt1.status = 9
2887: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 2945: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

2941: OR ( p_task_method = 'MANIFESTORDER' AND
2942: wdtv.transaction_source_id IN (
2943: SELECT MMTT.TRANSACTION_SOURCE_ID
2944: FROM MTL_SALES_ORDERS MSO ,
2945: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
2946: WHERE MMTT.TRANSACTION_SOURCE_ID = MSO.SALES_ORDER_ID
2947: AND MSO.SEGMENT1 IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_ORDER_NUMBERS))
2948: )
2949: and wdtv.parent_line_id IS NULL -- Added for bulk task

Line 2974: FROM mtl_material_transactions_temp mmtt

2970: -1, 1,
2971: 1) = 1
2972: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
2973: (SELECT NULL
2974: FROM mtl_material_transactions_temp mmtt
2975: WHERE mmtt.transaction_temp_id = wdtv.task_id
2976: AND mmtt.parent_line_id IS NOT NULL
2977: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
2978: AND mmtt.wms_task_type = wdtv.wms_task_type_id)

Line 3239: FROM mtl_material_transactions_temp mmtt

3235: AND wdtv.subinventory_code = sub.secondary_inventory_name
3236: AND wdtv.organization_id = sub.organization_id
3237: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
3238: (SELECT NULL
3239: FROM mtl_material_transactions_temp mmtt
3240: WHERE mmtt.transaction_temp_id = wdtv.task_id
3241: AND mmtt.parent_line_id IS NOT NULL
3242: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
3243: AND mmtt.wms_task_type = wdtv.wms_task_type_id)

Line 3284: FROM mtl_material_transactions_temp

3280: task_num;
3281:
3282: CURSOR c_task_lock_check(v_transaction_temp_id NUMBER) IS
3283: SELECT transaction_temp_id
3284: FROM mtl_material_transactions_temp
3285: WHERE transaction_temp_id = v_transaction_temp_id
3286: FOR UPDATE nowait;
3287:
3288: CURSOR c_pick_slip_lock_check(v_pick_slip_number NUMBER) IS

Line 3290: FROM mtl_material_transactions_temp mmtt

3286: FOR UPDATE nowait;
3287:
3288: CURSOR c_pick_slip_lock_check(v_pick_slip_number NUMBER) IS
3289: SELECT mmtt.transaction_temp_id
3290: FROM mtl_material_transactions_temp mmtt
3291: WHERE mmtt.pick_slip_number = v_pick_slip_number
3292: AND NVL(mmtt.subinventory_code, '@@@') = NVL(p_sign_on_zone, NVL(mmtt.subinventory_code, '@@@'))
3293: -- Bug 14094713 added to lock only the tasks queued to that particular user
3294: AND NOT EXISTS ( SELECT 1

Line 3306: FROM mtl_material_transactions_temp mmtt

3302: v_transaction_source_type_id NUMBER,
3303: v_transaction_action_id NUMBER,
3304: v_transaction_type_id NUMBER) IS
3305: SELECT transaction_temp_id
3306: FROM mtl_material_transactions_temp mmtt
3307: WHERE transaction_source_id = v_order_header_id
3308: AND transaction_source_type_id = v_transaction_source_type_id
3309: AND transaction_action_id = v_transaction_action_id
3310: AND transaction_type_id = v_transaction_type_id

Line 3322: FROM mtl_material_transactions_temp

3318: FOR UPDATE nowait;
3319:
3320: CURSOR c_carton_lock_check(v_cartonization_id NUMBER) IS
3321: SELECT transaction_temp_id
3322: FROM mtl_material_transactions_temp
3323: WHERE cartonization_id = v_cartonization_id
3324: AND NVL(subinventory_code, '@@@') = NVL(p_sign_on_zone, NVL(subinventory_code, '@@@'))
3325: FOR UPDATE nowait;
3326:

Line 3350: SELECT transaction_temp_id FROM mtl_material_transactions_temp

3346: WHERE mso.segment1 = lon.column_value;
3347:
3348:
3349: CURSOR c_manifest_order_lock_check(v_sales_order_id NUMBER) IS
3350: SELECT transaction_temp_id FROM mtl_material_transactions_temp
3351: WHERE transaction_source_id = v_sales_order_id
3352: AND NVL(subinventory_code, '@@@') = NVL(p_sign_on_zone,NVL(subinventory_code, '@@@'))
3353: FOR UPDATE nowait;
3354:

Line 3580: FROM mtl_material_transactions_temp

3576: pick_slip_number pick_slip_number,
3577: cartonization_id cartonization_id,
3578: inventory_item_id,
3579: move_order_line_id
3580: FROM mtl_material_transactions_temp
3581: WHERE wms_task_type IS NOT NULL
3582: AND transaction_status = 2
3583: UNION ALL
3584: SELECT

Line 4193: FROM mtl_material_transactions_temp mmtt

4189: END IF;
4190: /*Take the LPN_ID from MMTT*/
4191: l_lpn_id := NULL;
4192: SELECT cartonization_id INTO l_lpn_id
4193: FROM mtl_material_transactions_temp mmtt
4194: WHERE mmtt.transaction_temp_id= l_task_id;
4195:
4196:
4197:

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

4202:
4203: /*Check if any task has been dispatched to other users for the same LPN*/
4204: IF l_lpn_id IS NOT NULL THEN
4205: l_wdt_count := 0 ;
4206: SELECT count(1) INTO l_wdt_count FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt
4207: WHERE mmtt.cartonization_id = l_lpn_id
4208: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
4209: AND wdt.status in(3,9) AND wdt.person_id <> p_sign_on_emp_id ;
4210:

Line 4780: FROM mtl_material_transactions_temp

4776: , pick_slip_number pick_slip_number
4777: , cartonization_id cartonization_id
4778: , inventory_item_id
4779: , move_order_line_id
4780: FROM mtl_material_transactions_temp
4781: WHERE wms_task_type IS NOT NULL
4782: AND transaction_status = 2
4783: AND(wms_task_status IS NULL
4784: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 4852: FROM mtl_material_transactions_temp mmtt

4848: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
4849: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
4850: (
4851: SELECT NULL
4852: FROM mtl_material_transactions_temp mmtt
4853: WHERE mmtt.transaction_temp_id = wdtv.task_id
4854: AND mmtt.parent_line_id IS NOT NULL
4855: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
4856: AND NOT EXISTS -- exclude tasks already dispatched

Line 4934: FROM mtl_material_transactions_temp

4930: , pick_slip_number pick_slip_number
4931: , cartonization_id cartonization_id
4932: , inventory_item_id
4933: , move_order_line_id
4934: FROM mtl_material_transactions_temp
4935: WHERE wms_task_type IS NOT NULL
4936: AND transaction_status = 2
4937: AND(wms_task_status IS NULL
4938: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 5008: FROM mtl_material_transactions_temp mmtt

5004: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'
5005: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5006: (
5007: SELECT NULL
5008: FROM mtl_material_transactions_temp mmtt
5009: WHERE mmtt.transaction_temp_id = wdtv.task_id
5010: AND mmtt.parent_line_id IS NOT NULL
5011: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5012: AND NOT EXISTS -- exclude tasks already dispatched

Line 5090: FROM mtl_material_transactions_temp

5086: , pick_slip_number pick_slip_number
5087: , cartonization_id cartonization_id
5088: , inventory_item_id
5089: , move_order_line_id
5090: FROM mtl_material_transactions_temp
5091: WHERE wms_task_type IS NOT NULL
5092: AND transaction_status = 2
5093: AND(wms_task_status IS NULL
5094: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 5161: FROM mtl_material_transactions_temp mmtt

5157: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
5158: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5159: (
5160: SELECT NULL
5161: FROM mtl_material_transactions_temp mmtt
5162: WHERE mmtt.transaction_temp_id = wdtv.task_id
5163: AND mmtt.parent_line_id IS NOT NULL
5164: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5165: AND NOT EXISTS -- exclude tasks already dispatched

Line 5243: FROM mtl_material_transactions_temp

5239: , pick_slip_number pick_slip_number
5240: , cartonization_id cartonization_id
5241: , inventory_item_id
5242: , move_order_line_id
5243: FROM mtl_material_transactions_temp
5244: WHERE wms_task_type IS NOT NULL
5245: AND transaction_status = 2
5246: AND(wms_task_status IS NULL
5247: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 5315: FROM mtl_material_transactions_temp mmtt

5311: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
5312: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5313: (
5314: SELECT NULL
5315: FROM mtl_material_transactions_temp mmtt
5316: WHERE mmtt.transaction_temp_id = wdtv.task_id
5317: AND mmtt.parent_line_id IS NOT NULL
5318: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5319: AND NOT EXISTS -- exclude tasks already dispatched

Line 5396: FROM mtl_material_transactions_temp

5392: , pick_slip_number pick_slip_number
5393: , cartonization_id cartonization_id
5394: , inventory_item_id
5395: , move_order_line_id
5396: FROM mtl_material_transactions_temp
5397: WHERE wms_task_type IS NOT NULL
5398: AND transaction_status = 2
5399: AND(wms_task_status IS NULL
5400: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 5470: FROM mtl_material_transactions_temp mmtt

5466: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
5467: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5468: (
5469: SELECT NULL
5470: FROM mtl_material_transactions_temp mmtt
5471: WHERE mmtt.transaction_temp_id = wdtv.task_id
5472: AND mmtt.parent_line_id IS NOT NULL
5473: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5474: AND NOT EXISTS -- exclude tasks already dispatched

Line 5550: FROM mtl_material_transactions_temp

5546: , pick_slip_number pick_slip_number
5547: , cartonization_id cartonization_id
5548: , inventory_item_id
5549: , move_order_line_id
5550: FROM mtl_material_transactions_temp
5551: WHERE wms_task_type IS NOT NULL
5552: AND transaction_status = 2
5553: AND(wms_task_status IS NULL
5554: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 5623: FROM mtl_material_transactions_temp mmtt

5619: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
5620: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5621: (
5622: SELECT NULL
5623: FROM mtl_material_transactions_temp mmtt
5624: WHERE mmtt.transaction_temp_id = wdtv.task_id
5625: AND mmtt.parent_line_id IS NOT NULL
5626: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5627: AND NOT EXISTS -- exclude tasks already dispatched

Line 5703: FROM mtl_material_transactions_temp

5699: , pick_slip_number pick_slip_number
5700: , cartonization_id cartonization_id
5701: , inventory_item_id
5702: , move_order_line_id
5703: FROM mtl_material_transactions_temp
5704: WHERE wms_task_type IS NOT NULL
5705: AND transaction_status = 2
5706: AND(wms_task_status IS NULL
5707: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 5774: FROM mtl_material_transactions_temp mmtt

5770: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
5771: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5772: (
5773: SELECT NULL
5774: FROM mtl_material_transactions_temp mmtt
5775: WHERE mmtt.transaction_temp_id = wdtv.task_id
5776: AND mmtt.parent_line_id IS NOT NULL
5777: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5778: AND NOT EXISTS -- exclude tasks already dispatched

Line 5854: FROM mtl_material_transactions_temp

5850: , pick_slip_number pick_slip_number
5851: , cartonization_id cartonization_id
5852: , inventory_item_id
5853: , move_order_line_id
5854: FROM mtl_material_transactions_temp
5855: WHERE wms_task_type IS NOT NULL
5856: AND transaction_status = 2
5857: AND(wms_task_status IS NULL
5858: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 5926: FROM mtl_material_transactions_temp mmtt

5922: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
5923: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5924: (
5925: SELECT NULL
5926: FROM mtl_material_transactions_temp mmtt
5927: WHERE mmtt.transaction_temp_id = wdtv.task_id
5928: AND mmtt.parent_line_id IS NOT NULL
5929: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5930: AND NOT EXISTS -- exclude tasks already dispatched

Line 6002: FROM mtl_material_transactions_temp

5998: , pick_slip_number pick_slip_number
5999: , cartonization_id cartonization_id
6000: , inventory_item_id
6001: , move_order_line_id
6002: FROM mtl_material_transactions_temp
6003: WHERE wms_task_type IS NOT NULL
6004: AND transaction_status = 2
6005: AND(wms_task_status IS NULL
6006: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 6076: FROM mtl_material_transactions_temp mmtt

6072: AND wdtv.move_order_line_id = mol.line_id(+) -- join task to MOL, outer join for tasks do not have MOL
6073: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
6074: (
6075: SELECT NULL
6076: FROM mtl_material_transactions_temp mmtt
6077: WHERE mmtt.transaction_temp_id = wdtv.task_id
6078: AND mmtt.parent_line_id IS NOT NULL
6079: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
6080: AND NOT EXISTS -- exclude tasks already dispatched

Line 6153: FROM mtl_material_transactions_temp

6149: , pick_slip_number pick_slip_number
6150: , cartonization_id cartonization_id
6151: , inventory_item_id
6152: , move_order_line_id
6153: FROM mtl_material_transactions_temp
6154: WHERE wms_task_type IS NOT NULL
6155: AND transaction_status = 2
6156: AND(wms_task_status IS NULL
6157: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 6230: FROM mtl_material_transactions_temp mmtt

6226: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'
6227: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
6228: (
6229: SELECT NULL
6230: FROM mtl_material_transactions_temp mmtt
6231: WHERE mmtt.transaction_temp_id = wdtv.task_id
6232: AND mmtt.parent_line_id IS NOT NULL
6233: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
6234: AND NOT EXISTS -- exclude tasks already dispatched

Line 6306: FROM mtl_material_transactions_temp

6302: , pick_slip_number pick_slip_number
6303: , cartonization_id cartonization_id
6304: , inventory_item_id
6305: , move_order_line_id
6306: FROM mtl_material_transactions_temp
6307: WHERE wms_task_type IS NOT NULL
6308: AND transaction_status = 2
6309: AND(wms_task_status IS NULL
6310: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 6378: FROM mtl_material_transactions_temp mmtt

6374: AND wdtv.move_order_line_id = mol.line_id(+) -- join task to MOL, outer join for tasks do not have MOL
6375: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
6376: (
6377: SELECT NULL
6378: FROM mtl_material_transactions_temp mmtt
6379: WHERE mmtt.transaction_temp_id = wdtv.task_id
6380: AND mmtt.parent_line_id IS NOT NULL
6381: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
6382: AND NOT EXISTS -- exclude tasks already dispatched

Line 6454: FROM mtl_material_transactions_temp

6450: , pick_slip_number pick_slip_number
6451: , cartonization_id cartonization_id
6452: , inventory_item_id
6453: , move_order_line_id
6454: FROM mtl_material_transactions_temp
6455: WHERE wms_task_type IS NOT NULL
6456: AND transaction_status = 2
6457: AND(wms_task_status IS NULL
6458: OR wms_task_status = 1) --Added for task planning WB. bug#2651318

Line 6529: FROM mtl_material_transactions_temp mmtt

6525: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'
6526: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
6527: (
6528: SELECT NULL
6529: FROM mtl_material_transactions_temp mmtt
6530: WHERE mmtt.transaction_temp_id = wdtv.task_id
6531: AND mmtt.parent_line_id IS NOT NULL
6532: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
6533: AND NOT EXISTS -- exclude tasks already dispatched

Line 6580: FROM mtl_material_transactions_temp mmtt

6576:
6577: CURSOR c_lock_check(v_pick_slip_number NUMBER) IS
6578:
6579: SELECT transaction_temp_id
6580: FROM mtl_material_transactions_temp mmtt
6581: WHERE mmtt.pick_slip_number = v_pick_slip_number
6582: FOR UPDATE nowait;
6583:
6584:

Line 6808: FROM mtl_material_transactions_temp

6804: , pick_slip_number pick_slip_number
6805: , cartonization_id cartonization_id
6806: , inventory_item_id
6807: , move_order_line_id
6808: FROM mtl_material_transactions_temp
6809: WHERE wms_task_type IS NOT NULL
6810: AND transaction_status = 2
6811: UNION ALL
6812: SELECT MIN(cycle_count_entry_id) task_id

Line 7251: FROM mtl_material_transactions_temp mmtt

7247: IF l_opt_task_pick_slip IS NULL THEN -- bug 2832818
7248: BEGIN
7249: SELECT mmtt.transaction_temp_id
7250: INTO l_opt_task_id
7251: FROM mtl_material_transactions_temp mmtt
7252: WHERE mmtt.transaction_temp_id = l_opt_task_id
7253: FOR UPDATE NOWAIT;
7254: EXCEPTION
7255: WHEN OTHERS THEN

Line 7317: FROM mtl_material_transactions_temp mmtt

7313: IF l_opt_task_pick_slip IS NULL THEN -- bug 2832818
7314: BEGIN
7315: SELECT mmtt.transaction_temp_id
7316: INTO l_opt_task_id
7317: FROM mtl_material_transactions_temp mmtt
7318: WHERE mmtt.transaction_temp_id = l_opt_task_id
7319: FOR UPDATE NOWAIT;
7320: EXCEPTION
7321: WHEN OTHERS THEN

Line 7436: FROM mtl_material_transactions_temp mmtt, wms_ordered_tasks wot

7432: , mmtt.transaction_quantity transaction_quantity
7433: , '' lot_number
7434: , mmtt.wms_task_type wms_task_type_id
7435: , mmtt.task_priority task_priority
7436: FROM mtl_material_transactions_temp mmtt, wms_ordered_tasks wot
7437: WHERE mmtt.wms_task_type IS NOT NULL
7438: AND mmtt.transaction_status = 2
7439: AND mmtt.transaction_temp_id = wot.task_id
7440: AND mmtt.transaction_temp_id > 0

Line 7680: FROM mtl_material_transactions_temp

7676: , pick_slip_number pick_slip_number
7677: , cartonization_id cartonization_id
7678: , inventory_item_id
7679: , move_order_line_id
7680: FROM mtl_material_transactions_temp
7681: WHERE wms_task_type IS NOT NULL
7682: AND transaction_status = 2
7683: AND(
7684: wms_task_status IS NULL

Line 7767: FROM mtl_material_transactions_temp mmtt

7763: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
7764: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
7765: (
7766: SELECT NULL
7767: FROM mtl_material_transactions_temp mmtt
7768: WHERE mmtt.transaction_temp_id = wdtv.task_id
7769: AND mmtt.parent_line_id IS NOT NULL
7770: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
7771: AND NOT EXISTS -- exclude tasks already dispatched

Line 7841: FROM mtl_material_transactions_temp

7837: , pick_slip_number pick_slip_number
7838: , cartonization_id cartonization_id
7839: , inventory_item_id
7840: , move_order_line_id
7841: FROM mtl_material_transactions_temp
7842: WHERE wms_task_type IS NOT NULL
7843: AND transaction_status = 2
7844: AND(
7845: wms_task_status IS NULL

Line 7924: FROM mtl_material_transactions_temp mmtt

7920: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
7921: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
7922: (
7923: SELECT NULL
7924: FROM mtl_material_transactions_temp mmtt
7925: WHERE mmtt.transaction_temp_id = wdtv.task_id
7926: AND mmtt.parent_line_id IS NOT NULL
7927: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
7928: AND NOT EXISTS -- exclude tasks already dispatched

Line 8001: FROM mtl_material_transactions_temp

7997: , pick_slip_number pick_slip_number
7998: , cartonization_id cartonization_id
7999: , inventory_item_id
8000: , move_order_line_id
8001: FROM mtl_material_transactions_temp
8002: WHERE wms_task_type IS NOT NULL
8003: AND transaction_status = 2
8004: AND(
8005: wms_task_status IS NULL

Line 8087: FROM mtl_material_transactions_temp mmtt

8083: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
8084: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
8085: (
8086: SELECT NULL
8087: FROM mtl_material_transactions_temp mmtt
8088: WHERE mmtt.transaction_temp_id = wdtv.task_id
8089: AND mmtt.parent_line_id IS NOT NULL
8090: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
8091: AND NOT EXISTS -- exclude tasks already dispatched

Line 8161: FROM mtl_material_transactions_temp

8157: , pick_slip_number pick_slip_number
8158: , cartonization_id cartonization_id
8159: , inventory_item_id
8160: , move_order_line_id
8161: FROM mtl_material_transactions_temp
8162: WHERE wms_task_type IS NOT NULL
8163: AND transaction_status = 2
8164: AND(
8165: wms_task_status IS NULL

Line 8243: FROM mtl_material_transactions_temp mmtt

8239: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
8240: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
8241: (
8242: SELECT NULL
8243: FROM mtl_material_transactions_temp mmtt
8244: WHERE mmtt.transaction_temp_id = wdtv.task_id
8245: AND mmtt.parent_line_id IS NOT NULL
8246: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
8247: AND NOT EXISTS -- exclude tasks already dispatched

Line 8329: FROM mtl_material_transactions_temp

8325: , pick_slip_number pick_slip_number
8326: , cartonization_id cartonization_id
8327: , inventory_item_id
8328: , move_order_line_id
8329: FROM mtl_material_transactions_temp
8330: WHERE wms_task_type IS NOT NULL
8331: AND transaction_status = 2
8332: AND Decode(transaction_source_type_id, 2, l_so_allowed,
8333: 8, l_io_allowed) = 1 -- filter out the request so or io

Line 8416: FROM mtl_material_transactions_temp

8412: , pick_slip_number pick_slip_number
8413: , cartonization_id cartonization_id
8414: , inventory_item_id
8415: , move_order_line_id
8416: FROM mtl_material_transactions_temp
8417: WHERE wms_task_type IS NOT NULL
8418: AND transaction_status = 2
8419: AND Decode(transaction_source_type_id, 2, l_so_allowed,
8420: 8, l_io_allowed) = 1 -- filter out the request so or io

Line 8484: FROM mtl_material_transactions_temp mmtt

8480: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
8481: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
8482: (
8483: SELECT NULL
8484: FROM mtl_material_transactions_temp mmtt
8485: WHERE mmtt.transaction_temp_id = wdtv.task_id
8486: AND mmtt.parent_line_id IS NOT NULL
8487: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
8488: AND NOT EXISTS -- exclude tasks already dispatched

Line 8573: FROM mtl_material_transactions_temp

8569: , pick_slip_number pick_slip_number
8570: , cartonization_id cartonization_id
8571: , inventory_item_id
8572: , move_order_line_id
8573: FROM mtl_material_transactions_temp
8574: WHERE wms_task_type IS NOT NULL
8575: AND transaction_status = 2
8576: AND(
8577: wms_task_status IS NULL

Line 8650: FROM mtl_material_transactions_temp

8646: , pick_slip_number pick_slip_number
8647: , cartonization_id cartonization_id
8648: , inventory_item_id
8649: , move_order_line_id
8650: FROM mtl_material_transactions_temp
8651: WHERE wms_task_type IS NOT NULL
8652: AND transaction_status = 2
8653: AND(
8654: wms_task_status IS NULL

Line 8712: FROM mtl_material_transactions_temp mmtt

8708: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
8709: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
8710: (
8711: SELECT NULL
8712: FROM mtl_material_transactions_temp mmtt
8713: WHERE mmtt.transaction_temp_id = wdtv.task_id
8714: AND mmtt.parent_line_id IS NOT NULL
8715: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
8716: AND NOT EXISTS -- exclude tasks already dispatched

Line 8801: FROM mtl_material_transactions_temp

8797: , pick_slip_number pick_slip_number
8798: , cartonization_id cartonization_id
8799: , inventory_item_id
8800: , move_order_line_id
8801: FROM mtl_material_transactions_temp
8802: WHERE wms_task_type IS NOT NULL
8803: AND transaction_status = 2
8804: AND Decode(transaction_source_type_id, 2, l_so_allowed,
8805: 8, l_io_allowed) = 1 -- filter out the request so or io

Line 8888: FROM mtl_material_transactions_temp

8884: , pick_slip_number pick_slip_number
8885: , cartonization_id cartonization_id
8886: , inventory_item_id
8887: , move_order_line_id
8888: FROM mtl_material_transactions_temp
8889: WHERE wms_task_type IS NOT NULL
8890: AND transaction_status = 2
8891: AND Decode(transaction_source_type_id, 2, l_so_allowed,
8892: 8, l_io_allowed) = 1 -- filter out the request so or io

Line 8956: FROM mtl_material_transactions_temp mmtt

8952: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
8953: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
8954: (
8955: SELECT NULL
8956: FROM mtl_material_transactions_temp mmtt
8957: WHERE mmtt.transaction_temp_id = wdtv.task_id
8958: AND mmtt.parent_line_id IS NOT NULL
8959: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
8960: AND NOT EXISTS -- exclude tasks already dispatched

Line 9035: FROM mtl_material_transactions_temp

9031: , pick_slip_number pick_slip_number
9032: , cartonization_id cartonization_id
9033: , inventory_item_id
9034: , move_order_line_id
9035: FROM mtl_material_transactions_temp
9036: WHERE wms_task_type IS NOT NULL
9037: AND transaction_status = 2
9038: AND(
9039: wms_task_status IS NULL

Line 9114: FROM mtl_material_transactions_temp

9110: , pick_slip_number pick_slip_number
9111: , cartonization_id cartonization_id
9112: , inventory_item_id
9113: , move_order_line_id
9114: FROM mtl_material_transactions_temp
9115: WHERE wms_task_type IS NOT NULL
9116: AND transaction_status = 2
9117: AND(
9118: wms_task_status IS NULL

Line 9176: FROM mtl_material_transactions_temp mmtt

9172: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
9173: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
9174: (
9175: SELECT NULL
9176: FROM mtl_material_transactions_temp mmtt
9177: WHERE mmtt.transaction_temp_id = wdtv.task_id
9178: AND mmtt.parent_line_id IS NOT NULL
9179: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
9180: AND NOT EXISTS -- exclude tasks already dispatched

Line 9265: FROM mtl_material_transactions_temp

9261: , pick_slip_number pick_slip_number
9262: , cartonization_id cartonization_id
9263: , inventory_item_id
9264: , move_order_line_id
9265: FROM mtl_material_transactions_temp
9266: WHERE wms_task_type IS NOT NULL
9267: AND transaction_status = 2
9268: AND Decode(transaction_source_type_id, 2, l_so_allowed,
9269: 8, l_io_allowed) = 1 -- filter out the request so or io

Line 9350: FROM mtl_material_transactions_temp

9346: , pick_slip_number pick_slip_number
9347: , cartonization_id cartonization_id
9348: , inventory_item_id
9349: , move_order_line_id
9350: FROM mtl_material_transactions_temp
9351: WHERE wms_task_type IS NOT NULL
9352: AND transaction_status = 2
9353: AND Decode(transaction_source_type_id, 2, l_so_allowed,
9354: 8, l_io_allowed) = 1 -- filter out the request so or io

Line 9416: FROM mtl_material_transactions_temp mmtt

9412: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
9413: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
9414: (
9415: SELECT NULL
9416: FROM mtl_material_transactions_temp mmtt
9417: WHERE mmtt.transaction_temp_id = wdtv.task_id
9418: AND mmtt.parent_line_id IS NOT NULL
9419: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
9420: AND NOT EXISTS -- exclude tasks already dispatched

Line 9504: FROM mtl_material_transactions_temp

9500: , pick_slip_number pick_slip_number
9501: , cartonization_id cartonization_id
9502: , inventory_item_id
9503: , move_order_line_id
9504: FROM mtl_material_transactions_temp
9505: WHERE wms_task_type IS NOT NULL
9506: AND transaction_status = 2
9507: AND(
9508: wms_task_status IS NULL

Line 9582: FROM mtl_material_transactions_temp

9578: , pick_slip_number pick_slip_number
9579: , cartonization_id cartonization_id
9580: , inventory_item_id
9581: , move_order_line_id
9582: FROM mtl_material_transactions_temp
9583: WHERE wms_task_type IS NOT NULL
9584: AND transaction_status = 2
9585: AND(
9586: wms_task_status IS NULL

Line 9643: FROM mtl_material_transactions_temp mmtt

9639: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
9640: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
9641: (
9642: SELECT NULL
9643: FROM mtl_material_transactions_temp mmtt
9644: WHERE mmtt.transaction_temp_id = wdtv.task_id
9645: AND mmtt.parent_line_id IS NOT NULL
9646: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
9647: AND NOT EXISTS -- exclude tasks already dispatched

Line 9729: FROM mtl_material_transactions_temp

9725: , pick_slip_number pick_slip_number
9726: , cartonization_id cartonization_id
9727: , inventory_item_id
9728: , move_order_line_id
9729: FROM mtl_material_transactions_temp
9730: WHERE wms_task_type IS NOT NULL
9731: AND transaction_status = 2
9732: AND Decode(transaction_source_type_id, 2, l_so_allowed,
9733: 8, l_io_allowed) = 1 -- filter out the request so or io

Line 9814: FROM mtl_material_transactions_temp

9810: , pick_slip_number pick_slip_number
9811: , cartonization_id cartonization_id
9812: , inventory_item_id
9813: , move_order_line_id
9814: FROM mtl_material_transactions_temp
9815: WHERE wms_task_type IS NOT NULL
9816: AND transaction_status = 2
9817: AND Decode(transaction_source_type_id, 2, l_so_allowed,
9818: 8, l_io_allowed) = 1 -- filter out the request so or io

Line 9881: FROM mtl_material_transactions_temp mmtt

9877: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
9878: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
9879: (
9880: SELECT NULL
9881: FROM mtl_material_transactions_temp mmtt
9882: WHERE mmtt.transaction_temp_id = wdtv.task_id
9883: AND mmtt.parent_line_id IS NOT NULL
9884: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
9885: AND NOT EXISTS -- exclude tasks already dispatched

Line 9960: FROM mtl_material_transactions_temp

9956: , pick_slip_number pick_slip_number
9957: , cartonization_id cartonization_id
9958: , inventory_item_id
9959: , move_order_line_id
9960: FROM mtl_material_transactions_temp
9961: WHERE wms_task_type IS NOT NULL
9962: AND transaction_status = 2
9963: AND(
9964: wms_task_status IS NULL

Line 10038: FROM mtl_material_transactions_temp

10034: , pick_slip_number pick_slip_number
10035: , cartonization_id cartonization_id
10036: , inventory_item_id
10037: , move_order_line_id
10038: FROM mtl_material_transactions_temp
10039: WHERE wms_task_type IS NOT NULL
10040: AND transaction_status = 2
10041: AND(
10042: wms_task_status IS NULL

Line 10099: FROM mtl_material_transactions_temp mmtt

10095: -- AND wdtv.inventory_item_id = msi.inventory_item_id -- bug 2648133
10096: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
10097: (
10098: SELECT NULL
10099: FROM mtl_material_transactions_temp mmtt
10100: WHERE mmtt.transaction_temp_id = wdtv.task_id
10101: AND mmtt.parent_line_id IS NOT NULL
10102: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
10103: AND NOT EXISTS -- exclude tasks already dispatched

Line 10727: FROM mtl_material_transactions_temp mmtt

10723: -- Test if this task is locked by any other user
10724: BEGIN
10725: SELECT mmtt.transaction_temp_id
10726: INTO t_opt_task_id(idx)
10727: FROM mtl_material_transactions_temp mmtt
10728: WHERE mmtt.transaction_temp_id = t_opt_task_id(idx)
10729: FOR UPDATE NOWAIT;
10730: EXCEPTION
10731: WHEN OTHERS THEN

Line 10806: FROM mtl_material_transactions_temp mmtt

10802: -- Test if this task is locked by any other user
10803: BEGIN
10804: SELECT mmtt.transaction_temp_id
10805: INTO t_opt_task_id(idx)
10806: FROM mtl_material_transactions_temp mmtt
10807: WHERE mmtt.transaction_temp_id = t_opt_task_id(idx)
10808: FOR UPDATE NOWAIT;
10809: EXCEPTION
10810: WHEN OTHERS THEN

Line 11004: FROM mtl_material_transactions_temp mmtt, wms_ordered_tasks wot

11000: wot.effective_end_date,
11001: wot.person_resource_id,
11002: wot.machine_resource_id,
11003: mmtt.move_order_line_id
11004: FROM mtl_material_transactions_temp mmtt, wms_ordered_tasks wot
11005: WHERE mmtt.wms_task_type IS NOT NULL
11006: AND mmtt.transaction_status = 2
11007: AND mmtt.transaction_temp_id = wot.task_id
11008: AND mmtt.transaction_temp_id > 0

Line 12803: FROM mtl_material_transactions_temp mmtt

12799: AND wdd.delivery_detail_id = wda.delivery_detail_id
12800: AND NVL(wda.delivery_id,mol.carton_grouping_id) = l_carton_grouping_id)
12801: AND wct.transaction_temp_id NOT IN ( -- added for bug 9309619 Vpedarla
12802: SELECT transaction_temp_id
12803: FROM mtl_material_transactions_temp mmtt
12804: WHERE mmtt.transaction_temp_id = wct.transaction_temp_id
12805: AND mmtt.allocated_lpn_id IS NOT NULL)
12806: AND wct.cartonization_id is NULL;--added for bug 9446937
12807: ELSE

Line 12827: FROM mtl_material_transactions_temp mmtt

12823: AND ((l_lot_allocated_flag = 'Y' AND EXISTS (SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP mtlt WHERE mtlt.transaction_temp_id=wct.transaction_temp_id))
12824: OR (l_lot_allocated_flag = 'N' AND NOT EXISTS (SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP mtlt WHERE mtlt.transaction_temp_id=wct.transaction_temp_id)))
12825: AND transaction_temp_id NOT IN ( -- added for bug 9309619 Vpedarla
12826: SELECT transaction_temp_id
12827: FROM mtl_material_transactions_temp mmtt
12828: WHERE mmtt.transaction_temp_id = wct.transaction_temp_id -- Modified for 14699845 (Flexible lot allocation)
12829: AND mmtt.allocated_lpn_id IS NOT NULL)
12830: AND cartonization_id is NULL;--added for bug 9446937
12831:

Line 12918: from mtl_system_items_b msi,mtl_material_transactions_temp mmtt

12914:
12915: -- to get the serial control code
12916: select serial_number_control_code,lot_control_code
12917: into l_serial_number_control_code,l_lot_control_code
12918: from mtl_system_items_b msi,mtl_material_transactions_temp mmtt
12919: where mmtt.transaction_temp_id = p_parent_transaction_temp_id
12920: and mmtt.inventory_item_id = msi.inventory_item_id
12921: and mmtt.organization_id = msi.organization_id;
12922:

Line 12955: FROM mtl_transaction_lots_temp mtlt,mtl_material_transactions_temp mmtt

12951: ,g_user_id
12952: ,SYSDATE
12953: ,g_user_id
12954: ,null
12955: FROM mtl_transaction_lots_temp mtlt,mtl_material_transactions_temp mmtt
12956: WHERE
12957: mtlt.transaction_temp_id = mmtt.transaction_temp_id
12958: and mmtt.parent_line_id = p_parent_transaction_temp_id -- child task
12959: and mmtt.transaction_temp_id <> p_parent_transaction_temp_id -- not parent task

Line 13015: l_task_rec_old_mmtt mtl_material_transactions_temp%ROWTYPE;

13011: l_eq_it_v_uom_ratio NUMBER := 1; -- conversion rate between equipment volume capacity and item unit volume UOM
13012: l_eq_it_w_uom_ratio NUMBER := 1; -- conversion rate between equipment weight capacity and item weight UOM
13013: l_task_rec_old_wct wms_cartonization_temp%ROWTYPE;
13014: l_task_rec_new_wct wms_cartonization_temp%ROWTYPE;
13015: l_task_rec_old_mmtt mtl_material_transactions_temp%ROWTYPE;
13016: l_task_rec_new_mmtt mtl_material_transactions_temp%ROWTYPE;
13017: l_child_rec_new mtl_material_transactions_temp%ROWTYPE;
13018: l_lot_split_rec inv_rcv_common_apis.trans_rec_tb_tp;
13019: l_min_cap NUMBER := -1; -- minimum equipment capacity for a task

Line 13016: l_task_rec_new_mmtt mtl_material_transactions_temp%ROWTYPE;

13012: l_eq_it_w_uom_ratio NUMBER := 1; -- conversion rate between equipment weight capacity and item weight UOM
13013: l_task_rec_old_wct wms_cartonization_temp%ROWTYPE;
13014: l_task_rec_new_wct wms_cartonization_temp%ROWTYPE;
13015: l_task_rec_old_mmtt mtl_material_transactions_temp%ROWTYPE;
13016: l_task_rec_new_mmtt mtl_material_transactions_temp%ROWTYPE;
13017: l_child_rec_new mtl_material_transactions_temp%ROWTYPE;
13018: l_lot_split_rec inv_rcv_common_apis.trans_rec_tb_tp;
13019: l_min_cap NUMBER := -1; -- minimum equipment capacity for a task
13020: l_min_cap_temp NUMBER;

Line 13017: l_child_rec_new mtl_material_transactions_temp%ROWTYPE;

13013: l_task_rec_old_wct wms_cartonization_temp%ROWTYPE;
13014: l_task_rec_new_wct wms_cartonization_temp%ROWTYPE;
13015: l_task_rec_old_mmtt mtl_material_transactions_temp%ROWTYPE;
13016: l_task_rec_new_mmtt mtl_material_transactions_temp%ROWTYPE;
13017: l_child_rec_new mtl_material_transactions_temp%ROWTYPE;
13018: l_lot_split_rec inv_rcv_common_apis.trans_rec_tb_tp;
13019: l_min_cap NUMBER := -1; -- minimum equipment capacity for a task
13020: l_min_cap_temp NUMBER;
13021: l_split_factor NUMBER; -- split task to this size

Line 13088: , mtl_material_transactions_temp mmtt

13084: , -- item volume UOM code
13085: item.weight_uom_code item_w_uom -- item weight UOM code
13086: FROM mtl_system_items equip
13087: , mtl_system_items item
13088: , mtl_material_transactions_temp mmtt
13089: , bom_resource_equipments res_equip
13090: , bom_resources res
13091: , bom_std_op_resources tt_x_res
13092: WHERE mmtt.transaction_temp_id = p_task_id -- the task in question

Line 13147: FROM mtl_material_transactions_temp

13143:
13144: -- get the mmtt rec too, will be used later on, the reason why both wct and mmtt are here is for branching
13145: SELECT *
13146: INTO l_task_rec_old_mmtt
13147: FROM mtl_material_transactions_temp
13148: WHERE transaction_temp_id = p_task_id;
13149:
13150: IF (l_task_rec_old_wct.parent_line_id is null) THEN -- not bulk task
13151: -- cache the move order header info first

Line 13665: update mtl_material_transactions_temp

13661: print_debug('l_child_total_qty '||l_child_total_qty,4);
13662: END IF;
13663: if l_child_total_qty <= l_new_qty then
13664: -- update the child records with the new parent line id
13665: update mtl_material_transactions_temp
13666: set parent_line_id = l_new_temp_id
13667: where transaction_Temp_id = l_child_rec.transaction_temp_id;
13668: l_child_remaining_qty := 0;
13669: -- if = which means fully satisfied the new parent, can exit

Line 13698: update mtl_material_transactions_temp

13694: END IF;
13695:
13696:
13697: -- update the child line with the remaining qty
13698: update mtl_material_transactions_temp
13699: set transaction_quantity = l_child_remaining_qty
13700: , primary_quantity = l_child_remaining_qty * l_txn_pri_uom_ratio
13701: , secondary_transaction_quantity = DECODE(l_ch_txn_sec_uom_ratio, NULL, NULL,0,NULL,Round((l_child_remaining_qty/l_ch_txn_sec_uom_ratio),5))
13702: where transaction_temp_id = l_child_rec.transaction_temp_id;

Line 13714: from mtl_material_transactions_temp

13710: l_progress := '140.1';
13711: select *
13712: into
13713: l_child_rec_new
13714: from mtl_material_transactions_temp
13715: where transaction_temp_id = l_child_rec.transaction_temp_id;
13716:
13717: /* Is it necessary to change transaction UOM to locator UOM here ???*/
13718: l_child_rec_new.transaction_temp_id := l_new_child_temp_id;

Line 13810: UPDATE mtl_material_transactions_temp

13806: -- the lot and serial info still need to be duplicated since consolidation didn't do it
13807: if G_CURRENT_RELEASE_LEVEL >= G_J_RELEASE_LEVEL AND
13808: l_move_order_type = G_MOVE_ORDER_PICK_WAVE THEN
13809: -- IF (l_debug = 1) THEN print_debug('PATCHSET J -- BULK PICKING --- START',4); END IF;
13810: UPDATE mtl_material_transactions_temp
13811: SET transaction_quantity = l_init_qty
13812: , primary_quantity = l_init_qty * l_txn_pri_uom_ratio
13813: , secondary_transaction_quantity = DECODE(l_txn_sec_uom_ratio, NULL, NULL,0,NULL,Round((l_init_qty/l_txn_sec_uom_ratio),5))
13814:

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

13898: print_debug('split_task: Other exception ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
13899: END IF;
13900: END split_task;
13901:
13902: PROCEDURE insert_mmtt(l_mmtt_rec mtl_material_transactions_temp%ROWTYPE) IS
13903: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
13904: BEGIN
13905: INSERT INTO mtl_material_transactions_temp
13906: (

Line 13905: INSERT INTO mtl_material_transactions_temp

13901:
13902: PROCEDURE insert_mmtt(l_mmtt_rec mtl_material_transactions_temp%ROWTYPE) IS
13903: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
13904: BEGIN
13905: INSERT INTO mtl_material_transactions_temp
13906: (
13907: transaction_header_id
13908: , transaction_temp_id
13909: , source_code

Line 14854: SELECT * FROM mtl_material_transactions_temp

14850: x_msg_data OUT NOCOPY VARCHAR2)
14851: IS
14852:
14853: CURSOR mmtt IS
14854: SELECT * FROM mtl_material_transactions_temp
14855: WHERE transaction_temp_id = p_transaction_temp_id ;
14856:
14857: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14858: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;

Line 14858: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;

14854: SELECT * FROM mtl_material_transactions_temp
14855: WHERE transaction_temp_id = p_transaction_temp_id ;
14856:
14857: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14858: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
14859: BEGIN
14860: x_return_status := fnd_api.g_ret_sts_success;
14861:
14862: OPEN mmtt;