Results for “purchasing_category_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
WIP_EAM_DIRECT_ITEMS is a Work in Process (WIP) transactional table that stores description-based direct items associated with enterprise asset management (EAM) work orders. In Oracle EBS 12.1.1 and 12.2.2, direct items represent materials, services, or non-inventory purchases that are charged directly to a work order without being defined as inventory items in the item master. This table captures the purchasing and requisition attributes needed to procure those items against a specific work order operation.
The table resides in the WIP schema and is documented with 47 columns in the ETRM 12.2.2 physical schema. Only one foreign key is documented — DEPARTMENT_ID references BOM_DEPARTMENTS — which is why the heuristic Data Vault classification derived from the FK structure is standalone. As a modeling suggestion, this classification reflects the sparse relationship footprint rather than functional dependence; in practice the table behaves as a transactional satellite of the work order entity, keyed by DIRECT_ITEM_SEQUENCE_ID and carrying descriptive and procurement attributes.
Key Information Stored
The surrogate primary key is DIRECT_ITEM_SEQUENCE_ID, which is also the sole documented unique index (WIP_EAM_DIRECT_ITEMS_U1) and therefore the primary business-key candidate. The remaining columns fall into several groups.
- Work order context: WIP_ENTITY_ID, ORGANIZATION_ID, OPERATION_SEQ_NUM, and DEPARTMENT_ID tie the direct item to a specific work order, organization, routing operation, and department. DEPARTMENT_ID is the documented foreign key to BOM_DEPARTMENTS.
- Item description: DESCRIPTION holds the free-text description that identifies the direct item, which is the defining characteristic of a description-based (non-item-master) purchase.
- Purchasing attributes: PURCHASING_CATEGORY_ID, UNIT_PRICE, REQUIRED_QUANTITY, UOM, NEED_BY_DATE, AMOUNT, and ORDER_TYPE_LOOKUP_CODE support requisition and purchase order creation.
- Suggested vendor details: SUGGESTED_VENDOR_NAME, SUGGESTED_VENDOR_ID, SUGGESTED_VENDOR_SITE, SUGGESTED_VENDOR_SITE_ID, SUGGESTED_VENDOR_CONTACT, SUGGESTED_VENDOR_CONTACT_ID, SUGGESTED_VENDOR_PHONE, and SUGGESTED_VENDOR_ITEM_NUM provide sourcing defaults for the buyer.
- Automation flag: AUTO_REQUEST_MATERIAL controls whether a requisition is generated automatically.
- Standard WHO columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE, and REQUEST_ID, plus the 15 ATTRIBUTE columns and ATTRIBUTE_CATEGORY for extensibility.
Common Use Cases and Queries
The most frequent reporting scenarios involve retrieving all direct items for a work order, checking procurement status, and joining to vendor or department reference data.
- List direct items for a work order:
SELECT DIRECT_ITEM_SEQUENCE_ID, DESCRIPTION, REQUIRED_QUANTITY, UNIT_PRICE, AMOUNT FROM WIP_EAM_DIRECT_ITEMS WHERE WIP_ENTITY_ID = :entity_id ORDER BY OPERATION_SEQ_NUM; - Identify items requiring automatic requisition:
WHERE AUTO_REQUEST_MATERIAL = 'Y' AND NEED_BY_DATE < SYSDATE + 7 - Department rollup: join DEPARTMENT_ID to BOM_DEPARTMENTS to report spend by department.
- Vendor aggregation: group by SUGGESTED_VENDOR_ID to summarize suggested spend.
- Open commitments: sum AMOUNT by WIP_ENTITY_ID for work-order cost review.
Related Objects
- BOM_DEPARTMENTS — referenced via DEPARTMENT_ID; supplies department code and description.
- WIP_ENTITIES — supplies the work order definition that WIP_ENTITY_ID points to.
- WIP_DISCRETE_JOBS / WIP_EAM_WORK_ORDERS — the operational work order headers associated with the entity.
- MTL_PARAMETERS — provides organization context via ORGANIZATION_ID.
- PO_VENDORS and PO_VENDOR_SITES_ALL — matched through SUGGESTED_VENDOR_ID and SUGGESTED_VENDOR_SITE_ID.
- PO_REQUISITION_HEADERS_ALL / PO_REQUISITION_LINES_ALL — downstream requisitions generated from direct items.
- MTL_SYSTEM_ITEMS_B — useful for validating purchasing categories where item-based procurement overlaps.
-
Table for storing description based direct items.
-
Table to hold data in Oracle Payables not posted to SLA.
-
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 →
-
Table to hold data in Oracle Payables not posted to SLA.
-
View: APFV_AP_INVOICE_LINES 12.2.2
Business View
APPS.APFV_AP_INVOICE_LINES·↳ AP_INVOICE_LINES_ALL·Explore AP module →
-
This table stores the direct item information for forecasted work orders in eAM maintenance budgeting and forecasting. This mirrors the structure of wip_eam_direct_items.
-
This table stores the direct item information for forecasted work orders in eAM maintenance budgeting and forecasting. This mirrors the structure of wip_eam_direct_items.
-
Table for storing description based direct items.
-
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 →
-
This table is the staging table for AP Summary Information.
-
AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface.
-
This table holds AP Summary Information. It is used to support AP and POA portlets.
-
APPS.AP_INVOICE_LINES_INTERFACE_V·↳ AP_AWT_GROUPS·↳ AP_DISTRIBUTION_SETS·↳ AP_INVOICES_INTERFACE·Explore AP module →
-
View: AP_INVOICE_LINES_V 12.2.2
APPS.AP_INVOICE_LINES_V·↳ AP_AWT_GROUPS·↳ AP_DISTRIBUTION_SETS_ALL·↳ AP_INVOICES_ALL·Explore AP module →
-
APPS.AP_INVOICE_LINES_INTERFACE_V·↳ AP_AWT_GROUPS·↳ AP_DISTRIBUTION_SETS·↳ AP_INVOICES_INTERFACE·Explore AP module →
-
View: AP_INVOICE_LINES_V 12.1.1
APPS.AP_INVOICE_LINES_V·↳ AP_AWT_GROUPS·↳ AP_DISTRIBUTION_SETS_ALL·↳ AP_INVOICES_ALL·Explore AP module →
-
Information used to create one or more invoice distributions
-
Information used to create one or more invoice distributions
-
AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface.
-
VIEW: EAM.EAM_FORECAST_WEDI# 12.2.2
-
VIEW: EAM.EAM_FORECAST_WEDI# 12.2.2
-
TABLE: FII.FII_AP_INV_DIST_T 12.1.1
-
TABLE: FII.FII_AP_INV_DIST_F 12.1.1
-
TABLE: EAM.EAM_FORECAST_WEDI 12.2.2
-
TABLE: FII.FII_AP_INV_STG 12.1.1
-
TABLE: EAM.EAM_FORECAST_WEDI 12.1.1
-
TABLE: FII.FII_AP_INV_B 12.1.1