VIEW: APPS.INVFV_FREIGHT_CARRIERS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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