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

VIEW: PA.PA_MC_DRAFT_REVS_ALL#

Object Details
Object Name: PA_MC_DRAFT_REVS_ALL#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Yes
PROJECT_ID NUMBER (15) Yes
DRAFT_REVENUE_NUM NUMBER (15) Yes
TRANSFER_STATUS_CODE VARCHAR2 (1) Yes
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

TRANSFERRED_DATE DATE

TRANSFER_REJECTION_REASON VARCHAR2 (250)
UNBILLED_RECEIVABLE_DR NUMBER

UNEARNED_REVENUE_CR NUMBER

UNBILLED_BATCH_NAME VARCHAR2 (30)
UNEARNED_BATCH_NAME VARCHAR2 (30)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
REALIZED_GAINS_AMOUNT NUMBER

REALIZED_LOSSES_AMOUNT NUMBER

REALIZED_GAINS_BATCH_NAME VARCHAR2 (30)
REALIZED_LOSSES_BATCH_NAME VARCHAR2 (30)
XLA_MIGRATED_FLAG VARCHAR2 (1)
Query Text

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


SELECT SET_OF_BOOKS_ID
,      PROJECT_ID
,      DRAFT_REVENUE_NUM
,      TRANSFER_STATUS_CODE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TRANSFERRED_DATE
,      TRANSFER_REJECTION_REASON
,      UNBILLED_RECEIVABLE_DR
,      UNEARNED_REVENUE_CR
,      UNBILLED_BATCH_NAME
,      UNEARNED_BATCH_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REALIZED_GAINS_AMOUNT
,      REALIZED_LOSSES_AMOUNT
,      REALIZED_GAINS_BATCH_NAME
,      REALIZED_LOSSES_BATCH_NAME
,      XLA_MIGRATED_FLAG
FROM PA.PA_MC_DRAFT_REVS_ALL#;

Dependencies

[top of page]

PA.PA_MC_DRAFT_REVS_ALL# references the following:

SchemaPA
TablePA_MC_DRAFT_REVS_ALL
PA.PA_MC_DRAFT_REVS_ALL# is referenced by following:

SchemaAPPS
SynonymPA_MC_DRAFT_REVS_ALL