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

Object Details

Object Name:	POBV_APPROVED_SUPPLIER_LISTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POBV_APPROVED_SUPPLIER_LISTS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows lists of approved suppliers, sites, and items.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
APPROVED_SUPPLIER_LIST_ID	NUMBER		Yes
USING_ORGANIZATION_ID	NUMBER		Yes
ASL_STATUS	VARCHAR2	(25)	Yes
ASL_STATUS_DESCRIPTION	VARCHAR2	(240)	Yes
DESCRIPTION	VARCHAR2	(240)
REVIEW_BY_DATE	DATE
_LA:SUPPLIER_BUSINESS_TYPE	CHAR	(84)
SUPPLIER_PRODUCT_NUMBER	VARCHAR2	(25)
_LA:DOCUMENT_SOURCING_METHOD	CHAR	(88)
_LA:RELEASE_CREATION_METHOD	CHAR	(86)
_LA:ENABLE_PLAN_SCHEDULE	CHAR	(71)
_LA:ENABLE_SHIP_SCHEDULE	CHAR	(71)
_LA:ENABLE_AUTO_SCHEDULE	CHAR	(70)
_LA:PLAN_SCHEDULE_TYPE	CHAR	(79)
_LA:SHIP_SCHEDULE_TYPE	CHAR	(79)
OWNING_ORGANIZATION_ID	NUMBER		Yes
MANUFACTURER_ID	NUMBER
SUPPLIER_ID	NUMBER
SUPPLIER_SITE_ID	NUMBER
ITEM_ID	NUMBER
CATEGORY_ID	NUMBER
MANUFACTURER_ASL_ID	NUMBER
PURCHASING_UNIT_OF_MEASURE	VARCHAR2	(25)
SCHEDULER_ID	NUMBER
CREATED_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PRICE_UPDATE_TOLERANCE	NUMBER
PROCESSING_LEAD_TIME	NUMBER
MIN_ORDER_QTY	NUMBER
DELIVERY_CALENDAR	VARCHAR2	(10)
COUNTRY_OF_ORIGIN_CODE	VARCHAR2	(2)
_LA:ENABLE_VMI_FLAG	CHAR	(61)
VMI_MIN_QTY	NUMBER
VMI_MAX_QTY	NUMBER
_LA:ENABLE_VMI_AUTO_REPLE_FG	CHAR	(76)
VMI_REPLENISHMENT_APPROVAL	VARCHAR2	(30)
_LA:CONSIGNED_FROM_SUPP_FLAG	CHAR	(74)
LAST_BILLING_DATE	DATE
CONSIGNED_BILLING_CYCLE	NUMBER

Query Text

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


SELECT APPROVED_SUPPLIER_LIST_ID
,      USING_ORGANIZATION_ID
,      ASL_STATUS
,      ASL_STATUS_DESCRIPTION
,      DESCRIPTION
,      REVIEW_BY_DATE
,      _LA:SUPPLIER_BUSINESS_TYPE
,      SUPPLIER_PRODUCT_NUMBER
,      _LA:DOCUMENT_SOURCING_METHOD
,      _LA:RELEASE_CREATION_METHOD
,      _LA:ENABLE_PLAN_SCHEDULE
,      _LA:ENABLE_SHIP_SCHEDULE
,      _LA:ENABLE_AUTO_SCHEDULE
,      _LA:PLAN_SCHEDULE_TYPE
,      _LA:SHIP_SCHEDULE_TYPE
,      OWNING_ORGANIZATION_ID
,      MANUFACTURER_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      ITEM_ID
,      CATEGORY_ID
,      MANUFACTURER_ASL_ID
,      PURCHASING_UNIT_OF_MEASURE
,      SCHEDULER_ID
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      PRICE_UPDATE_TOLERANCE
,      PROCESSING_LEAD_TIME
,      MIN_ORDER_QTY
,      DELIVERY_CALENDAR
,      COUNTRY_OF_ORIGIN_CODE
,      _LA:ENABLE_VMI_FLAG
,      VMI_MIN_QTY
,      VMI_MAX_QTY
,      _LA:ENABLE_VMI_AUTO_REPLE_FG
,      VMI_REPLENISHMENT_APPROVAL
,      _LA:CONSIGNED_FROM_SUPP_FLAG
,      LAST_BILLING_DATE
,      CONSIGNED_BILLING_CYCLE
FROM APPS.POBV_APPROVED_SUPPLIER_LISTS;

Dependencies

[top of page]

APPS.POBV_APPROVED_SUPPLIER_LISTS references the following:

APPS: PO_APPROVED_SUPPLIER_LIST; PO_ASL_ATTRIBUTES; PO_ASL_STATUSES

APPS.POBV_APPROVED_SUPPLIER_LISTS is not referenced by any database object