Results for “gms_draft_inv_line_details_v”

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

Overview

GMS_DRAFT_INV_LINE_DETAILS_V is an APPS-owned database view in Oracle E-Business Suite, part of the GMS – Grants Accounting product family. It presents draft invoice line detail for sponsored project awards, exposing expenditure item attributes alongside their corresponding draft invoice header and line identifiers. The view consolidates cost distribution amounts with currency, exchange rate, and rate-type context, and applies Oracle Projects security logic so that labor cost visibility is gated by the PA_SECURITY.VIEW_LABOR_COSTS function per project.

The object is marked VALID in the ETRM metadata and is available in both 12.1.1 and 12.2.2 release levels. Its principal role is reporting and downstream integration: it supplies the denormalized shape used by Grants Accounting forms, concurrent reports, and interfaces that need to reconcile draft invoice lines to underlying expenditure items, tasks, awards, and currency conversion definitions.

Underlying Base Objects

The view is defined over a broad set of synonym- and view-backed objects. The documented referenced base objects include:

• Transaction and distribution: GMS_AWARD_DISTRIBUTIONS, GMS_BURDEN_COMPONENTS, GMS_EVENT_INTERSECT, PA_COST_DISTRIBUTION_LINES_ALL, PA_EXPENDITURES_ALL, PA_EXPENDITURE_ITEMS_ALL, PA_DRAFT_INVOICES, PA_DRAFT_INVOICE_ITEMS.
• Project structures: PA_PROJECTS_ALL, PA_TASKS, PA_RBS_ELEMENTS, PA_SYSTEM_LINKAGES, PA_EXPENDITURE_TYPES, PA_TRANSACTION_SOURCES.
• Currency and conversion: GL_DAILY_CONVERSION_TYPES, PA_CONVERSION_TYPES_V, FND_LOOKUP_VALUES, PA_LOOKUPS.
• Parties and security: HR_ALL_ORGANIZATION_UNITS_TL, HR_ORGANIZATION_UNITS, HR_GENERAL, HR_PERSON_NAME, HR_SECURITY, PER_PEOPLE_F, PER_JOBS, PO_VENDORS.
• Program units: HR_GENERAL, HR_PERSON_NAME, HR_SECURITY, PA_SECURITY, PA_UTILS4.

The join path links draft invoice headers (PA_DRAFT_INVOICES) and lines (PA_DRAFT_INVOICE_ITEMS) to expenditure items, then outward to distributions and award components within GMS. Currency context is resolved through GL daily conversion types and conversion type views.

Key Columns

The view text reveals the semantic payload of each column:

• EXPENDITURE_ITEM_ID, ADL_LINE_NUM – identifiers tying a row to its expenditure item and award distribution line.
• PROJECT_ID, DRAFT_INVOICE_NUM, LINE_NUM – project and draft invoice header/line references.
• PROJECT_CURRENCY_CODE, PROJECT_RATE_DATE, PROJECT_RATE_TYPE – project-currency and rate context carried from PA_EXPENDITURE_ITEMS_ALL.
• USER_PROJECT_RATE_TYPE – mapped from CONV.USER_CONVERSION_TYPE via GL daily conversion types, providing the user-facing rate type name corresponding to PROJECT_RATE_TYPE. This is the column users typically search for when reconciling rate types across currency conversions.
• PROJECT_EXCHANGE_RATE, RECEIPT_CURRENCY_CODE, RECEIPT_EXCHANGE_RATE, DENOM_CURRENCY_CODE – exchange rate and receipt/denominator currency fields.
• Cost/distribution amount – derived as ADL.RAW_COST * ADL.DISTRIBUTION_VALUE / 100, repeated for multiple amount columns.

For SYSTEM_LINKAGE_FUNCTION values of 'ST' and 'OT', the amount expressions are wrapped in a DECODE against PA_SECURITY.VIEW_LABOR_COSTS(DRF.PROJECT_ID), returning NULL when the user lacks labor cost privileges. This security gating is repeated for each amount column in the view text.

Common Use Cases and Queries

Typical usage includes reconciling draft invoice lines to expenditure items, auditing currency conversion rates on sponsored awards, and validating labor cost visibility. A representative query:

• SELECT project_id, draft_invoice_num, line_num, expenditure_item_id, project_rate_type, user_project_rate_type, project_exchange_rate FROM apps.gms_draft_inv_line_details_v WHERE project_id = :project_id;
• Filter by user_project_rate_type to isolate lines using a specific conversion type: WHERE user_project_rate_type = 'Corporate';
• Join to PA_PROJECTS_ALL or GMS award tables on project_id for award-level reporting; note that amount columns may be NULL for users without VIEW_LABOR_COSTS privileges, so authorization expectations must be verified before relying on totals.

Because the view depends on HR_SECURITY and PA_SECURITY, effective results are sensitive to the responsibility and security profile under which it is queried.