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_WAVE_PLANNING_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 9544: from wms_waveplan_tasks_temp wwtt, mtl_item_locations_kfv mil

9540: -- Consolidation Locator
9541:
9542: CURSOR c_consol_locator IS
9543: select distinct wwtt.to_locator_id, wwtt.to_locator
9544: from wms_waveplan_tasks_temp wwtt, mtl_item_locations_kfv mil
9545: where wwtt.to_locator_id = mil.inventory_location_id
9546: and wwtt.to_organization_id = mil.organization_id
9547: and mil.inventory_location_type in (4, 5)
9548: and wwtt.transaction_temp_id in

Line 17962: mtl_item_locations_kfv mil,

17958: WSH_DELIVERY_DETAILS WDD,
17959: WMS_WP_WAVE_LINES WWL,
17960: WMS_LICENSE_PLATE_NUMBERS WLPN,
17961: WSH_DELIVERY_ASSIGNMENTS WDA,
17962: mtl_item_locations_kfv mil,
17963: wsh_Delivery_details wdd2
17964: WHERE WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
17965: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id(+)
17966: AND wdd.locator_id = mil.inventory_location_id(+)

Line 18165: mtl_item_locations_kfv mil,

18161: WMS_LICENSE_PLATE_NUMBERS WLPN,
18162: WSH_DELIVERY_ASSIGNMENTS WDA,
18163: WSH_TRIP_STOPS WTS,
18164: WSH_DELIVERY_LEGS WLG,
18165: mtl_item_locations_kfv mil,
18166: wsh_Delivery_details wdd2
18167: WHERE
18168: HP.party_id = cust_acct.party_id
18169: and cust_acct.status = 'A'

Line 18287: FROM MTL_ITEM_LOCATIONS_kfv mil

18283: WHERE organization_id = mmtt.transfer_organization) to_organization_code,
18284: mmtt.transfer_subinventory to_subinventory,
18285: mmtt.transfer_to_location to_locator_id,
18286: (SELECT mil.concatenated_segments --bug12642410
18287: FROM MTL_ITEM_LOCATIONS_kfv mil
18288: WHERE mmtt.transfer_to_location = mil.inventory_location_id
18289: AND mmtt.organization_id = mil.organization_id) to_locator,
18290: mmtt.standard_operation_id user_task_type_id,
18291: bso.operation_code,

Line 18382: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410

18378: mmtt.transaction_uom,
18379: mmtt.transaction_quantity
18380: FROM mtl_material_transactions_temp mmtt,
18381: WSH_DELIVERY_DETAILS WDD,
18382: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410
18383: mtl_system_items_kfv msiv,
18384: wms_op_plans_vl wopv,
18385: per_all_people_f pap,
18386: wms_op_operation_instances wooi,

Line 18436: FROM MTL_ITEM_LOCATIONS_kfv mil

18432: WHERE organization_id = mmtt.transfer_organization) to_organization_code,
18433: mmtt.transfer_subinventory to_subinventory,
18434: mmtt.transfer_to_location to_locator_id,
18435: (SELECT mil.concatenated_segments --bug12642410
18436: FROM MTL_ITEM_LOCATIONS_kfv mil
18437: WHERE mmtt.transfer_to_location = mil.inventory_location_id
18438: AND mmtt.organization_id = mil.organization_id) to_locator,
18439: mmtt.standard_operation_id user_task_type_id,
18440: bso.operation_code,

Line 18514: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410

18510: mmtt.transaction_quantity
18511: FROM mtl_material_transactions_temp mmtt,
18512: mtl_material_transactions_temp mmtt2, --12736677
18513: WSH_DELIVERY_DETAILS WDD,
18514: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410
18515: mtl_system_items_kfv msiv,
18516: wms_op_plans_vl wopv,
18517: per_all_people_f pap,
18518: wms_op_operation_instances wooi,

Line 18568: FROM MTL_ITEM_LOCATIONS_kfv mil

18564: WHERE organization_id = mmtt.transfer_organization) to_organization_code,
18565: mmtt.transfer_subinventory to_subinventory,
18566: mmtt.transfer_to_location to_locator_id,
18567: (select mil.concatenated_segments --bug12642410
18568: FROM MTL_ITEM_LOCATIONS_kfv mil
18569: WHERE mmtt.transfer_to_location = mil.inventory_location_id
18570: AND mmtt.organization_id = mil.organization_id) to_locator,
18571: mmtt.standard_operation_id user_task_type_id,
18572: bso.operation_code,

Line 18662: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410

18658: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) PICKED_LPN,
18659: mmtt.transaction_uom,
18660: mmtt.transaction_quantity
18661: FROM mtl_material_transactions_temp mmtt,
18662: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410
18663: mtl_system_items_kfv msiv,
18664: wms_op_plans_vl wopv,
18665: per_all_people_f pap,
18666: wms_op_operation_instances wooi,

Line 18722: FROM MTL_ITEM_LOCATIONS_kfv mil

18718: mmt.transfer_subinventory to_subinventory,
18719: mmt.transfer_locator_id to_locator_id,
18720: (SELECT mil.concatenated_segments --bug12642410
18721:
18722: FROM MTL_ITEM_LOCATIONS_kfv mil
18723: WHERE mmt.transfer_locator_id = mil.inventory_location_id
18724: AND mmt.organization_id = mil.organization_id) to_locator,
18725: wdth.user_task_type user_task_type_id,
18726: bso.operation_code,

Line 18826: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410

18822: mmt.transaction_uom,
18823: abs(mmt.transaction_quantity)
18824: FROM mtl_material_transactions mmt,
18825: WSH_DELIVERY_DETAILS WDD,
18826: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410
18827: mtl_system_items_kfv msiv,
18828: wms_op_plans_vl wopv,
18829: per_all_people_f pap,
18830: wms_op_operation_instances wooi,

Line 18905: FROM MTL_ITEM_LOCATIONS_kfv mil

18901: mmtt.transfer_subinventory to_subinventory,
18902: mmtt.transfer_to_location to_locator_id,
18903: (SELECT mil.concatenated_segments --bug12642410
18904:
18905: FROM MTL_ITEM_LOCATIONS_kfv mil
18906: WHERE mmtt.transfer_to_location = mil.inventory_location_id
18907: AND mmtt.organization_id = mil.organization_id) to_locator,
18908: mmtt.standard_operation_id user_task_type_id,
18909: bso.operation_code,

Line 19000: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410

18996: mmtt.transaction_uom,
18997: mmtt.transaction_quantity
18998: FROM mtl_material_transactions_temp mmtt,
18999: WSH_DELIVERY_DETAILS WDD,
19000: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410
19001: mtl_system_items_kfv msiv,
19002: wms_op_plans_vl wopv,
19003: per_all_people_f pap,
19004: wms_op_operation_instances wooi,

Line 19055: FROM MTL_ITEM_LOCATIONS_kfv mil

19051: wdth.dest_subinventory_code to_subinventory,
19052: wdth.dest_locator_id to_locator_id,
19053: (SELECT mil.concatenated_segments --bug12642410
19054:
19055: FROM MTL_ITEM_LOCATIONS_kfv mil
19056: WHERE wdth.dest_locator_id = mil.inventory_location_id
19057: AND wdth.organization_id = mil.organization_id) to_locator,
19058: wdth.user_task_type user_task_type_id,
19059: bso.operation_code,

Line 19159: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410

19155: wdth.transaction_uom_code,
19156: abs(wdth.transaction_quantity)
19157: FROM
19158: WSH_DELIVERY_DETAILS WDD,
19159: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410
19160: mtl_system_items_kfv msiv,
19161: wms_op_plans_vl wopv,
19162: per_all_people_f pap,
19163: wms_op_operation_instances wooi,