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

TABLE: JA.JAI_PO_REQUEST_T

Object Details
Object Name: JAI_PO_REQUEST_T
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_PO_REQUEST_T
Subobject Name:
Status: VALID


Used by JAINPOCR concurrent for defaulting taxes


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LINE_LOCATION_ID NUMBER (15)
Foreign key to PO_LINE_LOCATIONS_ALL.line_location_id.
TAX_LINE_NO NUMBER (15)
Indicates the line number of the tax which are attached to Scheduled Release shipment.
PO_LINE_ID NUMBER (15)
Foreign key to PO_LINES_ALL.po_line_id.
PO_HEADER_ID NUMBER (15)
Foreign key to PO_HEADERS_ALL.po_header_id.
PRECEDENCE_1 NUMBER

Indicates the first precedence on which this tax is based on for tax calculation.
PRECEDENCE_2 NUMBER

Indicates the second precedence on which this tax is based on for tax calculation.
PRECEDENCE_3 NUMBER

Indicates the third precedence on which this tax is based on for tax calculation.
PRECEDENCE_4 NUMBER

Indicates the fourth precedence on which this tax is based on for tax calculation.
PRECEDENCE_5 NUMBER

Indicates fifth precedence on which this tax is based on for tax calculation.
TAX_ID NUMBER (15)
Foreign key to JAI_CMN_TAXES_ALL.tax_id.
CURRENCY VARCHAR2 (15)
Currency Code of the tax.
TAX_RATE NUMBER

Rate of the tax in which the tax is calculated.
QTY_RATE NUMBER

Rate/ UOM for UOM based taxes.
UOM VARCHAR2 (3)
UOM Code in which the tax has to be calculated in case of UOM based taxes.
TAX_AMOUNT NUMBER

Calculated tax amount based on currency, tax_rate, uom and qty_rate, precedences and base amount.
TAX_TYPE VARCHAR2 (30)
Type of the tax (e.g. Excise, Sales).
VENDOR_ID NUMBER (15)
Foreign key to PO_VENDORS.vendor_id to which this tax is attached.
MODVAT_FLAG VARCHAR2 (1)
Indicates whether MODVAT can be claimed on the tax or not. If `Y` then tax can be claimed.
LINE_FOCUS_ID NUMBER (15)
Foreign key to JAI_PO_LINE_LOCATIONS.line_focus_id. This field combined with tax_id form the Unique key for this table.
TAX_TARGET_AMOUNT NUMBER

Tax amount on which the tax is calculated. i.e. base amount.
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
TAX_CATEGORY_ID NUMBER (15)
Foreign key to JAI_CMN_TAX_CTGS_ALL.tax_category_id. Indicates from which tax category that this tax has been defaulted.
OBJECT_VERSION_NUMBER NUMBER

Object version number
PRECEDENCE_6 NUMBER

Sixth precedence on which this tax is dependent.
PRECEDENCE_7 NUMBER

Seventh precedence on which this tax is dependent.
PRECEDENCE_8 NUMBER

Eighth precedence on which this tax is dependent.
PRECEDENCE_9 NUMBER

Nineth precedence on which this tax is dependent.
PRECEDENCE_10 NUMBER

Tenth precedence on which this tax is dependent.
Query Text

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


SELECT LINE_LOCATION_ID
,      TAX_LINE_NO
,      PO_LINE_ID
,      PO_HEADER_ID
,      PRECEDENCE_1
,      PRECEDENCE_2
,      PRECEDENCE_3
,      PRECEDENCE_4
,      PRECEDENCE_5
,      TAX_ID
,      CURRENCY
,      TAX_RATE
,      QTY_RATE
,      UOM
,      TAX_AMOUNT
,      TAX_TYPE
,      VENDOR_ID
,      MODVAT_FLAG
,      LINE_FOCUS_ID
,      TAX_TARGET_AMOUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TAX_CATEGORY_ID
,      OBJECT_VERSION_NUMBER
,      PRECEDENCE_6
,      PRECEDENCE_7
,      PRECEDENCE_8
,      PRECEDENCE_9
,      PRECEDENCE_10
FROM JA.JAI_PO_REQUEST_T;

Dependencies

[top of page]

JA.JAI_PO_REQUEST_T does not reference any database object

JA.JAI_PO_REQUEST_T is referenced by following:

SchemaAPPS
SynonymJAI_PO_REQUEST_T