Product: | CSP - Spares Management |
---|---|
Description: | Shows Carrier Deliver times |
Implementation/DBA Data: | APPS.CSP_CARRIER_DELIVERY_TIMES_V |
SELECT CSM.ORGANIZATION_ID
, OOD.ORGANIZATION_CODE
, CSM.FREIGHT_CODE
, CSM.SHIP_METHOD_CODE
, CDT.ROWID
, CDT.RELATION_SHIP_ID
, CDT.CREATED_BY
, CDT.CREATION_DATE
, CDT.LAST_UPDATED_BY
, CDT.LAST_UPDATE_DATE
, CDT.LAST_UPDATE_LOGIN
, CDT.ORGANIZATION_ID
, CDT.FREIGHT_CODE
, CDT.SHIPPING_METHOD
, CDT.LEAD_TIME
, CDT.LEAD_TIME_UOM
, CDT.DELIVERY_TIME
, CDT.CUTOFF_TIME
, CDT.TIMEZONE_ID
, CDT.ATTRIBUTE_CATEGORY
, CDT.ATTRIBUTE1
, CDT.ATTRIBUTE2
, CDT.ATTRIBUTE3
, CDT.ATTRIBUTE4
, CDT.ATTRIBUTE5
, CDT.ATTRIBUTE6
, CDT.ATTRIBUTE7
, CDT.ATTRIBUTE8
, CDT.ATTRIBUTE9
, CDT.ATTRIBUTE10
, CDT.ATTRIBUTE11
, CDT.ATTRIBUTE12
, CDT.ATTRIBUTE13
, CDT.ATTRIBUTE14
, CDT.ATTRIBUTE15
, CDT.SAFETY_ZONE
, TN.NAME
FROM CSP_CARRIER_DELIVERY_TIMES CDT
, WSH_CARRIER_SHIP_METHODS CSM
, ORG_ORGANIZATION_DEFINITIONS OOD
, HZ_TIMEZONES_VL TN
WHERE CSM.ORGANIZATION_ID = CDT.ORGANIZATION_ID (+)
AND CSM.FREIGHT_CODE = CDT.FREIGHT_CODE (+)
AND CSM.SHIP_METHOD_CODE = CDT.SHIPPING_METHOD(+)
AND OOD.ORGANIZATION_ID = CSM.ORGANIZATION_ID
AND TN.TIMEZONE_ID (+) = CDT.TIMEZONE_ID ORDER BY OOD.ORGANIZATION_CODE