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

Object Details

Object Name:	AMS_DS_ORDERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_DS_ORDERS_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
ORG_ID	NUMBER			Operating Unit which performed this transaction
SOLD_TO_ORG_ID	NUMBER			Sold to customer
PARTY_ID	NUMBER	(15)	Yes	A foreign key to the HZ_PARTY table.
ORDERED_DATE	DATE			Ordered Date
TRANSACTIONAL_CURR_CODE	VARCHAR2	(15)		Currency for the order
SOLD_FROM_ORG_ID	NUMBER			Selling Organization
SALES_CHANNEL_CODE	VARCHAR2	(30)		Sales channel through which order was placed
BOOKED_DATE	DATE			Indicates the date when the order was booked
MARKETING_SOURCE_CODE_ID	NUMBER			Marketing Source Code Identifier, Foreign key reference to AMS_SOURCE_CODES
LINE_ID	NUMBER		Yes	System Generated Line Identifier.
HEADER_ID	NUMBER		Yes	Foreign key refernence to OE_ORDER_HEADERS_ALL; the order to which this line belongs.
LINE_CATEGORY_CODE	VARCHAR2	(30)	Yes	Indicates whether the line is regular or return
LINE_NUMBER	NUMBER		Yes	Line sequence number within the order
ORDER_QUANTITY_UOM	VARCHAR2	(3)		Ordered quantity Unit of measure
ORDERED_QUANTITY	NUMBER			Quantity Ordered
ITEM_NUMBER	VARCHAR2	(40)
ITEM_DESCRIPTION	VARCHAR2	(240)
UNIT_SELLING_PRICE	NUMBER
UNIT_LIST_PRICE	NUMBER
EXTENDED_PRICE	NUMBER
SCHEDULE_SHIP_DATE	DATE
SCHEDULE_ARRIVAL_DATE	DATE
ACTUAL_SHIPMENT_DATE	DATE
ACTUAL_ARRIVAL_DATE	DATE
SHIPPED_QUANTITY	NUMBER
SHIP_TO_CONTACT_ID	NUMBER
CANCELLED_FLAG	VARCHAR2	(1)
OPEN_FLAG	VARCHAR2	(1)	Yes
BOOKED_FLAG	VARCHAR2	(1)	Yes
OPTION_NUMBER	NUMBER
SHIPPING_QUANTITY_UOM	VARCHAR2	(3)
CANCELLED_QUANTITY	NUMBER
PROMISE_DATE	DATE
REQUEST_DATE	DATE
SHIPPING_METHOD_CODE	VARCHAR2	(30)
SHIPMENT_PRIORITY_CODE	VARCHAR2	(30)
LINE_TYPE_ID	NUMBER		Yes
PRICING_QUANTITY	NUMBER
PRICING_QUANTITY_UOM	VARCHAR2	(3)
FULFILLED_QUANTITY	NUMBER
SHIPPING_QUANTITY	NUMBER
ORDER_SOURCE_ID	NUMBER
INVOICE_TO_ORG_ID	NUMBER
SHIP_TO_ORG_ID	NUMBER
ATO_LINE_ID	NUMBER
CREATION_DATE	DATE		Yes
LAST_UPDATE_DATE	DATE		Yes
CATEGORY_DESC	CHAR	(2)
CONCATENATED_SEGMENTS	VARCHAR2	(40)
INVENTORY_ITEM_ID	NUMBER		Yes
ATTRIBUTE1	VARCHAR2	(240)
ATTRIBUTE2	VARCHAR2	(240)
ATTRIBUTE3	VARCHAR2	(240)
ATTRIBUTE4	VARCHAR2	(240)
ATTRIBUTE5	VARCHAR2	(240)
ATTRIBUTE6	VARCHAR2	(240)
ATTRIBUTE7	VARCHAR2	(240)
ATTRIBUTE8	VARCHAR2	(240)
ATTRIBUTE9	VARCHAR2	(240)
ATTRIBUTE10	VARCHAR2	(240)
ATTRIBUTE11	VARCHAR2	(240)
ATTRIBUTE12	VARCHAR2	(240)
ATTRIBUTE13	VARCHAR2	(240)
ATTRIBUTE14	VARCHAR2	(240)
ATTRIBUTE15	VARCHAR2	(240)
ATTRIBUTE16	VARCHAR2	(240)
ATTRIBUTE17	VARCHAR2	(240)
ATTRIBUTE18	VARCHAR2	(240)
ATTRIBUTE19	VARCHAR2	(240)
ATTRIBUTE20	VARCHAR2	(240)
CATEGORY_ID	NUMBER		Yes	Category ID

Query Text

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


SELECT ORG_ID
,      SOLD_TO_ORG_ID
,      PARTY_ID
,      ORDERED_DATE
,      TRANSACTIONAL_CURR_CODE
,      SOLD_FROM_ORG_ID
,      SALES_CHANNEL_CODE
,      BOOKED_DATE
,      MARKETING_SOURCE_CODE_ID
,      LINE_ID
,      HEADER_ID
,      LINE_CATEGORY_CODE
,      LINE_NUMBER
,      ORDER_QUANTITY_UOM
,      ORDERED_QUANTITY
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      UNIT_SELLING_PRICE
,      UNIT_LIST_PRICE
,      EXTENDED_PRICE
,      SCHEDULE_SHIP_DATE
,      SCHEDULE_ARRIVAL_DATE
,      ACTUAL_SHIPMENT_DATE
,      ACTUAL_ARRIVAL_DATE
,      SHIPPED_QUANTITY
,      SHIP_TO_CONTACT_ID
,      CANCELLED_FLAG
,      OPEN_FLAG
,      BOOKED_FLAG
,      OPTION_NUMBER
,      SHIPPING_QUANTITY_UOM
,      CANCELLED_QUANTITY
,      PROMISE_DATE
,      REQUEST_DATE
,      SHIPPING_METHOD_CODE
,      SHIPMENT_PRIORITY_CODE
,      LINE_TYPE_ID
,      PRICING_QUANTITY
,      PRICING_QUANTITY_UOM
,      FULFILLED_QUANTITY
,      SHIPPING_QUANTITY
,      ORDER_SOURCE_ID
,      INVOICE_TO_ORG_ID
,      SHIP_TO_ORG_ID
,      ATO_LINE_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CATEGORY_DESC
,      CONCATENATED_SEGMENTS
,      INVENTORY_ITEM_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CATEGORY_ID
FROM APPS.AMS_DS_ORDERS_V;

Dependencies

[top of page]

APPS.AMS_DS_ORDERS_V references the following:

APPS: HZ_CUST_ACCOUNTS; MTL_DEFAULT_CATEGORY_SETS; MTL_ITEM_CATEGORIES; MTL_SYSTEM_ITEMS_B_KFV; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL

APPS.AMS_DS_ORDERS_V is not referenced by any database object