VIEW: JA.JAI_CMN_RG_CONSLDATIONS#

Source

View Text - Preformatted

select CONSOLIDATION_ID CONSOLIDATION_ID, CONSOLIDATION_DATE CONSOLIDATION_DATE, PREV_CONSOLIDATION_DATE PREV_CONSOLIDATION_DATE, ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, CUR_RG23AP2_BED CUR_RG23AP2_BED, CON_RG23AP2_BED CON_RG23AP2_BED, CUR_RG23AP2_SED CUR_RG23AP2_SED, CON_RG23AP2_SED CON_RG23AP2_SED, CUR_RG23AP2_OED CUR_RG23AP2_OED, CON_RG23AP2_OED CON_RG23AP2_OED, PREV_RG23AP2_RID PREV_RG23AP2_RID, CUR_RG23CP2_BED CUR_RG23CP2_BED, CON_RG23CP2_BED CON_RG23CP2_BED, CUR_RG23CP2_SED CUR_RG23CP2_SED, CON_RG23CP2_SED CON_RG23CP2_SED, CUR_RG23CP2_OED CUR_RG23CP2_OED, CON_RG23CP2_OED CON_RG23CP2_OED, PREV_RG23CP2_RID PREV_RG23CP2_RID, CUR_PLA_BED CUR_PLA_BED, CON_PLA_BED CON_PLA_BED, CUR_PLA_SED CUR_PLA_SED, CON_PLA_SED CON_PLA_SED, CUR_PLA_OED CUR_PLA_OED, CON_PLA_OED CON_PLA_OED, PREV_PLA_RID PREV_PLA_RID, CUR_NET_PAYABLE CUR_NET_PAYABLE, CON_NET_PAYABLE CON_NET_PAYABLE, CON_RG23AP2_RID CON_RG23AP2_RID, CON_RG23CP2_RID CON_RG23CP2_RID, CON_PLA_RID CON_PLA_RID, TOD_RG23AP2_BED TOD_RG23AP2_BED, TOD_RG23CP2_BED TOD_RG23CP2_BED, TOD_PLA_BED TOD_PLA_BED, TOD_RG23AP2_SED TOD_RG23AP2_SED, TOD_RG23CP2_SED TOD_RG23CP2_SED, TOD_PLA_SED TOD_PLA_SED, TOD_RG23AP2_OED TOD_RG23AP2_OED, TOD_RG23CP2_OED TOD_RG23CP2_OED, TOD_PLA_OED TOD_PLA_OED, REMARKS REMARKS, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CUR_RG23AP2_CESS CUR_RG23AP2_CESS, CON_RG23AP2_CESS CON_RG23AP2_CESS, TOD_RG23AP2_CESS TOD_RG23AP2_CESS, CUR_RG23CP2_CESS CUR_RG23CP2_CESS, CON_RG23CP2_CESS CON_RG23CP2_CESS, TOD_RG23CP2_CESS TOD_RG23CP2_CESS, CUR_PLA_CESS CUR_PLA_CESS, CON_PLA_CESS CON_PLA_CESS, TOD_PLA_CESS TOD_PLA_CESS, PAYMENT_ID_REF PAYMENT_ID_REF, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CON_SH_PLA_CESS CON_SH_PLA_CESS, CON_SH_RG23AP2_CESS CON_SH_RG23AP2_CESS, CON_SH_RG23CP2_CESS CON_SH_RG23CP2_CESS, CUR_SH_PLA_CESS CUR_SH_PLA_CESS, CUR_SH_RG23AP2_CESS CUR_SH_RG23AP2_CESS, CUR_SH_RG23CP2_CESS CUR_SH_RG23CP2_CESS, TOD_SH_PLA_CESS TOD_SH_PLA_CESS, TOD_SH_RG23AP2_CESS TOD_SH_RG23AP2_CESS, TOD_SH_RG23CP2_CESS TOD_SH_RG23CP2_CESS from "JA"."JAI_CMN_RG_CONSLDATIONS"

View Text - HTML Formatted

SELECT CONSOLIDATION_ID CONSOLIDATION_ID
, CONSOLIDATION_DATE CONSOLIDATION_DATE
, PREV_CONSOLIDATION_DATE PREV_CONSOLIDATION_DATE
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, CUR_RG23AP2_BED CUR_RG23AP2_BED
, CON_RG23AP2_BED CON_RG23AP2_BED
, CUR_RG23AP2_SED CUR_RG23AP2_SED
, CON_RG23AP2_SED CON_RG23AP2_SED
, CUR_RG23AP2_OED CUR_RG23AP2_OED
, CON_RG23AP2_OED CON_RG23AP2_OED
, PREV_RG23AP2_RID PREV_RG23AP2_RID
, CUR_RG23CP2_BED CUR_RG23CP2_BED
, CON_RG23CP2_BED CON_RG23CP2_BED
, CUR_RG23CP2_SED CUR_RG23CP2_SED
, CON_RG23CP2_SED CON_RG23CP2_SED
, CUR_RG23CP2_OED CUR_RG23CP2_OED
, CON_RG23CP2_OED CON_RG23CP2_OED
, PREV_RG23CP2_RID PREV_RG23CP2_RID
, CUR_PLA_BED CUR_PLA_BED
, CON_PLA_BED CON_PLA_BED
, CUR_PLA_SED CUR_PLA_SED
, CON_PLA_SED CON_PLA_SED
, CUR_PLA_OED CUR_PLA_OED
, CON_PLA_OED CON_PLA_OED
, PREV_PLA_RID PREV_PLA_RID
, CUR_NET_PAYABLE CUR_NET_PAYABLE
, CON_NET_PAYABLE CON_NET_PAYABLE
, CON_RG23AP2_RID CON_RG23AP2_RID
, CON_RG23CP2_RID CON_RG23CP2_RID
, CON_PLA_RID CON_PLA_RID
, TOD_RG23AP2_BED TOD_RG23AP2_BED
, TOD_RG23CP2_BED TOD_RG23CP2_BED
, TOD_PLA_BED TOD_PLA_BED
, TOD_RG23AP2_SED TOD_RG23AP2_SED
, TOD_RG23CP2_SED TOD_RG23CP2_SED
, TOD_PLA_SED TOD_PLA_SED
, TOD_RG23AP2_OED TOD_RG23AP2_OED
, TOD_RG23CP2_OED TOD_RG23CP2_OED
, TOD_PLA_OED TOD_PLA_OED
, REMARKS REMARKS
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CUR_RG23AP2_CESS CUR_RG23AP2_CESS
, CON_RG23AP2_CESS CON_RG23AP2_CESS
, TOD_RG23AP2_CESS TOD_RG23AP2_CESS
, CUR_RG23CP2_CESS CUR_RG23CP2_CESS
, CON_RG23CP2_CESS CON_RG23CP2_CESS
, TOD_RG23CP2_CESS TOD_RG23CP2_CESS
, CUR_PLA_CESS CUR_PLA_CESS
, CON_PLA_CESS CON_PLA_CESS
, TOD_PLA_CESS TOD_PLA_CESS
, PAYMENT_ID_REF PAYMENT_ID_REF
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CON_SH_PLA_CESS CON_SH_PLA_CESS
, CON_SH_RG23AP2_CESS CON_SH_RG23AP2_CESS
, CON_SH_RG23CP2_CESS CON_SH_RG23CP2_CESS
, CUR_SH_PLA_CESS CUR_SH_PLA_CESS
, CUR_SH_RG23AP2_CESS CUR_SH_RG23AP2_CESS
, CUR_SH_RG23CP2_CESS CUR_SH_RG23CP2_CESS
, TOD_SH_PLA_CESS TOD_SH_PLA_CESS
, TOD_SH_RG23AP2_CESS TOD_SH_RG23AP2_CESS
, TOD_SH_RG23CP2_CESS TOD_SH_RG23CP2_CESS
FROM "JA"."JAI_CMN_RG_CONSLDATIONS"