VIEW: AR.AR_BPA_TEMPLATES_B#

Source

View Text - Preformatted

select TEMPLATE_ID TEMPLATE_ID, REF_TEMPLATE_ID REF_TEMPLATE_ID, PRIMARY_APP_ID PRIMARY_APP_ID, SECONDARY_APP_ID SECONDARY_APP_ID, CONTRACT_LINE_TYPE CONTRACT_LINE_TYPE, SHOW_LINE_DETAILS_FLAG SHOW_LINE_DETAILS_FLAG, SHOW_LINE_GROUPING_FLAG SHOW_LINE_GROUPING_FLAG, 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, SHOW_SEQUENCE_FLAG SHOW_SEQUENCE_FLAG, SHOW_ITEMIZED_TAX_FLAG SHOW_ITEMIZED_TAX_FLAG, USE_AR_TAXOPTION_FLAG USE_AR_TAXOPTION_FLAG, TAX_SUMMARY_GRPBY TAX_SUMMARY_GRPBY, COMPLETED_FLAG COMPLETED_FLAG, SEEDED_FLAG SEEDED_FLAG, HEADER_HEIGHT HEADER_HEIGHT, FOOTER_HEIGHT FOOTER_HEIGHT, HEADER_SHOW_TYPE HEADER_SHOW_TYPE, FOOTER_SHOW_TYPE FOOTER_SHOW_TYPE, PAGE_WIDTH PAGE_WIDTH, PAGE_HEIGHT PAGE_HEIGHT, TOP_MARGIN TOP_MARGIN, BOTTOM_MARGIN BOTTOM_MARGIN, LEFT_MARGIN LEFT_MARGIN, RIGHT_MARGIN RIGHT_MARGIN, PAGE_NUMBER_LOC PAGE_NUMBER_LOC, PAGE_SETUP_ID PAGE_SETUP_ID, SECONDARY_HEADER_HEIGHT SECONDARY_HEADER_HEIGHT, EXTERNAL_TEMPLATE_FLAG EXTERNAL_TEMPLATE_FLAG, TEMPLATE_TYPE TEMPLATE_TYPE, PRINT_LINES_FLAG PRINT_LINES_FLAG, PRINT_FONT_FAMILY PRINT_FONT_FAMILY, PRINT_FONT_SIZE PRINT_FONT_SIZE, TRX_CLASS TRX_CLASS, TEMPLATE_FORMAT TEMPLATE_FORMAT, ZD_EDITION_NAME ZD_EDITION_NAME from "AR"."AR_BPA_TEMPLATES_B"

View Text - HTML Formatted

SELECT TEMPLATE_ID TEMPLATE_ID
, REF_TEMPLATE_ID REF_TEMPLATE_ID
, PRIMARY_APP_ID PRIMARY_APP_ID
, SECONDARY_APP_ID SECONDARY_APP_ID
, CONTRACT_LINE_TYPE CONTRACT_LINE_TYPE
, SHOW_LINE_DETAILS_FLAG SHOW_LINE_DETAILS_FLAG
, SHOW_LINE_GROUPING_FLAG SHOW_LINE_GROUPING_FLAG
, 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
, SHOW_SEQUENCE_FLAG SHOW_SEQUENCE_FLAG
, SHOW_ITEMIZED_TAX_FLAG SHOW_ITEMIZED_TAX_FLAG
, USE_AR_TAXOPTION_FLAG USE_AR_TAXOPTION_FLAG
, TAX_SUMMARY_GRPBY TAX_SUMMARY_GRPBY
, COMPLETED_FLAG COMPLETED_FLAG
, SEEDED_FLAG SEEDED_FLAG
, HEADER_HEIGHT HEADER_HEIGHT
, FOOTER_HEIGHT FOOTER_HEIGHT
, HEADER_SHOW_TYPE HEADER_SHOW_TYPE
, FOOTER_SHOW_TYPE FOOTER_SHOW_TYPE
, PAGE_WIDTH PAGE_WIDTH
, PAGE_HEIGHT PAGE_HEIGHT
, TOP_MARGIN TOP_MARGIN
, BOTTOM_MARGIN BOTTOM_MARGIN
, LEFT_MARGIN LEFT_MARGIN
, RIGHT_MARGIN RIGHT_MARGIN
, PAGE_NUMBER_LOC PAGE_NUMBER_LOC
, PAGE_SETUP_ID PAGE_SETUP_ID
, SECONDARY_HEADER_HEIGHT SECONDARY_HEADER_HEIGHT
, EXTERNAL_TEMPLATE_FLAG EXTERNAL_TEMPLATE_FLAG
, TEMPLATE_TYPE TEMPLATE_TYPE
, PRINT_LINES_FLAG PRINT_LINES_FLAG
, PRINT_FONT_FAMILY PRINT_FONT_FAMILY
, PRINT_FONT_SIZE PRINT_FONT_SIZE
, TRX_CLASS TRX_CLASS
, TEMPLATE_FORMAT TEMPLATE_FORMAT
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "AR"."AR_BPA_TEMPLATES_B"