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_INVOICE_SUP_ORDERS_V

Object Details

Object Name:	POS_PO_INVOICE_SUP_ORDERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POS_PO_INVOICE_SUP_ORDERS_V POS.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	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	(60)	city
STATE	VARCHAR2	(60)	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:

APPS: AP_INVOICE_DISTRIBUTIONS_ALL; FND_CURRENCY - show dependent code; FND_GLOBAL - show dependent code; POS_GET - show dependent code; POS_TOTALS_PO_SV - show dependent code; PO_DISTRIBUTIONS_ALL; PO_HEADERS_ALL; PO_RELEASES_ALL; PO_VENDORS; PO_VENDOR_CONTACTS; PO_VENDOR_SITES_ALL

APPS.POS_PO_INVOICE_SUP_ORDERS_V is not referenced by any database object