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_BILL_ONLY_ORDERS_V

Object Details

Object Name:	POS_BILL_ONLY_ORDERS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

POS_BILL_ONLY_ORDERS_V is used to select consumption advices.

[View Source]

Columns

Name	Datatype	Length	Comments
APPROVED_DATE	DATE		Approved Date
COMMENTS	VARCHAR2	(240)	Comments
REVISION_NUM	NUMBER		Revision Num
AGENT_ID	NUMBER	(9)	Agent Id
AGENT_NAME	VARCHAR2	(4000)	Agent Name
BILL_TO_LOCATION_ID	NUMBER		Bill To Location Id
BILL_TO_LOCATION	VARCHAR2	(60)	Bill To Location
PO_HEADER_ID	NUMBER		Po Header Id
VENDOR_ID	NUMBER		Vendor Id
VENDOR_SITE_ID	NUMBER		Vendor Site Id
VENDOR_CONTACT_ID	NUMBER		Vendor Contact Id
CLOSED_CODE	VARCHAR2	(25)	Closed Code
STATUS	VARCHAR2	(80)	Status
CURRENCY_CODE	VARCHAR2	(15)	Currency Code
TYPE_LOOKUP_CODE	VARCHAR2	(25)	Type Lookup Code
TYPE_NAME	VARCHAR2	(4000)	Type Name
PO_NUM	VARCHAR2	(61)	Po Num
VENDOR_NAME	VARCHAR2	(240)	Vendor Name
VENDOR_SITE_CODE	VARCHAR2	(15)	Vendor Site Code
PO_RELEASE_ID	NUMBER		Po Release Id
AMOUNT	VARCHAR2	(4000)	Amount
ORG_ID	NUMBER		Org Id
ORG_NAME	VARCHAR2	(240)	Org Name
ATTRIBUTE1	VARCHAR2	(150)	Attribute1
ATTRIBUTE2	VARCHAR2	(150)	Attribute2
ATTRIBUTE3	VARCHAR2	(150)	Attribute3
ATTRIBUTE4	VARCHAR2	(150)	Attribute4
ATTRIBUTE5	VARCHAR2	(150)	Attribute5
ATTRIBUTE6	VARCHAR2	(150)	Attribute6
ATTRIBUTE7	VARCHAR2	(150)	Attribute7
ATTRIBUTE8	VARCHAR2	(150)	Attribute8
ATTRIBUTE9	VARCHAR2	(150)	Attribute9
ATTRIBUTE10	VARCHAR2	(150)	Attribute10
ATTRIBUTE11	VARCHAR2	(150)	Attribute11
ATTRIBUTE12	VARCHAR2	(150)	Attribute12
ATTRIBUTE13	VARCHAR2	(150)	Attribute13
ATTRIBUTE14	VARCHAR2	(150)	Attribute14
ATTRIBUTE15	VARCHAR2	(150)	Attribute15
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Attribute Category

Query Text

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


SELECT APPROVED_DATE
,      COMMENTS
,      REVISION_NUM
,      AGENT_ID
,      AGENT_NAME
,      BILL_TO_LOCATION_ID
,      BILL_TO_LOCATION
,      PO_HEADER_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_CONTACT_ID
,      CLOSED_CODE
,      STATUS
,      CURRENCY_CODE
,      TYPE_LOOKUP_CODE
,      TYPE_NAME
,      PO_NUM
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      PO_RELEASE_ID
,      AMOUNT
,      ORG_ID
,      ORG_NAME
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
FROM APPS.POS_BILL_ONLY_ORDERS_V;

Dependencies

[top of page]

APPS.POS_BILL_ONLY_ORDERS_V references the following:

APPS: FND_CURRENCY_CACHE - show dependent code; FND_GLOBAL - show dependent code; FND_MESSAGE - show dependent code; HR_ALL_ORGANIZATION_UNITS_TL; HR_LOCATIONS_ALL_TL; HZ_LOCATIONS; POS_GET - show dependent code; POS_TOTALS_PO_SV - show dependent code; PO_HEADERS_ALL; PO_LOOKUP_CODES; PO_RELEASES_ALL; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.POS_BILL_ONLY_ORDERS_V is not referenced by any database object