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

VIEW: JA.JAI_PO_OSP_LINES#

Object Details
Object Name: JAI_PO_OSP_LINES#
Object Type: VIEW
Owner: JA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
FORM_ID NUMBER
Yes
LINE_ID NUMBER
Yes
PO_LINE_ID NUMBER

PO_DISTRIBUTION_ID NUMBER

ITEM_ID NUMBER
Yes
WIP_ENTITY_ID NUMBER

WIP_LINE_ID NUMBER

WIP_REPETITIVE_SCHEDULE_ID NUMBER

WIP_OPERATION_SEQUENCE_NUM NUMBER

ASSEMBLY_ID NUMBER

IDENTIFICATION VARCHAR2 (100)
DESPATCH_QTY NUMBER
Yes
ITEM_UOM VARCHAR2 (25) Yes
ITEM_VALUE NUMBER
Yes
TARIFF_CODE VARCHAR2 (50)
EXCISE_RATE NUMBER
Yes
PROCESS_REQD VARCHAR2 (100)
RETURN_QTY NUMBER

PARENT_ITEM_ID NUMBER

COMP_QTY_PA NUMBER

BAL_PARENT_ITEM_QTY NUMBER

SOURCE_CODE VARCHAR2 (2)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

DISPATCHED_QTY NUMBER

ORIGINAL_QTY NUMBER

SCRAP_QTY NUMBER

OBJECT_VERSION_NUMBER 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# references the following:

SchemaJA
TableJAI_PO_OSP_LINES
JA.JAI_PO_OSP_LINES# is referenced by following:

SchemaAPPS
SynonymJAI_PO_OSP_LINES