VIEW: APPS.OTA_CROSS_CHARGES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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