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_OPM_OSP_HDRS

Object Details

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

This is the header table for storing OSP information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_OPM_OSP_HDRS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	OSP_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OSP_HEADER_ID	NUMBER	(15)	Yes	Unique Identifier
PO_ID	NUMBER	(15)		PO identifier
TRANSACTION_DATE	DATE			Transaction Date
USER_REFERENCE	VARCHAR2	(40)	Yes	User reference
TOT_MODVAT_CLAIMED	NUMBER			Total Modvat claimed amount
TOT_EXCISE_PAID	NUMBER			Total Excise Paid Amount
FINAL_RECEIPT	VARCHAR2	(2)		Final Receipt indicator
ORIGINAL_DUE_DATE	DATE			Original Due Date
EXTENDED_DUE_DATE	DATE			Extended due date
RECEIVABLE_EXCISE	NUMBER			Excise Receivable
PAYABLE_EXCISE	NUMBER			Excise Payble
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REGISTER_SELECTED	VARCHAR2	(20)		Register selected for the transaction
BATCH_STATUS	NUMBER	(9)		Batch Status
BATCH_CLOSE_DATE	DATE			Batch Close Date
FORM_NAME	VARCHAR2	(20)		FORM name
ORGN_CODE	VARCHAR2	(4)		Organization Code
WHSE_CODE	VARCHAR2	(4)	Yes	Warehouse Code
POST_RG23_II	VARCHAR2	(2)		Flag to indicate if the transaction was posted to RG23 part I(I register
FIN_YEAR	NUMBER	(9)		Financial Year
FORM_NUMBER	NUMBER			FORM number
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number.
FORMULA_ID_REF	NUMBER	(15)		Formula Identifier
ORGANIZATION_ID	NUMBER	(15)		Organization identifier

Query Text

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


SELECT OSP_HEADER_ID
,      PO_ID
,      TRANSACTION_DATE
,      USER_REFERENCE
,      TOT_MODVAT_CLAIMED
,      TOT_EXCISE_PAID
,      FINAL_RECEIPT
,      ORIGINAL_DUE_DATE
,      EXTENDED_DUE_DATE
,      RECEIVABLE_EXCISE
,      PAYABLE_EXCISE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REGISTER_SELECTED
,      BATCH_STATUS
,      BATCH_CLOSE_DATE
,      FORM_NAME
,      ORGN_CODE
,      WHSE_CODE
,      POST_RG23_II
,      FIN_YEAR
,      FORM_NUMBER
,      OBJECT_VERSION_NUMBER
,      FORMULA_ID_REF
,      ORGANIZATION_ID
FROM JA.JAI_OPM_OSP_HDRS;

Dependencies

[top of page]

JA.JAI_OPM_OSP_HDRS does not reference any database object

JA.JAI_OPM_OSP_HDRS is referenced by following:

APPS: JAI_OPM_OSP_HDRS