eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: JA.JAI_CMN_RG_CONSLDATIONS#

Object Details

Object Name:	JAI_CMN_RG_CONSLDATIONS#
Object Type:	VIEW
Owner:	JA
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
CONSOLIDATION_ID	NUMBER	(15)	Yes
CONSOLIDATION_DATE	DATE		Yes
PREV_CONSOLIDATION_DATE	DATE		Yes
ORGANIZATION_ID	NUMBER	(15)	Yes
LOCATION_ID	NUMBER	(15)	Yes
CUR_RG23AP2_BED	NUMBER
CON_RG23AP2_BED	NUMBER
CUR_RG23AP2_SED	NUMBER
CON_RG23AP2_SED	NUMBER
CUR_RG23AP2_OED	NUMBER
CON_RG23AP2_OED	NUMBER
PREV_RG23AP2_RID	NUMBER
CUR_RG23CP2_BED	NUMBER
CON_RG23CP2_BED	NUMBER
CUR_RG23CP2_SED	NUMBER
CON_RG23CP2_SED	NUMBER
CUR_RG23CP2_OED	NUMBER
CON_RG23CP2_OED	NUMBER
PREV_RG23CP2_RID	NUMBER
CUR_PLA_BED	NUMBER
CON_PLA_BED	NUMBER
CUR_PLA_SED	NUMBER
CON_PLA_SED	NUMBER
CUR_PLA_OED	NUMBER
CON_PLA_OED	NUMBER
PREV_PLA_RID	NUMBER
CUR_NET_PAYABLE	NUMBER
CON_NET_PAYABLE	NUMBER
CON_RG23AP2_RID	NUMBER	(15)
CON_RG23CP2_RID	NUMBER	(15)
CON_PLA_RID	NUMBER	(15)
TOD_RG23AP2_BED	NUMBER	(15)
TOD_RG23CP2_BED	NUMBER	(15)
TOD_PLA_BED	NUMBER	(15)
TOD_RG23AP2_SED	NUMBER	(15)
TOD_RG23CP2_SED	NUMBER	(15)
TOD_PLA_SED	NUMBER	(15)
TOD_RG23AP2_OED	NUMBER	(15)
TOD_RG23CP2_OED	NUMBER	(15)
TOD_PLA_OED	NUMBER	(15)
REMARKS	VARCHAR2	(100)
CREATION_DATE	DATE
CREATED_BY	NUMBER
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
CUR_RG23AP2_CESS	NUMBER
CON_RG23AP2_CESS	NUMBER
TOD_RG23AP2_CESS	NUMBER
CUR_RG23CP2_CESS	NUMBER
CON_RG23CP2_CESS	NUMBER
TOD_RG23CP2_CESS	NUMBER
CUR_PLA_CESS	NUMBER
CON_PLA_CESS	NUMBER
TOD_PLA_CESS	NUMBER
PAYMENT_ID_REF	NUMBER	(15)
OBJECT_VERSION_NUMBER	NUMBER
CON_SH_PLA_CESS	NUMBER
CON_SH_RG23AP2_CESS	NUMBER
CON_SH_RG23CP2_CESS	NUMBER
CUR_SH_PLA_CESS	NUMBER
CUR_SH_RG23AP2_CESS	NUMBER
CUR_SH_RG23CP2_CESS	NUMBER
TOD_SH_PLA_CESS	NUMBER
TOD_SH_RG23AP2_CESS	NUMBER
TOD_SH_RG23CP2_CESS	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

JA.JAI_CMN_RG_CONSLDATIONS# references the following:

JA: JAI_CMN_RG_CONSLDATIONS

JA.JAI_CMN_RG_CONSLDATIONS# is referenced by following:

APPS: JAI_CMN_RG_CONSLDATIONS