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
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
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 (25)
Vendor City
STATE VARCHAR2 (150)
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:

SchemaAPPS
SynonymAP_TERMS
PL/SQL PackageFND_CURRENCY_CACHE - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUP_VALUES_VL
PL/SQL PackageFND_MESSAGE - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_LOCATIONS_ALL
PL/SQL PackagePOS_GET - show dependent code
PL/SQL PackagePOS_TOTALS_PO_SV - show dependent code
PL/SQL PackagePO_ACKNOWLEDGE_PO_GRP - show dependent code
SynonymPO_HEADERS_ALL
SynonymPO_HEADERS_ARCHIVE_ALL
PL/SQL PackagePO_INQ_SV - show dependent code
ViewPO_LOOKUP_CODES
SynonymPO_RELEASES_ALL
SynonymPO_RELEASES_ARCHIVE_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.POS_PO_ARCH_SUMMARY_V is not referenced by any database object