View: OTA_CROSS_CHARGES_V

Product:	OTA - Learning Management
Description:
Implementation/DBA Data:	APPS.OTA_CROSS_CHARGES_V

View Text

SELECT TCC.ROWID
, TCC.CROSS_CHARGE_ID
, TCC.BUSINESS_GROUP_ID
, BUS.NAME
, TCC.GL_SET_OF_BOOKS_ID
, GLS.NAME
, GLS.CHART_OF_ACCOUNTS_ID
, TCC.OBJECT_VERSION_NUMBER
, TCC.TYPE
, LK1.MEANING
, TCC.FROM_TO
, LK2.MEANING
, TCC.START_DATE_ACTIVE
, TCC.END_DATE_ACTIVE
, TCC.LAST_UPDATE_DATE
, TCC.LAST_UPDATED_BY
, TCC.LAST_UPDATE_LOGIN
, TCC.CREATION_DATE
, TCC.CREATED_BY
FROM OTA_CROSS_CHARGES TCC
, PER_BUSINESS_GROUPS BUS
, GL_SETS_OF_BOOKS GLS
, HR_LOOKUPS LK1
, HR_LOOKUPS LK2
WHERE BUS.BUSINESS_GROUP_ID = TCC.BUSINESS_GROUP_ID
AND GLS.SET_OF_BOOKS_ID = TCC.GL_SET_OF_BOOKS_ID
AND LK1.LOOKUP_TYPE = 'OTA_CROSS_CHARGE_TYPE'
AND LK1.LOOKUP_CODE = TCC.TYPE
AND LK2.LOOKUP_TYPE = 'OTA_CROSS_CHARGE_FROM_TO'
AND LK2.LOOKUP_CODE = TCC.FROM_TO

Columns