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_LINES

Object Details

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

Stores Line Level Information of the 57F4 Form.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_PO_OSP_LINES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_ID
JAI_PO_OSP_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FORM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FORM_ID	NUMBER		Yes	Indicates the Form Identifier.
LINE_ID	NUMBER		Yes	Indicates the Line Identifier.
PO_LINE_ID	NUMBER			Indicates the PO Line Identifier.
PO_DISTRIBUTION_ID	NUMBER			Indicates the PO Distribution Identifier.
ITEM_ID	NUMBER		Yes	Indicates the Item Identifier.
WIP_ENTITY_ID	NUMBER			Indicates the WIP Entity Identifier.
WIP_LINE_ID	NUMBER			Indicates the WIP Line Identifier.
WIP_REPETITIVE_SCHEDULE_ID	NUMBER			Indicates the WIP Repetitive Schedule Identifier.
WIP_OPERATION_SEQUENCE_NUM	NUMBER			Indicates the WIP operation Sequence.
ASSEMBLY_ID	NUMBER			Indicates the Assembly Identifier.
IDENTIFICATION	VARCHAR2	(100)		Indicates the Identification.
DESPATCH_QTY	NUMBER		Yes	Indicates the 57F4 Dispatch Quantity.
ITEM_UOM	VARCHAR2	(25)	Yes	Indicates the Item Unit of Measure.
ITEM_VALUE	NUMBER		Yes	Indicates the Item Value.
TARIFF_CODE	VARCHAR2	(50)		Indicates the Tariff.
EXCISE_RATE	NUMBER		Yes	Indicates the Excise Rate.
PROCESS_REQD	VARCHAR2	(100)		Indicates the Process Required(Possible values are Y,N and Null).
RETURN_QTY	NUMBER			Indicates the Quantity Returned. This will be Updated after Receipt IS DONE.
PARENT_ITEM_ID	NUMBER			Indicates the Parent Item Identifier.
COMP_QTY_PA	NUMBER			Indicates the No off required for Processing.
BAL_PARENT_ITEM_QTY	NUMBER			Indicates the Balance Parent Item Quantity.
SOURCE_CODE	VARCHAR2	(2)		Indicates the source code.
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
DISPATCHED_QTY	NUMBER			Indicates the Dispatched Quantity.
ORIGINAL_QTY	NUMBER			Indicates the Original 57F4 Quantity.
SCRAP_QTY	NUMBER			Indicates the scrap 57F4 Quantity.
OBJECT_VERSION_NUMBER	NUMBER			Object version number

Query Text

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


SELECT FORM_ID
,      LINE_ID
,      PO_LINE_ID
,      PO_DISTRIBUTION_ID
,      ITEM_ID
,      WIP_ENTITY_ID
,      WIP_LINE_ID
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_OPERATION_SEQUENCE_NUM
,      ASSEMBLY_ID
,      IDENTIFICATION
,      DESPATCH_QTY
,      ITEM_UOM
,      ITEM_VALUE
,      TARIFF_CODE
,      EXCISE_RATE
,      PROCESS_REQD
,      RETURN_QTY
,      PARENT_ITEM_ID
,      COMP_QTY_PA
,      BAL_PARENT_ITEM_QTY
,      SOURCE_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DISPATCHED_QTY
,      ORIGINAL_QTY
,      SCRAP_QTY
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_PO_OSP_LINES;

Dependencies

[top of page]

JA.JAI_PO_OSP_LINES does not reference any database object

JA.JAI_PO_OSP_LINES is referenced by following:

JA: JAI_PO_OSP_LINES#