[Home] [Help] [Dependency Information]
Object Name: | JAI_PO_OSP_LINES# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
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 |
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#;
|
|
|