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_PO_OSP_HDRS

Object Details

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

Stores 57F4 Header Information for Purchase Orders of type OSP.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_PO_OSP_HDRS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	FORM_ID
JAI_PO_OSP_HDRS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FORM_NUMBER
JAI_PO_OSP_HDRS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_HEADER_ID
JAI_PO_OSP_HDRS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID VENDOR_SITE_ID
JAI_PO_OSP_HDRS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID LOCATION_ID FORM_NUMBER PO_HEADER_ID OTH_DOC_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FORM_ID	NUMBER		Yes	Indicates the Form identifier. Unique identifier
VENDOR_ID	NUMBER		Yes	Indicates the Supplier Identifier.
VENDOR_SITE_ID	NUMBER		Yes	Indicates the Supplier Site Identifier.
ORGANIZATION_ID	NUMBER	(15)		Indicates the Organization Identifier.
LOCATION_ID	NUMBER	(15)		Indicates the Location Identifier.
FORM_NUMBER	NUMBER			Indicates the Form Number.
PO_HEADER_ID	NUMBER			Indicates the PO Header Identifier.
OTH_DOC_ID	NUMBER			Indicates the Other Document Identifier.
PROCESS_TIME	NUMBER			Indicates the Process Time.
ISSUE_APPROVED	VARCHAR2	(2)		Indicates whether the Issue is Approved(Possible Values are Y, N and Null).
ISSUE_DATE	DATE			Indicates the Date of Issue.
RECEIPT_APPROVED	VARCHAR2	(2)		Indicates whether the Receipt is Approved(Possible Values are Y, N and Null).
RECEIPT_DATE	DATE			Indicates the Date of Receipt.
DR_REGISTER	VARCHAR2	(30)		Indicates the Register, which is Debited. The Debit Register can be either RG23A, PLA or null.
DR_REG_REGISTER_ID	NUMBER	(15)		Indicates the Register Identifier of the Register Debited.
DR_REG_SLNO	NUMBER	(15)		Indicates the Sl. No. of the Register Debited.
DR_REG_ENTRY_DATE	DATE			Indicates the Entry Date of the Register Debited.
CR_REGISTER	VARCHAR2	(30)		Indicates the Register, which is credited.
CR_REG_REGISTER_ID	NUMBER			Indicates the Register Identifier of the Register Credited.
CR_REG_SLNO	NUMBER	(15)		Indicates the Sl. No. of the Register Credited.
CR_REG_ENTRY_DATE	DATE			Indicates the Entry Date of the Register Credited.
CANCEL_FLAG	VARCHAR2	(1)		Indicates whether the 57F4 is Cancelled ( Possible Values are Y, N and Null).
SOURCE	VARCHAR2	(25)		Indicates the Source of 57F4. The Possible Cases are : Purchase Order, PO Release, Manual, and RTV.
OSP_SI	VARCHAR2	(2)		Indicates the OSP SI.
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER			Standard Who column
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER			Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
PRIMARY_FLAG	VARCHAR2	(1)		Indicates whether it is a Primary Form ( Possible Values are Y , N and Null).
PRIMARY_FORM_ID	NUMBER			Indicates the Primary Form Identifier if any.
FIN_YEAR	NUMBER			Indicates the Financial year.
PRINT_ORIGINAL	VARCHAR2	(2)		Indicates the Print is Original(Possible values are Y,N and Null).
PRINT_DUPLICATE	VARCHAR2	(2)		Indicates the Print is Duplicate(Possible values are Y,N and Null).
PRINT_CNT	NUMBER			Indicates the Print Count.
OBJECT_VERSION_NUMBER	NUMBER			Object version number

Query Text

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


SELECT FORM_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      ORGANIZATION_ID
,      LOCATION_ID
,      FORM_NUMBER
,      PO_HEADER_ID
,      OTH_DOC_ID
,      PROCESS_TIME
,      ISSUE_APPROVED
,      ISSUE_DATE
,      RECEIPT_APPROVED
,      RECEIPT_DATE
,      DR_REGISTER
,      DR_REG_REGISTER_ID
,      DR_REG_SLNO
,      DR_REG_ENTRY_DATE
,      CR_REGISTER
,      CR_REG_REGISTER_ID
,      CR_REG_SLNO
,      CR_REG_ENTRY_DATE
,      CANCEL_FLAG
,      SOURCE
,      OSP_SI
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PRIMARY_FLAG
,      PRIMARY_FORM_ID
,      FIN_YEAR
,      PRINT_ORIGINAL
,      PRINT_DUPLICATE
,      PRINT_CNT
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_PO_OSP_HDRS;

Dependencies

[top of page]

JA.JAI_PO_OSP_HDRS does not reference any database object

JA.JAI_PO_OSP_HDRS is referenced by following:

APPS: JAI_PO_OSP_HDRS