Search Results pol_attribute1




Overview
Explore in AI Chat

Overview

APPS.AP_PO_LINES_EXTRACT_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite. It is registered in the application's design metadata under the FND Design Data identifier SQLAP.AP_PO_LINES_EXTRACT_V, placing it within the Payables (SQLAP) product family. The view is currently documented as VALID in ETRM for release 12.2.2 and is equally applicable to 12.1.1.

The view exposes purchase order line information drawn from the Payables/Procurement data model, together with the descriptive flexfield (DFF) context and segment values attached to those lines. Its name and column profile indicate that it was created as an extraction interface — a purpose-built projection used to surface PO line data and their flexfield attributes to external processes, reports, or integration programs rather than for online transactional use. The columns prefixed POL_ reflect the source alias for the PO lines table and carry the attribute segments that the user is searching for, including POL_ATTRIBUTE1, which corresponds to the query term "pol_attribute1".

Underlying Base Objects

Per the documented view metadata for release 12.2.2, the view is defined over a single referenced base object: PO_LINES_ALL, accessed through a SYNONYM. PO_LINES_ALL is the core Purchasing table storing every purchase order line across all operating units; it holds the line identifiers, line numbers, item descriptions, and the DFF/global DFF columns that the view renames with the POL_ prefix.

Because the view resolves against a synonym and a single base table, it introduces no joins or aggregation of its own — it is a straightforward column-renaming projection. This is significant for two reasons. First, it means the view inherits the row-level security and multi-org filtering characteristics of the underlying synonym. Second, the descriptive flexfield columns (ATTRIBUTE1 through ATTRIBUTE15) and global descriptive flexfield columns (GLOBAL_ATTRIBUTE1 through GLOBAL_ATTRIBUTE20) are exposed directly from PO_LINES_ALL, so any values written by the PO Line DFF must already exist in the base table for the view to return them.

Key Columns

The view exposes a focused set of columns suited to line-level extraction:

Common Use Cases and Queries

The primary use case is extracting PO line DFF data for downstream reporting, conversion, or interface processing. A typical query retrieves the descriptive flexfield context and attribute values for a specific line:

SELECT PO_LINE_ID, POL_LINE_NUM, POL_ATTRIBUTE_CATEGORY, POL_ATTRIBUTE1
FROM APPS.AP_PO_LINES_EXTRACT_V
WHERE POL_LINE_NUM IS NOT NULL;

A more targeted extraction selects all populated attributes for lines in a given DFF context:

SELECT PO_LINE_ID, POL_LINE_NUM, POL_ATTRIBUTE1, POL_ATTRIBUTE2, POL_ATTRIBUTE3
FROM APPS.AP_PO_LINES_EXTRACT_V
WHERE POL_ATTRIBUTE_CATEGORY = :p_context
AND POL_LINE_NUM = :p_line_num;

Because the view is a thin projection over PO_LINES_ALL, developers commonly use it to avoid hard-coding the base table name and to obtain consistent POL_-prefixed aliases in extraction programs. Note that the view is a reporting construct only; DML against the extracted flexfield values must be performed against PO_LINES_ALL itself, subject to the standard Purchasing APIs and validation.

  • VIEW: APPS.AP_PO_LINES_EXTRACT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_PO_LINES_EXTRACT_V,  object_name:AP_PO_LINES_EXTRACT_V,  status:VALID, 

  • VIEW: APPS.AP_PO_LINES_EXTRACT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_PO_LINES_EXTRACT_V,  object_name:AP_PO_LINES_EXTRACT_V,  status:VALID, 

  • View: ECE_POO_LINES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_POO_LINES_V,  object_name:ECE_POO_LINES_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: /*#* This view extracts line information* for the outbound Purchase Order (850/ORDERS) transaction.* @rep:scope private* @rep:product PO* @rep:lifecycle active* @rep:displayname Purchase Order Line View* @rep:category BUSINESS_ENTITY PO_PUR ,  implementation_dba_data: APPS.ECE_POO_LINES_V , 

  • View: ECE_POCO_LINES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_POCO_LINES_V,  object_name:ECE_POCO_LINES_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts line informationfor the outbound Purchase Order Change (860/ORDCHG) transaction.@rep:scope private@rep:product PO@rep:lifecycle active@rep:displayname Purchase Order Change Line View@rep:category BUSINESS_ENTITY PO_PURCHA ,  implementation_dba_data: APPS.ECE_POCO_LINES_V , 

  • View: ECE_POO_LINES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_POO_LINES_V,  object_name:ECE_POO_LINES_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: /*#* This view extracts line information* for the outbound Purchase Order (850/ORDERS) transaction.* @rep:scope private* @rep:product PO* @rep:lifecycle active* @rep:displayname Purchase Order Line View* @rep:category BUSINESS_ENTITY PO_PUR ,  implementation_dba_data: APPS.ECE_POO_LINES_V , 

  • View: ECE_POCO_LINES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_POCO_LINES_V,  object_name:ECE_POCO_LINES_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts line informationfor the outbound Purchase Order Change (860/ORDCHG) transaction.@rep:scope private@rep:product PO@rep:lifecycle active@rep:displayname Purchase Order Change Line View@rep:category BUSINESS_ENTITY PO_PURCHA ,  implementation_dba_data: APPS.ECE_POCO_LINES_V , 

  • VIEW: APPS.ECE_POO_LINES_V 12.2.2

  • VIEW: APPS.ECE_POCO_LINES_V 12.1.1

  • VIEW: APPS.ECE_POCO_LINES_V 12.2.2

  • VIEW: APPS.ECE_POO_LINES_V 12.1.1

  • VIEW: APPS.PO_LINES_REF_V 12.2.2

    owner:APPS,  object_type:VIEW,  object_name:PO_LINES_REF_V,  status:VALID, 

  • VIEW: APPS.ECE_POO_LINES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_POO_LINES_V,  object_name:ECE_POO_LINES_V,  status:VALID, 

  • View: AP_PO_DETAILS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_PO_DETAILS_V,  object_name:AP_PO_DETAILS_V,  status:VALID,  product: AP - Payables ,  implementation_dba_data: APPS.AP_PO_DETAILS_V , 

  • View: AP_PO_DETAILS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_PO_DETAILS_V,  object_name:AP_PO_DETAILS_V,  status:VALID,  product: AP - Payables ,  implementation_dba_data: APPS.AP_PO_DETAILS_V , 

  • VIEW: APPS.ECE_POCO_LINES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_POCO_LINES_V,  object_name:ECE_POCO_LINES_V,  status:VALID, 

  • VIEW: APPS.PO_LINES_REF_V 12.1.1

    owner:APPS,  object_type:VIEW,  object_name:PO_LINES_REF_V,  status:VALID, 

  • VIEW: APPS.ECE_POCO_LINES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_POCO_LINES_V,  object_name:ECE_POCO_LINES_V,  status:VALID, 

  • VIEW: APPS.ECE_POO_LINES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_POO_LINES_V,  object_name:ECE_POO_LINES_V,  status:VALID, 

  • VIEW: APPS.AP_PO_DETAILS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_PO_DETAILS_V,  object_name:AP_PO_DETAILS_V,  status:VALID, 

  • VIEW: APPS.AP_PO_DETAILS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.AP_PO_DETAILS_V,  object_name:AP_PO_DETAILS_V,  status:VALID, 

  • eTRM - EC Tables and Views 12.1.1

    description: Contains the information for code conversions which identify external values for a given Oracle internal value and vice versa. , 

  • eTRM - EC Tables and Views 12.2.2

    description: Contains the information for code conversions which identify external values for a given Oracle internal value and vice versa. , 

  • eTRM - SQLAP Tables and Views 12.2.2

    description: Set Distribution Table. , 

  • eTRM - SQLAP Tables and Views 12.1.1

    description: Set Distribution Table. ,