eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: JA.JAI_CMN_MTAX_HDRS_ALL

Object Details

Object Name:	JAI_CMN_MTAX_HDRS_ALL
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_CMN_MTAX_HDRS_ALL
Subobject Name:
Status:	VALID

Contains the Mass Tax Changes request information. Stores all inputs submitted to the mass tax changes request will be stored in this table. A record is inserted into this table for each mass tax changes request fired.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_CMN_MTAX_HDRS_ALL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(15)	Yes	Unique key for this table generated through sequence.
ORG_ID	NUMBER	(15)		Operating unit for which the request is fired. value from PROFILES.
DOCUMENT_TYPE	VARCHAR2	(60)		Type of document. possible values - STANDARD_PO, PLANNED_PA, BLANKET_PA, SCHEDULED_RELEASES, QUOTATION, RFQ, BLANKET_RELEASES, REQUISITION_IN, , REQUISITION_PO and SALES_ORDERS.
FROM_DATE	DATE			Minimum creation date for document creation.
TO_DATE	DATE			Maximum creation date fro document creation.
SUPPLIER_ID	NUMBER			This is used only for Purchasing documents. value from PO_VENDORS.vendor_id.
SUPPLIER_SITE_ID	NUMBER			Used only for purchasing documents. value from PO_VENDOR_SITES_ALL.vendor_site_id.
CUSTOMER_ID	NUMBER			Used only for Sales Order documents. value from RA_CUSTOMERS.
CUSTOMER_SITE_ID	NUMBER			Used only for Sales Order documents. Indicates customer site.
OLD_TAX_CATEGORY	NUMBER	(15)		Old tax category for which the mass tax changes has to be applied. indicates ja_in_tax_categories.tax_category_id.
NEW_TAX_CATEGORY	NUMBER	(15)		The new tax category from where the taxes should be defaulted. indicates ja_in_tax_categories.tax_category_id.
PROCESS_PARTIAL	VARCHAR2	(2)		If "Y" then mass tax changes processes partially received PO Shipments or partially shipped Sales Order lines. Possible Values are "Y or N". default is "N".
DOCUMENT_NO	VARCHAR2	(100)		Indicates the document number for document type selected. this can be PO Number, Sales Order No or Requisition Number.
RELEASE_NO	NUMBER			Used only for Blanket or Planned Pos. indicates the release no against the BLANKET or PLANNED agreement.
DOCUMENT_LINE_NO	NUMBER	(15)		The line number of the document specified. Either PO Line Number, So Order Line Number or Requisition line number.
SHIPMENT_NO	NUMBER	(15)		Used only for PO. indicates the shipment number for which the mass tax changes has to be executed.
COMMIT_INTERVAL	NUMBER	(15)		Interval length, which says after processing how many records the database COMMIT has to happen, to avoid rollback segments errors.
OVERRIDE_MANUAL_TAXES	VARCHAR2	(2)		If `Y` then removes all the taxes attached to the processing records and redefaults the taxes. Default value is `N`.
ERROR_MESSAGE	VARCHAR2	(512)		If any error occurred while processing the record that is selected based on the input parameters, then it stops processing and saves the error messages in this column.
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
PROGRAM_ID	NUMBER			Identifies the concurrent program
PROGRAM_LOGIN_ID	NUMBER			Identifies the Oracle Applications Concurrent Program Login ID
PROGRAM_APPLICATION_ID	NUMBER			Identifies the Oracle Application that spawned the concurrent program
REQUEST_ID	NUMBER			Identifies the concurrent request instance that spawned the concurrent program
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number

Query Text

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


SELECT BATCH_ID
,      ORG_ID
,      DOCUMENT_TYPE
,      FROM_DATE
,      TO_DATE
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      OLD_TAX_CATEGORY
,      NEW_TAX_CATEGORY
,      PROCESS_PARTIAL
,      DOCUMENT_NO
,      RELEASE_NO
,      DOCUMENT_LINE_NO
,      SHIPMENT_NO
,      COMMIT_INTERVAL
,      OVERRIDE_MANUAL_TAXES
,      ERROR_MESSAGE
,      CREATION_DATE
,      CREATED_BY
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_CMN_MTAX_HDRS_ALL;

Dependencies

[top of page]

JA.JAI_CMN_MTAX_HDRS_ALL does not reference any database object

JA.JAI_CMN_MTAX_HDRS_ALL is referenced by following:

APPS: JAI_CMN_MTAX_HDRS_ALL