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.BIM_DIMV_SOURCE_LISTS

Object Details

Object Name:	BIM_DIMV_SOURCE_LISTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BIM.BIM_DIMV_SOURCE_LISTS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

BIM_DIMV_SOURCE_LISTS is a view showing all source lists.
.

[View Source]

Columns

Name	Datatype	Length	Comments
SOURCE_LIST_ID	NUMBER		AMS_IMP_LIST_HEADERS_ALL.IMPORT_LIST_HEADER_ID
SOURCE_LIST_NAME	VARCHAR2	(120)	AMS_IMP_LIST_HEADERS_ALL.NAME
SOURCE_LIST_VERSION	VARCHAR2	(10)	AMS_IMP_LIST_HEADERS_ALL.VERSION
SOURCE_STATUS_CODE	VARCHAR2	(30)	AMS_IMP_LIST_HEADERS_ALL.STATUS_CODE
SOURCE_STATUS_DATE	DATE		AMS_IMP_LIST_HEADERS_ALL.STATUS_DATE
SOURCE_STATUS_NAME	VARCHAR2	(120)	AMS_USER_STATUSES_VL.NAME
SOURCE_STATUS_DESCRIPTION	VARCHAR2	(4000)	AMS_USER_STATUSES_VL.DESCRIPTION
SOURCE_ORG_ID	NUMBER		source organization id
VENDOR_ID	NUMBER		vendor id
PIN_ID	NUMBER		pin id
IMPORT_LIST_TYPE_ID	NUMBER		AMS_IMP_LIST_HEADERS_ALL.LIST_SOURCE_TYPE_ID
DESCRIPTION	VARCHAR2	(4000)	description
TRANSACTIONAL_COST	NUMBER		transactional cost
TRANSACTIONAL_CURRENCY_CODE	VARCHAR2	(15)	transactional currency code
FUNCTIONAL_COST	NUMBER		funcational cost
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)	funcational currency code
CREATION_DATE	DATE		standard who column

Query Text

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


SELECT SOURCE_LIST_ID
,      SOURCE_LIST_NAME
,      SOURCE_LIST_VERSION
,      SOURCE_STATUS_CODE
,      SOURCE_STATUS_DATE
,      SOURCE_STATUS_NAME
,      SOURCE_STATUS_DESCRIPTION
,      SOURCE_ORG_ID
,      VENDOR_ID
,      PIN_ID
,      IMPORT_LIST_TYPE_ID
,      DESCRIPTION
,      TRANSACTIONAL_COST
,      TRANSACTIONAL_CURRENCY_CODE
,      FUNCTIONAL_COST
,      FUNCTIONAL_CURRENCY_CODE
,      CREATION_DATE
FROM APPS.BIM_DIMV_SOURCE_LISTS;

Dependencies

[top of page]

APPS.BIM_DIMV_SOURCE_LISTS references the following:

APPS: AMS_IMP_LIST_HEADERS_ALL; AMS_USER_STATUSES_VL; FND_GLOBAL - show dependent code; FND_LOOKUPS

APPS.BIM_DIMV_SOURCE_LISTS is referenced by following:

APPS: BIM_SUMV_CAMP_RESP; BIM_SUMV_SLIST_PROFIT