[Home] [Help] [Dependency Information]
Object Name: | OKL_BATCH_RECEIPTS_SUMMARY_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_BATCH_RECEIPTS_SUMMARY_UV |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View to display Batch Receipt information .
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECEIPT_NUMBER | VARCHAR2 | (90) | Receipt Number | |
RECEIPT_AMOUNT | NUMBER | (14) | Receipt Amount | |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer Name | |
ACCOUNT_NUMBER | VARCHAR2 | (30) | Customer Account Number | |
CUSTOMER_ID | NUMBER | (15) | Customer Id | |
CUST_ACCOUNT_ID | NUMBER | Customer Account Id | ||
CONTRACT_NUMBER | VARCHAR2 | (120) | Contract Number | |
CONTRACT_ID | NUMBER | Contract Id | ||
INVOICE_NUMBER | VARCHAR2 | (90) | Invoice Number | |
INVOICE_ID | NUMBER | Invoice Id | ||
BATCH_ID | NUMBER | Batch Receipt Id | ||
RECEIPT_ID | NUMBER | Receipt Id | ||
RECEIPT_CURRENCY | VARCHAR2 | (15) | Receipt Currency | |
RECEIPT_DATE | DATE | Receipt Date | ||
RCPT_STATUS_CODE | VARCHAR2 | (30) | Receipt Status Code | |
INVOICE_TYPE | VARCHAR2 | (4) | Invoice Type |
Cut, paste (and edit) the following text to query this object:
SELECT RECEIPT_NUMBER
, RECEIPT_AMOUNT
, CUSTOMER_NAME
, ACCOUNT_NUMBER
, CUSTOMER_ID
, CUST_ACCOUNT_ID
, CONTRACT_NUMBER
, CONTRACT_ID
, INVOICE_NUMBER
, INVOICE_ID
, BATCH_ID
, RECEIPT_ID
, RECEIPT_CURRENCY
, RECEIPT_DATE
, RCPT_STATUS_CODE
, INVOICE_TYPE
FROM APPS.OKL_BATCH_RECEIPTS_SUMMARY_UV;
APPS.OKL_BATCH_RECEIPTS_SUMMARY_UV is not referenced by any database object
|
|
|