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

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ASL_ID	NUMBER		Yes	ASL id
USING_ORGANIZATION_ID	NUMBER		Yes	Organization Using the ASL
LAST_UPDATE_DATE	DATE		Yes	Who Column
LAST_UPDATED_BY	NUMBER		Yes	Who Column
CREATION_DATE	DATE		Yes	Who Column
CREATED_BY	NUMBER		Yes	Who Column
DOCUMENT_SOURCING_METHOD	VARCHAR2	(25)		Not Used
RELEASE_GENERATION_METHOD	VARCHAR2	(25)		Automatic Release 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)		Planning Schedule Type
SHIP_SCHEDULE_TYPE	VARCHAR2	(25)		Shipping Schedule Type
PLAN_BUCKET_PATTERN_ID	NUMBER			Planning Schedule Bucket Pattern
SHIP_BUCKET_PATTERN_ID	NUMBER			Shipping Schedule Bucket Pattern
ENABLE_AUTOSCHEDULE_FLAG	VARCHAR2	(1)		Autoschedule enabled
SCHEDULER_ID	NUMBER			Scheduler
ENABLE_AUTHORIZATIONS_FLAG	VARCHAR2	(1)		Authorizations Enabled or Not
VENDOR_ID	NUMBER			Vendor Id
VENDOR_SITE_ID	NUMBER			Vendor Site Id
ITEM_ID	NUMBER			Item Id
CATEGORY_ID	NUMBER			Category Id
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flex
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flex
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flex
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flex
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flex
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flex
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flex
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flex
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flex
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flex
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flex
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flex
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flex
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flex
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flex
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flex
LAST_UPDATE_LOGIN	NUMBER			who columns
REQUEST_ID	NUMBER			Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who Column
PROGRAM_ID	NUMBER			Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
PRICE_UPDATE_TOLERANCE	NUMBER			Maximum percentage increase allowed to price/sales catalog
PROCESSING_LEAD_TIME	NUMBER			Processing Lead Time in days
MIN_ORDER_QTY	NUMBER			Minimum quantity that needs to be ordered
FIXED_LOT_MULTIPLE	NUMBER			Minimum Lot multiple that can be ordered
DELIVERY_CALENDAR	VARCHAR2	(10)		Name of the Delivery Calendar
COUNTRY_OF_ORIGIN_CODE	VARCHAR2	(2)		Country of Origin Code
PRIMARY_VENDOR_ITEM	VARCHAR2	(25)		Supplier or Manufacturer Item Number
SEGMENT1	VARCHAR2	(40)		Item Number
DESCRIPTION	VARCHAR2	(240)		Description
BUYER_ID	NUMBER	(9)		Buyer Id
PLANNER_ID	NUMBER			Planner Id
UOM	VARCHAR2	(25)		Uom
SUPPLIER_ITEM_NUMBER	VARCHAR2	(25)		Supplier Item Number
ITEM_NUMBER	VARCHAR2	(40)		Item Number
ORGANIZATION_ID	NUMBER		Yes	Organization Id
ORG_NAME	VARCHAR2	(240)
VENDOR_NAME	VARCHAR2	(240)		Vendor Name
VENDOR_NUMBER	VARCHAR2	(30)		Vendor Number

Query Text

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


SELECT ASL_ID
,      USING_ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      DOCUMENT_SOURCING_METHOD
,      RELEASE_GENERATION_METHOD
,      PURCHASING_UNIT_OF_MEASURE
,      ENABLE_PLAN_SCHEDULE_FLAG
,      ENABLE_SHIP_SCHEDULE_FLAG
,      PLAN_SCHEDULE_TYPE
,      SHIP_SCHEDULE_TYPE
,      PLAN_BUCKET_PATTERN_ID
,      SHIP_BUCKET_PATTERN_ID
,      ENABLE_AUTOSCHEDULE_FLAG
,      SCHEDULER_ID
,      ENABLE_AUTHORIZATIONS_FLAG
,      VENDOR_ID
,      VENDOR_SITE_ID
,      ITEM_ID
,      CATEGORY_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PRICE_UPDATE_TOLERANCE
,      PROCESSING_LEAD_TIME
,      MIN_ORDER_QTY
,      FIXED_LOT_MULTIPLE
,      DELIVERY_CALENDAR
,      COUNTRY_OF_ORIGIN_CODE
,      PRIMARY_VENDOR_ITEM
,      SEGMENT1
,      DESCRIPTION
,      BUYER_ID
,      PLANNER_ID
,      UOM
,      SUPPLIER_ITEM_NUMBER
,      ITEM_NUMBER
,      ORGANIZATION_ID
,      ORG_NAME
,      VENDOR_NAME
,      VENDOR_NUMBER
FROM APPS.POS_ORD_MODIFIERS_V;

Dependencies

[top of page]

APPS.POS_ORD_MODIFIERS_V references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; MTL_PLANNERS; MTL_SYSTEM_ITEMS_KFV; PO_APPROVED_SUPPLIER_LIST; PO_ASL_ATTRIBUTES; PO_VENDORS

APPS.POS_ORD_MODIFIERS_V is referenced by following:

APPS: POS_ORDER_MODIFIERS_PKG - show dependent code; POS_UPDATE_CAPACITY_PKG - show dependent code