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 WSH_LOCATIONS

Line 18064: (select ui_location_code from wsh_locations where wsh_location_id=OOL.DELIVER_TO_ORG_ID) DELIVER_TO,

18060: REMOVE_FROM_WAVE_FLAG,
18061: WAVE_FIRMED_FLAG,
18062: MESSAGE)
18063: select /*+ use_nl(MSIV) */
18064: (select ui_location_code from wsh_locations where wsh_location_id=OOL.DELIVER_TO_ORG_ID) DELIVER_TO,
18065: WND.NAME DELIVERY,
18066: null,
18067: MSIV.concatenated_segments ITEM, --12642410
18068: (select meaning from FND_LOOKUP_VALUES WHERE lookup_type = 'PICK_STATUS' AND LANGUAGE = userenv('LANG') and lookup_code = wdd.released_status) line_status, --12693583

Line 18081: (select ui_location_code from wsh_locations where wsh_location_id=WDD.SHIP_TO_LOCATION_ID) SHIP_TO,

18077: WDD.REQUESTED_QUANTITY REQUESTED_QTY,
18078: WWl.planned_FILL_RATE,
18079: wwl.release_fill_rate,
18080: wwl.pick_fill_rate,
18081: (select ui_location_code from wsh_locations where wsh_location_id=WDD.SHIP_TO_LOCATION_ID) SHIP_TO,
18082: WDD.SHIPPED_QUANTITY SHIPPED_QTY,
18083: WDD.DATE_SCHEDULED,
18084: WDD.BATCH_ID BATCH,
18085: WC.FREIGHT_CODE CARRIER,

Line 18086: (select ui_location_code from wsh_locations where wsh_location_id=OOL.SHIP_TO_CONTACT_ID) Line_Ship_To_Contact,

18082: WDD.SHIPPED_QUANTITY SHIPPED_QTY,
18083: WDD.DATE_SCHEDULED,
18084: WDD.BATCH_ID BATCH,
18085: WC.FREIGHT_CODE CARRIER,
18086: (select ui_location_code from wsh_locations where wsh_location_id=OOL.SHIP_TO_CONTACT_ID) Line_Ship_To_Contact,
18087: OOL.CUST_MODEL_SERIAL_NUMBER,
18088: OOL.REQUEST_DATE Line_request_date,
18089: (select ui_location_code from wsh_locations where wsh_location_id=OOL.DELIVER_TO_CONTACT_ID) DELIVER_TO_CONTACT,
18090: (select ui_location_code from wsh_locations where

Line 18089: (select ui_location_code from wsh_locations where wsh_location_id=OOL.DELIVER_TO_CONTACT_ID) DELIVER_TO_CONTACT,

18085: WC.FREIGHT_CODE CARRIER,
18086: (select ui_location_code from wsh_locations where wsh_location_id=OOL.SHIP_TO_CONTACT_ID) Line_Ship_To_Contact,
18087: OOL.CUST_MODEL_SERIAL_NUMBER,
18088: OOL.REQUEST_DATE Line_request_date,
18089: (select ui_location_code from wsh_locations where wsh_location_id=OOL.DELIVER_TO_CONTACT_ID) DELIVER_TO_CONTACT,
18090: (select ui_location_code from wsh_locations where
18091: wsh_location_id=WDD.DELIVER_TO_LOCATION_ID) DELIVER_TO_LOCATION,
18092: WDD.DELIVERED_QUANTITY,
18093: WDD.EARLIEST_DROPOFF_DATE,

Line 18090: (select ui_location_code from wsh_locations where

18086: (select ui_location_code from wsh_locations where wsh_location_id=OOL.SHIP_TO_CONTACT_ID) Line_Ship_To_Contact,
18087: OOL.CUST_MODEL_SERIAL_NUMBER,
18088: OOL.REQUEST_DATE Line_request_date,
18089: (select ui_location_code from wsh_locations where wsh_location_id=OOL.DELIVER_TO_CONTACT_ID) DELIVER_TO_CONTACT,
18090: (select ui_location_code from wsh_locations where
18091: wsh_location_id=WDD.DELIVER_TO_LOCATION_ID) DELIVER_TO_LOCATION,
18092: WDD.DELIVERED_QUANTITY,
18093: WDD.EARLIEST_DROPOFF_DATE,
18094: to_date(OOL.EARLIEST_SHIP_DATE),

Line 18102: (select ui_location_code from wsh_locations where wsh_location_id=WDD.INTMED_SHIP_TO_LOCATION_ID),

18098: WDD.GROSS_WEIGHT,
18099: WDD.HAZARD_CLASS_ID,
18100: WDD.IGNORE_FOR_PLANNING,
18101: WDD.INSPECTION_FLAG,
18102: (select ui_location_code from wsh_locations where wsh_location_id=WDD.INTMED_SHIP_TO_LOCATION_ID),
18103: (select ui_location_code from wsh_locations where wsh_location_id=WDD.INTMED_SHIP_TO_CONTACT_ID),
18104: WDD.ITEM_DESCRIPTION,
18105: WDD.LATEST_DROPOFF_DATE,
18106: WDD.LOAD_SEQ_NUMBER,

Line 18103: (select ui_location_code from wsh_locations where wsh_location_id=WDD.INTMED_SHIP_TO_CONTACT_ID),

18099: WDD.HAZARD_CLASS_ID,
18100: WDD.IGNORE_FOR_PLANNING,
18101: WDD.INSPECTION_FLAG,
18102: (select ui_location_code from wsh_locations where wsh_location_id=WDD.INTMED_SHIP_TO_LOCATION_ID),
18103: (select ui_location_code from wsh_locations where wsh_location_id=WDD.INTMED_SHIP_TO_CONTACT_ID),
18104: WDD.ITEM_DESCRIPTION,
18105: WDD.LATEST_DROPOFF_DATE,
18106: WDD.LOAD_SEQ_NUMBER,
18107: mil.concatenated_segments,

Line 18130: (select ui_location_code from wsh_locations where wsh_location_id=WDD.SHIP_TO_CONTACT_ID),

18126: WDD.SERVICE_LEVEL,
18127: WDD.SHIP_METHOD_CODE SHIP_METHOD,
18128: WDD.SHIP_MODEL_COMPLETE_FLAG,
18129: WDD.SHIP_SET_ID,
18130: (select ui_location_code from wsh_locations where wsh_location_id=WDD.SHIP_TO_CONTACT_ID),
18131: (SELECT p.party_name FROM hz_party_sites ps, hz_parties p WHERE p.party_id = ps.party_id AND ps.location_id = wdd.ship_to_location_id AND party_type = 'ORGANIZATION' and rownum=1) SHIP_TO_CUSTOMER,
18132: WDD.SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY,
18133: WDD.SHIPPING_INSTRUCTIONS,
18134: WDD.SRC_REQUESTED_QUANTITY,