Search Results payables_batch_name

Overview

PA_PROJECT_ASSET_LINES is a single-organization (Single-Org) reporting view in the Oracle EBS Projects (PA) module. It exposes the capital asset line information generated by Oracle Projects when costs accumulated against a project are capitalized and interfaced to Oracle Assets. The view presents one row per project asset line, capturing the descriptive, financial, transfer, and reversal attributes associated with each capitalized cost line.

The view is defined as a filtered projection over PA_PROJECT_ASSET_LINES_ALL. Rather than exposing all organization rows directly, the view applies an ORG_ID predicate derived from the session's CLIENT_INFO, restricting results to a single operating unit. This design allows reporting and integration consumers to query asset lines without manually applying multi-org security filters, while the underlying _ALL table retains the full multi-org data set. Note that within the specific implementation from which this metadata was drawn, the view is documented as "Not implemented in this database," meaning the definition is catalogued but not instantiated in that environment.

Underlying Base Objects

The view is defined over a single documented base object: PA_PROJECT_ASSET_LINES_ALL. No additional referenced base objects are documented. The relationship is a straightforward column projection with a row-level filter. The view selects columns directly from the _ALL table and appends a WHERE clause that resolves ORG_ID for the current session:

• The predicate compares NVL(ORG_ID, NVL(decoded CLIENT_INFO value, -99)) against the same decoded session expression.
• The CLIENT_INFO substitution extracts the first ten characters of USERENV('CLIENT_INFO'), handling the standard multi-org initialization format where a leading space indicates a null organization.
• Rows whose ORG_ID matches the session organization pass through; rows for other operating units are excluded.

Because the view is single-org, it is appropriate for operating-unit-scoped reporting, but queries requiring cross-organization visibility must target PA_PROJECT_ASSET_LINES_ALL directly.

Key Columns

• PROJECT_ASSET_LINE_ID — Primary identifier for the asset line.
• PROJECT_ASSET_ID / PROJECT_ID / TASK_ID — Links to the parent project asset, project, and task.
• CIP_CCID / ASSET_COST_CCID — Construction-in-process and asset cost account code combinations.
• ORIGINAL_ASSET_COST / CURRENT_ASSET_COST — Original and current capitalized cost amounts.
• AMORTIZE_FLAG — Indicates whether the associated cost is subject to amortization; directly relevant to the reported search term.
• TRANSFER_STATUS_CODE / TRANSFER_REJECTION_REASON — Status of the line's transfer to Oracle Assets and any rejection reason.
• ASSET_CATEGORY_ID / NEW_MASTER_FLAG — Asset category assignment and master-asset designation.
• GL_DATE / FA_PERIOD_NAME — Accounting date and the Assets period affected.
• INVOICE_NUMBER / VENDOR_NUMBER / PO_NUMBER / INVOICE_DATE — Sourcing payables and purchasing references.
• REV_PROJ_ASSET_LINE_ID / REV_FROM_PROJ_ASSET_LINE_ID — Reversal linkage between asset lines.
• LINE_TYPE / ORG_ID — Line classification and the operating unit used by the view filter.

Common Use Cases and Queries

Typical uses include reconciling capitalized costs between Projects and Assets, reporting transfer status, and auditing amortization treatment. The following sample retrieves amortization-relevant capitalized lines for the current operating unit:

SELECT project_asset_line_id, project_id, task_id, original_asset_cost, current_asset_cost, amortize_flag, transfer_status_code, gl_date FROM pa_project_asset_lines WHERE amortize_flag = 'Y' AND transfer_status_code = 'PENDING';

To review rejected transfers and their reasons:

SELECT project_asset_line_id, transfer_status_code, transfer_rejection_reason, fa_period_name FROM pa_project_asset_lines WHERE transfer_status_code = 'REJECTED';

For cross-organization analysis, query PA_PROJECT_ASSET_LINES_ALL and apply explicit ORG_ID filtering, since the view intentionally limits results to the session organization.