[Home] [Help] [Dependency Information]

VIEW: PA.PA_DRAFT_REVENUES_AR#

Object Details

[View Source]

Columns

Query Text

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

SELECT PURGE_BATCH_ID
,      PURGE_RELEASE
,      PURGE_PROJECT_ID
,      LAST_UPDATE_LOGIN
,      RESOURCE_ACCUMULATED_FLAG
,      ORG_ID
,      PROJECT_ID
,      DRAFT_REVENUE_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      AGREEMENT_ID
,      TRANSFER_STATUS_CODE
,      GENERATION_ERROR_FLAG
,      PA_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CUSTOMER_BILL_SPLIT
,      ACCRUE_THROUGH_DATE
,      RELEASED_DATE
,      TRANSFERRED_DATE
,      TRANSFER_REJECTION_REASON
,      UNBILLED_RECEIVABLE_DR
,      UNEARNED_REVENUE_CR
,      UNBILLED_CODE_COMBINATION_ID
,      UNEARNED_CODE_COMBINATION_ID
,      UNBILLED_BATCH_NAME
,      UNEARNED_BATCH_NAME
,      GL_DATE
,      ACCUMULATED_FLAG
,      DRAFT_REVENUE_NUM_CREDITED
,      GL_PERIOD_NAME
,      PA_PERIOD_NAME
,      ADJUSTING_REVENUE_FLAG
,      UBR_SUMMARY_ID
,      UER_SUMMARY_ID
,      UBR_UER_PROCESS_FLAG
,      PJI_SUMMARIZED_FLAG
,      REALIZED_GAINS_AMOUNT
,      REALIZED_LOSSES_AMOUNT
,      REALIZED_GAINS_CCID
,      REALIZED_LOSSES_CCID
,      REALIZED_GAINS_BATCH_NAME
,      REALIZED_LOSSES_BATCH_NAME
FROM PA.PA_DRAFT_REVENUES_AR#;

Dependencies

[top of page]

PA

PA_DRAFT_REVENUES_AR

APPS

PA_DRAFT_REVENUES_AR