Results for “non_labor”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PA_PROJ_RETN_EXP_V is a security-aware reporting view in Oracle EBS Projects (PA) that exposes project retention rules and the retention amounts withheld from expenditures. It joins retention rule definitions to the retention transactions actually held against a project, task, agreement, and customer, and flattens the result into a single denormalized row per retention rule instance. The view is primarily consumed by Oracle Projects retention inquiry screens, by the Project Billing and Project Costing reporting layers, and by external integrations that must reconcile retained amounts across multiple currencies.

The view is particularly relevant to searches involving non_labor. The underlying driver predicate restricts results to retention rules whose RETENTION_LEVEL_CODE is IN ('EXPENDITURE_TYPE', 'EXPENDITURE_CATEGORY', 'NON_LABOR'). A NON_LABOR retention rule is one whose level of application is not the labor expenditure type but rather the non-labor resource, identified by the NON_LABOR_RESOURCE column surfaced from PA_PROJ_RETN_RULES. This makes the view the canonical source for reporting retention that is keyed to non-labor resources rather than to labor cost.

Underlying Base Objects

The view is defined over the following documented objects:

• PA_PROJ_RETN_RULES (alias RL) — retention rule header: level code, effective dates, retention percentage, retention amount, threshold amount, expenditure category, expenditure type, and non-labor resource.
• PA_PROJECT_RETENTIONS (alias RT) — retention transactions actually recorded, including retained totals in invoice processing, funding, project, and project functional currencies.
• PA_PROJECTS_ALL (alias P) and PA_TASKS (alias T) — project and task context; task join is outer (T.PROJECT_ID(+) and T.TASK_ID(+)), so rules at project level without a task still return.
• PA_AGREEMENTS_ALL (alias A), HZ_CUST_ACCOUNTS (alias CUST_ACCT), and HZ_PARTIES (alias PARTY) — agreement and customer identification.
• PA_LOOKUPS (alias LK) — supplies the masked literal 'SECURED_DATA' used to substitute secured project and task identifiers.
• PA_SECURITY (package) — PA_SECURITY.ALLOW_QUERY is invoked per row to determine whether the caller may see real project, task, and customer values.

Key Columns

• ROW_ID, RETENTION_RULE_ID — row identity and the originating rule identifier used for drill-down.
• RETENTION_LEVEL_CODE — EXPENDITURE_TYPE, EXPENDITURE_CATEGORY, or NON_LABOR; the NON_LABOR value drives non-labor retention analysis.
• PROJECT_ID / project segment and name — masked to the string 'SECURED_DATA' when PA_SECURITY.ALLOW_QUERY returns other than 'Y'.
• TASK_ID / TASK_NUMBER / TASK_NAME — task-level retention context, similarly secured.
• AGREEMENT_ID, AGREEMENT_NUM, CUSTOMER_ID, ACCOUNT_NUMBER, PARTY_NAME — billing and customer attribution.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE, RETENTION_PERCENTAGE, RETENTION_AMOUNT, THRESHOLD_AMOUNT — rule terms governing when and how much is retained.
• EXPENDITURE_CATEGORY, EXPENDITURE_TYPE, NON_LABOR_RESOURCE — the applicability key for the rule; NON_LABOR_RESOURCE identifies the non-labor item.
• INVPROC_CURRENCY_CODE / TOTAL_RETAINED, FUNDING_CURRENCY_CODE / FUNDING_TOTAL_RETAINED, PROJECT_CURRENCY_CODE / PROJECT_TOTAL_RETAINED, PROJFUNC_CURRENCY_CODE / PROJFUNC_TOTAL_RETAINED — retained balances in each of the four retention currency bases.

Common Use Cases and Queries

Typical scenarios include listing all retention rules applying at the NON_LABOR level, reconciling retained totals against billed amounts, and auditing projects where secured project data must be hidden from the caller. A representative query returning non-labor retention for a project follows:

• SELECT retention_rule_id, project_id, task_id, agreement_num, customer_id, non_labor_resource, retention_percentage, threshold_amount, project_total_retained, projfunc_total_retained FROM apps.pa_proj_retn_exp_v WHERE retention_level_code = 'NON_LABOR' AND project_id = :p_project_id;
• SELECT project_id, SUM(project_total_retained) FROM apps.pa_proj_retn_exp_v WHERE retention_level_code IN ('NON_LABOR','EXPENDITURE_TYPE') GROUP BY project_id;
• SELECT retention_rule_id, effective_start_date, effective_end_date, retention_amount FROM apps.pa_proj_retn_exp_v WHERE non_labor_resource IS NOT NULL AND SYSDATE BETWEEN effective_start_date AND effective_end_date;

Because every query is filtered through PA_SECURITY.ALLOW_QUERY, reports built on this view automatically respect Oracle Projects security profiles without additional view-level predicates.