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_UPD_DTLS

Object Details

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

Stores the processed lines for Mass Tax Changes and their details along with errors if any generated for that line

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_CMN_MTAX_UPD_DTLS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	MTAX_DTL_ID
JAI_CMN_MTAX_UPD_DTLS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID DOCUMENT_NO RELEASE_NO DOCUMENT_LINE_NO SHIPMENT_NO

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(15)		"Foreign key to JAI_CMN_MTAX_HDRS_ALL
DETAIL_ID	NUMBER	(15)	Yes	Indicates one of JAI_PO_LINE_LOCATIONS.line_focus_id or JAI_PO_REQ_LINES.requisition_line_id or JAI_OM_OE_SO_LINES.line_id
DOCUMENT_TYPE	VARCHAR2	(60)		Indicates one of po_line_location_all.shipment_type or po_requisition_headers_all.type_lookup_code or `SO`.
DOCUMENT_NO	VARCHAR2	(100)		Indicates processing line Header No.
RELEASE_NO	NUMBER	(15)		Indicates processing line Release Number in case of Blanket Releases or Scheduled Releases.
DOCUMENT_LINE_NO	NUMBER	(15)		Indicates the processing lines line number.
SHIPMENT_NO	NUMBER	(15)		Indicates processing line shipment number in case of PO.
OLD_TAX_CATEGORY_ID	NUMBER	(15)		Old tax category that was defaulted previously and which is overridden by mass tax changes to default new tax category.
NEW_TAX_CATEGORY_ID	NUMBER	(15)		The new tax category from where the taxes got redefaulted.
ERROR_REASON	VARCHAR2	(512)		Stores the error (if any) generated while processing the line.
PROGRAM_ID	NUMBER		Yes	Identifies the concurrent program
PROGRAM_LOGIN_ID	NUMBER		Yes	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
MTAX_DTL_ID	NUMBER	(15)	Yes	Mass tax update detail transaction identifier
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
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
,      DETAIL_ID
,      DOCUMENT_TYPE
,      DOCUMENT_NO
,      RELEASE_NO
,      DOCUMENT_LINE_NO
,      SHIPMENT_NO
,      OLD_TAX_CATEGORY_ID
,      NEW_TAX_CATEGORY_ID
,      ERROR_REASON
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      MTAX_DTL_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_CMN_MTAX_UPD_DTLS;

Dependencies

[top of page]

JA.JAI_CMN_MTAX_UPD_DTLS does not reference any database object

JA.JAI_CMN_MTAX_UPD_DTLS is referenced by following:

APPS: JAI_CMN_MTAX_UPD_DTLS