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: ViewBIM.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 Mandatory 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:

SchemaAPPS
SynonymAMS_IMP_LIST_HEADERS_ALL
ViewAMS_USER_STATUSES_VL
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
APPS.BIM_DIMV_SOURCE_LISTS is referenced by following:

SchemaAPPS
ViewBIM_SUMV_CAMP_RESP
ViewBIM_SUMV_SLIST_PROFIT