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

VIEW: APPS.ARBV_CREDIT_MEMO_APPLICATIONS

Object Details
Object Name: ARBV_CREDIT_MEMO_APPLICATIONS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.ARBV_CREDIT_MEMO_APPLICATIONS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows information about credits issued to the customer as settlement for one or more debit items.


[View Source]

Columns
Name Datatype Length Mandatory Comments
RECEIVABLE_APPLICATION_ID NUMBER (15) Yes
AMOUNT_APPLIED NUMBER
Yes
AMOUNT_APPLIED_BASE NUMBER

ALLOCATED_RECEIPT_AMOUNT_BASE NUMBER
Yes
APPLY_DATE DATE
Yes
LINE_AMOUNT_APPLIED NUMBER

TAX_AMOUNT_APPLIED NUMBER

FREIGHT_AMOUNT_APPLIED NUMBER

RECEIVABLES_CHARGES_APPLIED NUMBER

DAYS_LATE NUMBER (15)
USSGL_TRANSACTION_CODE VARCHAR2 (30)
COMMENTS VARCHAR2 (240)
ORG_ID NUMBER (15)
CUSTOMER_TRX_ID NUMBER (15)
APPLIED_PAYMENT_SCHEDULE_ID NUMBER (15)
TRANSACTION_LINE_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
Query Text

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


SELECT RECEIVABLE_APPLICATION_ID
,      AMOUNT_APPLIED
,      AMOUNT_APPLIED_BASE
,      ALLOCATED_RECEIPT_AMOUNT_BASE
,      APPLY_DATE
,      LINE_AMOUNT_APPLIED
,      TAX_AMOUNT_APPLIED
,      FREIGHT_AMOUNT_APPLIED
,      RECEIVABLES_CHARGES_APPLIED
,      DAYS_LATE
,      USSGL_TRANSACTION_CODE
,      COMMENTS
,      ORG_ID
,      CUSTOMER_TRX_ID
,      APPLIED_PAYMENT_SCHEDULE_ID
,      TRANSACTION_LINE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.ARBV_CREDIT_MEMO_APPLICATIONS;

Dependencies

[top of page]

APPS.ARBV_CREDIT_MEMO_APPLICATIONS references the following:

SchemaAPPS
SynonymAR_RECEIVABLE_APPLICATIONS

APPS.ARBV_CREDIT_MEMO_APPLICATIONS is not referenced by any database object