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

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)
ASL_ID	NUMBER		ASL unique identifier
OWNING_ORGANIZATION_ID	NUMBER		Organization that created record initially
OWNING_ORGANIZATION_CODE	VARCHAR2	(3)	Organization code that created record initially
OWNING_ORGANIZATION_NAME	VARCHAR2	(240)	Organization name that created record initially
SUPPLIER_ITEM_USING_ORG_ID	NUMBER		Organization unique identifier using the organization. (-1 if global)
SUPPLIER_ITEM_USING_ORG_CODE	VARCHAR2	(3)	Organization code using the organization. (-1 if global)
SUPPLIER_ITEM_USING_ORG_NAME	VARCHAR2	(240)	Organization name using the organization. (-1 if global)
VENDOR_BUSINESS_TYPE	VARCHAR2	(25)	Business type of Distributor, Direct, or Manufacturer
VENDOR_BUSINESS_TYPE_DSP	VARCHAR2	(80)	Business type name of Distributor, Direct, or Manufacturer
VENDOR_ID	NUMBER		Vendor
MANUFACTURER_ID	NUMBER		Manufacturer
VENDOR_NAME	VARCHAR2	(240)	Vendor name
ASL_STATUS_ID	NUMBER		Approval/Certification status
ASL_STATUS_DSP	VARCHAR2	(25)	Approval/certification status name
ITEM_ID	NUMBER		Item
ITEM_NUM	VARCHAR2	(40)	Item
CATEGORY_ID	NUMBER		Category
COMMODITY	VARCHAR2	(163)	Commodity
VENDOR_SITE_ID	NUMBER		Vendor Site
VENDOR_SITE_CODE	VARCHAR2	(15)	Site code name
PRIMARY_VENDOR_ITEM	VARCHAR2	(25)	Supplier, Manufacturer, or Distributor item number
MANUFACTURER_ASL_ID	NUMBER		Manufacturer associated with distributor
ASL_MANUFACTURER	VARCHAR2	(30)	Manufacturer name associated with distributor
REVIEW_BY_DATE	DATE		Review by date
DOCUMENT_SOURCING_METHOD	VARCHAR2	(25)	Source from ASL documents or PO tables
DOCUMENT_SRCING_METHOD_DSP	VARCHAR2	(80)	Source from ASL documents or PO tables
RELEASE_GENERATION_METHOD	VARCHAR2	(25)	Blanket relelase created automatically
RELEASE_GEN_METHOD_DSP	VARCHAR2	(80)	Automatic release generation method
PURCHASING_UNIT_OF_MEASURE	VARCHAR2	(25)	Supplier unit of measure
ENABLE_PLAN_SCHEDULE_FLAG	VARCHAR2	(1)	Enable planning schedules
ENABLE_SHIP_SCHEDULE_FLAG	VARCHAR2	(1)	Enable shipping schedules
PLAN_SCHEDULE_TYPE	VARCHAR2	(25)	Default planning schedule type
PLAN_SCHEDULE_TYPE_DSP	VARCHAR2	(80)	Planning schedule type name
SHIP_SCHEDULE_TYPE	VARCHAR2	(25)	Default shipping schedule type
SHIP_SCHEDULE_TYPE_DSP	VARCHAR2	(80)	Shipping schedule type name
PLAN_BUCKET_PATTERN_ID	NUMBER		Default planning schedule bucket pattern
PLAN_BUCKET_PATTERN	VARCHAR2	(25)	Planning bucket pattern name
SHIP_BUCKET_PATTERN_ID	NUMBER		Default shipping schedule bucket pattern
SHIP_BUCKET_PATTERN	VARCHAR2	(25)	Shipping bucket pattern name
ENABLE_AUTOSCHEDULE_FLAG	VARCHAR2	(1)	Autoschedule enabled
ENABLE_AUTHORIZATIONS_FLAG	VARCHAR2	(1)	Authorizations enabled
SCHEDULER_ID	NUMBER		Scheduler
SCHEDULER_NAME	VARCHAR2	(240)	Schedulers name
SUPPLIER_ITEM_GLOBAL_FLAG	VARCHAR2	(1)	Item global flag
ATTRIBUTE_GLOBAL_FLAG	VARCHAR2	(1)	Descriptive flexfield segment
ATTRIBUTE_USING_ORG_ID	NUMBER		Descriptive flexfield segment
ATTRIBUTE_USING_ORG_CODE	VARCHAR2	(3)	Descriptive flexfield segment
ATTRIBUTE_USING_ORG_NAME	VARCHAR2	(240)	Descriptive flexfield segment
COMMENTS	VARCHAR2	(240)	Comments
BUYER_NAME	VARCHAR2	(240)	Buyer name
BUYER_ID	NUMBER		Buyer unique identifier
ITEM_DESCRIPTION	VARCHAR2	(240)	Item description
CREATION_DATE	DATE		Standard who column - date when this row was created.
CREATED_BY	NUMBER		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PRICE_UPDATE_TOLERANCE	NUMBER		Price Update Tolerance
DISABLE_FLAG	VARCHAR2	(1)	Indicates whether the ASL is disabled or not.
PROCESSING_LEAD_TIME	NUMBER
DELIVERY_CALENDAR	VARCHAR2	(10)
MIN_ORDER_QTY	NUMBER
FIXED_LOT_MULTIPLE	NUMBER
COUNTRY_OF_ORIGIN_CODE	VARCHAR2	(2)
ENABLE_VMI_FLAG	VARCHAR2	(1)	VMI enabled
ORG_ID	NUMBER		Organization identifier

Query Text

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


SELECT ROW_ID
,      ASL_ID
,      OWNING_ORGANIZATION_ID
,      OWNING_ORGANIZATION_CODE
,      OWNING_ORGANIZATION_NAME
,      SUPPLIER_ITEM_USING_ORG_ID
,      SUPPLIER_ITEM_USING_ORG_CODE
,      SUPPLIER_ITEM_USING_ORG_NAME
,      VENDOR_BUSINESS_TYPE
,      VENDOR_BUSINESS_TYPE_DSP
,      VENDOR_ID
,      MANUFACTURER_ID
,      VENDOR_NAME
,      ASL_STATUS_ID
,      ASL_STATUS_DSP
,      ITEM_ID
,      ITEM_NUM
,      CATEGORY_ID
,      COMMODITY
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      PRIMARY_VENDOR_ITEM
,      MANUFACTURER_ASL_ID
,      ASL_MANUFACTURER
,      REVIEW_BY_DATE
,      DOCUMENT_SOURCING_METHOD
,      DOCUMENT_SRCING_METHOD_DSP
,      RELEASE_GENERATION_METHOD
,      RELEASE_GEN_METHOD_DSP
,      PURCHASING_UNIT_OF_MEASURE
,      ENABLE_PLAN_SCHEDULE_FLAG
,      ENABLE_SHIP_SCHEDULE_FLAG
,      PLAN_SCHEDULE_TYPE
,      PLAN_SCHEDULE_TYPE_DSP
,      SHIP_SCHEDULE_TYPE
,      SHIP_SCHEDULE_TYPE_DSP
,      PLAN_BUCKET_PATTERN_ID
,      PLAN_BUCKET_PATTERN
,      SHIP_BUCKET_PATTERN_ID
,      SHIP_BUCKET_PATTERN
,      ENABLE_AUTOSCHEDULE_FLAG
,      ENABLE_AUTHORIZATIONS_FLAG
,      SCHEDULER_ID
,      SCHEDULER_NAME
,      SUPPLIER_ITEM_GLOBAL_FLAG
,      ATTRIBUTE_GLOBAL_FLAG
,      ATTRIBUTE_USING_ORG_ID
,      ATTRIBUTE_USING_ORG_CODE
,      ATTRIBUTE_USING_ORG_NAME
,      COMMENTS
,      BUYER_NAME
,      BUYER_ID
,      ITEM_DESCRIPTION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      PRICE_UPDATE_TOLERANCE
,      DISABLE_FLAG
,      PROCESSING_LEAD_TIME
,      DELIVERY_CALENDAR
,      MIN_ORDER_QTY
,      FIXED_LOT_MULTIPLE
,      COUNTRY_OF_ORIGIN_CODE
,      ENABLE_VMI_FLAG
,      ORG_ID
FROM APPS.PO_APPROVED_SUPPLIER_LIST_V;

Dependencies

[top of page]

APPS.PO_APPROVED_SUPPLIER_LIST_V references the following:

APPS: CHV_BUCKET_PATTERNS; FND_GLOBAL - show dependent code; HR_ALL_ORGANIZATION_UNITS_TL; HR_GENERAL - show dependent code; HR_ORG_UNITS_NO_JOIN; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; MTL_CATEGORIES_KFV; MTL_MANUFACTURERS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_KFV; PER_PEOPLE_F; PO_APPROVED_SUPPLIER_LIST; PO_ASL_ATTRIBUTES; PO_ASL_STATUSES; PO_LOOKUP_CODES; PO_VENDORS; PO_VENDOR_SITES

APPS.PO_APPROVED_SUPPLIER_LIST_V is not referenced by any database object