[Home] [Help]
[Dependency Information]
| Object Name: | JAI_AP_MATCH_TAXES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | JA.JAI_AP_MATCH_TAXES_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INVOICE_ID | NUMBER | (15) | Invoice identifier. | |
| INVOICE_NUM | VARCHAR2 | (50) | Yes | |
| INVOICE_AMOUNT | NUMBER | |||
| INVOICE_DATE | DATE | |||
| ERROR_MESSAGE | VARCHAR2 | (1996) | ||
| ERROR_DATE | DATE | |||
| NUM_DIST_LINES | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, INVOICE_NUM
, INVOICE_AMOUNT
, INVOICE_DATE
, ERROR_MESSAGE
, ERROR_DATE
, NUM_DIST_LINES
FROM APPS.JAI_AP_MATCH_TAXES_V;
APPS
AP_INVOICES_ALL
JAI_AP_MATCH_ERS_T
APPS.JAI_AP_MATCH_TAXES_V is not referenced by any database object
|
|
|
|