Search Results project_status_m




Overview
Explore in AI Chat

Overview

APPS.GMS_DRAFT_INVOICES_V is a supplementary view in the Oracle E-Business Suite Grants Management (GMS) module, owned by the APPS schema and registered under FND Design Data as GMS.GMS_DRAFT_INVOICES_V. It exposes draft invoice information associated with awards, projects, customers, agreements, and terms, combining columns from the Project Billing and Grants Accounting data model into a single denormalized result set. The view is classified as a "supplementary view used to simplify forms coding," meaning it exists primarily to support Oracle Forms-based user interfaces rather than as a sanctioned integration or reporting interface. Oracle explicitly warns that this view may change dramatically in subsequent minor or major releases, so it should not be used for custom development where stability is required. Its status is VALID in ETRM 12.2.2, and it remains relevant for backward compatibility with Grants Management draft invoice screens in both Release 12.1.1 and 12.2.2.

Underlying Base Objects

The view is defined over a substantial set of base tables, synonyms, packages, and views. Core project and award data is sourced from PA_PROJECTS_ALL, GMS_AWARDS, PA_PROJECT_TYPES, PA_PROJECT_STATUSES, and PA_PROJECT_CUSTOMERS. Customer information is drawn from HZ_CUST_ACCOUNTS, HZ_PARTIES, and HZ_CUST_SITE_USES. Draft invoice details originate from PA_DRAFT_INVOICES, PA_DRAFT_INVOICES_ALL, and PA_DRAFT_INV_ITEMS_BAS, while agreement and terms data come from PA_AGREEMENTS_ALL and RA_TERMS. Distribution rules are retrieved from PA_DISTRIBUTION_RULES and PA_LOOKUPS. Personnel data is joined via PER_ALL_PEOPLE_F, and organization units via HR_ALL_ORGANIZATION_UNITS. Currency and conversion logic rely on PA_MULTI_CURRENCY, PA_CONVERSION_TYPES_V, and GL_SETS_OF_BOOKS. Security filtering is applied through the GMS_SECURITY and PA_SECURITY packages, with PA_ROLE_CONTROLS and PA_PROJECT_PARTIES governing access. FND_LANGUAGES supports multilingual lookups, and PA_IMPLEMENTATIONS_ALL governs configuration behavior. PA_OUTPUT_TAX handles tax processing logic referenced in the view definition.

Key Columns

The view exposes identifiers such as AWARD_ID, PROJECT_ID, CUSTOMER_ID, AGREEMENT_ID, TERM_ID, and DRAFT_INVOICE_NUM, which serve as join keys to their respective parent entities. Descriptive attributes include AWARD_NUMBER, AWARD_SHORT_NAME, PROJECT_NUMBER, PROJECT_NAME, CUSTOMER_NAME, CUSTOMER_NUMBER, AGREEMENT_NUM, and TERM_NAME. Status-related columns are central to the view's purpose: PROJECT_STATUS_M and PROJECT_STATUS_CODE expose the translated and coded project status, where PROJECT_STATUS_CODE maps to PA_PROJECT_STATUSES and PROJECT_STATUS_M is the multilingual display value. Similarly, INVOICE_STATUS_CODE and INVOICE_STATUS_M convey the invoice lifecycle state, DISTRIBUTION_RULE_M provides the translated distribution rule description, and CHK_STATUS supports workflow or form validation logic. Approval and release metadata are represented by APPROVED_DATE, APPROVED_BY_PERSON_NAME, RELEASED_DATE, and RELEASED_BY_PERSON_NAME. Financial attributes include BILL_THROUGH_DATE, INVOICE_DATE, PA_DATE, GL_DATE, RETENTION_PERCENTAGE, RA_INVOICE_CURRENCY_CODE, INV_CURRENCY_CODE, INV_EXCHANGE_RATE, INV_RATE_TYPE, and INV_RATE_DATE. Flags such as CANCELED_FLAG, CANCEL_CREDIT_MEMO_FLAG, WRITE_OFF_FLAG, and CONVERTED_FLAG indicate the invoice's processing condition.

Common Use Cases and Queries

Typical usage involves querying draft invoices for a specific award or project, reviewing invoice status before transfer to Receivables, or auditing approval and release activity. A representative query filtering by project status might select award and invoice identifiers alongside the translated status:

  • SELECT AWARD_NUMBER, PROJECT_NUMBER, PROJECT_NAME, PROJECT_STATUS_M, INVOICE_STATUS_M, DRAFT_INVOICE_NUM, INVOICE_DATE FROM APPS.GMS_DRAFT_INVOICES_V WHERE PROJECT_STATUS_M = 'Approved';
  • SELECT DRAFT_INVOICE_NUM, RA_INVOICE_NUMBER, INVOICE_STATUS_M, BILL_THROUGH_DATE, RETENTION_PERCENTAGE FROM APPS.GMS_DRAFT_INVOICES_V WHERE AWARD_ID = :award_id AND CANCELED_FLAG = 'N';
  • SELECT PROJECT_NUMBER, DISTRIBUTION_RULE_M, INV_CURRENCY_CODE, INV_EXCHANGE_RATE, APPROVED_BY_PERSON_NAME, RELEASED_DATE FROM APPS.GMS_DRAFT_INVOICES_V WHERE TRUNC(INVOICE_DATE) BETWEEN :start_date AND :end_date;

Because Oracle does not recommend querying this view directly, custom reports should instead join the documented base tables such as PA_DRAFT_INVOICES_ALL, PA_PROJECTS_ALL, and PA_PROJECT_STATUSES. When the view is used, it should be restricted to ad hoc analysis or form-level diagnostics where its instability across patches is acceptable.