VIEW: JA.JAI_PO_OSP_CENVAT_HDRS#

Source

View Text - Preformatted

select OSP_HEADER_ID OSP_HEADER_ID, OSP_VENDOR_ID OSP_VENDOR_ID, TRANSACTION_DATE TRANSACTION_DATE, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, 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, PARENT_HEADER_ID PARENT_HEADER_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REGISTER_SELECTED REGISTER_SELECTED, ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, 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, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "JA"."JAI_PO_OSP_CENVAT_HDRS"

View Text - HTML Formatted

SELECT OSP_HEADER_ID OSP_HEADER_ID
, OSP_VENDOR_ID OSP_VENDOR_ID
, TRANSACTION_DATE TRANSACTION_DATE
, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, 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
, PARENT_HEADER_ID PARENT_HEADER_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REGISTER_SELECTED REGISTER_SELECTED
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, 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
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "JA"."JAI_PO_OSP_CENVAT_HDRS"