AR_BPA_TEMPLATES

Details

Schema: FUSION
Object owner: AR
Object type: VIEW

Columns

Name
ROW_ID TEMPLATE_ID REF_TEMPLATE_ID PRIMARY_APP_ID SECONDARY_APP_ID CONTRACT_LINE_TYPE SHOW_LINE_DETAILS_FLAG SHOW_LINE_GROUPING_FLAG LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN SHOW_SEQUENCE_FLAG SHOW_ITEMIZED_TAX_FLAG USE_AR_TAXOPTION_FLAG TAX_SUMMARY_GRPBY COMPLETED_FLAG SEEDED_FLAG TEMPLATE_NAME TEMPLATE_DESCRIPTION HEADER_HEIGHT FOOTER_HEIGHT HEADER_SHOW_TYPE FOOTER_SHOW_TYPE PAGE_WIDTH PAGE_HEIGHT TOP_MARGIN BOTTOM_MARGIN LEFT_MARGIN RIGHT_MARGIN PAGE_NUMBER_LOC PAGE_SETUP_ID SECONDARY_HEADER_HEIGHT EXTERNAL_TEMPLATE_FLAG TEMPLATE_TYPE PRINT_LINES_FLAG PRINT_FONT_FAMILY PRINT_FONT_SIZE TRX_CLASS TEMPLATE_FORMAT

Name

ROW_ID

TEMPLATE_ID

REF_TEMPLATE_ID

PRIMARY_APP_ID

SECONDARY_APP_ID

CONTRACT_LINE_TYPE

SHOW_LINE_DETAILS_FLAG

SHOW_LINE_GROUPING_FLAG

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

SHOW_SEQUENCE_FLAG

SHOW_ITEMIZED_TAX_FLAG

USE_AR_TAXOPTION_FLAG

TAX_SUMMARY_GRPBY

COMPLETED_FLAG

SEEDED_FLAG

TEMPLATE_NAME

TEMPLATE_DESCRIPTION

HEADER_HEIGHT

FOOTER_HEIGHT

HEADER_SHOW_TYPE

FOOTER_SHOW_TYPE

PAGE_WIDTH

PAGE_HEIGHT

TOP_MARGIN

BOTTOM_MARGIN

LEFT_MARGIN

RIGHT_MARGIN

PAGE_NUMBER_LOC

PAGE_SETUP_ID

SECONDARY_HEADER_HEIGHT

EXTERNAL_TEMPLATE_FLAG

TEMPLATE_TYPE

PRINT_LINES_FLAG

PRINT_FONT_FAMILY

PRINT_FONT_SIZE

TRX_CLASS

TEMPLATE_FORMAT

Query

SQL_Statement
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')

SQL_Statement

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')