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


VIEW: APPS.POS_PO_INVOICE_SUP_ORDERS_V

Object Details
Object Name: POS_PO_INVOICE_SUP_ORDERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POS_PO_INVOICE_SUP_ORDERS_V
Subobject Name:
Status: VALID

View Type

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


Fetches the invoices associated with a Purchase Order and the details of the PO and the invoice.


[View Source]

Columns
Name Datatype Length Mandatory Comments
INVOICE_ID NUMBER (15)
Invoice Unique Identifier
PO_RELEASE_FLAG VARCHAR2 (7)
Indicated whether document is a relase or not
ROW_ID ROWID (10)
Row ID
ACCEPTANCE_DUE_DATE DATE

Accepatance Due date of the purchase order
AMOUNT_LIMIT NUMBER

Maximum amount that can be released against the purchase order (blanket, contract, or planned)
APPROVED_DATE DATE

Approval date on the document
AUTHORIZATION_STATUS VARCHAR2 (25)
Authorization status of the document
BLANKET_TOTAL_AMOUNT NUMBER

Total Amount agreed on the blanket
CLOSED_DATE DATE

Closure date
COMMENTS VARCHAR2 (240)
Descriptive comments for the document
END_DATE DATE

Expiration date of the document
END_DATE_ACTIVE DATE

Key Flexfield end date
FIRM_DATE DATE

Date from which the purchase order is firmed
GOVERNMENT_CONTEXT VARCHAR2 (30)
USSGL descriptive flexfield context column
MIN_RELEASE_AMOUNT NUMBER

Minimum amount that can be released against a blanket or planned purchase order
NOTE_TO_AUTHORIZER VARCHAR2 (240)
Note for Authorizer
NOTE_TO_RECEIVER VARCHAR2 (480)
Short note for receiver
NOTE_TO_VENDOR VARCHAR2 (480)
Short Note for Supplier
PRINT_COUNT NUMBER

Number of times document was printed
PRINTED_DATE DATE

Date document was printed
QUOTE_VENDOR_QUOTE_NUMBER VARCHAR2 (25)
Number of the quotation for the supplier
QUOTE_WARNING_DELAY NUMBER

Number of days prior to the expiration of the quotation that you want to be notified
QUOTE_WARNING_DELAY_UNIT VARCHAR2 (25)
Warning delay unit of measure (Unused since release 7.0)
RATE NUMBER

Currency conversion Rate
RATE_DATE DATE

Conversion Date
RATE_TYPE VARCHAR2 (30)
Conversion Type
REPLY_DATE DATE

Date the supplier replied to the RFQ
REVISED_DATE DATE

Date of revison of the document
REVISION_NUM NUMBER

Revision Number
RFQ_CLOSE_DATE DATE

Date the RFQ was closed
START_DATE DATE

Date the document becomes effective
START_DATE_ACTIVE DATE

Key Flexfield start date
VENDOR_ORDER_NUM VARCHAR2 (25)
No longer used
AGENT_ID NUMBER (9)
Employee ID
BILL_TO_LOCATION_ID NUMBER

Bill to location unique identifier
FROM_HEADER_ID NUMBER

Unique identifier of the RFQ used to autocreate a quotation
PO_HEADER_ID NUMBER

Document unique identifier
SHIP_TO_LOCATION_ID NUMBER

Ship to unique identifier
TERMS_ID NUMBER

Payment Terms unique identifier
VENDOR_CONTACT_ID NUMBER

Supplier COntact unique identifier
PO_VENDOR_ID NUMBER

Supplier unique identifier
VENDOR_SITE_ID NUMBER

Supplier site unique identifier
CLOSED_CODE VARCHAR2 (25)
Closed code
PO_CURRENCY_CODE VARCHAR2 (15)
Currency code of the purchase order
FIRM_STATUS_LOOKUP_CODE VARCHAR2 (30)
Firm status code
FOB_LOOKUP_CODE VARCHAR2 (25)
Fob Code
FREIGHT_TERMS_LOOKUP_CODE VARCHAR2 (25)
Freight code
FROM_TYPE_LOOKUP_CODE VARCHAR2 (25)
Document type of the document used to autocreate another document
QUOTATION_CLASS_CODE VARCHAR2 (25)
Class of quotation
QUOTE_TYPE_LOOKUP_CODE VARCHAR2 (25)
Type of Quote
REPLY_METHOD_LOOKUP_CODE VARCHAR2 (25)
Type of Reply Method
SHIP_VIA_LOOKUP_CODE VARCHAR2 (25)
Type of carrier to be used
STATUS_LOOKUP_CODE VARCHAR2 (25)
Status code
TYPE_LOOKUP_CODE VARCHAR2 (25)
Document Type
USSGL_TRANSACTION_CODE VARCHAR2 (30)
United States standard general ledger transaction code
ACCEPTANCE_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether acceptance is required on this purchase order
APPROVAL_REQUIRED_FLAG VARCHAR2 (1)
indicates where approval is required or not
APPROVED_FLAG VARCHAR2 (1)
indicates if purchase order is approved or not
CANCEL_FLAG VARCHAR2 (1)
indicates if purchase order is cancelled or not
CONFIRMING_ORDER_FLAG VARCHAR2 (1)
indicates if purchase order is confirming or not
ENABLED_FLAG VARCHAR2 (1)
indicates if purchase order is enabled or not
FROZEN_FLAG VARCHAR2 (1)
indicates if purchase order is frozen or not
SUMMARY_FLAG VARCHAR2 (1)
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

Standard Who Column
LAST_UPDATE_DATE DATE

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_DOCUMENT_NUM VARCHAR2 (61)
Document Number
SEGMENT2 VARCHAR2 (20)
Key Flexfield segment column
SEGMENT3 VARCHAR2 (20)
Key Flexfield segment column
SEGMENT4 VARCHAR2 (20)
Key Flexfield segment column
SEGMENT5 VARCHAR2 (20)
Key Flexfield segment column
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
BUYER_NAME VARCHAR2 (4000)
Buyer name of the purchase order
PO_VENDOR_NAME VARCHAR2 (240)
Supplier name
TYPE_1099 VARCHAR2 (10)
Type 1099
PO_VENDOR_SITE_CODE VARCHAR2 (15)
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 code
COUNTRY VARCHAR2 (25)
country
PHONE VARCHAR2 (28)
phone
FAX VARCHAR2 (28)
fax
PO_VENDOR_CONTACT VARCHAR2 (32)
Supplier contact name
RELEASE_NUM NUMBER

Release Number
RELEASE_TYPE VARCHAR2 (25)
Release Type
PO_RELEASE_ID NUMBER

Document Release unique identifier
PO_TOTAL VARCHAR2 (4000)
Total Amount o purchase order
SUPPLIER_URL VARCHAR2 (150)
Supplier Info URL
Query Text

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


SELECT INVOICE_ID
,      PO_RELEASE_FLAG
,      ROW_ID
,      ACCEPTANCE_DUE_DATE
,      AMOUNT_LIMIT
,      APPROVED_DATE
,      AUTHORIZATION_STATUS
,      BLANKET_TOTAL_AMOUNT
,      CLOSED_DATE
,      COMMENTS
,      END_DATE
,      END_DATE_ACTIVE
,      FIRM_DATE
,      GOVERNMENT_CONTEXT
,      MIN_RELEASE_AMOUNT
,      NOTE_TO_AUTHORIZER
,      NOTE_TO_RECEIVER
,      NOTE_TO_VENDOR
,      PRINT_COUNT
,      PRINTED_DATE
,      QUOTE_VENDOR_QUOTE_NUMBER
,      QUOTE_WARNING_DELAY
,      QUOTE_WARNING_DELAY_UNIT
,      RATE
,      RATE_DATE
,      RATE_TYPE
,      REPLY_DATE
,      REVISED_DATE
,      REVISION_NUM
,      RFQ_CLOSE_DATE
,      START_DATE
,      START_DATE_ACTIVE
,      VENDOR_ORDER_NUM
,      AGENT_ID
,      BILL_TO_LOCATION_ID
,      FROM_HEADER_ID
,      PO_HEADER_ID
,      SHIP_TO_LOCATION_ID
,      TERMS_ID
,      VENDOR_CONTACT_ID
,      PO_VENDOR_ID
,      VENDOR_SITE_ID
,      CLOSED_CODE
,      PO_CURRENCY_CODE
,      FIRM_STATUS_LOOKUP_CODE
,      FOB_LOOKUP_CODE
,      FREIGHT_TERMS_LOOKUP_CODE
,      FROM_TYPE_LOOKUP_CODE
,      QUOTATION_CLASS_CODE
,      QUOTE_TYPE_LOOKUP_CODE
,      REPLY_METHOD_LOOKUP_CODE
,      SHIP_VIA_LOOKUP_CODE
,      STATUS_LOOKUP_CODE
,      TYPE_LOOKUP_CODE
,      USSGL_TRANSACTION_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_DOCUMENT_NUM
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      BUYER_NAME
,      PO_VENDOR_NAME
,      TYPE_1099
,      PO_VENDOR_SITE_CODE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      CITY
,      STATE
,      ZIP
,      COUNTRY
,      PHONE
,      FAX
,      PO_VENDOR_CONTACT
,      RELEASE_NUM
,      RELEASE_TYPE
,      PO_RELEASE_ID
,      PO_TOTAL
,      SUPPLIER_URL
FROM APPS.POS_PO_INVOICE_SUP_ORDERS_V;

Dependencies

[top of page]

APPS.POS_PO_INVOICE_SUP_ORDERS_V references the following:

SchemaAPPS
SynonymAP_INVOICE_DISTRIBUTIONS_ALL
PL/SQL PackageFND_CURRENCY - show dependent code
PL/SQL PackagePOS_GET - show dependent code
PL/SQL PackagePOS_TOTALS_PO_SV - show dependent code
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_HEADERS_ALL
SynonymPO_RELEASES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL

APPS.POS_PO_INVOICE_SUP_ORDERS_V is not referenced by any database object