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_ARCH_SUMMARY_V

Object Details

Object Name:	POS_PO_ARCH_SUMMARY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	POS.POS_PO_ARCH_SUMMARY_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	Comments
PO_RELEASE_FLAG	VARCHAR2	(7)	Release Flag
ACCEPTANCE_DUE_DATE	DATE		Acceptance Due Date
APPROVED_DATE	DATE		Approved Date
AUTHORIZATION_STATUS	VARCHAR2	(25)	Authorization Status of PO
CLOSED_DATE	DATE		Closed Date
COMMENTS	VARCHAR2	(240)	Description
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		Last Print Date
RATE	NUMBER		Currency Rate
RATE_DATE	DATE		Conversion Rate Date
RATE_TYPE	VARCHAR2	(30)	Conversion Rate Type
REVISED_DATE	DATE		Revised Date
REVISION_NUM	NUMBER		Revision Date
AGENT_ID	NUMBER	(9)	Buyer Id
BILL_TO_LOCATION_ID	NUMBER		Bill To Location Id
FROM_HEADER_ID	NUMBER		From Header Id
PO_HEADER_ID	NUMBER		Purchase Order Header Id
SHIP_TO_LOCATION_ID	NUMBER		Ship To Location Id
TERMS_ID	NUMBER		Payment Terms Id
VENDOR_CONTACT_ID	NUMBER		Vendor Contact Id
VENDOR_ID	NUMBER		Vendor Id
VENDOR_SITE_ID	NUMBER		Vendor Site Id
CLOSED_CODE	VARCHAR2	(25)	Closed Code
CURRENCY_CODE	VARCHAR2	(15)	Currency Code
FIRM_STATUS_LOOKUP_CODE	VARCHAR2	(30)	Firm Status Lookup Code
FOB_LOOKUP_CODE	VARCHAR2	(25)	FOB Lookup Code
FREIGHT_TERMS_LOOKUP_CODE	VARCHAR2	(25)	Freight Terms Code
SHIP_VIA_LOOKUP_CODE	VARCHAR2	(25)	Ship Via Lookup Code
TYPE_LOOKUP_CODE	VARCHAR2	(25)	Document Type Lookup 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		Who Cloumn
CREATION_DATE	DATE		Who Cloumn
LAST_UPDATED_BY	NUMBER		Who Cloumn
LAST_UPDATE_DATE	DATE		Who Cloumn
LAST_UPDATE_LOGIN	NUMBER		Who Cloumn
PROGRAM_APPLICATION_ID	NUMBER		Who Cloumn
PROGRAM_ID	NUMBER		Who Cloumn
PROGRAM_UPDATE_DATE	DATE
REQUEST_ID	NUMBER
PO_NUM	VARCHAR2	(20)	PO Number
AGENT_NAME	VARCHAR2	(4000)	Buyer Name
VENDOR_NAME	VARCHAR2	(240)	Vendor Name
VENDOR_SITE_CODE	VARCHAR2	(15)	Vendor Site Code
ADDRESS_LINE1	VARCHAR2	(240)	Vendor Address Line 1
ADDRESS_LINE2	VARCHAR2	(240)	Vendor Address Line 2
ADDRESS_LINE3	VARCHAR2	(240)	Vendor Address Line 3
CITY	VARCHAR2	(60)	Vendor City
STATE	VARCHAR2	(60)	Vendor State
ZIP	VARCHAR2	(20)	Vendor Zip Code
COUNTRY	VARCHAR2	(25)	Vedor Country
PHONE	VARCHAR2	(28)	Vendor Phone Number
FAX	VARCHAR2	(28)	Vendor Fax Number
NAME	VARCHAR2	(50)	Terms Name
TYPE_NAME	VARCHAR2	(4000)	Document Type Display
SHIP_TO_LOCATION	VARCHAR2	(60)	Ship To Location Code
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
SHIP_COUNTRY	VARCHAR2	(60)	Ship To Country
BILL_TO_LOCATION	VARCHAR2	(60)	Bill To Location Code
BILL_ADDR1	VARCHAR2	(240)	Bill To Address Line1
BILL_ADDR2	VARCHAR2	(240)	Bill To Address2
BILL_ADDR3	VARCHAR2	(240)	Bill To Address3
BILL_CITY	VARCHAR2	(30)	Bill To City
BILL_STATE	VARCHAR2	(120)	Bill To State
BILL_ZIP	VARCHAR2	(30)	Bill To Zip
BILL_COUNTRY	VARCHAR2	(60)	Bill To Country
FOB_DSP	VARCHAR2	(80)	FOB Display Value
FREIGHT_TERMS_DSP	VARCHAR2	(80)	Freight Terms Display
CANCEL_DATE	DATE		Cancel Date
CANCEL_REASON	VARCHAR2	(240)	Cancel Reason
CANCELLED_BY	NUMBER		Cancelled by user id
CANCELLED_BY_NAME	VARCHAR2	(4000)	Cancelled by User Name
HOLD_BY	NUMBER		Hold By User Id
HOLD_DATE	DATE		Hold Date
HOLD_REASON	VARCHAR2	(240)	Hold Reason
RELEASE_NUM	NUMBER		Release Number
RELEASE_TYPE	VARCHAR2	(25)	PO Release Id
PO_RELEASE_ID	NUMBER		PO Release Id
AMOUNT	VARCHAR2	(4000)	Total Amount
SUPPLIER_URL	VARCHAR2	(150)	URL
USSGL_TRANSACTION_CODE	VARCHAR2	(30)	USSGL Transaction Code
ORG_ID	NUMBER		Organization Id
ORG_NAME	VARCHAR2	(240)	Oranization Name
ATTRIBUTE1	VARCHAR2	(150)	Descriptive Flex Field
ATTRIBUTE2	VARCHAR2	(150)	Descriptive Flex Field
ATTRIBUTE3	VARCHAR2	(150)	Descriptive Flex Field
ATTRIBUTE4	VARCHAR2	(150)	Descriptive Flex Field
ATTRIBUTE5	VARCHAR2	(150)	Descriptive Flex Field
ATTRIBUTE6	VARCHAR2	(150)	Descriptive Flex Field
ATTRIBUTE7	VARCHAR2	(150)	Descriptive Flex Field
ATTRIBUTE8	VARCHAR2	(150)	Descriptive Flex Field
ATTRIBUTE9	VARCHAR2	(150)	Descriptive Flex Field
ATTRIBUTE10	VARCHAR2	(150)	Descriptive Flex Field
ATTRIBUTE11	VARCHAR2	(150)	Descriptive Flex Field
ATTRIBUTE12	VARCHAR2	(150)	Descriptive Flex Field
ATTRIBUTE13	VARCHAR2	(150)	Descriptive Flex Field
ATTRIBUTE14	VARCHAR2	(150)	Descriptive Flex Field
ATTRIBUTE15	VARCHAR2	(150)	Descriptive Flex Field
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Descriptive Flex Field
PO_STATUS	VARCHAR2	(4000)	PO Status
VENDOR_ORDER_NUM	VARCHAR2	(25)	Old Sales Order Number
NEW_SUPPLIER_ORDER_NO	VARCHAR2	(0)	New Sales Order Number
REQUEST_STATUS	VARCHAR2	(0)	Chage Request Status
GLOBAL_AGREEMENT_FLAG	VARCHAR2	(1)	Global Agreement Flag
CONSIGNED_CONSUMPTION_FLAG	VARCHAR2	(1)	Consigned Consumption Flag
STATUS_CODE	VARCHAR2	(4000)	Calculated Status Code of PO Header/Release

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
,      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
,      VENDOR_ORDER_NUM
,      NEW_SUPPLIER_ORDER_NO
,      REQUEST_STATUS
,      GLOBAL_AGREEMENT_FLAG
,      CONSIGNED_CONSUMPTION_FLAG
,      STATUS_CODE
FROM APPS.POS_PO_ARCH_SUMMARY_V;

Dependencies

[top of page]

APPS.POS_PO_ARCH_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_ACKNOWLEDGE_PO_GRP - show dependent code; PO_HEADERS_ALL; PO_HEADERS_ARCHIVE_ALL; PO_INQ_SV - show dependent code; PO_LOOKUP_CODES; PO_RELEASES_ALL; PO_RELEASES_ARCHIVE_ALL; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.POS_PO_ARCH_SUMMARY_V is not referenced by any database object