ECC Project Procurement, Item Analysis

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: po-proc-item
Query Procedure: PO_PPCC_ECC_UTIL_PVT.LOAD_ECC_DATA_FULL
Security Procedure:
Run ECC Project Procurement, Item Analysis and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
SELECT
									 RECORD_TYPE,
									 ECC_SPEC_ID,
									 RECORD_IDENTIFIER,
									 ORG_ID,
									 OU_NAME,
									 DELIVER_TO_LOCATION,
									 ADDRESS,
									 ADDRESS_LINE_1,
									 ADDRESS_LINE_2,
									 ADDRESS_LINE_3,
									 COUNTRY,
									 TOWN_OR_CITY,
									 STATE,
									 ITEM_ID,
									 CATEGORY_ID,
									 ITEM_DESCRIPTION,
									 ITEM_NUMBER,
									 PRIMARY_UOM_CODE,
									 PRIMARY_UNIT_OF_MEASURE,
									 CATEGORY_ITEM,
									 UOM,
									 DATE_YEAR,
									 DATE_TRX,
									 DATE_QUARTER,
									 PROMISED_DATE,
									 QUANTITY_CANCELLED,
									 QUANTITY_REJECTED,
									 QUANTITY_RECEIVED,
									 UNIT_PRICE,
									 QUANTITY,
									 LEAD_TIME,
									 LEAD_TIME_UNIT,
									 TOTAL_SPEND,
									 TYPE_REQ,
									 DOC_TYPE,
									 TYPE_AGR,
									 OFF_CONTRACT_SPEND,
									 PO_TYPE_LOOKUP_CODE,
									 CONTRACT_SPEND,
									 QUANTITY_ACCEPTED,
									 QUANTITY_BILLED,
									 QUANTITY_OVERDUE,
									 PRICE_OVERRIDE,
									 ORDER_NUMBER,
									 AGREEMENT_NUMBER,
									 REQUISITION_NUMBER,
									 PROJECT_NUMBER,
									 PROJECT_NAME,
									 TASK_NUMBER,
									 TASK_NAME,
									 TASK_SCH_START_DATE,
									 TASK_SCH_END_DATE,
									 SUPPLIER_NAME,
									 SUPPLIER_NUMBER,
									 CURRENCY_CODE,
									 PO_STATUS,
									 ORDER_STATUS_CODE,
									 REQUISITION_STATUS,
									 AGREEMENT_STATUS,
									 ORGANIZATION_ID,
									 ORGANIZATION_NAME,
									 ORGANIZATION_CODE,
									 TYPE_LINE,
									 SUPPLIER_TYPE,
									 SUPPLIER_SITE,
									 AUTHORIZATION_STATUS,
									 ORDER_DATE,
									 BUYER_NAME,
									 PROJECT_STATUS,
									 PROJECT_MANAGER_NAME,
									 INVENTORY_ITEM_STATUS_CODE,
									 LIST_PRICE,
									 MARKET_PRICE,
									 INVENTORY_PLANNING_METHOD,
									 ITEM_LONG_DESCRIPTION,
									 PO_LINE_STATUS,
									 CREATION_DATE,
									 SUGGESTED_BUYER_NAME,
									 QUANTITY_DELIVERED,
									 REQUESTOR_NAME,
									 AMOUNT_AGREED,
									 AMOUNT_RELEASED,
									 RFQ_NUMBER,
									 NEGOTIATION_STATUS,
									 NEGOTIATION_TITLE,
									 START_DATE,
									 END_DATE,
									 PREVIEW_DATE,
									 PUBLISH_DATE,
									 AWARD_DATE,
									 AWARD_AMOUNT,
									 PO_DISTRIBUTION_ID,
									 LINE_LOCATION_ID,
									 PO_HEADER_ID,
									 PO_LINE_ID,
									 DISTRIBUTION_ID,
									 REQUISITION_LINE_ID,
									 REQUISITION_HEADER_ID,
									 AMOUNT1,
									 AMOUNT2,
									 AMOUNT3,
									 AMOUNT4,
									 AMOUNT5,
									 AMOUNT6,
									 AMOUNT7,
									 AMOUNT8,
									 AMOUNT9,
									 PROJECT_ID,
									 CLOSED_DATE,
									 BUSINESS_TYPE,
									 ASL_STATUS,
									 MANUFACTURER,
									 SUPPLIER_ITEM,
									 ONE_TIME_FLAG,
									 QUALITY_RATING,
									 PRICE_COMPLIANCE,
									 SHIPMENT_ONTIME_FLAG,
									 PO_LINE_ATTACHMENT_TEXT,
									 END_DATE_MONTH,
									 END_DATE_YEAR,
									 PA_COST_CODE,
                   QUANTITY_RECEIVED QUANTITY_COMMITED,
                   END_DATE NEED_BY_DATE
									FROM PO_ECC_ITEMS_PROCUREMENT_V
 
) x
where
2=2
Parameter Name SQL text Validation
Operating Unit 
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
 LOV
Download
Related Blitz Reports
ECC Admin - Concurrent Programs ECC Project Manufacturing, Exceptions and Overdues, SQL12 ECC Project Manufacturing, Exceptions and Overdues, SQL11 ECC Project Manufacturing, Exceptions and Overdues, SQL10 ECC Project Manufacturing, Exceptions and Overdues, SQL9 ECC Project Manufacturing, Exceptions and Overdues, SQL8 ECC Project Manufacturing, Exceptions and Overdues, SQL7 ECC Project Manufacturing, Exceptions and Overdues, SQL6 ECC Project Manufacturing, Exceptions and Overdues, SQL14
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™