Search Results cdl_status

Overview

APPS.PA_CINT_TXN_DETAILS_V is an Oracle E-Business Suite view that exposes detailed capitalized interest (CINT) transaction information. It is a reporting and integration construct rather than a base table, joining project, task, expenditure, cost distribution, rate-schedule, and capitalization definition data into a single denormalized row per capitalized-interest transaction line. In releases 12.1.1 and 12.2.2, the view is owned by APPS and is used primarily by capitalized interest processing, project asset capitalization reporting, and downstream interfaces that require per-line burdened or raw cost amounts, grouping keys, and capitalization status.

The view is significant because it resolves several values through PL/SQL functions in the PA_CLIENT_EXTN_CAP_INT package (grouping_method, expenditure_org, rate_multiplier), allowing client-specific capitalization logic to be reflected directly in the query output without custom columns in the base tables.

Underlying Base Objects

The view is defined over the following documented synonyms and package:

• PA_COST_DISTRIBUTION_LINES_ALL — the primary transactional source (line amount, line type, line number, GL/Recvr GL date, billable flag, org_id).
• PA_EXPENDITURE_ITEMS_ALL — expenditure item date, attributes, category, and transaction source.
• PA_EXPENDITURE_TYPES — expenditure type and expenditure category.
• PA_PROJECTS and PA_TASKS — carrying-out organization, start/completion/capitalization stop dates, and task number.
• PA_PROJECT_TYPES — capital cost type code, burden amount display method, and total burden flag.
• PA_CINT_RATE_INFO — capitalization rate information and expenditure organization source.
• PA_IND_COST_CODES — indirect cost code.
• PA_PROJECT_ASSET_LINE_DETAILS — used in a scalar subquery to derive capitalization line status.
• GL_PERIOD_STATUSES — period name context via the gps alias.
• PA_IMPLEMENTATIONS, PA_CINT_EXP_TYPE_EXCL_ALL — supporting implementation and exclusion logic.
• PA_CLIENT_EXTN_CAP_INT — package invoked for grouping_method, expenditure_org, and rate_multiplier.

Key Columns

• cdl_status — derived via a scalar subquery on PA_PROJECT_ASSET_LINE_DETAILS; returns 'CLOSED' when a matching unreversed asset line detail exists for the expenditure item and line number, otherwise 'OPEN'. This is the column most commonly searched by users.
• project_id, segment1, task_id, task_number — project and task identification.
• expenditure_item_id, expenditure_item_date — expenditure item identity and date.
• capital_cost_type_code, burden_amt_display_method, total_burden_flag — capitalization behavior flags.
• line_type, line_num — cost distribution line type and number; line_type 'D' alters amount selection.
• amount (computed expression) — either the raw line amount or burdened cost, depending on line_type and capital_cost_type_code.
• TRUNC(NVL(recvr_gl_date, gl_date)) — effective GL date.
• ind_cost_code, billable_flag, org_id — indirect cost classification, billing indicator, and organization.
• rate_multiplier — resolved through PA_CLIENT_EXTN_CAP_INT.
• period_name — GL period for capitalization reporting.

Common Use Cases and Queries

Typical scenarios include reviewing which capitalized interest transactions remain open versus closed, reconciling capitalized cost amounts by project/task and period, and feeding capitalization data into asset interfaces.

• Reporting open capitalized interest lines by project.
• Reconciling burdened versus raw capitalized amounts by cost type.
• Feeding project asset capitalization extracts.

Sample query filtering on the searched column:

• SELECT project_id, task_number, expenditure_item_id, line_num, cdl_status, period_name FROM apps.pa_cint_txn_details_v WHERE cdl_status = 'OPEN';
• SELECT project_id, segment1, period_name, SUM(amount) FROM apps.pa_cint_txn_details_v WHERE cdl_status = 'CLOSED' GROUP BY project_id, segment1, period_name;

Because cdl_status is computed from PA_PROJECT_ASSET_LINE_DETAILS using ROWNUM = 1 and reversed_flag = 'N', the result reflects the first unreversed asset line detail matching the expenditure item and line number, and defaults to 'OPEN' when no match exists.