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

Object Details

Object Name:	POFV_APPROVED_SUPPLIER_LISTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POFV_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	Comments
APPROVED_SUPPLIER_LIST_ID	NUMBER
USING_ORGANIZATION_ID	NUMBER
USING_ORGANIZATION_CODE	VARCHAR2	(3)
USING_ORGANIZATION_NAME	VARCHAR2	(240)
ASL_STATUS	VARCHAR2	(25)
ASL_STATUS_DESCRIPTION	VARCHAR2	(240)
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)
_DF	CHAR	(35)
OWNING_ORGANIZATION_ID	NUMBER
OWNING_ORGANIZATION_CODE	VARCHAR2	(3)
OWNING_ORGANIZATION_NAME	VARCHAR2	(240)
MANUFACTURER_ID	NUMBER
MANUFACTURER_NAME	VARCHAR2	(30)
SUPPLIER_ID	NUMBER
SUPPLIER_NAME	VARCHAR2	(240)
SUPPLIER_SITE_ID	NUMBER
SUPPLIER_SITE	VARCHAR2	(15)
SITE_OPERATING_UNIT_ID	NUMBER
SITE_OPERATING_UNIT_NAME	VARCHAR2	(240)
ITEM_ID	NUMBER
_KF:ITEM_NUMBER::_CO	CHAR	(15)
ITEM_DESCRIPTION	VARCHAR2	(240)
CATEGORY_ID	NUMBER
_KF:CATEGORY::_CO	CHAR	(15)
MANUFACTURER_ASL_ID	NUMBER
PURCHASING_UNIT_OF_MEASURE	VARCHAR2	(25)
UOM_CLASS	VARCHAR2	(10)
UOM_DESCRIPTION	VARCHAR2	(50)
SCHEDULER_ID	NUMBER
SCHEDULER_EMPLOYEE_NUMBER	VARCHAR2	(30)
SCHEDULER_NAME	VARCHAR2	(240)
CREATED_DATE	DATE
CREATED_BY	NUMBER		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_DATE	DATE
LAST_UPDATED_BY	NUMBER		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PRICE_UPDATE_TOLERANCE	NUMBER
OCESSING_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_REP_FLAG	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
,      USING_ORGANIZATION_CODE
,      USING_ORGANIZATION_NAME
,      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
,      _DF
,      OWNING_ORGANIZATION_ID
,      OWNING_ORGANIZATION_CODE
,      OWNING_ORGANIZATION_NAME
,      MANUFACTURER_ID
,      MANUFACTURER_NAME
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE
,      SITE_OPERATING_UNIT_ID
,      SITE_OPERATING_UNIT_NAME
,      ITEM_ID
,      _KF:ITEM_NUMBER::_CO
,      ITEM_DESCRIPTION
,      CATEGORY_ID
,      _KF:CATEGORY::_CO
,      MANUFACTURER_ASL_ID
,      PURCHASING_UNIT_OF_MEASURE
,      UOM_CLASS
,      UOM_DESCRIPTION
,      SCHEDULER_ID
,      SCHEDULER_EMPLOYEE_NUMBER
,      SCHEDULER_NAME
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      PRICE_UPDATE_TOLERANCE
,      OCESSING_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_REP_FLAG
,      VMI_REPLENISHMENT_APPROVAL
,      _LA:CONSIGNED_FROM_SUPP_FLAG
,      LAST_BILLING_DATE
,      CONSIGNED_BILLING_CYCLE
FROM APPS.POFV_APPROVED_SUPPLIER_LISTS;

Dependencies

[top of page]

APPS.POFV_APPROVED_SUPPLIER_LISTS references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; MTL_CATEGORIES; MTL_MANUFACTURERS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS; MTL_UNITS_OF_MEASURE; PER_PEOPLE_F; PO_APPROVED_SUPPLIER_LIST; PO_ASL_ATTRIBUTES; PO_ASL_STATUSES; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.POFV_APPROVED_SUPPLIER_LISTS is not referenced by any database object