VIEW: JA.JAI_AP_TDS_THHOLD_GRPS#

Source

View Text - Preformatted

select THRESHOLD_GRP_ID THRESHOLD_GRP_ID, VENDOR_ID VENDOR_ID, ORG_TAN_NUM ORG_TAN_NUM, VENDOR_PAN_NUM VENDOR_PAN_NUM, SECTION_TYPE SECTION_TYPE, SECTION_CODE SECTION_CODE, FIN_YEAR FIN_YEAR, TOTAL_INVOICE_AMOUNT TOTAL_INVOICE_AMOUNT, TOTAL_INVOICE_CANCEL_AMOUNT TOTAL_INVOICE_CANCEL_AMOUNT, TOTAL_INVOICE_APPLY_AMOUNT TOTAL_INVOICE_APPLY_AMOUNT, TOTAL_INVOICE_UNAPPLY_AMOUNT TOTAL_INVOICE_UNAPPLY_AMOUNT, TOTAL_TAX_PAID TOTAL_TAX_PAID, TOTAL_THHOLD_CHANGE_TAX_PAID TOTAL_THHOLD_CHANGE_TAX_PAID, CURRENT_THRESHOLD_SLAB_ID CURRENT_THRESHOLD_SLAB_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CUSTOMER_TYPE_LOOKUP_CODE CUSTOMER_TYPE_LOOKUP_CODE, REGIME_ID REGIME_ID, TOTAL_CALC_TAX_PAID TOTAL_CALC_TAX_PAID, THRESHOLD_HDR_ID THRESHOLD_HDR_ID from "JA"."JAI_AP_TDS_THHOLD_GRPS"

View Text - HTML Formatted

SELECT THRESHOLD_GRP_ID THRESHOLD_GRP_ID
, VENDOR_ID VENDOR_ID
, ORG_TAN_NUM ORG_TAN_NUM
, VENDOR_PAN_NUM VENDOR_PAN_NUM
, SECTION_TYPE SECTION_TYPE
, SECTION_CODE SECTION_CODE
, FIN_YEAR FIN_YEAR
, TOTAL_INVOICE_AMOUNT TOTAL_INVOICE_AMOUNT
, TOTAL_INVOICE_CANCEL_AMOUNT TOTAL_INVOICE_CANCEL_AMOUNT
, TOTAL_INVOICE_APPLY_AMOUNT TOTAL_INVOICE_APPLY_AMOUNT
, TOTAL_INVOICE_UNAPPLY_AMOUNT TOTAL_INVOICE_UNAPPLY_AMOUNT
, TOTAL_TAX_PAID TOTAL_TAX_PAID
, TOTAL_THHOLD_CHANGE_TAX_PAID TOTAL_THHOLD_CHANGE_TAX_PAID
, CURRENT_THRESHOLD_SLAB_ID CURRENT_THRESHOLD_SLAB_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CUSTOMER_TYPE_LOOKUP_CODE CUSTOMER_TYPE_LOOKUP_CODE
, REGIME_ID REGIME_ID
, TOTAL_CALC_TAX_PAID TOTAL_CALC_TAX_PAID
, THRESHOLD_HDR_ID THRESHOLD_HDR_ID
FROM "JA"."JAI_AP_TDS_THHOLD_GRPS"