DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_ENGINE dependencies on MTL_ITEM_LOCATIONS

Line 392: mtl_item_locations loc,

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,
395: bre.resource_id,
396: bre.inventory_item_id equipment_id

Line 542: mtl_item_locations loc,

538: WHERE x_utt_res2.resource_id = r2.resource_id
539: AND r2.resource_type = 1
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

Line 695: mtl_item_locations loc,

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,
698: bre.resource_id,
699: bre.inventory_item_id equipment_id

Line 773: mtl_item_locations loc,

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,
776: bre.resource_id,
777: bre.inventory_item_id equipment_id

Line 891: mtl_item_locations loc,

887: WHERE x_utt_res2.resource_id = r2.resource_id
888: AND r2.resource_type = 1
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

Line 1036: mtl_item_locations loc,

1032:
1033: AND NVL(mcch.disable_date,sysdate+1)> sysdate
1034: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
1035: mtl_secondary_inventories sub,
1036: mtl_item_locations loc,
1037: (SELECT
1038: bsor.standard_operation_id,
1039: bre.resource_id,
1040: bre.inventory_item_id equipment_id

Line 1137: mtl_item_locations loc,

1133: WHERE x_utt_res2.resource_id = r2.resource_id
1134: AND r2.resource_type = 1
1135: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
1136: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
1137: mtl_item_locations loc,
1138: mtl_secondary_inventories sub
1139: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
1140: AND wdtv.organization_id = p_sign_on_org_id
1141: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 1300: mtl_item_locations loc,

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,
1303: bre.resource_id,
1304: bre.inventory_item_id equipment_id

Line 1449: mtl_item_locations loc,

1445: WHERE x_utt_res2.resource_id = r2.resource_id
1446: AND r2.resource_type = 1
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

Line 1602: mtl_item_locations loc,

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,
1605: bre.resource_id,
1606: bre.inventory_item_id equipment_id

Line 1679: mtl_item_locations loc,

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,
1682: bre.resource_id,
1683: bre.inventory_item_id equipment_id

Line 1796: mtl_item_locations loc,

1792: WHERE x_utt_res2.resource_id = r2.resource_id
1793: AND r2.resource_type = 1
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

Line 1935: mtl_item_locations loc,

1931: AND mcch.organization_id = p_sign_on_org_id -- Bug 13796753
1932: AND NVL(mcch.disable_date,sysdate+1)> sysdate
1933: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
1934: mtl_secondary_inventories sub,
1935: mtl_item_locations loc,
1936: (SELECT
1937: bsor.standard_operation_id,
1938: bre.resource_id,
1939: bre.inventory_item_id equipment_id

Line 2036: mtl_item_locations loc,

2032: WHERE x_utt_res2.resource_id = r2.resource_id
2033: AND r2.resource_type = 1
2034: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
2035: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
2036: mtl_item_locations loc,
2037: mtl_secondary_inventories sub
2038: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
2039: AND wdtv.organization_id = p_sign_on_org_id
2040: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match

Line 2232: mtl_item_locations loc,

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,
2235: bre.resource_id,
2236: bre.inventory_item_id equipment_id

Line 2433: mtl_item_locations loc,

2429: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
2430: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)
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

Line 2628: mtl_item_locations loc,

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,
2631: bre.resource_id,
2632: bre.inventory_item_id equipment_id

Line 2755: mtl_item_locations loc,

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,
2758: bre.resource_id,
2759: bre.inventory_item_id equipment_id

Line 2922: mtl_item_locations loc,

2918: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
2919: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)
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

Line 3104: mtl_item_locations loc,

3100:
3101: AND NVL(mcch.disable_date,sysdate+1)> sysdate
3102: GROUP BY mcce.cycle_count_header_id, mcce.organization_id, mcce.subinventory, mcce.locator_id, mcce.inventory_item_id, mcce.revision) qt,
3103: mtl_secondary_inventories sub,
3104: mtl_item_locations loc,
3105: (SELECT
3106: bsor.standard_operation_id,
3107: bre.resource_id,
3108: bre.inventory_item_id equipment_id

Line 3225: mtl_item_locations loc,

3221: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
3222: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)
3223: 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)
3224: GROUP BY utt_emp.standard_operation_id, utt_emp.person_id, utt_emp.effective_start_date, utt_emp.effective_end_date) v,
3225: mtl_item_locations loc,
3226: mtl_secondary_inventories sub
3227: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
3228: AND (wdtv.task_id = v_task_id AND wdtv.wms_task_type_id = v_task_type)
3229: AND wdtv.organization_id = p_sign_on_org_id

Line 3562: FROM mtl_item_locations loc,

3558:
3559: -- use Nvl to make sure if coordinates not defined, use 0
3560: SELECT NVL(loc.x_coordinate, 0), NVL(loc.y_coordinate, 0), NVL(loc.z_coordinate, 0)
3561: INTO l_cur_x, l_cur_y, l_cur_z
3562: FROM mtl_item_locations loc,
3563: (SELECT
3564: transaction_temp_id task_id,
3565: standard_operation_id user_task_type_id,
3566: wms_task_type wms_task_type_id,

Line 3637: FROM mtl_item_locations loc, mtl_material_transactions mmt

3633: , NVL(loc.z_coordinate, 0)
3634: INTO l_cur_x
3635: , l_cur_y
3636: , l_cur_z
3637: FROM mtl_item_locations loc, mtl_material_transactions mmt
3638: WHERE mmt.locator_id = loc.inventory_location_id
3639: AND mmt.organization_id = loc.organization_id
3640: AND mmt.transaction_set_id = l_last_task_id
3641: AND ROWNUM = 1;

Line 3663: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce

3659: , NVL(loc.z_coordinate, 0)
3660: INTO l_cur_x
3661: , l_cur_y
3662: , l_cur_z
3663: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce
3664: WHERE mcce.locator_id = loc.inventory_location_id
3665: AND mcce.organization_id = loc.organization_id
3666: AND mcce.cycle_count_entry_id = l_last_task_id;
3667:

Line 4833: mtl_item_locations loc

4829: AND r2.resource_type = 1
4830: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
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

Line 4987: mtl_item_locations loc

4983: AND r2.resource_type = 1
4984: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
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

Line 5143: mtl_item_locations loc

5139: AND r2.resource_type = 1
5140: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
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

Line 5296: mtl_item_locations loc

5292: AND r2.resource_type = 1
5293: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
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

Line 5449: mtl_item_locations loc

5445: AND r2.resource_type = 1
5446: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
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

Line 5603: mtl_item_locations loc

5599: AND r2.resource_type = 1
5600: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
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

Line 5756: mtl_item_locations loc

5752: AND r2.resource_type = 1
5753: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
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

Line 5907: mtl_item_locations loc

5903: AND r2.resource_type = 1
5904: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
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

Line 6055: mtl_item_locations loc

6051: AND r2.resource_type = 1
6052: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
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

Line 6206: mtl_item_locations loc

6202: AND r2.resource_type = 1
6203: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
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

Line 6357: mtl_item_locations loc

6353: AND r2.resource_type = 1
6354: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
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

Line 6507: mtl_item_locations loc

6503: AND r2.resource_type = 1
6504: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
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

Line 6791: FROM mtl_item_locations loc

6787: , NVL(loc.z_coordinate, 0)
6788: INTO l_cur_x
6789: , l_cur_y
6790: , l_cur_z
6791: FROM mtl_item_locations loc
6792: , (SELECT transaction_temp_id task_id
6793: , standard_operation_id user_task_type_id
6794: , wms_task_type wms_task_type_id
6795: , organization_id organization_id

Line 6864: FROM mtl_item_locations loc, mtl_material_transactions mmt

6860: , NVL(loc.z_coordinate, 0)
6861: INTO l_cur_x
6862: , l_cur_y
6863: , l_cur_z
6864: FROM mtl_item_locations loc, mtl_material_transactions mmt
6865: WHERE mmt.locator_id = loc.inventory_location_id
6866: AND mmt.organization_id = loc.organization_id
6867: AND mmt.transaction_set_id = l_last_task_id
6868: AND ROWNUM = 1;

Line 6890: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce

6886: , NVL(loc.z_coordinate, 0)
6887: INTO l_cur_x
6888: , l_cur_y
6889: , l_cur_z
6890: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce
6891: WHERE mcce.locator_id = loc.inventory_location_id
6892: AND mcce.organization_id = loc.organization_id
6893: AND mcce.cycle_count_entry_id = l_last_task_id;
6894:

Line 7737: mtl_item_locations_kfv loc

7733: AND r2.resource_type = 1
7734: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
7735: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
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

Line 7898: mtl_item_locations_kfv loc

7894: AND r2.resource_type = 1
7895: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
7896: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
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

Line 8058: mtl_item_locations_kfv loc

8054: AND r2.resource_type = 1
8055: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8056: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
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

Line 8218: mtl_item_locations_kfv loc

8214: AND r2.resource_type = 1
8215: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8216: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
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

Line 8347: , mtl_item_locations_kfv loc

8343: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
8344: WHERE bsor.resource_id = bre.resource_id
8345: AND br.resource_type = 1
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

Line 8454: mtl_item_locations_kfv loc

8450: AND r2.resource_type = 1
8451: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8452: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
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

Line 8589: , mtl_item_locations_kfv loc

8585: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
8586: WHERE bsor.resource_id = bre.resource_id
8587: AND br.resource_type = 1
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

Line 8686: mtl_item_locations_kfv loc

8682: AND r2.resource_type = 1
8683: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8684: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
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

Line 8819: , mtl_item_locations_kfv loc

8815: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
8816: WHERE bsor.resource_id = bre.resource_id
8817: AND br.resource_type = 1
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

Line 8926: mtl_item_locations_kfv loc

8922: AND r2.resource_type = 1
8923: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8924: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
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

Line 9051: , mtl_item_locations_kfv loc

9047: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9048: WHERE bsor.resource_id = bre.resource_id
9049: AND br.resource_type = 1
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

Line 9150: mtl_item_locations_kfv loc

9146: AND r2.resource_type = 1
9147: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9148: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
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

Line 9283: , mtl_item_locations_kfv loc

9279: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9280: WHERE bsor.resource_id = bre.resource_id
9281: AND br.resource_type = 1
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

Line 9388: mtl_item_locations_kfv loc

9384: AND r2.resource_type = 1
9385: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9386: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
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

Line 9520: , mtl_item_locations_kfv loc

9516: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9517: WHERE bsor.resource_id = bre.resource_id
9518: AND br.resource_type = 1
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

Line 9618: mtl_item_locations_kfv loc

9614: AND r2.resource_type = 1
9615: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9616: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
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

Line 9747: , mtl_item_locations_kfv loc

9743: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9744: WHERE bsor.resource_id = bre.resource_id
9745: AND br.resource_type = 1
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

Line 9852: mtl_item_locations_kfv loc

9848: AND r2.resource_type = 1
9849: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9850: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
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

Line 9976: , mtl_item_locations_kfv loc

9972: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9973: WHERE bsor.resource_id = bre.resource_id
9974: AND br.resource_type = 1
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

Line 10074: mtl_item_locations_kfv loc

10070: AND r2.resource_type = 1
10071: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
10072: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
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

Line 10347: FROM mtl_item_locations loc, wms_dispatchable_tasks_v wdtv

10343: , NVL(loc.z_coordinate, 0)
10344: INTO l_cur_x
10345: , l_cur_y
10346: , l_cur_z
10347: FROM mtl_item_locations loc, wms_dispatchable_tasks_v wdtv
10348: WHERE wdtv.locator_id = loc.inventory_location_id
10349: AND wdtv.organization_id = loc.organization_id
10350: AND wdtv.task_id = l_last_task_id
10351: AND wdtv.wms_task_type_id = l_last_task_type;

Line 10377: FROM mtl_item_locations loc, mtl_material_transactions mmt

10373: , NVL(loc.z_coordinate, 0)
10374: INTO l_cur_x
10375: , l_cur_y
10376: , l_cur_z
10377: FROM mtl_item_locations loc, mtl_material_transactions mmt
10378: WHERE mmt.locator_id = loc.inventory_location_id
10379: AND mmt.organization_id = loc.organization_id
10380: AND mmt.transaction_set_id = l_last_task_id
10381: AND ROWNUM = 1;

Line 10402: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce

10398: , NVL(loc.z_coordinate, 0)
10399: INTO l_cur_x
10400: , l_cur_y
10401: , l_cur_z
10402: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce
10403: WHERE mcce.locator_id = loc.inventory_location_id
10404: AND mcce.organization_id = loc.organization_id
10405: AND mcce.cycle_count_entry_id = l_last_task_id;
10406:

Line 13191: FROM wms_cartonization_temp mmtt, mtl_item_locations mil, mtl_secondary_inventories msi, mtl_system_items item

13187: , l_item_prim_uom_code
13188: , l_lot_control_code
13189: , l_serial_number_control_code
13190: , l_item_sec_uom_code
13191: FROM wms_cartonization_temp mmtt, mtl_item_locations mil, mtl_secondary_inventories msi, mtl_system_items item
13192: WHERE mmtt.transaction_temp_id = p_task_id
13193: AND mmtt.locator_id = mil.inventory_location_id(+)
13194: AND mmtt.organization_id = mil.organization_id(+)
13195: AND mmtt.subinventory_code = msi.secondary_inventory_name