[Home] [Help] [Dependency Information]
Object Name: | AR_BPA_TEMPLATES_B# |
---|---|
Object Type: | VIEW |
Owner: | AR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEMPLATE_ID | NUMBER | (15) | Yes | |
REF_TEMPLATE_ID | NUMBER | (15) | ||
PRIMARY_APP_ID | NUMBER | (15) | Yes | |
SECONDARY_APP_ID | NUMBER | (15) | ||
CONTRACT_LINE_TYPE | VARCHAR2 | (30) | ||
SHOW_LINE_DETAILS_FLAG | VARCHAR2 | (1) | ||
SHOW_LINE_GROUPING_FLAG | VARCHAR2 | (1) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
SHOW_SEQUENCE_FLAG | VARCHAR2 | (1) | ||
SHOW_ITEMIZED_TAX_FLAG | VARCHAR2 | (1) | ||
USE_AR_TAXOPTION_FLAG | VARCHAR2 | (1) | ||
TAX_SUMMARY_GRPBY | VARCHAR2 | (30) | ||
COMPLETED_FLAG | VARCHAR2 | (1) | ||
SEEDED_FLAG | VARCHAR2 | (1) | ||
HEADER_HEIGHT | NUMBER | (15) | ||
FOOTER_HEIGHT | NUMBER | (15) | ||
HEADER_SHOW_TYPE | VARCHAR2 | (30) | ||
FOOTER_SHOW_TYPE | VARCHAR2 | (30) | ||
PAGE_WIDTH | NUMBER | (15) | ||
PAGE_HEIGHT | NUMBER | (15) | ||
TOP_MARGIN | NUMBER | (15) | ||
BOTTOM_MARGIN | NUMBER | (15) | ||
LEFT_MARGIN | NUMBER | (15) | ||
RIGHT_MARGIN | NUMBER | (15) | ||
PAGE_NUMBER_LOC | VARCHAR2 | (30) | ||
PAGE_SETUP_ID | NUMBER | (15) | ||
SECONDARY_HEADER_HEIGHT | NUMBER | (15) | ||
EXTERNAL_TEMPLATE_FLAG | VARCHAR2 | (1) | ||
TEMPLATE_TYPE | VARCHAR2 | (30) | ||
PRINT_LINES_FLAG | VARCHAR2 | (1) | ||
PRINT_FONT_FAMILY | VARCHAR2 | (30) | ||
PRINT_FONT_SIZE | VARCHAR2 | (30) | ||
TRX_CLASS | VARCHAR2 | (30) | ||
TEMPLATE_FORMAT | VARCHAR2 | (30) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT TEMPLATE_ID
, REF_TEMPLATE_ID
, PRIMARY_APP_ID
, SECONDARY_APP_ID
, CONTRACT_LINE_TYPE
, SHOW_LINE_DETAILS_FLAG
, SHOW_LINE_GROUPING_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SHOW_SEQUENCE_FLAG
, SHOW_ITEMIZED_TAX_FLAG
, USE_AR_TAXOPTION_FLAG
, TAX_SUMMARY_GRPBY
, COMPLETED_FLAG
, SEEDED_FLAG
, 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
, ZD_EDITION_NAME
FROM AR.AR_BPA_TEMPLATES_B#;
|
|
|