VIEW: JA.JAI_CMN_ST_FORM_DTLS#

Source

View Text - Preformatted

select ST_HDR_ID ST_HDR_ID, ST_DTL_ID ST_DTL_ID, HEADER_ID HEADER_ID, LINE_ID LINE_ID, LOCATION_ID LOCATION_ID, ORGANIZATION_ID ORGANIZATION_ID, TAX_ID TAX_ID, TAX_LINE_NO TAX_LINE_NO, INVOICE_ID INVOICE_ID, ISSUE_RECEIPT_FLAG ISSUE_RECEIPT_FLAG, TAX_TARGET_AMOUNT TAX_TARGET_AMOUNT, MATCHED_AMOUNT MATCHED_AMOUNT, PO_NUM PO_NUM, DOC_TYPE DOC_TYPE, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID, RCV_TRANSACTION_ID RCV_TRANSACTION_ID, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, ORDER_FLAG ORDER_FLAG, ORDER_NUMBER ORDER_NUMBER, TRX_TYPE_ID TRX_TYPE_ID, TRX_NUMBER TRX_NUMBER, 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, MIGRATED_HDR MIGRATED_HDR, MIGRATED_DTL MIGRATED_DTL, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER from "JA"."JAI_CMN_ST_FORM_DTLS"

View Text - HTML Formatted

SELECT ST_HDR_ID ST_HDR_ID
, ST_DTL_ID ST_DTL_ID
, HEADER_ID HEADER_ID
, LINE_ID LINE_ID
, LOCATION_ID LOCATION_ID
, ORGANIZATION_ID ORGANIZATION_ID
, TAX_ID TAX_ID
, TAX_LINE_NO TAX_LINE_NO
, INVOICE_ID INVOICE_ID
, ISSUE_RECEIPT_FLAG ISSUE_RECEIPT_FLAG
, TAX_TARGET_AMOUNT TAX_TARGET_AMOUNT
, MATCHED_AMOUNT MATCHED_AMOUNT
, PO_NUM PO_NUM
, DOC_TYPE DOC_TYPE
, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID
, RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, ORDER_FLAG ORDER_FLAG
, ORDER_NUMBER ORDER_NUMBER
, TRX_TYPE_ID TRX_TYPE_ID
, TRX_NUMBER TRX_NUMBER
, 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
, MIGRATED_HDR MIGRATED_HDR
, MIGRATED_DTL MIGRATED_DTL
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER
FROM "JA"."JAI_CMN_ST_FORM_DTLS"