Search Results ap_pol_lines




Overview
Explore in AI Chat

Overview

The AP_POL_LINES table is a core data structure within the Oracle E-Business Suite Payables (AP) module, specifically supporting the Policy Schedule functionality. It serves as the detailed repository for individual line items that constitute a policy schedule. Each record in this table defines a specific financial or coverage component, such as a deductible, limit, or coverage amount, within a broader insurance or corporate policy defined in the AP_POL_HEADERS table. Its primary role is to enable the systematic capture, tracking, and application of policy rules to payable transactions, ensuring compliance and accurate financial accounting for insured liabilities.

Key Information Stored

The table's central identifier is the POLICY_LINE_ID, a system-generated primary key that uniquely defines each schedule line. Critical relational columns include POLICY_ID, which links the line to its parent policy header, and SCHEDULE_PERIOD_ID, associating the line with a specific effective time period. The table stores the financial and descriptive details of the policy line, such as the CURRENCY_CODE for the line amount and a LOCATION_ID to specify applicable geographic or organizational scope. A significant structural feature is the PARENT_LINE_ID column, which supports hierarchical relationships between lines, allowing for complex, multi-level policy schedules. Other columns typically define line types, calculated or fixed amounts, and descriptive information.

Common Use Cases and Queries

A primary use case is generating reports to analyze policy coverage details or validate payable transactions against policy rules. For instance, a query to list all lines for a specific policy, ordered hierarchically, is common. Auditors may run queries to reconcile policy schedules with general ledger accounts or to identify lines nearing their coverage limits. A typical SQL pattern involves joining to AP_POL_HEADERS for policy metadata and using a self-join or hierarchical query (CONNECT BY) to navigate parent-child relationships within the lines themselves.

  • Sample Query (Basic Join): SELECT line.policy_line_id, line.line_type, header.policy_number FROM ap_pol_lines line, ap_pol_headers header WHERE line.policy_id = header.policy_id AND header.policy_number = 'POL1001';
  • Reporting Use Case: Creating a detailed policy schedule report that displays the hierarchical structure of coverage lines, their effective periods, and associated financial limits.

Related Objects

The AP_POL_LINES table is centrally connected to several key objects via documented foreign key relationships. It is a child of the AP_POL_HEADERS table through the POLICY_ID column, establishing the core policy-to-line relationship. It references AP_POL_SCHEDULE_PERIODS via SCHEDULE_PERIOD_ID for temporal validity. The CURRENCY_CODE column links to the standard FND_CURRENCIES table, and LOCATION_ID references AP_POL_LOCATIONS_B. The self-referencing foreign key on PARENT_LINE_ID enables the internal line hierarchy. Furthermore, it is a parent table to AP_POL_LINES_HISTORY, which tracks changes to policy line records over time via the POLICY_LINE_ID foreign key.

  • Table: AP_POL_LINES 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_POL_LINES,  object_name:AP_POL_LINES,  status:VALID,  product: AP - Payables ,  description: This table stores the policy schedule line information. ,  implementation_dba_data: AP.AP_POL_LINES , 

  • Table: AP_POL_LINES 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_POL_LINES,  object_name:AP_POL_LINES,  status:VALID,  product: AP - Payables ,  description: This table stores the policy schedule line information. ,  implementation_dba_data: AP.AP_POL_LINES , 

  • Table: AP_POL_SCHEDULE_PERIODS 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_POL_SCHEDULE_PERIODS,  object_name:AP_POL_SCHEDULE_PERIODS,  status:VALID,  product: AP - Payables ,  description: This table stores policy schedule period information. ,  implementation_dba_data: AP.AP_POL_SCHEDULE_PERIODS , 

  • Table: AP_POL_LINES_HISTORY 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_POL_LINES_HISTORY,  object_name:AP_POL_LINES_HISTORY,  status:VALID,  product: AP - Payables ,  description: This table stores the life cycle of a policy schedule line. ,  implementation_dba_data: AP.AP_POL_LINES_HISTORY , 

  • Table: AP_POL_SCHEDULE_PERIODS 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_POL_SCHEDULE_PERIODS,  object_name:AP_POL_SCHEDULE_PERIODS,  status:VALID,  product: AP - Payables ,  description: This table stores policy schedule period information. ,  implementation_dba_data: AP.AP_POL_SCHEDULE_PERIODS , 

  • Table: AP_POL_LINES_HISTORY 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_POL_LINES_HISTORY,  object_name:AP_POL_LINES_HISTORY,  status:VALID,  product: AP - Payables ,  description: This table stores the life cycle of a policy schedule line. ,  implementation_dba_data: AP.AP_POL_LINES_HISTORY , 

  • Table: AP_POL_HEADERS 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_POL_HEADERS,  object_name:AP_POL_HEADERS,  status:VALID,  product: AP - Payables ,  description: This table stores the policy schedule header information. ,  implementation_dba_data: AP.AP_POL_HEADERS , 

  • Table: AP_POL_HEADERS 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_POL_HEADERS,  object_name:AP_POL_HEADERS,  status:VALID,  product: AP - Payables ,  description: This table stores the policy schedule header information. ,  implementation_dba_data: AP.AP_POL_HEADERS , 

  • Table: AP_POL_LOCATIONS_B 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_POL_LOCATIONS_B,  object_name:AP_POL_LOCATIONS_B,  status:VALID,  product: AP - Payables ,  description: This table stores policy schedule location information. ,  implementation_dba_data: AP.AP_POL_LOCATIONS_B , 

  • Table: AP_POL_LOCATIONS_B 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_POL_LOCATIONS_B,  object_name:AP_POL_LOCATIONS_B,  status:VALID,  product: AP - Payables ,  description: This table stores policy schedule location information. ,  implementation_dba_data: AP.AP_POL_LOCATIONS_B ,