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_TXN_REQUEST_LINES

Line 352: mtl_txn_request_lines mol,

348: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')
349: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
350: AND NVL(mcch.disable_date,sysdate+1)> sysdate
351: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
352: mtl_txn_request_lines mol,
353: mtl_secondary_inventories sub,
354: mtl_item_locations loc,
355: (SELECT
356: bsor.standard_operation_id,

Line 506: mtl_txn_request_lines mol,

502: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
503: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
504: mtl_item_locations loc,
505: mtl_secondary_inventories sub,
506: mtl_txn_request_lines mol,
507: mtl_txn_request_headers moh
508: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
509: AND wdtv.organization_id = p_sign_on_org_id
510: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 655: mtl_txn_request_lines mol,

651: and wdt1.status = 9
652: and mmtt1.cartonization_id = mmtt.cartonization_id)
653: )
654: ) qt,
655: mtl_txn_request_lines mol,
656: mtl_secondary_inventories sub,
657: mtl_item_locations loc,
658: (SELECT
659: bsor.standard_operation_id,

Line 733: mtl_txn_request_lines mol,

729: and wdt1.status = 9
730: and mmtt1.cartonization_id = mmtt.cartonization_id)
731: )
732: ) qt,
733: mtl_txn_request_lines mol,
734: mtl_secondary_inventories sub,
735: mtl_item_locations loc,
736: (SELECT
737: bsor.standard_operation_id,

Line 855: mtl_txn_request_lines mol,

851: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
852: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
853: mtl_item_locations loc,
854: mtl_secondary_inventories sub,
855: mtl_txn_request_lines mol,
856: mtl_txn_request_headers moh
857: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
858: AND wdtv.organization_id = p_sign_on_org_id
859: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 1260: mtl_txn_request_lines mol,

1256: AND mcch.organization_id = p_sign_on_org_id
1257: ---------------------------
1258: AND NVL(mcch.disable_date,sysdate+1)> sysdate
1259: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
1260: mtl_txn_request_lines mol,
1261: mtl_secondary_inventories sub,
1262: mtl_item_locations loc,
1263: (SELECT
1264: bsor.standard_operation_id,

Line 1413: mtl_txn_request_lines mol,

1409: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
1410: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
1411: mtl_item_locations loc,
1412: mtl_secondary_inventories sub,
1413: mtl_txn_request_lines mol,
1414: mtl_txn_request_headers moh
1415: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
1416: AND wdtv.organization_id = p_sign_on_org_id
1417: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 1562: mtl_txn_request_lines mol,

1558: and wdt1.status = 9
1559: and mmtt1.cartonization_id = mmtt.cartonization_id)
1560: )
1561: ) qt,
1562: mtl_txn_request_lines mol,
1563: mtl_secondary_inventories sub,
1564: mtl_item_locations loc,
1565: (SELECT
1566: bsor.standard_operation_id,

Line 1639: mtl_txn_request_lines mol,

1635: and wdt1.status = 9
1636: and mmtt1.cartonization_id = mmtt.cartonization_id)
1637: )
1638: ) qt,
1639: mtl_txn_request_lines mol,
1640: mtl_secondary_inventories sub,
1641: mtl_item_locations loc,
1642: (SELECT
1643: bsor.standard_operation_id,

Line 1760: mtl_txn_request_lines mol,

1756: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
1757: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
1758: mtl_item_locations loc,
1759: mtl_secondary_inventories sub,
1760: mtl_txn_request_lines mol,
1761: mtl_txn_request_headers moh
1762: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
1763: AND wdtv.organization_id = p_sign_on_org_id
1764: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 2188: mtl_txn_request_lines mol,

2184: ---------------------------
2185:
2186: AND NVL(mcch.disable_date,sysdate+1)> sysdate
2187: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
2188: mtl_txn_request_lines mol,
2189: mtl_secondary_inventories sub,
2190: mtl_item_locations loc,
2191: (SELECT
2192: bsor.standard_operation_id,

Line 2372: mtl_txn_request_lines mol,

2368: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
2369: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
2370: mtl_item_locations loc,
2371: mtl_secondary_inventories sub,
2372: mtl_txn_request_lines mol,
2373: mtl_txn_request_headers moh
2374: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
2375: AND ((wdtv.pick_slip_number = v_pick_slip_number AND p_task_method = 'DISCRETE')
2376: OR (p_task_method IN ('MANUAL', 'WAVE', 'BULK', 'DISCRETE')

Line 2533: mtl_txn_request_lines mol,

2529: and wdt1.status = 9
2530: and mmtt1.cartonization_id = mmtt.cartonization_id)
2531: )
2532: ) qt,
2533: mtl_txn_request_lines mol,
2534: mtl_secondary_inventories sub,
2535: mtl_item_locations loc,
2536: (SELECT
2537: bsor.standard_operation_id,

Line 2642: mtl_txn_request_lines mol,

2638: and wdt1.status = 9
2639: and mmtt1.cartonization_id = mmtt.cartonization_id)
2640: )
2641: ) qt,
2642: mtl_txn_request_lines mol,
2643: mtl_secondary_inventories sub,
2644: mtl_item_locations loc,
2645: (SELECT
2646: bsor.standard_operation_id,

Line 2793: mtl_txn_request_lines mol,

2789: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
2790: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
2791: mtl_item_locations loc,
2792: mtl_secondary_inventories sub,
2793: mtl_txn_request_lines mol,
2794: mtl_txn_request_headers moh
2795: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
2796: AND ((wdtv.pick_slip_number = v_pick_slip_number AND p_task_method = 'DISCRETE')
2797: OR (p_task_method IN ('MANUAL', 'WAVE', 'BULK', 'DISCRETE')

Line 4496: , mtl_txn_request_lines mol

4492: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
4493: , -- inlined wms_person_resource_utt_v, bug 2648133
4494: mtl_item_locations loc
4495: , mtl_secondary_inventories sub
4496: , mtl_txn_request_lines mol
4497: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
4498: AND wdtv.organization_id = p_sign_on_org_id
4499: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
4500: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 4650: , mtl_txn_request_lines mol

4646: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
4647: , -- inlined wms_person_resource_utt_v, bug 2648133
4648: mtl_item_locations loc
4649: , mtl_secondary_inventories sub
4650: , mtl_txn_request_lines mol
4651: -- mtl_system_items msi -- bug 2648133
4652: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
4653: AND wdtv.organization_id = p_sign_on_org_id
4654: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks

Line 4806: , mtl_txn_request_lines mol

4802: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
4803: , -- inlined wms_person_resource_utt_v, bug 2648133
4804: mtl_item_locations loc
4805: , mtl_secondary_inventories sub
4806: , mtl_txn_request_lines mol
4807: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
4808: AND wdtv.organization_id = p_sign_on_org_id
4809: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
4810: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 4959: , mtl_txn_request_lines mol

4955: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
4956: , -- inlined wms_person_resource_utt_v, bug 2648133
4957: mtl_item_locations loc
4958: , mtl_secondary_inventories sub
4959: , mtl_txn_request_lines mol
4960: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
4961: AND wdtv.organization_id = p_sign_on_org_id
4962: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
4963: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 5112: , mtl_txn_request_lines mol

5108: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
5109: , -- inlined wms_person_resource_utt_v, bug 2648133
5110: mtl_item_locations loc
5111: , mtl_secondary_inventories sub
5112: , mtl_txn_request_lines mol
5113: -- mtl_system_items msi -- bug 2648133
5114: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5115: AND wdtv.organization_id = p_sign_on_org_id
5116: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks

Line 5266: , mtl_txn_request_lines mol

5262: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
5263: , -- inlined wms_person_resource_utt_v, bug 2648133
5264: mtl_item_locations loc
5265: , mtl_secondary_inventories sub
5266: , mtl_txn_request_lines mol
5267: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5268: AND wdtv.organization_id = p_sign_on_org_id
5269: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
5270: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 5419: , mtl_txn_request_lines mol

5415: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
5416: , -- inlined wms_person_resource_utt_v, bug 2648133
5417: mtl_item_locations loc
5418: , mtl_secondary_inventories sub
5419: , mtl_txn_request_lines mol
5420: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5421: AND wdtv.organization_id = p_sign_on_org_id
5422: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
5423: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 5570: , mtl_txn_request_lines mol

5566: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
5567: , -- inlined wms_person_resource_utt_v, bug 2648133
5568: mtl_item_locations loc
5569: , mtl_secondary_inventories sub
5570: , mtl_txn_request_lines mol
5571: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5572: AND wdtv.organization_id = p_sign_on_org_id
5573: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
5574: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 5718: , mtl_txn_request_lines mol

5714: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
5715: , -- inlined wms_person_resource_utt_v, bug 2648133
5716: mtl_item_locations loc
5717: , mtl_secondary_inventories sub
5718: , mtl_txn_request_lines mol
5719: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5720: AND(wdtv.pick_slip_number = v_pick_slip_number
5721: OR(wdtv.task_id = v_task_id
5722: AND wdtv.wms_task_type_id = v_task_type))

Line 5869: , mtl_txn_request_lines mol

5865: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
5866: , -- inlined wms_person_resource_utt_v, bug 2648133
5867: mtl_item_locations loc
5868: , mtl_secondary_inventories sub
5869: , mtl_txn_request_lines mol
5870: -- mtl_system_items msi -- bug 2648133
5871: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5872: AND(wdtv.pick_slip_number = v_pick_slip_number
5873: OR(wdtv.task_id = v_task_id

Line 6020: , mtl_txn_request_lines mol

6016: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
6017: , -- inlined wms_person_resource_utt_v, bug 2648133
6018: mtl_item_locations loc
6019: , mtl_secondary_inventories sub
6020: , mtl_txn_request_lines mol
6021: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
6022: AND(wdtv.pick_slip_number = v_pick_slip_number
6023: OR(wdtv.task_id = v_task_id
6024: AND wdtv.wms_task_type_id = v_task_type))

Line 6170: , mtl_txn_request_lines mol

6166: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
6167: , -- inlined wms_person_resource_utt_v, bug 2648133
6168: mtl_item_locations loc
6169: , mtl_secondary_inventories sub
6170: , mtl_txn_request_lines mol
6171: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
6172: AND(wdtv.pick_slip_number = v_pick_slip_number
6173: OR(wdtv.task_id = v_task_id
6174: AND wdtv.wms_task_type_id = v_task_type))

Line 7401: , mtl_txn_request_lines mol

7397: , -- inlined wms_person_resource_utt_v, bug 2648133
7398: mtl_item_locations_kfv loc
7399: , --changed to kfv bug#2742611
7400: mtl_secondary_inventories sub
7401: , mtl_txn_request_lines mol
7402: , mtl_txn_request_headers moh
7403: , -- mtl_system_items msi -- bug 2648133
7404: wsh_delivery_details_ob_grp_v wdd
7405: , -- added

Line 7562: , mtl_txn_request_lines mol

7558: , -- inlined wms_person_resource_utt_v, bug 2648133
7559: mtl_item_locations_kfv loc
7560: , --changed to kfv bug#2742611
7561: mtl_secondary_inventories sub
7562: , mtl_txn_request_lines mol
7563: , mtl_txn_request_headers moh
7564: -- mtl_system_items msi -- bug 2648133
7565: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
7566: AND wdtv.organization_id = p_sign_on_org_id

Line 7722: , mtl_txn_request_lines mol

7718: , -- inlined wms_person_resource_utt_v, bug 2648133
7719: mtl_item_locations_kfv loc
7720: , --changed to kfv bug#2742611
7721: mtl_secondary_inventories sub
7722: , mtl_txn_request_lines mol
7723: , mtl_txn_request_headers moh
7724: , -- mtl_system_items msi -- bug 2648133
7725: wsh_delivery_details_ob_grp_v wdd
7726: , -- added

Line 7882: , mtl_txn_request_lines mol

7878: , -- inlined wms_person_resource_utt_v, bug 2648133
7879: mtl_item_locations_kfv loc
7880: , --changed to kfv bug#2742611
7881: mtl_secondary_inventories sub
7882: , mtl_txn_request_lines mol
7883: , mtl_txn_request_headers moh
7884: -- mtl_system_items msi -- bug 2648133
7885: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
7886: AND wdtv.organization_id = p_sign_on_org_id

Line 8011: , mtl_txn_request_lines mol

8007: AND bsor.resource_id = br.resource_id) e
8008: , mtl_item_locations_kfv loc
8009: , --changed to kfv bug#2742611
8010: mtl_secondary_inventories sub
8011: , mtl_txn_request_lines mol
8012: , mtl_txn_request_headers moh
8013: , -- mtl_system_items msi -- bug 2648133
8014: wsh_delivery_details_ob_grp_v wdd
8015: , -- added

Line 8118: , mtl_txn_request_lines mol

8114: , -- inlined wms_person_resource_utt_v, bug 2648133
8115: mtl_item_locations_kfv loc
8116: , --changed to kfv bug#2742611
8117: mtl_secondary_inventories sub
8118: , mtl_txn_request_lines mol
8119: , mtl_txn_request_headers moh
8120: , -- mtl_system_items msi -- bug 2648133
8121: wsh_delivery_details_ob_grp_v wdd
8122: , -- added

Line 8253: , mtl_txn_request_lines mol

8249: AND bsor.resource_id = br.resource_id) e
8250: , mtl_item_locations_kfv loc
8251: , --changed to kfv bug#2742611
8252: mtl_secondary_inventories sub
8253: , mtl_txn_request_lines mol
8254: , mtl_txn_request_headers moh
8255: -- mtl_system_items msi -- bug 2648133
8256: WHERE wdt.transaction_temp_id = wdtv.task_id
8257: AND wdt.status in ( 2,3) -- Queued and dispatched tasks only bug 4310093

Line 8350: , mtl_txn_request_lines mol

8346: , -- inlined wms_person_resource_utt_v, bug 2648133
8347: mtl_item_locations_kfv loc
8348: , --changed to kfv bug#2742611
8349: mtl_secondary_inventories sub
8350: , mtl_txn_request_lines mol
8351: , mtl_txn_request_headers moh
8352: -- mtl_system_items msi -- bug 2648133
8353: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
8354: AND wdtv.organization_id = p_sign_on_org_id

Line 8483: , mtl_txn_request_lines mol

8479: AND bsor.resource_id = br.resource_id) e
8480: , mtl_item_locations_kfv loc
8481: , --changed to kfv bug#2742611
8482: mtl_secondary_inventories sub
8483: , mtl_txn_request_lines mol
8484: , mtl_txn_request_headers moh
8485: , -- mtl_system_items msi -- bug 2648133
8486: wsh_delivery_details_ob_grp_v wdd
8487: , -- added

Line 8590: , mtl_txn_request_lines mol

8586: , -- inlined wms_person_resource_utt_v, bug 2648133
8587: mtl_item_locations_kfv loc
8588: , --changed to kfv bug#2742611
8589: mtl_secondary_inventories sub
8590: , mtl_txn_request_lines mol
8591: , mtl_txn_request_headers moh
8592: , -- mtl_system_items msi -- bug 2648133
8593: wsh_delivery_details_ob_grp_v wdd
8594: , -- added

Line 8715: , mtl_txn_request_lines mol

8711: AND bsor.resource_id = br.resource_id) e
8712: , mtl_item_locations_kfv loc
8713: , --changed to kfv bug#2742611
8714: mtl_secondary_inventories sub
8715: , mtl_txn_request_lines mol
8716: , mtl_txn_request_headers moh
8717: -- mtl_system_items msi -- bug 2648133
8718: WHERE wdt.transaction_temp_id = wdtv.task_id
8719: AND wdt.status = 2 -- Queued tasks only

Line 8814: , mtl_txn_request_lines mol

8810: , -- inlined wms_person_resource_utt_v, bug 2648133
8811: mtl_item_locations_kfv loc
8812: , --changed to kfv bug#2742611
8813: mtl_secondary_inventories sub
8814: , mtl_txn_request_lines mol
8815: , mtl_txn_request_headers moh
8816: -- mtl_system_items msi -- bug 2648133
8817: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
8818: AND wdtv.organization_id = p_sign_on_org_id

Line 8947: , mtl_txn_request_lines mol

8943: AND bsor.resource_id = br.resource_id) e
8944: , mtl_item_locations_kfv loc
8945: , --changed to kfv bug#2742611
8946: mtl_secondary_inventories sub
8947: , mtl_txn_request_lines mol
8948: , mtl_txn_request_headers moh
8949: , -- mtl_system_items msi -- bug 2648133
8950: wsh_delivery_details_ob_grp_v wdd
8951: , -- added

Line 9052: , mtl_txn_request_lines mol

9048: , -- inlined wms_person_resource_utt_v, bug 2648133
9049: mtl_item_locations_kfv loc
9050: , --changed to kfv bug#2742611
9051: mtl_secondary_inventories sub
9052: , mtl_txn_request_lines mol
9053: , mtl_txn_request_headers moh
9054: , -- mtl_system_items msi -- bug 2648133
9055: wsh_delivery_details_ob_grp_v wdd
9056: , -- added

Line 9184: , mtl_txn_request_lines mol

9180: AND bsor.resource_id = br.resource_id) e
9181: , mtl_item_locations_kfv loc
9182: , --changed to kfv bug#2742611
9183: mtl_secondary_inventories sub
9184: , mtl_txn_request_lines mol
9185: , mtl_txn_request_headers moh
9186: -- mtl_system_items msi -- bug 2648133
9187: WHERE wdt.transaction_temp_id = wdtv.task_id
9188: AND wdt.status in ( 2,3) -- Queued and dispatched tasks only bug 4310093

Line 9282: , mtl_txn_request_lines mol

9278: , -- inlined wms_person_resource_utt_v, bug 2648133
9279: mtl_item_locations_kfv loc
9280: , --changed to kfv bug#2742611
9281: mtl_secondary_inventories sub
9282: , mtl_txn_request_lines mol
9283: , mtl_txn_request_headers moh
9284: -- mtl_system_items msi -- bug 2648133
9285: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
9286: AND wdtv.organization_id = p_sign_on_org_id

Line 9411: , mtl_txn_request_lines mol

9407: AND bsor.resource_id = br.resource_id) e
9408: , mtl_item_locations_kfv loc
9409: , --changed to kfv bug#2742611
9410: mtl_secondary_inventories sub
9411: , mtl_txn_request_lines mol
9412: , mtl_txn_request_headers moh
9413: , -- mtl_system_items msi -- bug 2648133
9414: wsh_delivery_details_ob_grp_v wdd
9415: , -- added

Line 9516: , mtl_txn_request_lines mol

9512: , -- inlined wms_person_resource_utt_v, bug 2648133
9513: mtl_item_locations_kfv loc
9514: , --changed to kfv bug#2742611
9515: mtl_secondary_inventories sub
9516: , mtl_txn_request_lines mol
9517: , mtl_txn_request_headers moh
9518: , -- mtl_system_items msi -- bug 2648133
9519: wsh_delivery_details_ob_grp_v wdd
9520: , -- added

Line 9640: , mtl_txn_request_lines mol

9636: AND bsor.resource_id = br.resource_id) e
9637: , mtl_item_locations_kfv loc
9638: , --changed to kfv bug#2742611
9639: mtl_secondary_inventories sub
9640: , mtl_txn_request_lines mol
9641: , mtl_txn_request_headers moh
9642: -- mtl_system_items msi -- bug 2648133
9643: WHERE wdt.transaction_temp_id = wdtv.task_id
9644: AND wdt.status = 2 -- Queued tasks only

Line 9738: , mtl_txn_request_lines mol

9734: , -- inlined wms_person_resource_utt_v, bug 2648133
9735: mtl_item_locations_kfv loc
9736: , --changed to kfv bug#2742611
9737: mtl_secondary_inventories sub
9738: , mtl_txn_request_lines mol
9739: , mtl_txn_request_headers moh
9740: -- mtl_system_items msi -- bug 2648133
9741: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
9742: AND wdtv.organization_id = p_sign_on_org_id

Line 10757: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol

10753: l_move_order_type NUMBER;
10754:
10755: CURSOR task_list IS
10756: SELECT mmtt.transaction_temp_id
10757: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol
10758: WHERE mmtt.move_order_line_id = mol.line_id
10759: AND mol.header_id = p_move_order_header_id;
10760:
10761:

Line 11179: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol

11175: , mmtt.item_lot_control_code
11176: , mmtt.item_serial_control_code
11177: , mmtt.serial_allocated_flag
11178: -- Bug 4584538
11179: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol
11180: WHERE mmtt.move_order_line_id = mol.line_id
11181: AND mol.header_id = p_move_order_header_id
11182: AND mmtt.wms_task_type NOT IN(5, 6)
11183: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation

Line 11274: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol

11270: , mmtt.item_lot_control_code
11271: , mmtt.item_serial_control_code
11272: , mmtt.serial_allocated_flag
11273: -- Bug 4584538
11274: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol
11275: WHERE mmtt.move_order_line_id = mol.line_id
11276: AND mol.header_id = p_move_order_header_id
11277: AND mmtt.wms_task_type NOT IN(5, 6)
11278: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation

Line 11583: FROM mtl_txn_request_lines mol

11579: AND NVL(cost_group_id, -1) = NVL(l_cost_group_id, NVL(cost_group_id, -1))
11580: AND NVL(container_item_id, -1) = NVL(l_container_item_id, NVL(container_item_id, -1))
11581: AND NVL(cartonization_id, -1) = NVL(l_cartonization_id, NVL(cartonization_id, -1))
11582: AND EXISTS(SELECT 1
11583: FROM mtl_txn_request_lines mol
11584: WHERE mol.line_id = move_order_line_id
11585: AND mol.header_id = p_move_order_header_id
11586: AND NVL(mol.carton_grouping_id,-1) = NVL(l_carton_grouping_id,NVL(mol.carton_grouping_id,-1)));
11587:

Line 11707: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda

11703: , mmtt.item_primary_uom_code
11704: , mmtt.item_lot_control_code
11705: , mmtt.item_serial_control_code
11706: , mmtt.serial_allocated_flag
11707: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
11708: WHERE mmtt.move_order_line_id = mol.line_id
11709: -- AND mol.header_id = p_move_order_header_id -- no need since wct only have the records in concerns
11710: AND mol.line_id = wdd.move_ordeR_line_id
11711: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 11858: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol,

11854: , mmtt.item_primary_uom_code
11855: , mmtt.item_lot_control_code
11856: , mmtt.item_serial_control_code
11857: , mmtt.serial_allocated_flag
11858: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol,
11859: wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
11860: WHERE mmtt.move_order_line_id = mol.line_id
11861: AND ( mmtt.serial_allocated_flag = 'N' -- do not bulk serial allocated lines
11862: or mmtt.serial_allocated_flag is null)

Line 12297: FROM mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda

12293: AND NVL(transaction_action_id, -1) = NVL(l_transaction_action_id, NVL(transaction_action_id, -1))
12294: AND NVL(transaction_source_type_id, -1) = NVL(l_transaction_source_type_id, NVL(transaction_source_type_id, -1))
12295: AND NVL(cost_group_id, -1) = NVL(l_cost_group_id, NVL(cost_group_id, -1))
12296: AND EXISTS(SELECT 1
12297: FROM mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
12298: WHERE mol.line_id = wct.move_order_line_id
12299: AND mol.line_id = wdd.move_ordeR_line_id
12300: AND wdd.delivery_detail_id = wda.delivery_detail_id
12301: AND NVL(wda.delivery_id,mol.carton_grouping_id) = l_carton_grouping_id);

Line 12580: From wms_cartonization_temp mmtt,mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,

12576:
12577: -- A new cursor will be defined to find all the child tasks ordered by delivery
12578: Cursor c_child_tasks(p_parent_line_id NUMBER) is
12579: Select mmtt.transaction_temp_id,mmtt.transaction_quantity
12580: From wms_cartonization_temp mmtt,mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,
12581: wsh_delivery_assignments_v wda
12582: WHERE mmtt.parent_line_id = p_parent_line_id
12583: And mol.line_id = mmtt.move_order_line_id
12584: and mol.line_id = wdd.move_order_line_id