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


VIEW: APPS.AR_INV_ACT_V

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
PAYMENT_SCHEDULE_ID NUMBER (15)
ROW_ID ROWID (10)
TRX_REC_NUMBER VARCHAR2 (30)
CLASS VARCHAR2 (80)
APPLY_DATE DATE

AMOUNT NUMBER

AMOUNT_CURRENCY VARCHAR2 (15)
STATUS VARCHAR2 (80)
CASH_RECEIPT_ID NUMBER

CUSTOMER_TRX_ID NUMBER (15)
REASON_MEANING VARCHAR2 (80)
APPLIED_PAYMENT_SCHEDULE_ID NUMBER

APPLIED_TERMS_SEQ_NUMBER NUMBER

PS_CLASS VARCHAR2 (20)
LINE_AMOUNT NUMBER

TAX_AMOUNT NUMBER

FREIGHT_AMOUNT NUMBER

CHARGES_AMOUNT NUMBER

TOTAL_AMOUNT NUMBER

Query Text

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


SELECT PAYMENT_SCHEDULE_ID
,      ROW_ID
,      TRX_REC_NUMBER
,      CLASS
,      APPLY_DATE
,      AMOUNT
,      AMOUNT_CURRENCY
,      STATUS
,      CASH_RECEIPT_ID
,      CUSTOMER_TRX_ID
,      REASON_MEANING
,      APPLIED_PAYMENT_SCHEDULE_ID
,      APPLIED_TERMS_SEQ_NUMBER
,      PS_CLASS
,      LINE_AMOUNT
,      TAX_AMOUNT
,      FREIGHT_AMOUNT
,      CHARGES_AMOUNT
,      TOTAL_AMOUNT
FROM APPS.AR_INV_ACT_V;

Dependencies

[top of page]

APPS.AR_INV_ACT_V references the following:

SchemaAPPS
SynonymAR_ADJUSTMENTS
SynonymAR_CASH_RECEIPTS_ALL
ViewAR_LOOKUPS
SynonymAR_PAYMENT_SCHEDULES
SynonymAR_RECEIVABLE_APPLICATIONS_ALL
SynonymRA_CUSTOMER_TRX_ALL

APPS.AR_INV_ACT_V is not referenced by any database object