VIEW: JA.JAI_PO_OSP_LINES#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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