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]

VIEW: APPS.APBV_CARDS

Object Details

Object Name:	APBV_CARDS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLAP.APBV_CARDS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Based on AP_CARDS_ALL, this view contains credit card information.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EMPLOYEE_ID	NUMBER	(15)		Employee identifier
CARD_ID	NUMBER	(15)	Yes	Card identifier
LIMIT_OVERRIDE_AMOUNT	NUMBER			Reserved for future use
TRX_LIMIT_OVERRIDE_AMOUNT	NUMBER			Reserved for future use
PROFILE_ID	NUMBER	(15)		Card profile identifier
CARDMEMBER_NAME	VARCHAR2	(80)		Cardmember name
DEPARTMENT_NAME	VARCHAR2	(80)		Reserved for future use
PHYSICAL_CARD_FLAG	VARCHAR2	(1)		Reserved for future use
PAPER_STATEMENT_REQ_FLAG	VARCHAR2	(1)		Reserved for future use
LOCATION_ID	NUMBER	(15)		Location identifier
DESCRIPTION	VARCHAR2	(240)		Description
ORG_ID	NUMBER	(15)		Organization identifier
INACTIVE_DATE	DATE			Inactive date
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
_DF	CHAR	(22)
CARD_EXPIRATION_DATE	DATE
CARD_PROGRAM_ID	NUMBER	(15)	Yes
REQUEST_ID	NUMBER	(15)
CARD_REFERENCE_ID	NUMBER	(15)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EMPLOYEE_ID
,      CARD_ID
,      LIMIT_OVERRIDE_AMOUNT
,      TRX_LIMIT_OVERRIDE_AMOUNT
,      PROFILE_ID
,      CARDMEMBER_NAME
,      DEPARTMENT_NAME
,      PHYSICAL_CARD_FLAG
,      PAPER_STATEMENT_REQ_FLAG
,      LOCATION_ID
,      DESCRIPTION
,      ORG_ID
,      INACTIVE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      _DF
,      CARD_EXPIRATION_DATE
,      CARD_PROGRAM_ID
,      REQUEST_ID
,      CARD_REFERENCE_ID
FROM APPS.APBV_CARDS;

Dependencies

[top of page]

APPS.APBV_CARDS references the following:

APPS: AP_CARDS_ALL

APPS.APBV_CARDS is not referenced by any database object