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_PO_SUPPLIER_ORDERS_V

Object Details

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

View Type

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

Displays all types of Approved Purchase Orders

[View Source]

Columns

Name	Datatype	Length	Comments
PO_RELEASE_FLAG	VARCHAR2	(7)	Purchase Order Release Flag
ACCEPTANCE_DUE_DATE	DATE		Acceptance Due Date
APPROVED_DATE	DATE		Approved Date
AUTHORIZATION_STATUS	VARCHAR2	(25)	Authorization Status
CLOSED_DATE	DATE		Closed Date
COMMENTS	VARCHAR2	(240)	Comments
FIRM_DATE	DATE		Firm Date
NOTE_TO_AUTHORIZER	VARCHAR2	(240)	Note-to Authorizer
NOTE_TO_RECEIVER	VARCHAR2	(480)	Note-to Receiver
NOTE_TO_VENDOR	VARCHAR2	(480)	Note-to Vendor
PRINT_COUNT	NUMBER		Print Count
PRINTED_DATE	DATE		Printed Date
RATE	NUMBER		Rate
RATE_DATE	DATE		Rate Date
RATE_TYPE	VARCHAR2	(30)	Rate Type
REVISED_DATE	DATE		Revised Date
REVISION_NUM	NUMBER		Revision Number
AGENT_ID	NUMBER	(9)	Agent Identifier
BILL_TO_LOCATION_ID	NUMBER		Bill-to Location Identifier
FROM_HEADER_ID	NUMBER		From Header Identifier
PO_HEADER_ID	NUMBER		Purchase Order Header Identifier
SHIP_TO_LOCATION_ID	NUMBER		Ship-to Location Identifier
TERMS_ID	NUMBER		Terms Identifier
VENDOR_CONTACT_ID	NUMBER		Vendor Contact Identifier
VENDOR_ID	NUMBER		Vendor Identifier
VENDOR_SITE_ID	NUMBER		Vendor Site Identifier
CLOSED_CODE	VARCHAR2	(25)	Closed Code
CURRENCY_CODE	VARCHAR2	(15)	Currency Code
FIRM_STATUS_LOOKUP_CODE	VARCHAR2	(30)	Firm Status Look-up Code
FOB_LOOKUP_CODE	VARCHAR2	(25)	Freight-on Board Lookup Code
FREIGHT_TERMS_LOOKUP_CODE	VARCHAR2	(25)	Freight Terms Lookup Code
SHIP_VIA_LOOKUP_CODE	VARCHAR2	(25)	Ship via Look-up Code
TYPE_LOOKUP_CODE	VARCHAR2	(25)	Type Look-up Code
ACCEPTANCE_REQUIRED_FLAG	VARCHAR2	(1)	Acceptance Required Flag
APPROVAL_REQUIRED_FLAG	VARCHAR2	(1)	Approval Required Flag
APPROVED_FLAG	VARCHAR2	(1)	Approved Flag
CANCEL_FLAG	VARCHAR2	(1)	Cancel Flag
STATUS	VARCHAR2	(25)	Status
CONFIRMING_ORDER_FLAG	VARCHAR2	(1)	Confirming Order Flag
ENABLED_FLAG	VARCHAR2	(1)	Enabled Flag
FROZEN_FLAG	VARCHAR2	(1)	Frozen Flag
SUMMARY_FLAG	VARCHAR2	(1)	Summary Flag
USER_HOLD_FLAG	VARCHAR2	(1)	User Hold Flag
CREATED_BY	NUMBER		Created By Person
ORDER_DATE	DATE		Order Date
LAST_UPDATED_BY	NUMBER		Last Update by Person
LAST_UPDATE_DATE	DATE		Last Update Date
LAST_UPDATE_LOGIN	NUMBER		Last Update Login
PROGRAM_APPLICATION_ID	NUMBER		Program Application Identifier
PROGRAM_ID	NUMBER		Program Identifier
PROGRAM_UPDATE_DATE	DATE		Program Update Date
REQUEST_ID	NUMBER		Request Identifier
PO_NUM	VARCHAR2	(61)	Purchase Order Number
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Attribute Category
ATTRIBUTE1	VARCHAR2	(150)	Attribute 1
ATTRIBUTE2	VARCHAR2	(150)	Attribute 2
ATTRIBUTE3	VARCHAR2	(150)	Attribute 3
ATTRIBUTE4	VARCHAR2	(150)	Attribute 4
ATTRIBUTE5	VARCHAR2	(150)	Attribute 5
ATTRIBUTE6	VARCHAR2	(150)	Attribute 6
ATTRIBUTE7	VARCHAR2	(150)	Attribute 7
ATTRIBUTE8	VARCHAR2	(150)	Attribute 8
ATTRIBUTE9	VARCHAR2	(150)	Attribute 9
ATTRIBUTE10	VARCHAR2	(150)	Attribute 10
ATTRIBUTE11	VARCHAR2	(150)	Attribute 11
ATTRIBUTE12	VARCHAR2	(150)	Attribute 12
ATTRIBUTE13	VARCHAR2	(150)	Attribute 13
ATTRIBUTE14	VARCHAR2	(150)	Attribute 14
ATTRIBUTE15	VARCHAR2	(150)	Attribute 15
DOC_TYPE_NAME	VARCHAR2	(80)	Document Type Name
AGENT_NAME	VARCHAR2	(4000)	Agent Name
VENDOR_NAME	VARCHAR2	(240)	Supplier Name
VENDOR_SITE_CODE	VARCHAR2	(15)	Vendor Site Code
ADDRESS_LINE1	VARCHAR2	(240)	Address Line 1
ADDRESS_LINE2	VARCHAR2	(240)	Address Line 2
ADDRESS_LINE3	VARCHAR2	(240)	Address Line 3
CITY	VARCHAR2	(25)	City
STATE	VARCHAR2	(150)	State
ZIP	VARCHAR2	(20)	Zip Code
COUNTRY	VARCHAR2	(25)	Country
PHONE	VARCHAR2	(28)	Phone
FAX	VARCHAR2	(28)	Fax
VENDOR_CONTACT	VARCHAR2	(32)	Supplier Contact
TERMS_NAME	VARCHAR2	(50)	Terms Name
SHIP_TO_LOCATION	VARCHAR2	(60)	Ship-to Location
BILL_TO_LOCATION	VARCHAR2	(60)	Bill-to Location
RATE_CONVERSION_TYPE	VARCHAR2	(30)	Rate Conversion Type
AUTHORIZATION_STATUS_DSP	VARCHAR2	(80)	Authorization Status Dsp
FOB_DSP	VARCHAR2	(80)	Freight On Board Dsp
FREIGHT_TERMS_DSP	VARCHAR2	(80)	Freight Terms Dsp
CLOSED_CODE_DSP	VARCHAR2	(80)	Closed Code Dsp
CANCEL_DATE	DATE		Cancel Date
CANCEL_REASON	VARCHAR2	(240)	Cancel Reason
CANCELLED_BY	NUMBER		Cancelled By
CANCELLED_BY_NAME	VARCHAR2	(4000)	Cancelled By Name
HOLD_BY	NUMBER		Hold By
HOLD_DATE	DATE		Hold Date
HOLD_REASON	VARCHAR2	(240)	Hold Reason
RELEASE_NUM	NUMBER		Release Number
RELEASE_TYPE	VARCHAR2	(25)	Release Type
PO_RELEASE_ID	NUMBER		Purchase Order Release Identifier
AMOUNT	VARCHAR2	(4000)	Amount
SUPPLIER_URL	VARCHAR2	(150)	Supplier URL

Query Text

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


SELECT PO_RELEASE_FLAG
,      ACCEPTANCE_DUE_DATE
,      APPROVED_DATE
,      AUTHORIZATION_STATUS
,      CLOSED_DATE
,      COMMENTS
,      FIRM_DATE
,      NOTE_TO_AUTHORIZER
,      NOTE_TO_RECEIVER
,      NOTE_TO_VENDOR
,      PRINT_COUNT
,      PRINTED_DATE
,      RATE
,      RATE_DATE
,      RATE_TYPE
,      REVISED_DATE
,      REVISION_NUM
,      AGENT_ID
,      BILL_TO_LOCATION_ID
,      FROM_HEADER_ID
,      PO_HEADER_ID
,      SHIP_TO_LOCATION_ID
,      TERMS_ID
,      VENDOR_CONTACT_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CLOSED_CODE
,      CURRENCY_CODE
,      FIRM_STATUS_LOOKUP_CODE
,      FOB_LOOKUP_CODE
,      FREIGHT_TERMS_LOOKUP_CODE
,      SHIP_VIA_LOOKUP_CODE
,      TYPE_LOOKUP_CODE
,      ACCEPTANCE_REQUIRED_FLAG
,      APPROVAL_REQUIRED_FLAG
,      APPROVED_FLAG
,      CANCEL_FLAG
,      STATUS
,      CONFIRMING_ORDER_FLAG
,      ENABLED_FLAG
,      FROZEN_FLAG
,      SUMMARY_FLAG
,      USER_HOLD_FLAG
,      CREATED_BY
,      ORDER_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      PO_NUM
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DOC_TYPE_NAME
,      AGENT_NAME
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      CITY
,      STATE
,      ZIP
,      COUNTRY
,      PHONE
,      FAX
,      VENDOR_CONTACT
,      TERMS_NAME
,      SHIP_TO_LOCATION
,      BILL_TO_LOCATION
,      RATE_CONVERSION_TYPE
,      AUTHORIZATION_STATUS_DSP
,      FOB_DSP
,      FREIGHT_TERMS_DSP
,      CLOSED_CODE_DSP
,      CANCEL_DATE
,      CANCEL_REASON
,      CANCELLED_BY
,      CANCELLED_BY_NAME
,      HOLD_BY
,      HOLD_DATE
,      HOLD_REASON
,      RELEASE_NUM
,      RELEASE_TYPE
,      PO_RELEASE_ID
,      AMOUNT
,      SUPPLIER_URL
FROM APPS.POS_PO_SUPPLIER_ORDERS_V;

Dependencies

[top of page]

APPS.POS_PO_SUPPLIER_ORDERS_V references the following:

APPS: AP_TERMS; FND_CURRENCY - show dependent code; FND_GLOBAL - show dependent code; GL_DAILY_CONVERSION_TYPES; HR_LOCATIONS_ALL; POS_GET - show dependent code; POS_TOTALS_PO_SV - show dependent code; PO_DOCUMENT_TYPES_ALL_TL; PO_HEADERS_ALL; PO_LOOKUP_CODES; PO_RELEASES_ALL; PO_VENDORS; PO_VENDOR_CONTACTS; PO_VENDOR_SITES_ALL

APPS.POS_PO_SUPPLIER_ORDERS_V is not referenced by any database object