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.

[Home] [Help]

View: CUN_PROJECT_SHIPMENT_V

Product:	CUN - Network Logistics - NATS (Obsolete)
Description:	Project shipment information
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT TRANS.ORGANIZATION_ID
, TRANS.TRANSACTION_ID
, TRANS.ITEM_ID
, TRANS.PROJECT_ID
, PROJ.SEGMENT1
, TASK.TASK_ID
, TASK.TASK_NUMBER
, TRANS.WORK_ORDER_NUMBER
, MTRH.REQUEST_NUMBER
, MTRH.DATE_REQUIRED
, MTR.FREIGHT_CODE
, MTR.WAYBILL_AIRBILL
, SUBSTR(CUL.DESCRIPTION
, 1
, 240)
, CUL.ADDRESS_LINE_1
, CUL.ADDRESS_LINE_2
, CUL.ADDRESS_LINE_3
, NULL
, CUL.TOWN_OR_CITY
, CUL.POSTAL_CODE
, CUL.REGION_2
, MTRH.DESCRIPTION
FROM CUN_TRANSACTION_HIST_V TRANS
, PA_PROJECTS_ALL PROJ
, PA_TASKS TASK
, MTL_MATERIAL_TRANSACTIONS MTR
, MTL_TXN_REQUEST_LINES MTRL
, MTL_TXN_REQUEST_HEADERS MTRH
, CUN_LOCATIONS_V CUL
WHERE TRANS.PROJECT_ID = PROJ.PROJECT_ID (+)
AND TRANS.TASK_ID = TASK.TASK_ID (+)
AND TRANS.MTL_TRANSACTION_ID = MTR.TRANSACTION_ID
AND MTRL.LINE_ID = MTR.MOVE_ORDER_LINE_ID
AND MTRL.SHIP_TO_LOCATION_ID = CUL.LOCATION_ID
AND MTRH.HEADER_ID = MTRL.HEADER_ID

Columns

Name
INVENTORY_ORG_ID
TRANSACTION_ID
ITEM_ID
PROJECT_ID
PROJECT_NUMBER
PROJECT_TASK_ID
TASK_NUMBER
WORK_ORDER_NUMBER
SHIPMENT_NUMBER
SHIPPED_DATE
FREIGHT_CARRIER_CODE
WAYBILL_AIRBILL_NUM
SHIP_TO_LOCATION
SHIP_TO_ADDRESS1
SHIP_TO_ADDRESS2
SHIP_TO_ADDRESS3
SHIP_TO_ADDRESS4
SHIP_TO_CITY
SHIP_TO_ZIP
SHIP_TO_STATE
DESCRIPTION