VIEW: JA.JAI_OPM_OSP_HDRS#

Source

View Text - Preformatted

select OSP_HEADER_ID OSP_HEADER_ID, PO_ID PO_ID, TRANSACTION_DATE TRANSACTION_DATE, USER_REFERENCE USER_REFERENCE, TOT_MODVAT_CLAIMED TOT_MODVAT_CLAIMED, TOT_EXCISE_PAID TOT_EXCISE_PAID, FINAL_RECEIPT FINAL_RECEIPT, ORIGINAL_DUE_DATE ORIGINAL_DUE_DATE, EXTENDED_DUE_DATE EXTENDED_DUE_DATE, RECEIVABLE_EXCISE RECEIVABLE_EXCISE, PAYABLE_EXCISE PAYABLE_EXCISE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REGISTER_SELECTED REGISTER_SELECTED, BATCH_STATUS BATCH_STATUS, BATCH_CLOSE_DATE BATCH_CLOSE_DATE, FORM_NAME FORM_NAME, ORGN_CODE ORGN_CODE, WHSE_CODE WHSE_CODE, POST_RG23_II POST_RG23_II, FIN_YEAR FIN_YEAR, FORM_NUMBER FORM_NUMBER, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, FORMULA_ID_REF FORMULA_ID_REF, ORGANIZATION_ID ORGANIZATION_ID from "JA"."JAI_OPM_OSP_HDRS"

View Text - HTML Formatted

SELECT OSP_HEADER_ID OSP_HEADER_ID
, PO_ID PO_ID
, TRANSACTION_DATE TRANSACTION_DATE
, USER_REFERENCE USER_REFERENCE
, TOT_MODVAT_CLAIMED TOT_MODVAT_CLAIMED
, TOT_EXCISE_PAID TOT_EXCISE_PAID
, FINAL_RECEIPT FINAL_RECEIPT
, ORIGINAL_DUE_DATE ORIGINAL_DUE_DATE
, EXTENDED_DUE_DATE EXTENDED_DUE_DATE
, RECEIVABLE_EXCISE RECEIVABLE_EXCISE
, PAYABLE_EXCISE PAYABLE_EXCISE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REGISTER_SELECTED REGISTER_SELECTED
, BATCH_STATUS BATCH_STATUS
, BATCH_CLOSE_DATE BATCH_CLOSE_DATE
, FORM_NAME FORM_NAME
, ORGN_CODE ORGN_CODE
, WHSE_CODE WHSE_CODE
, POST_RG23_II POST_RG23_II
, FIN_YEAR FIN_YEAR
, FORM_NUMBER FORM_NUMBER
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, FORMULA_ID_REF FORMULA_ID_REF
, ORGANIZATION_ID ORGANIZATION_ID
FROM "JA"."JAI_OPM_OSP_HDRS"