eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AR.AR_BPA_TEMPLATES_B

Object Details

Object Name:	AR_BPA_TEMPLATES_B
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_BPA_TEMPLATES_B
Subobject Name:
Status:	VALID

Release 11i: Used by Bill Presentment Architecture

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_BPA_TEMPLATES_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID ZD_EDITION_NAME
AR_BPA_TEMPLATES_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SECONDARY_APP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TEMPLATE_ID	NUMBER	(15)	Yes	Unique identifier
REF_TEMPLATE_ID	NUMBER	(15)		Reference template that this template is copied from
PRIMARY_APP_ID	NUMBER	(15)	Yes	Application providing primary content for the template
SECONDARY_APP_ID	NUMBER	(15)		Application providing supplementary content for the template
CONTRACT_LINE_TYPE	VARCHAR2	(30)		Service or Usage line type from Oracle Contracts modules
SHOW_LINE_DETAILS_FLAG	VARCHAR2	(1)		Flag to indicate if lines can be drilled into, for more information
SHOW_LINE_GROUPING_FLAG	VARCHAR2	(1)		Flag to indicate if summary table for transaction lines are displayed
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SHOW_SEQUENCE_FLAG	VARCHAR2	(1)		Indicates if sequence number is displayed
SHOW_ITEMIZED_TAX_FLAG	VARCHAR2	(1)		Indicates if itemized tax information is displayed
USE_AR_TAXOPTION_FLAG	VARCHAR2	(1)		Indicates if AR Tax Printing Option is used
TAX_SUMMARY_GRPBY	VARCHAR2	(30)		Indicates grouping criteria for the tax summary section
COMPLETED_FLAG	VARCHAR2	(1)		Indicates if template is complete
SEEDED_FLAG	VARCHAR2	(1)		Indicates if template is seeded
HEADER_HEIGHT	NUMBER	(15)		Primary Header height
FOOTER_HEIGHT	NUMBER	(15)		Footer height
HEADER_SHOW_TYPE	VARCHAR2	(30)		Header display type
FOOTER_SHOW_TYPE	VARCHAR2	(30)		Footer display type
PAGE_WIDTH	NUMBER	(15)		Page width
PAGE_HEIGHT	NUMBER	(15)		Page height
TOP_MARGIN	NUMBER	(15)		Top margin
BOTTOM_MARGIN	NUMBER	(15)		Bottom margin
LEFT_MARGIN	NUMBER	(15)		Left margin
RIGHT_MARGIN	NUMBER	(15)		Right margin
PAGE_NUMBER_LOC	VARCHAR2	(30)		Page number location
PAGE_SETUP_ID	NUMBER	(15)		Foreign key to AR_BPA_PAGE_SETUPS_B
SECONDARY_HEADER_HEIGHT	NUMBER	(15)		Secondary Header height
EXTERNAL_TEMPLATE_FLAG	VARCHAR2	(1)		Indicates if template is uploaded
TEMPLATE_TYPE	VARCHAR2	(30)		Indicates template type
PRINT_LINES_FLAG	VARCHAR2	(1)		Indicates if billing lines are to be printed on OKS Invoice
PRINT_FONT_FAMILY	VARCHAR2	(30)		Stores the font name
PRINT_FONT_SIZE	VARCHAR2	(30)		Stores the font Size
TRX_CLASS	VARCHAR2	(30)		Identifies the transaction class for the template.
TEMPLATE_FORMAT	VARCHAR2	(30)		Display format of balance forward bills
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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;

Dependencies

[top of page]

AR.AR_BPA_TEMPLATES_B does not reference any database object

AR.AR_BPA_TEMPLATES_B is referenced by following:

AR: AR_BPA_TEMPLATES_B#