[Home] [Help]
View: INVFV_FREIGHT_CARRIERS
View Text
SELECT MOF.FREIGHT_CODE
, MOF.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, MOF.DESCRIPTION
, MOF.DISABLE_DATE
, MOF.DISTRIBUTION_ACCOUNT
, '_KF:SQLGL:GL#:GLC'
, MOF.CREATED_BY
, MOF.CREATION_DATE
, MOF.LAST_UPDATED_BY
, MOF.LAST_UPDATE_DATE
FROM MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HOU
, GL_CODE_COMBINATIONS GLC
, ORG_FREIGHT MOF
WHERE MP.ORGANIZATION_ID = MOF.ORGANIZATION_ID AND HOU.ORGANIZATION_ID = MOF.ORGANIZATION_ID
AND GLC.CODE_COMBINATION_ID (+) = MOF.DISTRIBUTION_ACCOUNT
AND '_SEC:MOF.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
Columns
Name |
CARRIER_NAME |
ORGANIZATION_ID |
ORGANIZATION_CODE |
ORGANIZATION_NAME |
DESCRIPTION |
INACTIVE_DATE |
DISTRIBUTION_ACCOUNT |
"_KF:DIST_ACC_NUM:_CO" |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |