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

VIEW: AP.AP_PREPAY_HISTORY_ALL#

Object Details
Object Name: AP_PREPAY_HISTORY_ALL#
Object Type: VIEW
Owner: AP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PREPAY_HISTORY_ID NUMBER (15) Yes
PREPAY_INVOICE_ID NUMBER (15) Yes
PREPAY_LINE_NUM NUMBER
Yes
ACCOUNTING_EVENT_ID NUMBER (15)
HISTORICAL_FLAG VARCHAR2 (1)
INVOICE_ID NUMBER (15) Yes
INVOICE_ADJUSTMENT_EVENT_ID NUMBER (15)
ORG_ID NUMBER (15)
POSTED_FLAG VARCHAR2 (1)
RELATED_PREPAY_APP_EVENT_ID NUMBER (15)
TRANSACTION_TYPE VARCHAR2 (30) Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER (15)
INVOICE_LINE_NUMBER NUMBER

ACCOUNTING_DATE DATE

BC_EVENT_ID NUMBER (15)
GAIN_LOSS_INDICATOR VARCHAR2 (1)
Query Text

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


SELECT PREPAY_HISTORY_ID
,      PREPAY_INVOICE_ID
,      PREPAY_LINE_NUM
,      ACCOUNTING_EVENT_ID
,      HISTORICAL_FLAG
,      INVOICE_ID
,      INVOICE_ADJUSTMENT_EVENT_ID
,      ORG_ID
,      POSTED_FLAG
,      RELATED_PREPAY_APP_EVENT_ID
,      TRANSACTION_TYPE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      INVOICE_LINE_NUMBER
,      ACCOUNTING_DATE
,      BC_EVENT_ID
,      GAIN_LOSS_INDICATOR
FROM AP.AP_PREPAY_HISTORY_ALL#;

Dependencies

[top of page]

AP.AP_PREPAY_HISTORY_ALL# references the following:

SchemaAP
TableAP_PREPAY_HISTORY_ALL
AP.AP_PREPAY_HISTORY_ALL# is referenced by following:

SchemaAPPS
SynonymAP_PREPAY_HISTORY
SynonymAP_PREPAY_HISTORY_ALL