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

Object Details

Object Name:	ICX_REQ_DIST_HEADER_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ICX.ICX_REQ_DIST_HEADER_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
CART_ID	NUMBER		Yes
REQUISITION_NUMBER	VARCHAR2	(20)	Yes
SHOPPER_ID	NUMBER	(9)	Yes
CART_LINE_ID	NUMBER
CART_LINE_NUMBER	NUMBER
LINE_ID	NUMBER
ITEM_DESCRIPTION	VARCHAR2	(240)
ITEM_ID	NUMBER
ITEM_REV	VARCHAR2	(3)
UNIT_OF_MEASURE	VARCHAR2	(25)
QUANTITY	NUMBER
UNIT_PRICE	VARCHAR2	(4000)		Unit price
EXT_PRICE	NUMBER			Extended price
CATEGORY_ID	NUMBER
LINE_TYPE_ID	NUMBER
EXPENDITURE_TYPE	VARCHAR2	(30)
DESTINATION_ORGANIZATION_ID	NUMBER
DELIVER_TO_LOCATION_ID	NUMBER
SUGGESTED_BUYER_ID	NUMBER	(9)
SUGGESTED_VENDOR_NAME	VARCHAR2	(240)
SUGGESTED_VENDOR_SITE	VARCHAR2	(240)
SUGGESTED_VENDOR_CONTACT	VARCHAR2	(80)
SUGGESTED_VENDOR_PHONE	VARCHAR2	(25)
SUGGESTED_VENDOR_ITEM_NUM	VARCHAR2	(25)
LINE_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
LINE_ATTRIBUTE1	VARCHAR2	(150)
LINE_ATTRIBUTE2	VARCHAR2	(150)
LINE_ATTRIBUTE3	VARCHAR2	(150)
LINE_ATTRIBUTE4	VARCHAR2	(150)
LINE_ATTRIBUTE5	VARCHAR2	(150)
LINE_ATTRIBUTE6	VARCHAR2	(150)
LINE_ATTRIBUTE7	VARCHAR2	(150)
LINE_ATTRIBUTE8	VARCHAR2	(150)
LINE_ATTRIBUTE9	VARCHAR2	(150)
LINE_ATTRIBUTE10	VARCHAR2	(150)
LINE_ATTRIBUTE11	VARCHAR2	(150)
LINE_ATTRIBUTE12	VARCHAR2	(150)
LINE_ATTRIBUTE13	VARCHAR2	(150)
LINE_ATTRIBUTE14	VARCHAR2	(150)
LINE_ATTRIBUTE15	VARCHAR2	(150)
NEED_BY_DATE	DATE
EXPENDITURE_ORGANIZATION_ID	NUMBER
PROJECT_ID	NUMBER
TASK_ID	NUMBER
EXPENDITURE_ITEM_DATE	DATE
DISTRIBUTION_ID	NUMBER
CATEGORY_NAME	VARCHAR2	(4000)
ORG_ID	NUMBER

Query Text

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


SELECT CART_ID
,      REQUISITION_NUMBER
,      SHOPPER_ID
,      CART_LINE_ID
,      CART_LINE_NUMBER
,      LINE_ID
,      ITEM_DESCRIPTION
,      ITEM_ID
,      ITEM_REV
,      UNIT_OF_MEASURE
,      QUANTITY
,      UNIT_PRICE
,      EXT_PRICE
,      CATEGORY_ID
,      LINE_TYPE_ID
,      EXPENDITURE_TYPE
,      DESTINATION_ORGANIZATION_ID
,      DELIVER_TO_LOCATION_ID
,      SUGGESTED_BUYER_ID
,      SUGGESTED_VENDOR_NAME
,      SUGGESTED_VENDOR_SITE
,      SUGGESTED_VENDOR_CONTACT
,      SUGGESTED_VENDOR_PHONE
,      SUGGESTED_VENDOR_ITEM_NUM
,      LINE_ATTRIBUTE_CATEGORY
,      LINE_ATTRIBUTE1
,      LINE_ATTRIBUTE2
,      LINE_ATTRIBUTE3
,      LINE_ATTRIBUTE4
,      LINE_ATTRIBUTE5
,      LINE_ATTRIBUTE6
,      LINE_ATTRIBUTE7
,      LINE_ATTRIBUTE8
,      LINE_ATTRIBUTE9
,      LINE_ATTRIBUTE10
,      LINE_ATTRIBUTE11
,      LINE_ATTRIBUTE12
,      LINE_ATTRIBUTE13
,      LINE_ATTRIBUTE14
,      LINE_ATTRIBUTE15
,      NEED_BY_DATE
,      EXPENDITURE_ORGANIZATION_ID
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_ITEM_DATE
,      DISTRIBUTION_ID
,      CATEGORY_NAME
,      ORG_ID
FROM APPS.ICX_REQ_DIST_HEADER_V;

Dependencies

[top of page]

APPS.ICX_REQ_DIST_HEADER_V references the following:

APPS: FND_CURRENCY - show dependent code; GL_SETS_OF_BOOKS; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; ICX_UTIL - show dependent code; ORG_ORGANIZATION_DEFINITIONS; PO_REQUISITION_HEADERS; PO_REQUISITION_LINES; PO_REQ_DISTRIBUTIONS

APPS.ICX_REQ_DIST_HEADER_V is not referenced by any database object