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 390: mtl_txn_request_lines mol,

386: AND mcce.organization_id = mcch.organization_id -- Bug 13796753
387: AND mcch.organization_id = p_sign_on_org_id -- Bug 13796753
388: AND NVL(mcch.disable_date,sysdate+1)> sysdate
389: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
390: mtl_txn_request_lines mol,
391: mtl_secondary_inventories sub,
392: mtl_item_locations loc,
393: (SELECT
394: bsor.standard_operation_id,

Line 544: mtl_txn_request_lines mol,

540: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
541: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
542: mtl_item_locations loc,
543: mtl_secondary_inventories sub,
544: mtl_txn_request_lines mol,
545: mtl_txn_request_headers moh
546: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
547: AND wdtv.organization_id = p_sign_on_org_id
548: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 693: mtl_txn_request_lines mol,

689: and wdt1.status = 9
690: and mmtt1.cartonization_id = mmtt.cartonization_id)
691: )
692: ) qt,
693: mtl_txn_request_lines mol,
694: mtl_secondary_inventories sub,
695: mtl_item_locations loc,
696: (SELECT
697: bsor.standard_operation_id,

Line 771: mtl_txn_request_lines mol,

767: and wdt1.status = 9
768: and mmtt1.cartonization_id = mmtt.cartonization_id)
769: )
770: ) qt,
771: mtl_txn_request_lines mol,
772: mtl_secondary_inventories sub,
773: mtl_item_locations loc,
774: (SELECT
775: bsor.standard_operation_id,

Line 893: mtl_txn_request_lines mol,

889: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
890: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
891: mtl_item_locations loc,
892: mtl_secondary_inventories sub,
893: mtl_txn_request_lines mol,
894: mtl_txn_request_headers moh
895: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
896: AND wdtv.organization_id = p_sign_on_org_id
897: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 1298: mtl_txn_request_lines mol,

1294: AND mcch.organization_id = p_sign_on_org_id
1295: ---------------------------
1296: AND NVL(mcch.disable_date,sysdate+1)> sysdate
1297: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
1298: mtl_txn_request_lines mol,
1299: mtl_secondary_inventories sub,
1300: mtl_item_locations loc,
1301: (SELECT
1302: bsor.standard_operation_id,

Line 1451: mtl_txn_request_lines mol,

1447: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
1448: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
1449: mtl_item_locations loc,
1450: mtl_secondary_inventories sub,
1451: mtl_txn_request_lines mol,
1452: mtl_txn_request_headers moh
1453: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
1454: AND wdtv.organization_id = p_sign_on_org_id
1455: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 1600: mtl_txn_request_lines mol,

1596: and wdt1.status = 9
1597: and mmtt1.cartonization_id = mmtt.cartonization_id)
1598: )
1599: ) qt,
1600: mtl_txn_request_lines mol,
1601: mtl_secondary_inventories sub,
1602: mtl_item_locations loc,
1603: (SELECT
1604: bsor.standard_operation_id,

Line 1677: mtl_txn_request_lines mol,

1673: and wdt1.status = 9
1674: and mmtt1.cartonization_id = mmtt.cartonization_id)
1675: )
1676: ) qt,
1677: mtl_txn_request_lines mol,
1678: mtl_secondary_inventories sub,
1679: mtl_item_locations loc,
1680: (SELECT
1681: bsor.standard_operation_id,

Line 1798: mtl_txn_request_lines mol,

1794: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
1795: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
1796: mtl_item_locations loc,
1797: mtl_secondary_inventories sub,
1798: mtl_txn_request_lines mol,
1799: mtl_txn_request_headers moh
1800: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
1801: AND wdtv.organization_id = p_sign_on_org_id
1802: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 2230: mtl_txn_request_lines mol,

2226: ---------------------------
2227:
2228: AND NVL(mcch.disable_date,sysdate+1)> sysdate
2229: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
2230: mtl_txn_request_lines mol,
2231: mtl_secondary_inventories sub,
2232: mtl_item_locations loc,
2233: (SELECT
2234: bsor.standard_operation_id,

Line 2435: mtl_txn_request_lines mol,

2431: AND NVL(utt_eqp.inventory_item_id, -999) = NVL(l_sign_on_equipment_id, NVL(utt_eqp.inventory_item_id, -999)) --Modified for Case Picking Project + Picking ER (FP 7709357)
2432: GROUP BY utt_emp.standard_operation_id, utt_emp.person_id, utt_emp.effective_start_date, utt_emp.effective_end_date) v,
2433: mtl_item_locations loc,
2434: mtl_secondary_inventories sub,
2435: mtl_txn_request_lines mol,
2436: mtl_txn_request_headers moh
2437: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
2438: AND ((wdtv.pick_slip_number = v_pick_slip_number AND p_task_method = 'DISCRETE')
2439: OR (p_task_method IN ('MANUAL', 'WAVE', 'BULK', 'DISCRETE')

Line 2626: mtl_txn_request_lines mol,

2622: and wdt1.status = 9
2623: and mmtt1.cartonization_id = mmtt.cartonization_id)
2624: )
2625: ) qt,
2626: mtl_txn_request_lines mol,
2627: mtl_secondary_inventories sub,
2628: mtl_item_locations loc,
2629: (SELECT
2630: bsor.standard_operation_id,

Line 2753: mtl_txn_request_lines mol,

2749: and wdt1.status = 9
2750: and mmtt1.cartonization_id = mmtt.cartonization_id)
2751: )
2752: ) qt,
2753: mtl_txn_request_lines mol,
2754: mtl_secondary_inventories sub,
2755: mtl_item_locations loc,
2756: (SELECT
2757: bsor.standard_operation_id,

Line 2924: mtl_txn_request_lines mol,

2920: AND NVL(utt_eqp.inventory_item_id, -999) = NVL(l_sign_on_equipment_id, NVL(utt_eqp.inventory_item_id, -999)) --Modified for Case Picking Project + Picking ER (FP 7709357)
2921: GROUP BY utt_emp.standard_operation_id, utt_emp.person_id, utt_emp.effective_start_date, utt_emp.effective_end_date) v,
2922: mtl_item_locations loc,
2923: mtl_secondary_inventories sub,
2924: mtl_txn_request_lines mol,
2925: mtl_txn_request_headers moh
2926: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
2927: AND ((wdtv.pick_slip_number = v_pick_slip_number AND p_task_method = 'DISCRETE')
2928: OR (p_task_method IN ('MANUAL', 'WAVE', 'BULK', 'DISCRETE')

Line 4835: , mtl_txn_request_lines mol

4831: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
4832: , -- inlined wms_person_resource_utt_v, bug 2648133
4833: mtl_item_locations loc
4834: , mtl_secondary_inventories sub
4835: , mtl_txn_request_lines mol
4836: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
4837: AND wdtv.organization_id = p_sign_on_org_id
4838: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
4839: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 4989: , mtl_txn_request_lines mol

4985: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
4986: , -- inlined wms_person_resource_utt_v, bug 2648133
4987: mtl_item_locations loc
4988: , mtl_secondary_inventories sub
4989: , mtl_txn_request_lines mol
4990: -- mtl_system_items msi -- bug 2648133
4991: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
4992: AND wdtv.organization_id = p_sign_on_org_id
4993: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks

Line 5145: , mtl_txn_request_lines mol

5141: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
5142: , -- inlined wms_person_resource_utt_v, bug 2648133
5143: mtl_item_locations loc
5144: , mtl_secondary_inventories sub
5145: , mtl_txn_request_lines mol
5146: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5147: AND wdtv.organization_id = p_sign_on_org_id
5148: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
5149: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 5298: , mtl_txn_request_lines mol

5294: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
5295: , -- inlined wms_person_resource_utt_v, bug 2648133
5296: mtl_item_locations loc
5297: , mtl_secondary_inventories sub
5298: , mtl_txn_request_lines mol
5299: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5300: AND wdtv.organization_id = p_sign_on_org_id
5301: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
5302: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 5451: , mtl_txn_request_lines mol

5447: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
5448: , -- inlined wms_person_resource_utt_v, bug 2648133
5449: mtl_item_locations loc
5450: , mtl_secondary_inventories sub
5451: , mtl_txn_request_lines mol
5452: -- mtl_system_items msi -- bug 2648133
5453: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5454: AND wdtv.organization_id = p_sign_on_org_id
5455: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks

Line 5605: , mtl_txn_request_lines mol

5601: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
5602: , -- inlined wms_person_resource_utt_v, bug 2648133
5603: mtl_item_locations loc
5604: , mtl_secondary_inventories sub
5605: , mtl_txn_request_lines mol
5606: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5607: AND wdtv.organization_id = p_sign_on_org_id
5608: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
5609: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 5758: , mtl_txn_request_lines mol

5754: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
5755: , -- inlined wms_person_resource_utt_v, bug 2648133
5756: mtl_item_locations loc
5757: , mtl_secondary_inventories sub
5758: , mtl_txn_request_lines mol
5759: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5760: AND wdtv.organization_id = p_sign_on_org_id
5761: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
5762: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 5909: , mtl_txn_request_lines mol

5905: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
5906: , -- inlined wms_person_resource_utt_v, bug 2648133
5907: mtl_item_locations loc
5908: , mtl_secondary_inventories sub
5909: , mtl_txn_request_lines mol
5910: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
5911: AND wdtv.organization_id = p_sign_on_org_id
5912: AND wdtv.wms_task_type_id = NVL(l_sys_task_type, wdtv.wms_task_type_id) -- restrict to picking tasks or all tasks
5913: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 6057: , mtl_txn_request_lines mol

6053: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
6054: , -- inlined wms_person_resource_utt_v, bug 2648133
6055: mtl_item_locations loc
6056: , mtl_secondary_inventories sub
6057: , mtl_txn_request_lines mol
6058: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
6059: AND(wdtv.pick_slip_number = v_pick_slip_number
6060: OR(wdtv.task_id = v_task_id
6061: AND wdtv.wms_task_type_id = v_task_type))

Line 6208: , mtl_txn_request_lines mol

6204: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
6205: , -- inlined wms_person_resource_utt_v, bug 2648133
6206: mtl_item_locations loc
6207: , mtl_secondary_inventories sub
6208: , mtl_txn_request_lines mol
6209: -- mtl_system_items msi -- bug 2648133
6210: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
6211: AND(wdtv.pick_slip_number = v_pick_slip_number
6212: OR(wdtv.task_id = v_task_id

Line 6359: , mtl_txn_request_lines mol

6355: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
6356: , -- inlined wms_person_resource_utt_v, bug 2648133
6357: mtl_item_locations loc
6358: , mtl_secondary_inventories sub
6359: , mtl_txn_request_lines mol
6360: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
6361: AND(wdtv.pick_slip_number = v_pick_slip_number
6362: OR(wdtv.task_id = v_task_id
6363: AND wdtv.wms_task_type_id = v_task_type))

Line 6509: , mtl_txn_request_lines mol

6505: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
6506: , -- inlined wms_person_resource_utt_v, bug 2648133
6507: mtl_item_locations loc
6508: , mtl_secondary_inventories sub
6509: , mtl_txn_request_lines mol
6510: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
6511: AND(wdtv.pick_slip_number = v_pick_slip_number
6512: OR(wdtv.task_id = v_task_id
6513: AND wdtv.wms_task_type_id = v_task_type))

Line 7740: , mtl_txn_request_lines mol

7736: , -- inlined wms_person_resource_utt_v, bug 2648133
7737: mtl_item_locations_kfv loc
7738: , --changed to kfv bug#2742611
7739: mtl_secondary_inventories sub
7740: , mtl_txn_request_lines mol
7741: , mtl_txn_request_headers moh
7742: , -- mtl_system_items msi -- bug 2648133
7743: wsh_delivery_details_ob_grp_v wdd
7744: , -- added

Line 7901: , mtl_txn_request_lines mol

7897: , -- inlined wms_person_resource_utt_v, bug 2648133
7898: mtl_item_locations_kfv loc
7899: , --changed to kfv bug#2742611
7900: mtl_secondary_inventories sub
7901: , mtl_txn_request_lines mol
7902: , mtl_txn_request_headers moh
7903: -- mtl_system_items msi -- bug 2648133
7904: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
7905: AND wdtv.organization_id = p_sign_on_org_id

Line 8061: , mtl_txn_request_lines mol

8057: , -- inlined wms_person_resource_utt_v, bug 2648133
8058: mtl_item_locations_kfv loc
8059: , --changed to kfv bug#2742611
8060: mtl_secondary_inventories sub
8061: , mtl_txn_request_lines mol
8062: , mtl_txn_request_headers moh
8063: , -- mtl_system_items msi -- bug 2648133
8064: wsh_delivery_details_ob_grp_v wdd
8065: , -- added

Line 8221: , mtl_txn_request_lines mol

8217: , -- inlined wms_person_resource_utt_v, bug 2648133
8218: mtl_item_locations_kfv loc
8219: , --changed to kfv bug#2742611
8220: mtl_secondary_inventories sub
8221: , mtl_txn_request_lines mol
8222: , mtl_txn_request_headers moh
8223: -- mtl_system_items msi -- bug 2648133
8224: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
8225: AND wdtv.organization_id = p_sign_on_org_id

Line 8350: , mtl_txn_request_lines mol

8346: AND bsor.resource_id = br.resource_id) e
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: wsh_delivery_details_ob_grp_v wdd
8354: , -- added

Line 8457: , mtl_txn_request_lines mol

8453: , -- inlined wms_person_resource_utt_v, bug 2648133
8454: mtl_item_locations_kfv loc
8455: , --changed to kfv bug#2742611
8456: mtl_secondary_inventories sub
8457: , mtl_txn_request_lines mol
8458: , mtl_txn_request_headers moh
8459: , -- mtl_system_items msi -- bug 2648133
8460: wsh_delivery_details_ob_grp_v wdd
8461: , -- added

Line 8592: , mtl_txn_request_lines mol

8588: AND bsor.resource_id = br.resource_id) e
8589: , mtl_item_locations_kfv loc
8590: , --changed to kfv bug#2742611
8591: mtl_secondary_inventories sub
8592: , mtl_txn_request_lines mol
8593: , mtl_txn_request_headers moh
8594: -- mtl_system_items msi -- bug 2648133
8595: WHERE wdt.transaction_temp_id = wdtv.task_id
8596: AND wdt.status in ( 2,3) -- Queued and dispatched tasks only bug 4310093

Line 8689: , mtl_txn_request_lines mol

8685: , -- inlined wms_person_resource_utt_v, bug 2648133
8686: mtl_item_locations_kfv loc
8687: , --changed to kfv bug#2742611
8688: mtl_secondary_inventories sub
8689: , mtl_txn_request_lines mol
8690: , mtl_txn_request_headers moh
8691: -- mtl_system_items msi -- bug 2648133
8692: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
8693: AND wdtv.organization_id = p_sign_on_org_id

Line 8822: , mtl_txn_request_lines mol

8818: AND bsor.resource_id = br.resource_id) e
8819: , mtl_item_locations_kfv loc
8820: , --changed to kfv bug#2742611
8821: mtl_secondary_inventories sub
8822: , mtl_txn_request_lines mol
8823: , mtl_txn_request_headers moh
8824: , -- mtl_system_items msi -- bug 2648133
8825: wsh_delivery_details_ob_grp_v wdd
8826: , -- added

Line 8929: , mtl_txn_request_lines mol

8925: , -- inlined wms_person_resource_utt_v, bug 2648133
8926: mtl_item_locations_kfv loc
8927: , --changed to kfv bug#2742611
8928: mtl_secondary_inventories sub
8929: , mtl_txn_request_lines mol
8930: , mtl_txn_request_headers moh
8931: , -- mtl_system_items msi -- bug 2648133
8932: wsh_delivery_details_ob_grp_v wdd
8933: , -- added

Line 9054: , mtl_txn_request_lines mol

9050: AND bsor.resource_id = br.resource_id) e
9051: , mtl_item_locations_kfv loc
9052: , --changed to kfv bug#2742611
9053: mtl_secondary_inventories sub
9054: , mtl_txn_request_lines mol
9055: , mtl_txn_request_headers moh
9056: -- mtl_system_items msi -- bug 2648133
9057: WHERE wdt.transaction_temp_id = wdtv.task_id
9058: AND wdt.status = 2 -- Queued tasks only

Line 9153: , mtl_txn_request_lines mol

9149: , -- inlined wms_person_resource_utt_v, bug 2648133
9150: mtl_item_locations_kfv loc
9151: , --changed to kfv bug#2742611
9152: mtl_secondary_inventories sub
9153: , mtl_txn_request_lines mol
9154: , mtl_txn_request_headers moh
9155: -- mtl_system_items msi -- bug 2648133
9156: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
9157: AND wdtv.organization_id = p_sign_on_org_id

Line 9286: , mtl_txn_request_lines mol

9282: AND bsor.resource_id = br.resource_id) e
9283: , mtl_item_locations_kfv loc
9284: , --changed to kfv bug#2742611
9285: mtl_secondary_inventories sub
9286: , mtl_txn_request_lines mol
9287: , mtl_txn_request_headers moh
9288: , -- mtl_system_items msi -- bug 2648133
9289: wsh_delivery_details_ob_grp_v wdd
9290: , -- added

Line 9391: , mtl_txn_request_lines mol

9387: , -- inlined wms_person_resource_utt_v, bug 2648133
9388: mtl_item_locations_kfv loc
9389: , --changed to kfv bug#2742611
9390: mtl_secondary_inventories sub
9391: , mtl_txn_request_lines mol
9392: , mtl_txn_request_headers moh
9393: , -- mtl_system_items msi -- bug 2648133
9394: wsh_delivery_details_ob_grp_v wdd
9395: , -- added

Line 9523: , mtl_txn_request_lines mol

9519: AND bsor.resource_id = br.resource_id) e
9520: , mtl_item_locations_kfv loc
9521: , --changed to kfv bug#2742611
9522: mtl_secondary_inventories sub
9523: , mtl_txn_request_lines mol
9524: , mtl_txn_request_headers moh
9525: -- mtl_system_items msi -- bug 2648133
9526: WHERE wdt.transaction_temp_id = wdtv.task_id
9527: AND wdt.status in ( 2,3) -- Queued and dispatched tasks only bug 4310093

Line 9621: , mtl_txn_request_lines mol

9617: , -- inlined wms_person_resource_utt_v, bug 2648133
9618: mtl_item_locations_kfv loc
9619: , --changed to kfv bug#2742611
9620: mtl_secondary_inventories sub
9621: , mtl_txn_request_lines mol
9622: , mtl_txn_request_headers moh
9623: -- mtl_system_items msi -- bug 2648133
9624: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
9625: AND wdtv.organization_id = p_sign_on_org_id

Line 9750: , mtl_txn_request_lines mol

9746: AND bsor.resource_id = br.resource_id) e
9747: , mtl_item_locations_kfv loc
9748: , --changed to kfv bug#2742611
9749: mtl_secondary_inventories sub
9750: , mtl_txn_request_lines mol
9751: , mtl_txn_request_headers moh
9752: , -- mtl_system_items msi -- bug 2648133
9753: wsh_delivery_details_ob_grp_v wdd
9754: , -- added

Line 9855: , mtl_txn_request_lines mol

9851: , -- inlined wms_person_resource_utt_v, bug 2648133
9852: mtl_item_locations_kfv loc
9853: , --changed to kfv bug#2742611
9854: mtl_secondary_inventories sub
9855: , mtl_txn_request_lines mol
9856: , mtl_txn_request_headers moh
9857: , -- mtl_system_items msi -- bug 2648133
9858: wsh_delivery_details_ob_grp_v wdd
9859: , -- added

Line 9979: , mtl_txn_request_lines mol

9975: AND bsor.resource_id = br.resource_id) e
9976: , mtl_item_locations_kfv loc
9977: , --changed to kfv bug#2742611
9978: mtl_secondary_inventories sub
9979: , mtl_txn_request_lines mol
9980: , mtl_txn_request_headers moh
9981: -- mtl_system_items msi -- bug 2648133
9982: WHERE wdt.transaction_temp_id = wdtv.task_id
9983: AND wdt.status = 2 -- Queued tasks only

Line 10077: , mtl_txn_request_lines mol

10073: , -- inlined wms_person_resource_utt_v, bug 2648133
10074: mtl_item_locations_kfv loc
10075: , --changed to kfv bug#2742611
10076: mtl_secondary_inventories sub
10077: , mtl_txn_request_lines mol
10078: , mtl_txn_request_headers moh
10079: -- mtl_system_items msi -- bug 2648133
10080: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
10081: AND wdtv.organization_id = p_sign_on_org_id

Line 11096: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol

11092: l_move_order_type NUMBER;
11093:
11094: CURSOR task_list IS
11095: SELECT mmtt.transaction_temp_id
11096: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol
11097: WHERE mmtt.move_order_line_id = mol.line_id
11098: AND mol.header_id = p_move_order_header_id;
11099:
11100:

Line 11594: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol

11590: , mmtt.item_lot_control_code
11591: , mmtt.item_serial_control_code
11592: , mmtt.serial_allocated_flag
11593: -- Bug 4584538
11594: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol
11595: WHERE mmtt.move_order_line_id = mol.line_id
11596: AND mol.header_id = p_move_order_header_id
11597: AND mmtt.wms_task_type NOT IN(5, 6)
11598: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation

Line 11694: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol

11690: , mmtt.item_lot_control_code
11691: , mmtt.item_serial_control_code
11692: , mmtt.serial_allocated_flag
11693: -- Bug 4584538
11694: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol
11695: WHERE mmtt.move_order_line_id = mol.line_id
11696: AND mol.header_id = p_move_order_header_id
11697: AND mmtt.wms_task_type NOT IN(5, 6)
11698: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation

Line 12014: FROM mtl_txn_request_lines mol

12010: AND NVL(cost_group_id, -1) = NVL(l_cost_group_id, NVL(cost_group_id, -1))
12011: AND NVL(container_item_id, -1) = NVL(l_container_item_id, NVL(container_item_id, -1))
12012: AND NVL(cartonization_id, -1) = NVL(l_cartonization_id, NVL(cartonization_id, -1))
12013: AND EXISTS(SELECT 1
12014: FROM mtl_txn_request_lines mol
12015: WHERE mol.line_id = move_order_line_id
12016: AND mol.header_id = p_move_order_header_id
12017: AND NVL(mol.carton_grouping_id,-1) = NVL(l_carton_grouping_id,NVL(mol.carton_grouping_id,-1)));
12018:

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

12138: , mmtt.item_lot_control_code
12139: , mmtt.item_serial_control_code
12140: , mmtt.serial_allocated_flag
12141: , Decode(Nvl(mmtt.lot_number, mtlt.LOT_NUMBER), NULL, 'N', 'Y') lot_allocated_flag -- Added for 14699845 (Flexible lot allocation)
12142: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
12143: , MTL_TRANSACTION_LOTS_TEMP mtlt -- Added for 14699845 (Flexible lot allocation)
12144: WHERE mmtt.move_order_line_id = mol.line_id
12145: -- AND mol.header_id = p_move_order_header_id -- no need since wct only have the records in concerns
12146: AND mol.line_id = wdd.move_ordeR_line_id

Line 12311: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol,

12307: , mmtt.item_lot_control_code
12308: , mmtt.item_serial_control_code
12309: , mmtt.serial_allocated_flag
12310: , Decode(Nvl(mmtt.lot_number, mtlt.LOT_NUMBER), NULL, 'N', 'Y') lot_allocated_flag -- Added for 14699845 (Flexible lot allocation)
12311: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol,
12312: wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
12313: , MTL_TRANSACTION_LOTS_TEMP mtlt -- Added for 14699845 (Flexible lot allocation)
12314: WHERE mmtt.move_order_line_id = mol.line_id
12315: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id (+) -- Added for 14699845 (Flexible lot allocation)

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

12792: -- Added for 14699845 (Flexible lot allocation)
12793: 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))
12794: 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)))
12795: AND EXISTS(SELECT 1
12796: FROM mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
12797: WHERE mol.line_id = wct.move_order_line_id
12798: AND mol.line_id = wdd.move_ordeR_line_id
12799: AND wdd.delivery_detail_id = wda.delivery_detail_id
12800: AND NVL(wda.delivery_id,mol.carton_grouping_id) = l_carton_grouping_id)

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

13101:
13102: -- A new cursor will be defined to find all the child tasks ordered by delivery
13103: Cursor c_child_tasks(p_parent_line_id NUMBER) is
13104: Select mmtt.transaction_temp_id,mmtt.transaction_quantity,mmtt.secondary_transaction_quantity,mmtt.primary_quantity
13105: From wms_cartonization_temp mmtt,mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,
13106: wsh_delivery_assignments_v wda
13107: WHERE mmtt.parent_line_id = p_parent_line_id
13108: And mol.line_id = mmtt.move_order_line_id
13109: and mol.line_id = wdd.move_order_line_id