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_SUMMARY_V

Object Details

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

View Type

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

This View Displays Approved Purchase Order Summary for all Organizations

[View Source]

Columns

Name	Datatype	Length	Comments
PO_RELEASE_FLAG	VARCHAR2	(7)	Indicates whether this Purchase Order is a release
ACCEPTANCE_DUE_DATE	DATE		Acceptance-Due Date
APPROVED_DATE	DATE		Approval 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 Look-up Code
FREIGHT_TERMS_LOOKUP_CODE	VARCHAR2	(25)	Freight Terms Look-up 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
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
CREATION_DATE	DATE		Creation Date
LAST_UPDATED_BY	NUMBER		Last Updated 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	(20)	Purchase Order Number
AGENT_NAME	VARCHAR2	(4000)	Agent Name
VENDOR_NAME	VARCHAR2	(240)	Vendor 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 Number
FAX	VARCHAR2	(28)	Fax Number
NAME	VARCHAR2	(50)	Name
TYPE_NAME	VARCHAR2	(4000)	Type Name
SHIP_TO_LOCATION	VARCHAR2	(60)	Ship-To Location
SHIP_ADDR1	VARCHAR2	(240)	Ship-to Address Line 1
SHIP_ADDR2	VARCHAR2	(240)	Ship-to Address Line 2
SHIP_ADDR3	VARCHAR2	(240)	Ship-to Address Line 3
SHIP_CITY	VARCHAR2	(30)	Ship-To City
SHIP_STATE	VARCHAR2	(120)	Ship-To State
SHIP_ZIP	VARCHAR2	(30)	Ship-To Zip Code
SHIP_COUNTRY	VARCHAR2	(60)	Ship-To Country
BILL_TO_LOCATION	VARCHAR2	(60)	Bill-To Location
BILL_ADDR1	VARCHAR2	(240)	Bill-to Address Line 1
BILL_ADDR2	VARCHAR2	(240)	Bill-to Address Line 2
BILL_ADDR3	VARCHAR2	(240)	Bill-to Address Line 3
BILL_CITY	VARCHAR2	(30)	Bill-to City
BILL_STATE	VARCHAR2	(120)	Bill-to State
BILL_ZIP	VARCHAR2	(30)	Bill-To Zip Code
BILL_COUNTRY	VARCHAR2	(60)	Bill-to Country
FOB_DSP	VARCHAR2	(80)	Freight On Board Dsp
FREIGHT_TERMS_DSP	VARCHAR2	(80)	Freight Terms 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		PO Release Identifier
AMOUNT	VARCHAR2	(4000)	Amount
SUPPLIER_URL	VARCHAR2	(150)	Supplier URL
ACCEPTANCE_FLAG	VARCHAR2	(1)	Acceptance Flag
ACTION_DATE	DATE		Action Date
USSGL_TRANSACTION_CODE	VARCHAR2	(30)	USSGL Transaction Code
ORG_ID	NUMBER		Organization Identifier
ORG_NAME	VARCHAR2	(240)	Organization Name
ATTRIBUTE1	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Descriptive flexfield segment
PO_STATUS	VARCHAR2	(4000)	PO Status

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
,      CONFIRMING_ORDER_FLAG
,      ENABLED_FLAG
,      FROZEN_FLAG
,      SUMMARY_FLAG
,      USER_HOLD_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      PO_NUM
,      AGENT_NAME
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      CITY
,      STATE
,      ZIP
,      COUNTRY
,      PHONE
,      FAX
,      NAME
,      TYPE_NAME
,      SHIP_TO_LOCATION
,      SHIP_ADDR1
,      SHIP_ADDR2
,      SHIP_ADDR3
,      SHIP_CITY
,      SHIP_STATE
,      SHIP_ZIP
,      SHIP_COUNTRY
,      BILL_TO_LOCATION
,      BILL_ADDR1
,      BILL_ADDR2
,      BILL_ADDR3
,      BILL_CITY
,      BILL_STATE
,      BILL_ZIP
,      BILL_COUNTRY
,      FOB_DSP
,      FREIGHT_TERMS_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
,      ACCEPTANCE_FLAG
,      ACTION_DATE
,      USSGL_TRANSACTION_CODE
,      ORG_ID
,      ORG_NAME
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      PO_STATUS
FROM APPS.POS_PO_SUMMARY_V;

Dependencies

[top of page]

APPS.POS_PO_SUMMARY_V references the following:

APPS: AP_TERMS; FND_CURRENCY_CACHE - show dependent code; FND_GLOBAL - show dependent code; FND_LOOKUP_VALUES_VL; FND_MESSAGE - show dependent code; HR_ALL_ORGANIZATION_UNITS_TL; HR_LOCATIONS_ALL; POS_GET - show dependent code; POS_TOTALS_PO_SV - show dependent code; PO_ACCEPTANCES; PO_HEADERS_ALL; PO_INQ_SV - show dependent code; PO_LOOKUP_CODES; PO_RELEASES_ALL; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.POS_PO_SUMMARY_V is not referenced by any database object