[Home] [Help] [Dependency Information]
Object Name: | JAI_AP_TDS_DISTRIBUTION_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JA.JAI_AP_TDS_DISTRIBUTION_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 |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Id | |
INVOICE_ID | NUMBER | (15) | Invoice id | |
INVOICE_LINE_NUMBER | NUMBER | Invoice Line Number | ||
DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | Distribution Line Number | |
INVOICE_DISTRIBUTION_ID | NUMBER | (15) | Invoice Distribution Id | |
DIST_CODE_COMBINATION_ID | NUMBER | (15) | Code Combination id | |
AMOUNT | NUMBER | Amount | ||
DESCRIPTION | VARCHAR2 | (240) | Description | |
MATCH_STATUS_FLAG | VARCHAR2 | (1) | Match Status Flag | |
LINE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Line Type Lookup code | |
TAX_CATEGORY_ID | VARCHAR2 | (0) | Tax Category id | |
SECTION_CODE | VARCHAR2 | (0) | TDS Section Code | |
TAX_CATEGORY_OVERRIDEN | VARCHAR2 | (0) | Tax Category Overriden |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, INVOICE_ID
, INVOICE_LINE_NUMBER
, DISTRIBUTION_LINE_NUMBER
, INVOICE_DISTRIBUTION_ID
, DIST_CODE_COMBINATION_ID
, AMOUNT
, DESCRIPTION
, MATCH_STATUS_FLAG
, LINE_TYPE_LOOKUP_CODE
, TAX_CATEGORY_ID
, SECTION_CODE
, TAX_CATEGORY_OVERRIDEN
FROM APPS.JAI_AP_TDS_DISTRIBUTION_V;
APPS.JAI_AP_TDS_DISTRIBUTION_V is not referenced by any database object
|
|
|