Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AR_BPA_TEMPLATES_VL |
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')