VIEW: JA.JAI_PO_REQUEST_T#

Source

View Text - Preformatted

select LINE_LOCATION_ID LINE_LOCATION_ID, TAX_LINE_NO TAX_LINE_NO, PO_LINE_ID PO_LINE_ID, PO_HEADER_ID PO_HEADER_ID, PRECEDENCE_1 PRECEDENCE_1, PRECEDENCE_2 PRECEDENCE_2, PRECEDENCE_3 PRECEDENCE_3, PRECEDENCE_4 PRECEDENCE_4, PRECEDENCE_5 PRECEDENCE_5, TAX_ID TAX_ID, CURRENCY CURRENCY, TAX_RATE TAX_RATE, QTY_RATE QTY_RATE, UOM UOM, TAX_AMOUNT TAX_AMOUNT, TAX_TYPE TAX_TYPE, VENDOR_ID VENDOR_ID, MODVAT_FLAG MODVAT_FLAG, LINE_FOCUS_ID LINE_FOCUS_ID, TAX_TARGET_AMOUNT TAX_TARGET_AMOUNT, 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, TAX_CATEGORY_ID TAX_CATEGORY_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PRECEDENCE_6 PRECEDENCE_6, PRECEDENCE_7 PRECEDENCE_7, PRECEDENCE_8 PRECEDENCE_8, PRECEDENCE_9 PRECEDENCE_9, PRECEDENCE_10 PRECEDENCE_10 from "JA"."JAI_PO_REQUEST_T"

View Text - HTML Formatted

SELECT LINE_LOCATION_ID LINE_LOCATION_ID
, TAX_LINE_NO TAX_LINE_NO
, PO_LINE_ID PO_LINE_ID
, PO_HEADER_ID PO_HEADER_ID
, PRECEDENCE_1 PRECEDENCE_1
, PRECEDENCE_2 PRECEDENCE_2
, PRECEDENCE_3 PRECEDENCE_3
, PRECEDENCE_4 PRECEDENCE_4
, PRECEDENCE_5 PRECEDENCE_5
, TAX_ID TAX_ID
, CURRENCY CURRENCY
, TAX_RATE TAX_RATE
, QTY_RATE QTY_RATE
, UOM UOM
, TAX_AMOUNT TAX_AMOUNT
, TAX_TYPE TAX_TYPE
, VENDOR_ID VENDOR_ID
, MODVAT_FLAG MODVAT_FLAG
, LINE_FOCUS_ID LINE_FOCUS_ID
, TAX_TARGET_AMOUNT TAX_TARGET_AMOUNT
, 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
, TAX_CATEGORY_ID TAX_CATEGORY_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PRECEDENCE_6 PRECEDENCE_6
, PRECEDENCE_7 PRECEDENCE_7
, PRECEDENCE_8 PRECEDENCE_8
, PRECEDENCE_9 PRECEDENCE_9
, PRECEDENCE_10 PRECEDENCE_10
FROM "JA"."JAI_PO_REQUEST_T"