Results for “amount_delivered”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_COMMITMENT_TXNS_EFC is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the summarized commitment amounts for each commitment transaction line. In Oracle Projects, a "commitment" represents an obligation to spend against a project or task, typically originating from Purchasing (purchase order distributions) or from other feeder systems. The "EFC" suffix denotes that the table is an Encumbrance / Funds Control style summary: rather than holding the raw transaction rows themselves (which live in PA_COMMITMENT_TXNS), it aggregates and rolls up amounts—ordered, cancelled, delivered, invoiced, outstanding, and overbilled—along with raw and burdened cost representations in multiple currencies. Its primary role is to provide a fast, pre-aggregated view of commitment balances for project cost reporting, funds checking, and burdening calculations without re-summing the detail table on every query.
With respect to Data Vault modeling, the ETRM metadata classifies this object as standalone based on its foreign-key structure. Because the table is keyed by CMT_LINE_ID and carries only one documented foreign key (to PA_COMMITMENT_TXNS), it behaves structurally like a satellite attached to the commitment transaction line hub, holding descriptive and calculated numeric attributes rather than defining new relationships. This is a heuristic suggestion only; the definitive classification rests on the surrounding PA star schema.
Key Information Stored
The single documented foreign key is CMT_LINE_ID, which references PA_COMMITMENT_TXNS.CMT_LINE_ID. This column is the surrogate/primary key of the table and the join path to the parent commitment transaction line.
- CMT_LINE_ID — surrogates the commitment line; joins to the parent transaction table.
- AMOUNT_ORDERED / ORIGINAL_AMOUNT_ORDERED — the current and originally ordered commitment value.
- AMOUNT_CANCELLED — quantity of the commitment that has been cancelled.
- AMOUNT_DELIVERED — value received against the commitment.
- AMOUNT_INVOICED — value billed against the commitment.
- AMOUNT_OUTSTANDING_DELIVERY and AMOUNT_OUTSTANDING_INVOICE — remaining open delivery/invoice balances.
- AMOUNT_OVERBILLED — excess billed beyond the commitment.
- TOT_CMT_RAW_COST / TOT_CMT_BURDENED_COST — total raw and burdened commitment cost.
- DENOM_RAW_COST / DENOM_BURDENED_COST — equivalent costs in the project's denominator currency.
- ACCT_RAW_COST / ACCT_BURDENED_COST plus ACCT_RATE_DATE, ACCT_RATE_TYPE, ACCT_EXCHANGE_RATE — accounting-currency cost and the exchange-rate context used to derive it.
- SET_OF_BOOKS_ID — identifies the ledger set of books under which the amounts are reported.
- Currency and rate columns (RECEIPT_CURRENCY_CODE, DENOM_CURRENCY_CODE, PROJECT_CURRENCY_CODE, their rate types, dates, and rates; RECEIPT_EXCHANGE_RATE, PROJECT_EXCHANGE_RATE) — capture the multi-currency translation context.
- CREATION_DATE — standard audit stamp of row insertion.
No unique business-key index is documented in the metadata, so CMT_LINE_ID acts as both surrogate and the practical join key.
Common Use Cases and Queries
Typical use cases include project commitment balance reporting, funds-consumption analysis (ordered versus delivered versus invoiced), and burdened-cost roll-forward. A common pattern joins the summary back to its parent transaction:
SELECT t.cmt_line_id, t.project_id, t.task_id,
e.amount_ordered, e.amount_invoiced,
e.amount_outstanding_invoice, e.tot_cmt_burdened_cost
FROM pa_commitment_txns t, pa_commitment_txns_efc e
WHERE t.cmt_line_id = e.cmt_line_id
AND e.set_of_books_id = :sobid;
Because the table already aggregates amounts in raw, burdened, denominator, and accounting currencies, reports can avoid re-summing detail cost rows—useful for performance-sensitive dashboards. Auditors may query differences between ordered and invoiced amounts to flag overbillings (AMOUNT_OVERBILLED). Without a documented unique index, de-duplication logic on CMT_LINE_ID should be applied in report queries.
Related Objects
- PA_COMMITMENT_TXNS — parent table; joined on CMT_LINE_ID. This is the only documented foreign key relationship.
- PO_DISTRIBUTIONS — Purchasing distributions that feed commitment transactions into Oracle Projects.
- PA_PROJECTS / PA_TASKS — supply project and task context via PA_COMMITMENT_TXNS.
- PA_PROJECT_CURRENCIES / PA_PROJECT_RATE_TYPES — source of the rate-type definitions referenced by ACCT_RATE_TYPE and PROJECT_RATE_TYPE.
- GL_SETS_OF_BOOKS — validates SET_OF_BOOKS_ID for ledger-based reporting.
- Projects commitment reporting views and concurrent programs that populate EFC summaries from the detail transactions.
In summary, PA_COMMITMENT_TXNS_EFC is a Project-level commitment summary satellite keyed on CMT_LINE_ID, providing multi-currency ordered, delivered, invoiced, and burdened amounts for funds control and commitment reporting in Oracle EBS 12.1.1 and 12.2.2.
-
View: PA_ACCUM_CMT_TXNS_V 12.2.2
This view retrieves project, task and resource related commitments, including commitment-line attribute
APPS.PA_ACCUM_CMT_TXNS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ PA_ACCUM_PROJ_CMT_TXNS_BASE_V·Explore PA module →
-
View: PA_ACCUM_CMT_TXNS_V 12.1.1
This view retrieves project, task and resource related commitments, including commitment-line attribute
APPS.PA_ACCUM_CMT_TXNS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ PA_ACCUM_PROJ_CMT_TXNS_BASE_V·Explore PA module →
-
Table: PO_DOCUMENT_TOTALS_GT 12.1.1
-
This view retrieves project level commitments, including commitment-line attributes like commitment - Retrofitted
APPS.PA_ACCUM_PROJ_CMT_TXNS_BASE_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
View: WIP_EAM_DIRECT_ITEMS_V 12.1.1
Direct Items for EAM work orders
APPS.WIP_EAM_DIRECT_ITEMS_V·↳ MTL_UNITS_OF_MEASURE·↳ PO_DISTRIBUTIONS_ALL·↳ PO_HEADERS_ALL·Explore WIP module →
-
View: WIP_EAM_DIRECT_ITEMS_V 12.2.2
Direct Items for EAM work orders
APPS.WIP_EAM_DIRECT_ITEMS_V·↳ MTL_UNITS_OF_MEASURE·↳ PO_DISTRIBUTIONS_ALL·↳ PO_HEADERS_ALL·Explore WIP module →
-
This view retrieves project-task level commitments, including commitment-line attributes like commi - Retrofitted
APPS.PA_ACCUM_TASK_CMT_TXNS_BASE_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
This view retrieves project-task level commitments, including commitment-line attributes like commi - Retrofitted
APPS.PA_ACCUM_TASK_CMT_TXNS_BASE_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
View shows direct item details of a work order.
APPS.EAM_WORK_ORDER_DIRECT_ITEMS_V·↳ FND_GLOBAL·↳ MFG_LOOKUPS·↳ MTL_DEFAULT_CATEGORY_SETS·Explore EAM module →
-
This view retrieves project level commitments, including commitment-line attributes like commitment - Retrofitted
APPS.PA_ACCUM_PROJ_CMT_TXNS_BASE_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
This view retrieves project-task-resource level commitments, including commitment-line attributes l - Retrofitted
APPS.PA_ACCUM_RSRC_CMT_TXNS_BASE_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
View for project-related uninvoiced purchase order distributions. The non-recoverable tax is added to the amount outstanding invoice values.
APPS.PA_PROJ_PO_DISTRIBUTIONS·↳ FND_PROFILE·↳ GL_LEDGERS·↳ HR_GENERAL·Explore PA module →
-
Shows all approved and uninvoiced purchase order distributions, which are project related.
APPS.PA_PROJ_APPR_PO_DISTRIBUTIONS·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_SECURITY·Explore PA module →
-
This is a light weight version og EAM_DIRECT_ITEMS_RECS_V
APPS.EAM_DIRECT_ITEMS_RECS_LITE_V·↳ EAM_WO_DIRECT_ITEMS_LITE_V·↳ EAM_WO_REQ_PO_LITE_V·↳ MFG_LOOKUPS·Explore EAM module →
-
View: PO_DISTRIBUTIONS_V 12.1.1
10SC ONLY
APPS.PO_DISTRIBUTIONS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PO_DISTRIBUTIONS·↳ PO_DISTRIBUTIONS_ALL·Explore PO module →
-
APPS.PO_DISTRIBUTION_ARCHIVE_XML·↳ GL_CODE_COMBINATIONS_KFV·↳ PER_ALL_PEOPLE_F·↳ PO_COMMUNICATION_GT·Explore PO module →
-
APPS.PO_DISTRIBUTION_ARCHIVE_XML·↳ GL_CODE_COMBINATIONS_KFV·↳ HR_API·↳ HR_LOOKUPS·Explore PO module →
-
Table: PO_DOCUMENT_TOTALS_GT 12.2.2
-
View: CST_PROJMFG_CMT_STUB_V 12.2.2
APPS.CST_PROJMFG_CMT_STUB_V·↳ PA_IMPLEMENTATIONS_ALL·Explore BOM module →
-
- Retrofitted
APPS.POBV_BKT_PO_DISTRIBUTIONS·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_DISTRIBUTIONS_ALL·↳ PO_HEADERS_ALL·Explore PO module →
-
Project-related unreceived purchase order distributions view for non-project manufacturing customers
APPS.PJM_PO_COMMITMENTS_STUB_V·↳ PA_IMPLEMENTATIONS_ALL·Explore PJM module →
-
- Retrofitted
APPS.POBV_STD_PO_DISTRIBUTIONS·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_DISTRIBUTIONS_ALL·↳ PO_HEADERS_ALL·Explore PO module →
-
Shows project related unapproved, uninvoiced purchase order distributions
APPS.PA_PROJ_PEND_PO_DISTRIBUTIONS·↳ HR_GENERAL·↳ HR_SECURITY·↳ PA_CMT_UTILS·Explore PA module →
-
APPS.AP_MATCH_CORRECTION_DISTS_V·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ AP_INVOICE_LINES_ALL·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore AP module →
-
View: PO_DISTRIBUTIONS_V 12.2.2
10SC ONLY
APPS.PO_DISTRIBUTIONS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PO_DISTRIBUTIONS·↳ PO_DISTRIBUTIONS_ALL·Explore PO module →
-
Shows project related unapproved, uninvoiced purchase order distributions
APPS.PA_PROJ_PEND_PO_DISTRIBUTIONS·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_SECURITY·Explore PA module →
-
View: PO_DISTRIBUTION_XML 12.2.2
APPS.PO_DISTRIBUTION_XML·↳ GL_CODE_COMBINATIONS_KFV·↳ HR_API·↳ HR_LOOKUPS·Explore PO module →
-
- Retrofitted
APPS.AP_PO_DISTRIBUTIONS_AP2_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·Explore AP module →
-
APPS.AP_MATCH_CORRECTION_DISTS_V·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ AP_INVOICE_LINES_ALL·↳ FND_PROFILE·Explore AP module →
-
View: EAM_WO_REQ_PO_LITE_V 12.2.2
This is a light weight version of EAM_WORK_ORDER_REQ_PO_V.
APPS.EAM_WO_REQ_PO_LITE_V·↳ MTL_UNITS_OF_MEASURE·↳ PO_DISTRIBUTIONS_ALL·↳ PO_HEADERS_ALL·Explore EAM module →
-
This is a light weight version of the view EAM_WORK_ORDER_DIRECT_ITEMS_V.
APPS.EAM_WO_DIRECT_ITEMS_LITE_V·↳ MFG_LOOKUPS·↳ MTL_DEFAULT_CATEGORY_SETS·↳ MTL_ITEM_CATEGORIES·Explore EAM module →
-
View: PO_DISTRIBUTION_XML 12.1.1
APPS.PO_DISTRIBUTION_XML·↳ GL_CODE_COMBINATIONS_KFV·↳ PER_ALL_PEOPLE_F·↳ PO_COMMUNICATION_GT·Explore PO module →
-
View: EAM_DIRECT_ITEM_RECS_V 12.2.2
View to select both the description based direct items as well as non-stockable inventory items
APPS.EAM_DIRECT_ITEM_RECS_V·↳ EAM_WORK_ORDER_DIRECT_ITEMS_V·↳ EAM_WORK_ORDER_REQ_PO_V·↳ FND_GLOBAL·Explore EAM module →
-
Project-related unreceived purchase order distributions view
APPS.PJM_PO_COMMITMENTS_BASIC_V·↳ GL_SETS_OF_BOOKS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PA_EXPENDITURE_TYPES·Explore PJM module →
-
Project-related unreceived purchase order distributions view for non-project manufacturing customers
APPS.PJM_PO_COMMITMENTS_STUB_V·↳ PA_IMPLEMENTATIONS_ALL·Explore PJM module →
-
For Internal Use Only: This table is global temporary table based on po_distributions_all table. It is used for internal processing of data for PO Approval Submission Checks.
-
View: CST_PROJMFG_CMT_STUB_V 12.1.1
APPS.CST_PROJMFG_CMT_STUB_V·↳ PA_IMPLEMENTATIONS_ALL·Explore BOM module →
-
Manufacturing commitments
APPS.CST_PROJMFG_CMT_BASIC_V·↳ BOM_RESOURCES·↳ CST_COST_ELEM_EXP_TYPES·↳ GL_SETS_OF_BOOKS·Explore BOM module →
-
This view retrieves project-task-resource level commitments, including commitment-line attributes l - Retrofitted
APPS.PA_ACCUM_RSRC_CMT_TXNS_BASE_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
View: POBV_PO_DISTRIBUTIONS 12.2.2
- Retrofitted
APPS.POBV_PO_DISTRIBUTIONS·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_DISTRIBUTIONS_ALL·↳ PO_HEADERS_ALL·Explore PO module →
-
- Retrofitted
APPS.POBV_STD_PO_DISTRIBUTIONS·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_DISTRIBUTIONS_ALL·↳ PO_HEADERS_ALL·Explore PO module →
-
View: POFV_PO_DISTRIBUTIONS 12.1.1
- Retrofitted
APPS.POFV_PO_DISTRIBUTIONS·↳ BOM_RESOURCES·↳ GL_CODE_COMBINATIONS·↳ GL_SETS_OF_BOOKS·Explore PO module →
-
- Retrofitted
APPS.POFV_BKT_PO_DISTRIBUTIONS·↳ BOM_RESOURCES·↳ GL_CODE_COMBINATIONS·↳ GL_SETS_OF_BOOKS·Explore PO module →
-
For Internal Use Only
-
APPS.PA_PROJ_PO_DISTRIBUTIONS_V·↳ GL_SETS_OF_BOOKS·↳ PA_CMT_UTILS·↳ PA_EXPENDITURE_TYPES·Explore PA module →