VIEW: APPS.CSM_INV_ORG_FREIGHTS_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, B.ORGANIZATION_ID, B.FREIGHT_CODE, B.DESCRIPTION, B.DISABLE_DATE, ACC.SHIP_METHOD_CODE, fl.meaning as SHIP_METHOD_MEANING FROM CSM_INV_ORG_FREIGHTS_ACC acc, ORG_FREIGHT_TL B,FND_LOOKUP_VALUES fl WHERE B.ORGANIZATION_ID=ACC.ORGANIZATION_ID AND B.FREIGHT_CODE=ACC.FREIGHT_CODE AND ACC.USER_ID=asg_base.get_user_id AND B.LANGUAGE=asg_base.get_LANGUAGE AND FL.LOOKUP_TYPE(+) = 'SHIP_METHOD' AND FL.VIEW_APPLICATION_ID(+) = 3 AND acc.SHIP_METHOD_CODE=FL.LOOKUP_CODE(+) AND FL.LANGUAGE(+) = asg_base.get_LANGUAGE

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.ORGANIZATION_ID
, B.FREIGHT_CODE
, B.DESCRIPTION
, B.DISABLE_DATE
, ACC.SHIP_METHOD_CODE
, FL.MEANING AS SHIP_METHOD_MEANING
FROM CSM_INV_ORG_FREIGHTS_ACC ACC
, ORG_FREIGHT_TL B
, FND_LOOKUP_VALUES FL
WHERE B.ORGANIZATION_ID=ACC.ORGANIZATION_ID
AND B.FREIGHT_CODE=ACC.FREIGHT_CODE
AND ACC.USER_ID=ASG_BASE.GET_USER_ID
AND B.LANGUAGE=ASG_BASE.GET_LANGUAGE
AND FL.LOOKUP_TYPE(+) = 'SHIP_METHOD'
AND FL.VIEW_APPLICATION_ID(+) = 3
AND ACC.SHIP_METHOD_CODE=FL.LOOKUP_CODE(+)
AND FL.LANGUAGE(+) = ASG_BASE.GET_LANGUAGE