[Home] [Help] [Dependency Information]
Object Name: | BIM_DIMV_SOURCE_LISTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BIM.BIM_DIMV_SOURCE_LISTS |
Subobject Name: | |
Status: | VALID |
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.
.
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 |
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;
|
|
|