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

VIEW: APPS.POS_PO_SUPPLIER_AGREEMENTS_V

Object Details
Object Name: POS_PO_SUPPLIER_AGREEMENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POS_PO_SUPPLIER_AGREEMENTS_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 Blanket Purchase Orders for All Organizations


[View Source]

Columns
Name Datatype Length Mandatory Comments
PO_RELEASE_FLAG CHAR (2)
Indicates whether document is a release
ACCEPTANCE_DUE_DATE DATE

Acceptance due date
AMOUNT_LIMIT VARCHAR2 (4000)
Maximum amount that can be released against the purchase order (blanket, contract, or planned)
APPROVED_DATE DATE

Date the purchase order was last approved
AUTHORIZATION_STATUS VARCHAR2 (25)
Authorization status of the purchase order
BLANKET_TOTAL_AMOUNT VARCHAR2 (4000)
Amount agreed for the planned or blanket purchase order
CLOSED_DATE DATE

Date the document was closed
COMMENTS VARCHAR2 (240)
Descriptive comments for the document
END_DATE DATE

Expiration date of the document
MIN_RELEASE_AMOUNT VARCHAR2 (4000)
Minimum amount that can be released against a blanket or planned purchase order
NOTE_TO_AUTHORIZER VARCHAR2 (240)
Not currently used
NOTE_TO_RECEIVER VARCHAR2 (480)
Note to the Receiver
NOTE_TO_VENDOR VARCHAR2 (480)
Note to the supplier
PRINT_COUNT NUMBER

Number of times the document was printed
PRINTED_DATE DATE

Date the document was last printed
RATE NUMBER

Currency conversion rate
RATE_DATE DATE

Currency conversion date
RATE_TYPE VARCHAR2 (30)
Currency conversion rate type
REVISED_DATE DATE

Date the document was last revised
REVISION_NUM NUMBER

Document revision number
START_DATE DATE

Date the document becomes effective
AGENT_ID NUMBER (9) Yes Buyer unique identifier
BILL_TO_LOCATION_ID NUMBER

Bill To location unique identifier
PO_HEADER_ID NUMBER
Yes Document unique identifier
SHIP_TO_LOCATION_ID NUMBER

Ship to location
TERMS_ID NUMBER

payment terms unique identifier
VENDOR_CONTACT_ID NUMBER

Supplier contact unique identifier
VENDOR_ID NUMBER

Supplier unique identifier
VENDOR_SITE_ID NUMBER

Supplier site unique identifier
CLOSED_CODE VARCHAR2 (25)
Closed code
CURRENCY_CODE VARCHAR2 (15)
Currency Code
FOB_LOOKUP_CODE VARCHAR2 (25)
FOB Lookup Code
FREIGHT_TERMS_LOOKUP_CODE VARCHAR2 (25)
Freight terms code
SHIP_VIA_LOOKUP_CODE VARCHAR2 (25)
Carrier Via lookup code
TYPE_LOOKUP_CODE VARCHAR2 (25) Yes Document Type code
ACCEPTANCE_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether acceptance from the supplier is required or not
APPROVAL_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether a quote or RFQ requires approval
APPROVED_FLAG VARCHAR2 (1)
Indicates whether the purchase order is approved or not
CANCEL_FLAG VARCHAR2 (1)
Indicates whether the purchase order is cancelled or not
CONFIRMING_ORDER_FLAG VARCHAR2 (1)
Indicates whether the purchase order is a confirming order or not
ENABLED_FLAG VARCHAR2 (1) Yes Key Flexfield enabled flag
FROZEN_FLAG VARCHAR2 (1)
Indicates whether the document is frozen or not
SUMMARY_FLAG VARCHAR2 (1) Yes Key Flexfield summary flag
USER_HOLD_FLAG VARCHAR2 (1)
Indicates whether the purchase order is on hold or not
CREATED_BY NUMBER

Standard Who Column
ORDER_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column
PROGRAM_ID NUMBER

Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
REQUEST_ID NUMBER

Standard Who Column
PO_NUM VARCHAR2 (20) Yes Document Number
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flex Field
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
DOC_TYPE_NAME VARCHAR2 (0)
Document Type Name
AGENT_NAME VARCHAR2 (4000)
Buyer Name
VENDOR_NAME VARCHAR2 (240)
Supplier Name
VENDOR_SITE_CODE VARCHAR2 (15) Yes Supplier Site Code
ADDRESS_LINE1 VARCHAR2 (240)
Address Line
ADDRESS_LINE2 VARCHAR2 (240)
Address Line
ADDRESS_LINE3 VARCHAR2 (240)
Address Line
CITY VARCHAR2 (25)
City
STATE VARCHAR2 (150)
State
ZIP VARCHAR2 (20)
Zip
COUNTRY VARCHAR2 (25)
Country
PHONE VARCHAR2 (28)
Phone
FAX VARCHAR2 (28)
Fax
VENDOR_CONTACT VARCHAR2 (32)
Supplier Contact
TERMS_NAME VARCHAR2 (50)
Payment Terms Name
SHIP_TO_LOCATION VARCHAR2 (60)
Ship To Location
BILL_TO_LOCATION VARCHAR2 (60)
Bill To Location
RATE_CONVERSION_TYPE VARCHAR2 (30)
Currency conversion rate type
AUTHORIZATION_STATUS_DSP VARCHAR2 (80) Yes Authorization status
FOB_DSP VARCHAR2 (80)
displayed Field
FREIGHT_TERMS_DSP VARCHAR2 (80)
displayed Field
CLOSED_CODE_DSP VARCHAR2 (80) Yes displayed Field
CANCEL_DATE DATE

Date the purchase order was cancelled
CANCEL_REASON VARCHAR2 (0)
Descriptive reason why the purchase order was cancelled
CANCELLED_BY NUMBER

Unique identifier of the employee who cancelled the purchase order
CANCELLED_BY_NAME VARCHAR2 (0)
Name of the employee who cancelled the purchase order
HOLD_BY NUMBER

Unique identifier of the employee who placed the document on hold
HOLD_DATE DATE

Date the document was placed on hold
HOLD_REASON VARCHAR2 (0)
Reason the document was placed on hold
RELEASE_NUM NUMBER

Release Number
RELEASE_TYPE VARCHAR2 (0)
Release Type
PO_RELEASE_ID NUMBER

Document Release unique Identifier
AMOUNT VARCHAR2 (4000)
Total Amount
SUPPLIER_URL VARCHAR2 (150)
Supplier Info URL
SUPPLIER_ID NUMBER

Supplier unique identifier
SUPPLIER_SITE_ID NUMBER

Supplier site unique identifier
DESCRIPTION VARCHAR2 (240)
descriptive comments
ORG_ID NUMBER

oarganization unique identifier
ORG_NAME VARCHAR2 (240)
Organization Name
Query Text

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


SELECT PO_RELEASE_FLAG
,      ACCEPTANCE_DUE_DATE
,      AMOUNT_LIMIT
,      APPROVED_DATE
,      AUTHORIZATION_STATUS
,      BLANKET_TOTAL_AMOUNT
,      CLOSED_DATE
,      COMMENTS
,      END_DATE
,      MIN_RELEASE_AMOUNT
,      NOTE_TO_AUTHORIZER
,      NOTE_TO_RECEIVER
,      NOTE_TO_VENDOR
,      PRINT_COUNT
,      PRINTED_DATE
,      RATE
,      RATE_DATE
,      RATE_TYPE
,      REVISED_DATE
,      REVISION_NUM
,      START_DATE
,      AGENT_ID
,      BILL_TO_LOCATION_ID
,      PO_HEADER_ID
,      SHIP_TO_LOCATION_ID
,      TERMS_ID
,      VENDOR_CONTACT_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CLOSED_CODE
,      CURRENCY_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
,      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
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      DESCRIPTION
,      ORG_ID
,      ORG_NAME
FROM APPS.POS_PO_SUPPLIER_AGREEMENTS_V;

Dependencies

[top of page]

APPS.POS_PO_SUPPLIER_AGREEMENTS_V references the following:

SchemaAPPS
SynonymAP_TERMS
PL/SQL PackageFND_CURRENCY - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymGL_DAILY_CONVERSION_TYPES
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_LOCATIONS_ALL_TL
PL/SQL PackagePOS_GET - show dependent code
PL/SQL PackagePOS_TOTALS_PO_SV - show dependent code
SynonymPO_HEADERS_ALL
ViewPO_LOOKUP_CODES
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL

APPS.POS_PO_SUPPLIER_AGREEMENTS_V is not referenced by any database object