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

VIEW: AR.AR_MC_RECEIVABLE_APPS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
RECEIVABLE_APPLICATION_ID NUMBER (15) Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
AMOUNT_APPLIED NUMBER
Yes
DISPLAY VARCHAR2 (1) Yes
STATUS VARCHAR2 (30) Yes
PAYMENT_SCHEDULE_ID NUMBER (15) Yes
CASH_RECEIPT_ID NUMBER (15)
GL_POSTED_DATE DATE

POSTING_CONTROL_ID NUMBER (15) Yes
ACCTD_AMOUNT_APPLIED_FROM NUMBER
Yes
ACCTD_AMOUNT_APPLIED_TO NUMBER

ACCTD_EARNED_DISCOUNT_TAKEN NUMBER

ACCTD_UNEARNED_DISCOUNT_TAKEN NUMBER

AMOUNT_APPLIED_FROM NUMBER

CASH_RECEIPT_HISTORY_ID NUMBER (15)
LAST_UPDATE_DATE DATE

PROGRAM_ID NUMBER (15)
APPLICATION_RULE VARCHAR2 (30)
REVERSAL_CREATED VARCHAR2 (1)
ADJUSTMENT_CREATED VARCHAR2 (1)
LAST_UPDATED_BY NUMBER (15)
Query Text

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


SELECT RECEIVABLE_APPLICATION_ID
,      SET_OF_BOOKS_ID
,      AMOUNT_APPLIED
,      DISPLAY
,      STATUS
,      PAYMENT_SCHEDULE_ID
,      CASH_RECEIPT_ID
,      GL_POSTED_DATE
,      POSTING_CONTROL_ID
,      ACCTD_AMOUNT_APPLIED_FROM
,      ACCTD_AMOUNT_APPLIED_TO
,      ACCTD_EARNED_DISCOUNT_TAKEN
,      ACCTD_UNEARNED_DISCOUNT_TAKEN
,      AMOUNT_APPLIED_FROM
,      CASH_RECEIPT_HISTORY_ID
,      LAST_UPDATE_DATE
,      PROGRAM_ID
,      APPLICATION_RULE
,      REVERSAL_CREATED
,      ADJUSTMENT_CREATED
,      LAST_UPDATED_BY
FROM AR.AR_MC_RECEIVABLE_APPS#;

Dependencies

[top of page]

AR.AR_MC_RECEIVABLE_APPS# references the following:

SchemaAR
TableAR_MC_RECEIVABLE_APPS
AR.AR_MC_RECEIVABLE_APPS# is referenced by following:

SchemaAPPS
SynonymAR_MC_RECEIVABLE_APPS