VIEW: APPS.AR_BPA_TEMPLATES_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.TEMPLATE_ID, B.REF_TEMPLATE_ID, B.PRIMARY_APP_ID, B.SECONDARY_APP_ID, B.CONTRACT_LINE_TYPE, B.SHOW_LINE_DETAILS_FLAG, B.SHOW_LINE_GROUPING_FLAG, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.SHOW_SEQUENCE_FLAG, B.SHOW_ITEMIZED_TAX_FLAG, B.USE_AR_TAXOPTION_FLAG, B.TAX_SUMMARY_GRPBY, B.COMPLETED_FLAG, B.SEEDED_FLAG, T.TEMPLATE_NAME, T.TEMPLATE_DESCRIPTION, B.HEADER_HEIGHT , B.FOOTER_HEIGHT, B.HEADER_SHOW_TYPE, B.FOOTER_SHOW_TYPE , B.PAGE_WIDTH, B.PAGE_HEIGHT, B.TOP_MARGIN, B.BOTTOM_MARGIN, B.LEFT_MARGIN, B.RIGHT_MARGIN, B.PAGE_NUMBER_LOC, B.PAGE_SETUP_ID, B.SECONDARY_HEADER_HEIGHT, B.EXTERNAL_TEMPLATE_FLAG, B.TEMPLATE_TYPE, B.PRINT_LINES_FLAG, B.PRINT_FONT_FAMILY, B.PRINT_FONT_SIZE, B.TRX_CLASS, B.TEMPLATE_FORMAT from AR_BPA_TEMPLATES_TL T, AR_BPA_TEMPLATES_B B WHERE B.TEMPLATE_ID = T.TEMPLATE_ID and T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.TEMPLATE_ID
, B.REF_TEMPLATE_ID
, B.PRIMARY_APP_ID
, B.SECONDARY_APP_ID
, B.CONTRACT_LINE_TYPE
, B.SHOW_LINE_DETAILS_FLAG
, B.SHOW_LINE_GROUPING_FLAG
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.SHOW_SEQUENCE_FLAG
, B.SHOW_ITEMIZED_TAX_FLAG
, B.USE_AR_TAXOPTION_FLAG
, B.TAX_SUMMARY_GRPBY
, B.COMPLETED_FLAG
, B.SEEDED_FLAG
, T.TEMPLATE_NAME
, T.TEMPLATE_DESCRIPTION
, B.HEADER_HEIGHT
, B.FOOTER_HEIGHT
, B.HEADER_SHOW_TYPE
, B.FOOTER_SHOW_TYPE
, B.PAGE_WIDTH
, B.PAGE_HEIGHT
, B.TOP_MARGIN
, B.BOTTOM_MARGIN
, B.LEFT_MARGIN
, B.RIGHT_MARGIN
, B.PAGE_NUMBER_LOC
, B.PAGE_SETUP_ID
, B.SECONDARY_HEADER_HEIGHT
, B.EXTERNAL_TEMPLATE_FLAG
, B.TEMPLATE_TYPE
, B.PRINT_LINES_FLAG
, B.PRINT_FONT_FAMILY
, B.PRINT_FONT_SIZE
, B.TRX_CLASS
, B.TEMPLATE_FORMAT
FROM AR_BPA_TEMPLATES_TL T
, AR_BPA_TEMPLATES_B B
WHERE B.TEMPLATE_ID = T.TEMPLATE_ID
AND T.LANGUAGE = USERENV('LANG')