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: ViewPO.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 Mandatory 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 (77)

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:

SchemaAPPS
SynonymAP_SUPPLIER_CONTACTS
SynonymFINANCIALS_SYSTEM_PARAMETERS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewGL_SETS_OF_BOOKS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymMTL_PARAMETERS
SynonymPER_ALL_PEOPLE_F
ViewPO_APPROVED_SUPPLIER_LIS_VAL_V
SynonymPO_ASL_ATTRIBUTES
SynonymPO_ASL_DOCUMENTS
SynonymPO_AUTOSOURCE_DOCUMENTS_ALL
SynonymPO_GA_ORG_ASSIGNMENTS
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_LINE_TYPES
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.PO_AUTOSOURCE_DOCUMENTS_V is not referenced by any database object