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

VIEW: AR.AR_AUTOREC_EXCEPTIONS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Yes
REQUEST_ID NUMBER (15) Yes
PAYMENT_SCHEDULE_ID NUMBER (15)
PAYING_CUSTOMER_ID NUMBER (15)
PAYING_SITE_USE_ID NUMBER (15)
DUE_DATE DATE

CUST_BANK_ACCT_ID NUMBER (15)
REMIT_BANK_ACCT_ID NUMBER (15)
CUST_MIN_REC_AMOUNT NUMBER

BANK_MIN_REC_AMOUNT NUMBER

EXCEPTION_CODE VARCHAR2 (30) Yes
LAST_UPDATE_DATE DATE
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15) Yes
ADDITIONAL_MESSAGE VARCHAR2 (240)
CASH_RECEIPT_ID NUMBER (15)
REMIT_BANK_ACCT_USE_ID NUMBER (15)
Query Text

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


SELECT BATCH_ID
,      REQUEST_ID
,      PAYMENT_SCHEDULE_ID
,      PAYING_CUSTOMER_ID
,      PAYING_SITE_USE_ID
,      DUE_DATE
,      CUST_BANK_ACCT_ID
,      REMIT_BANK_ACCT_ID
,      CUST_MIN_REC_AMOUNT
,      BANK_MIN_REC_AMOUNT
,      EXCEPTION_CODE
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATED_BY
,      ADDITIONAL_MESSAGE
,      CASH_RECEIPT_ID
,      REMIT_BANK_ACCT_USE_ID
FROM AR.AR_AUTOREC_EXCEPTIONS#;

Dependencies

[top of page]

AR.AR_AUTOREC_EXCEPTIONS# references the following:

SchemaAR
TableAR_AUTOREC_EXCEPTIONS
AR.AR_AUTOREC_EXCEPTIONS# is referenced by following:

SchemaAPPS
SynonymAR_AUTOREC_EXCEPTIONS