VIEW: APPS.CSP_CARRIER_DELIVERY_TIMES_V

Source

View Text - Preformatted

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, csm.ship_method_code_meaning from csp_carrier_delivery_times cdt, WSH_CARRIER_SHIP_METHODS_V 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

View Text - HTML Formatted

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
, CSM.SHIP_METHOD_CODE_MEANING
FROM CSP_CARRIER_DELIVERY_TIMES CDT
, WSH_CARRIER_SHIP_METHODS_V 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