DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.POS_ORDER_SUMMARY_V

Object Details
Object Name: POS_ORDER_SUMMARY_V
Object Type: VIEW
Owner: APPS
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
APPROVED_DATE DATE

AUTHORIZATION_STATUS VARCHAR2 (25)
COMMENTS VARCHAR2 (240)
REVISED_DATE DATE

REVISION_NUM NUMBER

AGENT_ID NUMBER (9) Yes
FROM_HEADER_ID NUMBER

PO_HEADER_ID NUMBER
Yes
SHIP_TO_LOCATION_ID NUMBER

VENDOR_CONTACT_ID NUMBER

VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

CURRENCY_CODE VARCHAR2 (15)
TYPE_LOOKUP_CODE VARCHAR2 (25) Yes
CREATED_BY NUMBER

ORDER_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

PO_NUM VARCHAR2 (61)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
AGENT_NAME VARCHAR2 (4000)
VENDOR_NAME VARCHAR2 (240)
VENDOR_SITE_CODE VARCHAR2 (15) Yes
AUTHORIZATION_STATUS_DSP VARCHAR2 (80) Yes
RELEASE_NUM NUMBER
Yes
RELEASE_TYPE VARCHAR2 (25)
PO_RELEASE_ID NUMBER
Yes
AMOUNT VARCHAR2 (4000)
SUPPLIER_URL VARCHAR2 (150)
GLOBAL_AGREEMENT_FLAG VARCHAR2 (1)
ORG_ID NUMBER

Organization Id
SECURITY_LEVEL_CODE VARCHAR2 (25)
ACCESS_LEVEL_CODE VARCHAR2 (25)
Query Text

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


SELECT APPROVED_DATE
,      AUTHORIZATION_STATUS
,      COMMENTS
,      REVISED_DATE
,      REVISION_NUM
,      AGENT_ID
,      FROM_HEADER_ID
,      PO_HEADER_ID
,      SHIP_TO_LOCATION_ID
,      VENDOR_CONTACT_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CURRENCY_CODE
,      TYPE_LOOKUP_CODE
,      CREATED_BY
,      ORDER_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PO_NUM
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      AGENT_NAME
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      AUTHORIZATION_STATUS_DSP
,      RELEASE_NUM
,      RELEASE_TYPE
,      PO_RELEASE_ID
,      AMOUNT
,      SUPPLIER_URL
,      GLOBAL_AGREEMENT_FLAG
,      ORG_ID
,      SECURITY_LEVEL_CODE
,      ACCESS_LEVEL_CODE
FROM APPS.POS_ORDER_SUMMARY_V;

Dependencies

[top of page]

APPS.POS_ORDER_SUMMARY_V references the following:

SchemaAPPS
PL/SQL PackageFND_CURRENCY - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackagePOS_GET - show dependent code
PL/SQL PackagePOS_TOTALS_PO_SV - show dependent code
SynonymPO_DOCUMENT_TYPES_ALL_B
SynonymPO_HEADERS_ARCHIVE_ALL
ViewPO_LOOKUP_CODES
SynonymPO_RELEASES_ARCHIVE_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.POS_ORDER_SUMMARY_V is not referenced by any database object