VIEW: IBY.IBY_GEN_DOCUMENT_LINES#

Source

View Text - Preformatted

select CALLING_APP_ID CALLING_APP_ID, CALLING_APP_DOCUMENT_LINE_CODE CALLING_APP_DOCUMENT_LINE_CODE, CALLING_APP_DOC_UNIQUE_REF1 CALLING_APP_DOC_UNIQUE_REF1, CALLING_APP_DOC_UNIQUE_REF2 CALLING_APP_DOC_UNIQUE_REF2, CALLING_APP_DOC_UNIQUE_REF3 CALLING_APP_DOC_UNIQUE_REF3, CALLING_APP_DOC_UNIQUE_REF4 CALLING_APP_DOC_UNIQUE_REF4, CALLING_APP_DOC_UNIQUE_REF5 CALLING_APP_DOC_UNIQUE_REF5, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PO_NUMBER PO_NUMBER, LINE_NUMBER LINE_NUMBER, LINE_TYPE LINE_TYPE, LINE_NAME LINE_NAME, LINE_AMOUNT LINE_AMOUNT, DESCRIPTION DESCRIPTION, UNIT_PRICE UNIT_PRICE, QUANTITY QUANTITY, UNIT_OF_MEASURE UNIT_OF_MEASURE from "IBY"."IBY_GEN_DOCUMENT_LINES"

View Text - HTML Formatted

SELECT CALLING_APP_ID CALLING_APP_ID
, CALLING_APP_DOCUMENT_LINE_CODE CALLING_APP_DOCUMENT_LINE_CODE
, CALLING_APP_DOC_UNIQUE_REF1 CALLING_APP_DOC_UNIQUE_REF1
, CALLING_APP_DOC_UNIQUE_REF2 CALLING_APP_DOC_UNIQUE_REF2
, CALLING_APP_DOC_UNIQUE_REF3 CALLING_APP_DOC_UNIQUE_REF3
, CALLING_APP_DOC_UNIQUE_REF4 CALLING_APP_DOC_UNIQUE_REF4
, CALLING_APP_DOC_UNIQUE_REF5 CALLING_APP_DOC_UNIQUE_REF5
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PO_NUMBER PO_NUMBER
, LINE_NUMBER LINE_NUMBER
, LINE_TYPE LINE_TYPE
, LINE_NAME LINE_NAME
, LINE_AMOUNT LINE_AMOUNT
, DESCRIPTION DESCRIPTION
, UNIT_PRICE UNIT_PRICE
, QUANTITY QUANTITY
, UNIT_OF_MEASURE UNIT_OF_MEASURE
FROM "IBY"."IBY_GEN_DOCUMENT_LINES"