[Home] [Help] [Dependency Information]
Object Name: | AR_INVOICE_COMMITMENT_INFO_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AR.AR_INVOICE_COMMITMENT_INFO_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The AR_INVOICE_COMMITMENT_INFO_V view, which is one of eight transaction printing views that Oracle Receivables provides, collects information about commitments (guarantees and deposits). A system administrator or Oracle consultant can use transaction printing views to extract transaction information from Receivables and then print the data in a custom format using Oracle Reports or a similar, SQL-based report generator.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_TRX_ID | NUMBER | (15) | Yes | Invoice identifier |
PREVIOUS_CUSTOMER_TRX_ID | NUMBER | (15) | Identifier for invoice credited | |
COMMITMENT_CUSTOMER_TRX_ID | NUMBER | (15) | Yes | Commitment identifier |
COMMITMENT_TRX_NUMBER | VARCHAR2 | (20) | Yes | Commitment number |
START_DATE_COMMITMENT | DATE | Date a commitment becomes inactive | ||
END_DATE_COMMITMENT | DATE | Date a commitment becomes active | ||
CLASS | VARCHAR2 | (20) | Invoice Type | |
CLASS_NAME | VARCHAR2 | (80) | Yes | Invoice Type Name |
ORIGINAL_AMOUNT | NUMBER | Invoice Original Amount | ||
THIS_INVOICE_AMOUNT | NUMBER | Commitment Amount | ||
TOTAL_ACTIVITY_AMT | NUMBER | Total Acitivity Amount | ||
UNINVOICED_AMOUNT | NUMBER | Uninvoiced Amount | ||
COMMITMENT_BALANCE | NUMBER | Commitment Balance |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMER_TRX_ID
, PREVIOUS_CUSTOMER_TRX_ID
, COMMITMENT_CUSTOMER_TRX_ID
, COMMITMENT_TRX_NUMBER
, START_DATE_COMMITMENT
, END_DATE_COMMITMENT
, CLASS
, CLASS_NAME
, ORIGINAL_AMOUNT
, THIS_INVOICE_AMOUNT
, TOTAL_ACTIVITY_AMT
, UNINVOICED_AMOUNT
, COMMITMENT_BALANCE
FROM APPS.AR_INVOICE_COMMITMENT_INFO_V;
APPS.AR_INVOICE_COMMITMENT_INFO_V is not referenced by any database object
|
|
|