VIEW: APPS.CSP_CARRIER_DELIVERY_TIMES_V

Source

View Text - Preformatted

SELECT mism.organization_id, mism.organization_code, NULL, mism.location_id, mism.ship_method, 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.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, htl.name, flvv.meaning, cdt.distance, cdt.distance_uom FROM (SELECT DISTINCT haou.organization_id, mp.organization_code, mism.ship_method, haou.location_id FROM hr_all_organization_units haou, mtl_parameters mp, mtl_interorg_ship_methods mism WHERE mism.from_location_id = haou.location_id AND mp.organization_id = haou.organization_id) mism, csp_carrier_delivery_times cdt, hz_timezones_vl htl, fnd_lookup_values_vl flvv WHERE cdt.organization_id(+) = mism.organization_id AND cdt.shipping_method(+) = mism.ship_method AND cdt.subinventory_code(+) IS NULL AND htl.timezone_id(+) = cdt.timezone_id AND flvv.lookup_type = 'SHIP_METHOD' AND flvv.lookup_code = mism.ship_method AND flvv.enabled_flag = 'Y' UNION SELECT msi_mism.organization_id, msi_mism.organization_code, msi_mism.secondary_inventory_name, msi_mism.location_id, msi_mism.ship_method, 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.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, htl.name, flvv.meaning, cdt.distance, cdt.distance_uom FROM (SELECT distinct msi.location_id, mp.organization_id, mp.organization_code, mthod.ship_method, msi.secondary_inventory_name FROM mtl_secondary_inventories msi, mtl_interorg_ship_methods mthod, mtl_parameters mp WHERE mthod.from_location_id = msi.location_id AND msi.organization_id = mp.organization_id ) msi_mism, csp_carrier_delivery_times cdt, hz_timezones_vl htl, fnd_lookup_values_vl flvv WHERE cdt.organization_id(+) = msi_mism.organization_id AND cdt.location_id(+) = msi_mism.location_id AND cdt.shipping_method(+) = msi_mism.ship_method AND cdt.subinventory_code(+) IS NOT NULL AND htl.timezone_id(+) = cdt.timezone_id AND flvv.lookup_type = 'SHIP_METHOD' AND flvv.lookup_code = msi_mism.ship_method AND flvv.enabled_flag = 'Y' AND cdt.subinventory_code(+) = msi_mism.secondary_inventory_name

View Text - HTML Formatted

SELECT MISM.ORGANIZATION_ID
, MISM.ORGANIZATION_CODE
, NULL
, MISM.LOCATION_ID
, MISM.SHIP_METHOD
, 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.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
, HTL.NAME
, FLVV.MEANING
, CDT.DISTANCE
, CDT.DISTANCE_UOM
FROM (SELECT DISTINCT HAOU.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, MISM.SHIP_METHOD
, HAOU.LOCATION_ID
FROM HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_PARAMETERS MP
, MTL_INTERORG_SHIP_METHODS MISM
WHERE MISM.FROM_LOCATION_ID = HAOU.LOCATION_ID
AND MP.ORGANIZATION_ID = HAOU.ORGANIZATION_ID) MISM
, CSP_CARRIER_DELIVERY_TIMES CDT
, HZ_TIMEZONES_VL HTL
, FND_LOOKUP_VALUES_VL FLVV
WHERE CDT.ORGANIZATION_ID(+) = MISM.ORGANIZATION_ID
AND CDT.SHIPPING_METHOD(+) = MISM.SHIP_METHOD
AND CDT.SUBINVENTORY_CODE(+) IS NULL
AND HTL.TIMEZONE_ID(+) = CDT.TIMEZONE_ID
AND FLVV.LOOKUP_TYPE = 'SHIP_METHOD'
AND FLVV.LOOKUP_CODE = MISM.SHIP_METHOD
AND FLVV.ENABLED_FLAG = 'Y' UNION SELECT MSI_MISM.ORGANIZATION_ID
, MSI_MISM.ORGANIZATION_CODE
, MSI_MISM.SECONDARY_INVENTORY_NAME
, MSI_MISM.LOCATION_ID
, MSI_MISM.SHIP_METHOD
, 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.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
, HTL.NAME
, FLVV.MEANING
, CDT.DISTANCE
, CDT.DISTANCE_UOM
FROM (SELECT DISTINCT MSI.LOCATION_ID
, MP.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, MTHOD.SHIP_METHOD
, MSI.SECONDARY_INVENTORY_NAME
FROM MTL_SECONDARY_INVENTORIES MSI
, MTL_INTERORG_SHIP_METHODS MTHOD
, MTL_PARAMETERS MP
WHERE MTHOD.FROM_LOCATION_ID = MSI.LOCATION_ID
AND MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID ) MSI_MISM
, CSP_CARRIER_DELIVERY_TIMES CDT
, HZ_TIMEZONES_VL HTL
, FND_LOOKUP_VALUES_VL FLVV
WHERE CDT.ORGANIZATION_ID(+) = MSI_MISM.ORGANIZATION_ID
AND CDT.LOCATION_ID(+) = MSI_MISM.LOCATION_ID
AND CDT.SHIPPING_METHOD(+) = MSI_MISM.SHIP_METHOD
AND CDT.SUBINVENTORY_CODE(+) IS NOT NULL
AND HTL.TIMEZONE_ID(+) = CDT.TIMEZONE_ID
AND FLVV.LOOKUP_TYPE = 'SHIP_METHOD'
AND FLVV.LOOKUP_CODE = MSI_MISM.SHIP_METHOD
AND FLVV.ENABLED_FLAG = 'Y'
AND CDT.SUBINVENTORY_CODE(+) = MSI_MISM.SECONDARY_INVENTORY_NAME