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_AUTOSOURCE_DOCUMENTS_V

Object Details

Object Name:	PO_AUTOSOURCE_DOCUMENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.PO_AUTOSOURCE_DOCUMENTS_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	Comments
AUTOSOURCE_RULE_ID	NUMBER
VENDOR_ID	NUMBER
VENDOR_NAME	VARCHAR2	(240)
SEQUENCE_NUM	NUMBER
TYPE_LOOKUP_CODE	VARCHAR2	(25)
PO_HEADER_ID	NUMBER
DOCUMENT_NUM	VARCHAR2	(20)
PO_LINE_ID	NUMBER
LINE_NUM	NUMBER
LINE_SHIP_CONCAT_NUM	VARCHAR2	(81)
DOC_GENERATION_METHOD	VARCHAR2	(25)
LINE_LOCATION_ID	NUMBER
VENDOR_SITE_ID	NUMBER
VENDOR_SITE_CODE	VARCHAR2	(15)
VENDOR_CONTACT_ID	NUMBER
VENDOR_CONTACT_NAME	VARCHAR2	(37)
DOCUMENT_STATUS_CODE	VARCHAR2	(25)
AGENT_ID	NUMBER	(9)
AGENT_NAME	VARCHAR2	(240)
CURRENCY_CODE	VARCHAR2	(15)
HEADER_PAYMENT_TERMS_ID	NUMBER
HEADER_SHIP_VIA_LOOKUP_CODE	VARCHAR2	(25)
HEADER_FREIGHT_TERMS_CODE	VARCHAR2	(25)
HEADER_FOB_LOOKUP_CODE	VARCHAR2	(25)
SHIPMENT_PAYMENT_TERMS_ID	NUMBER
SHIPMENT_SHIP_VIA_LOOKUP_CODE	VARCHAR2	(25)
SHIPMENT_FREIGHT_TERMS_CODE	VARCHAR2	(25)
SHIPMENT_FOB_LOOKUP_CODE	VARCHAR2	(25)
VENDOR_QUOTE_NUM	VARCHAR2	(25)
ASSOCIATED_RFQ_ID	NUMBER
ASSOCIATED_RFQ_NUM	VARCHAR2	(20)
EFFECTIVE_FROM	DATE
EFFECTIVE_TO	DATE
ITEM_REVISION	VARCHAR2	(3)
VENDOR_PRODUCT_NUM	VARCHAR2	(25)
LINE_TYPE_ID	NUMBER
LINE_TYPE	VARCHAR2	(25)
LINE_UOM	VARCHAR2	(25)
LINE_QUANTITY	NUMBER
CURRENCY_LINE_PRICE	NUMBER
SHIPMENT_QUANTITY	NUMBER
CURRENCY_SHIPMENT_PRICE	NUMBER
SHIPMENT_UOM	VARCHAR2	(25)
SHIP_TO_LOCATION_ID	NUMBER
SHIP_TO_ORGANIZATION_ID	NUMBER
SHIP_TO_ORGANIZATION_CODE	VARCHAR2	(3)
SHIP_TO_ORGANIZATION_NAME	VARCHAR2	(240)
SHIPMENT_EFFECTIVE_FROM	DATE
SHIPMENT_EFFECTIVE_TO	DATE
FUNCTIONAL_CURRENCY	VARCHAR2	(15)
QUOTE_APPROVAL_REQUIRED_FLAG	VARCHAR2	(1)
OUTSIDE_OPERATION_FLAG	VARCHAR2	(1)
ITEM_ID	NUMBER
CATEGORY_ID	NUMBER
ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(25)
ASL_INSTALLED_FLAG	CHAR	(1)
SECONDARY_LINE_UOM	VARCHAR2	(25)
SECONDARY_LINE_QUANTITY	NUMBER
SECONDARY_SHIPMENT_UOM	VARCHAR2	(25)
SECONDARY_SHIPMENT_QUANTITY	NUMBER
PREFERRED_GRADE	VARCHAR2	(150)
GLOBAL_AGREEMENT_FLAG	VARCHAR2	(1)	Global Agreement flag to indicate if the agreement is global.
OWNING_ORG_ID	NUMBER		The owning organization of the document.
GA_REQUESTING_ORG_ID	NUMBER		The Requesting Org of the current org assignment for this Global Agreement.
GA_PURCHASING_ORG_ID	NUMBER		The Purchasing Org of the current org assignment for this Global Agreement
NEGOTIATED_BY_PREPARER_FLAG	VARCHAR2	(1)
PURCHASE_BASIS	VARCHAR2	(30)	Purchase basis of the line. References PO_LINE_TYPES.PURCHASE_BASIS.
MATCHING_BASIS	VARCHAR2	(30)	Matching basis of the line. References PO_LINE_TYPES.matching_basis.
ORG_ID	NUMBER	(15)	Organization identifier

Query Text

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


SELECT AUTOSOURCE_RULE_ID
,      VENDOR_ID
,      VENDOR_NAME
,      SEQUENCE_NUM
,      TYPE_LOOKUP_CODE
,      PO_HEADER_ID
,      DOCUMENT_NUM
,      PO_LINE_ID
,      LINE_NUM
,      LINE_SHIP_CONCAT_NUM
,      DOC_GENERATION_METHOD
,      LINE_LOCATION_ID
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      VENDOR_CONTACT_ID
,      VENDOR_CONTACT_NAME
,      DOCUMENT_STATUS_CODE
,      AGENT_ID
,      AGENT_NAME
,      CURRENCY_CODE
,      HEADER_PAYMENT_TERMS_ID
,      HEADER_SHIP_VIA_LOOKUP_CODE
,      HEADER_FREIGHT_TERMS_CODE
,      HEADER_FOB_LOOKUP_CODE
,      SHIPMENT_PAYMENT_TERMS_ID
,      SHIPMENT_SHIP_VIA_LOOKUP_CODE
,      SHIPMENT_FREIGHT_TERMS_CODE
,      SHIPMENT_FOB_LOOKUP_CODE
,      VENDOR_QUOTE_NUM
,      ASSOCIATED_RFQ_ID
,      ASSOCIATED_RFQ_NUM
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      ITEM_REVISION
,      VENDOR_PRODUCT_NUM
,      LINE_TYPE_ID
,      LINE_TYPE
,      LINE_UOM
,      LINE_QUANTITY
,      CURRENCY_LINE_PRICE
,      SHIPMENT_QUANTITY
,      CURRENCY_SHIPMENT_PRICE
,      SHIPMENT_UOM
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_ORGANIZATION_CODE
,      SHIP_TO_ORGANIZATION_NAME
,      SHIPMENT_EFFECTIVE_FROM
,      SHIPMENT_EFFECTIVE_TO
,      FUNCTIONAL_CURRENCY
,      QUOTE_APPROVAL_REQUIRED_FLAG
,      OUTSIDE_OPERATION_FLAG
,      ITEM_ID
,      CATEGORY_ID
,      ORDER_TYPE_LOOKUP_CODE
,      ASL_INSTALLED_FLAG
,      SECONDARY_LINE_UOM
,      SECONDARY_LINE_QUANTITY
,      SECONDARY_SHIPMENT_UOM
,      SECONDARY_SHIPMENT_QUANTITY
,      PREFERRED_GRADE
,      GLOBAL_AGREEMENT_FLAG
,      OWNING_ORG_ID
,      GA_REQUESTING_ORG_ID
,      GA_PURCHASING_ORG_ID
,      NEGOTIATED_BY_PREPARER_FLAG
,      PURCHASE_BASIS
,      MATCHING_BASIS
,      ORG_ID
FROM APPS.PO_AUTOSOURCE_DOCUMENTS_V;

Dependencies

[top of page]

APPS.PO_AUTOSOURCE_DOCUMENTS_V references the following:

APPS: AP_SUPPLIER_CONTACTS; FINANCIALS_SYSTEM_PARAMETERS; GL_SETS_OF_BOOKS; HR_ALL_ORGANIZATION_UNITS_TL; MTL_PARAMETERS; PER_ALL_PEOPLE_F; PO_APPROVED_SUPPLIER_LIS_VAL_V; PO_ASL_ATTRIBUTES; PO_ASL_DOCUMENTS; PO_AUTOSOURCE_DOCUMENTS_ALL; PO_GA_ORG_ASSIGNMENTS; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_LINE_TYPES; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.PO_AUTOSOURCE_DOCUMENTS_V is not referenced by any database object