VIEW: APPS.CSM_MTL_INTERORG_FREIGHTS_V

Source

View Text - Preformatted

SELECT acc.access_id, acc.from_organization_id, acc.to_organization_id, acc.ship_method_code , flv.ship_method_code_meaning , wshc.freight_code, oft.description , flv.lead_time, flv.lead_time_uom, flv.distance, flv.distance_uom, ism.INTRANSIT_TIME FROM csm_interorg_freights_acc acc, MTL_INTERORG_SHIP_METHODS ism, CSP_CARRIER_DELIVERY_TIMES_V flv,WSH_CARRIER_SHIP_METHODS wshc,org_freight_tl oft WHERE acc.user_id=asg_base.get_user_id AND acc.from_organization_id = ism.from_organization_id AND acc.to_organization_id = ism.to_organization_id AND acc.ship_method_code=ism.ship_method AND flv.organization_id=acc.from_organization_id and flv.subinventory_code is null AND flv.ship_method_code = acc.ship_method_code and wshc.ship_method_code(+)=acc.ship_method_code and wshc.organization_id(+)=acc.from_organization_id and wshc.enabled_flag(+)='Y' and oft.freight_code(+)=wshc.freight_code and oft.organization_id(+)=wshc.organization_id and oft.language(+)=asg_base.get_language

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, ACC.FROM_ORGANIZATION_ID
, ACC.TO_ORGANIZATION_ID
, ACC.SHIP_METHOD_CODE
, FLV.SHIP_METHOD_CODE_MEANING
, WSHC.FREIGHT_CODE
, OFT.DESCRIPTION
, FLV.LEAD_TIME
, FLV.LEAD_TIME_UOM
, FLV.DISTANCE
, FLV.DISTANCE_UOM
, ISM.INTRANSIT_TIME
FROM CSM_INTERORG_FREIGHTS_ACC ACC
, MTL_INTERORG_SHIP_METHODS ISM
, CSP_CARRIER_DELIVERY_TIMES_V FLV
, WSH_CARRIER_SHIP_METHODS WSHC
, ORG_FREIGHT_TL OFT
WHERE ACC.USER_ID=ASG_BASE.GET_USER_ID
AND ACC.FROM_ORGANIZATION_ID = ISM.FROM_ORGANIZATION_ID
AND ACC.TO_ORGANIZATION_ID = ISM.TO_ORGANIZATION_ID
AND ACC.SHIP_METHOD_CODE=ISM.SHIP_METHOD
AND FLV.ORGANIZATION_ID=ACC.FROM_ORGANIZATION_ID
AND FLV.SUBINVENTORY_CODE IS NULL
AND FLV.SHIP_METHOD_CODE = ACC.SHIP_METHOD_CODE
AND WSHC.SHIP_METHOD_CODE(+)=ACC.SHIP_METHOD_CODE
AND WSHC.ORGANIZATION_ID(+)=ACC.FROM_ORGANIZATION_ID
AND WSHC.ENABLED_FLAG(+)='Y'
AND OFT.FREIGHT_CODE(+)=WSHC.FREIGHT_CODE
AND OFT.ORGANIZATION_ID(+)=WSHC.ORGANIZATION_ID
AND OFT.LANGUAGE(+)=ASG_BASE.GET_LANGUAGE