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.PO_REQUISITION_TEMPLATES_V

Object Details

Object Name:	PO_REQUISITION_TEMPLATES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.PO_REQUISITION_TEMPLATES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EXPRESS_NAME	VARCHAR2	(25)	Yes
TYPE_LOOKUP_CODE	VARCHAR2	(25)	Yes
DOCUMENT_TYPE	VARCHAR2	(80)
DESCRIPTION	VARCHAR2	(240)
SEQUENCE_NUM	NUMBER		Yes
SOURCE_DOC_HEADER_ID	NUMBER
SOURCE_DOC_NUM	VARCHAR2	(20)
SOURCE_DOC_TYPE_CODE	VARCHAR2	(25)
SOURCE_DOC_TYPE	VARCHAR2	(80)
SOURCE_DOC_CURRENCY	VARCHAR2	(15)
SOURCE_DOC_RATE	NUMBER
SOURCE_DOC_RATE_TYPE	VARCHAR2	(30)
SOURCE_DOC_RATE_TYPE_DSP	VARCHAR2	(30)
SOURCE_DOC_RATE_DATE	DATE
FUNCTIONAL_CURRENCY	VARCHAR2	(15)	Yes
SOURCE_DOC_LINE_ID	NUMBER
SOURCE_DOC_LINE_NUM	NUMBER
SOURCE_DOC_CURRENCY_PRICE	NUMBER
SOURCE_DOC_BASE_PRICE	NUMBER
ITEM_ID	NUMBER
ITEM_DESCRIPTION	VARCHAR2	(240)
LINE_TYPE_ID	NUMBER
LINE_TYPE	VARCHAR2	(25)	Yes
ITEM_REVISION	VARCHAR2	(3)
CATEGORY_ID	NUMBER
UNIT_MEAS_LOOKUP_CODE	VARCHAR2	(25)
TEMPLATE_LINE_PRICE	NUMBER
SUGGESTED_SOURCE_ID	NUMBER
SOURCE_NAME	VARCHAR2	(240)
SUGGESTED_VENDOR_SITE_ID	NUMBER
VENDOR_SITE_CODE	VARCHAR2	(15)
SUGGESTED_VENDOR_CONTACT_ID	NUMBER
VENDOR_CONTACT_NAME	VARCHAR2	(32)
SUGGESTED_VENDOR_PRODUCT_CODE	VARCHAR2	(25)
SUGGESTED_BUYER_ID	NUMBER	(9)
BUYER_NAME	VARCHAR2	(240)
RFQ_REQUIRED_FLAG	VARCHAR2	(1)
SOURCE_TYPE_CODE	VARCHAR2	(25)
SOURCE_TYPE	VARCHAR2	(80)	Yes
SOURCE_ORG_CODE	VARCHAR2	(3)
SOURCE_SUBINVENTORY	VARCHAR2	(10)
OUTSIDE_OPERATION_FLAG	VARCHAR2	(1)
ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(25)	Yes
ORDER_TYPE_LOOKUP_DSP	VARCHAR2	(80)	Yes
AMOUNT	NUMBER			Amount
PURCHASE_BASIS	VARCHAR2	(30)	Yes	Purchase basis for the line
NEGOTIATED_BY_PREPARER_FLAG	VARCHAR2	(1)
MATCHING_BASIS	VARCHAR2	(30)	Yes	Matching basis of the line. References PO_LINE_TYPES.MATCHING_BASIS.
ORG_ID	NUMBER			Organization identifier

Query Text

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


SELECT EXPRESS_NAME
,      TYPE_LOOKUP_CODE
,      DOCUMENT_TYPE
,      DESCRIPTION
,      SEQUENCE_NUM
,      SOURCE_DOC_HEADER_ID
,      SOURCE_DOC_NUM
,      SOURCE_DOC_TYPE_CODE
,      SOURCE_DOC_TYPE
,      SOURCE_DOC_CURRENCY
,      SOURCE_DOC_RATE
,      SOURCE_DOC_RATE_TYPE
,      SOURCE_DOC_RATE_TYPE_DSP
,      SOURCE_DOC_RATE_DATE
,      FUNCTIONAL_CURRENCY
,      SOURCE_DOC_LINE_ID
,      SOURCE_DOC_LINE_NUM
,      SOURCE_DOC_CURRENCY_PRICE
,      SOURCE_DOC_BASE_PRICE
,      ITEM_ID
,      ITEM_DESCRIPTION
,      LINE_TYPE_ID
,      LINE_TYPE
,      ITEM_REVISION
,      CATEGORY_ID
,      UNIT_MEAS_LOOKUP_CODE
,      TEMPLATE_LINE_PRICE
,      SUGGESTED_SOURCE_ID
,      SOURCE_NAME
,      SUGGESTED_VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      SUGGESTED_VENDOR_CONTACT_ID
,      VENDOR_CONTACT_NAME
,      SUGGESTED_VENDOR_PRODUCT_CODE
,      SUGGESTED_BUYER_ID
,      BUYER_NAME
,      RFQ_REQUIRED_FLAG
,      SOURCE_TYPE_CODE
,      SOURCE_TYPE
,      SOURCE_ORG_CODE
,      SOURCE_SUBINVENTORY
,      OUTSIDE_OPERATION_FLAG
,      ORDER_TYPE_LOOKUP_CODE
,      ORDER_TYPE_LOOKUP_DSP
,      AMOUNT
,      PURCHASE_BASIS
,      NEGOTIATED_BY_PREPARER_FLAG
,      MATCHING_BASIS
,      ORG_ID
FROM APPS.PO_REQUISITION_TEMPLATES_V;

Dependencies

[top of page]

APPS.PO_REQUISITION_TEMPLATES_V references the following:

APPS: CST_ITEM_COSTS; FINANCIALS_SYSTEM_PARAMS_ALL; FND_GLOBAL - show dependent code; GL_DAILY_CONVERSION_TYPES; GL_SETS_OF_BOOKS; HR_ALL_ORGANIZATION_UNITS_TL; HR_GENERAL - show dependent code; HR_ORG_UNITS_NO_JOIN; HR_SECURITY - show dependent code; MTL_PARAMETERS; PER_ALL_PEOPLE_F; PO_DOCUMENT_TYPES_ALL_B; PO_DOCUMENT_TYPES_ALL_TL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_TYPES; PO_LOOKUP_CODES; PO_REQEXPRESS_HEADERS; PO_REQEXPRESS_LINES_ALL; PO_VENDORS; PO_VENDOR_CONTACTS; PO_VENDOR_SITES_ALL

APPS.PO_REQUISITION_TEMPLATES_V is not referenced by any database object