ECC Project Procurement, Item Analysis
Description
Categories: Enterprise Command Center
Columns: Record Type, Ecc Spec Id, Record Identifier, Org Id, Ou Name, Deliver To Location, Address, Address Line 1, Address Line 2, Address Line 3 ...
Columns: Record Type, Ecc Spec Id, Record Identifier, Org Id, Ou Name, Deliver To Location, Address, Address Line 1, Address Line 2, Address Line 3 ...
Imported from Enterprise Command Center
Dataset Key: po-proc-item
Query Procedure: PO_PPCC_ECC_UTIL_PVT.LOAD_ECC_DATA_FULL
Security Procedure:
Dataset Key: po-proc-item
Query Procedure: PO_PPCC_ECC_UTIL_PVT.LOAD_ECC_DATA_FULL
Security Procedure:
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 |
| LOV |