VIEW: JA.JAI_CMN_LINES#

Source

View Text - Preformatted

select CMN_LINE_ID CMN_LINE_ID, SHIPMENT_NUMBER SHIPMENT_NUMBER, PO_HEADER_ID PO_HEADER_ID, PO_LINE_ID PO_LINE_ID, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID, PO_NUMBER PO_NUMBER, LINE_NUM LINE_NUM, SHIPMENT_LINE_NUM SHIPMENT_LINE_NUM, HEADER_INTERFACE_ID HEADER_INTERFACE_ID, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID, INTERFACE_TRANSACTION_ID INTERFACE_TRANSACTION_ID, SHIPMENT_LINE_ID SHIPMENT_LINE_ID, ITEM_ID ITEM_ID, QUANTITY QUANTITY, EXCISE_INV_NUMBER EXCISE_INV_NUMBER, EXCISE_INV_DATE EXCISE_INV_DATE, CURRENCY_CODE CURRENCY_CODE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PO_UNIT_PRICE PO_UNIT_PRICE, UOM_CODE UOM_CODE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "JA"."JAI_CMN_LINES"

View Text - HTML Formatted

SELECT CMN_LINE_ID CMN_LINE_ID
, SHIPMENT_NUMBER SHIPMENT_NUMBER
, PO_HEADER_ID PO_HEADER_ID
, PO_LINE_ID PO_LINE_ID
, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID
, PO_NUMBER PO_NUMBER
, LINE_NUM LINE_NUM
, SHIPMENT_LINE_NUM SHIPMENT_LINE_NUM
, HEADER_INTERFACE_ID HEADER_INTERFACE_ID
, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID
, INTERFACE_TRANSACTION_ID INTERFACE_TRANSACTION_ID
, SHIPMENT_LINE_ID SHIPMENT_LINE_ID
, ITEM_ID ITEM_ID
, QUANTITY QUANTITY
, EXCISE_INV_NUMBER EXCISE_INV_NUMBER
, EXCISE_INV_DATE EXCISE_INV_DATE
, CURRENCY_CODE CURRENCY_CODE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PO_UNIT_PRICE PO_UNIT_PRICE
, UOM_CODE UOM_CODE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "JA"."JAI_CMN_LINES"