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

VIEW: AR.AR_CASH_RECO_LINES_ALL#

Object Details
Object Name: AR_CASH_RECO_LINES_ALL#
Object Type: VIEW
Owner: AR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RECOMMENDATION_ID NUMBER (15) Yes
LINE_NUMBER NUMBER
Yes
CUSTOMER_TRX_ID NUMBER

PAYMENT_SCHEDULE_ID NUMBER
Yes
AMOUNT_APPLIED NUMBER

AMOUNT_APPLIED_FROM NUMBER

TRANS_TO_RECEIPT_RATE NUMBER

RECEIPT_CURRENCY_CODE VARCHAR2 (15) Yes
RECEIPT_DATE DATE
Yes
RECOMMENDATION_REASON VARCHAR2 (100) Yes
ORG_ID NUMBER
Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER (15)
DISCOUNT_TAKEN_EARNED NUMBER

DISCOUNT_TAKEN_UNEARNED NUMBER

Query Text

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


SELECT RECOMMENDATION_ID
,      LINE_NUMBER
,      CUSTOMER_TRX_ID
,      PAYMENT_SCHEDULE_ID
,      AMOUNT_APPLIED
,      AMOUNT_APPLIED_FROM
,      TRANS_TO_RECEIPT_RATE
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_DATE
,      RECOMMENDATION_REASON
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      DISCOUNT_TAKEN_EARNED
,      DISCOUNT_TAKEN_UNEARNED
FROM AR.AR_CASH_RECO_LINES_ALL#;

Dependencies

[top of page]

AR.AR_CASH_RECO_LINES_ALL# references the following:

SchemaAR
TableAR_CASH_RECO_LINES_ALL
AR.AR_CASH_RECO_LINES_ALL# is referenced by following:

SchemaAPPS
SynonymAR_CASH_RECO_LINES
SynonymAR_CASH_RECO_LINES_ALL