ECC Inventory Management, Inventory Cycle Counting

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Organization Id, Organization Code, Cycle Count Entry Id, Cycle Count Header Name, Item, Revision, Subinventory, Locator, Lot ...
Imported from Enterprise Command Center
Dataset Key: inv-cyclecounting
Query Procedure: INV_ECC_CYCLE_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure:
select
x.*
from
(
SELECT * FROM  (select ECC_SPEC_ID,
							ORGANIZATION_ID,
							ORGANIZATION_CODE,
							CYCLE_COUNT_ENTRY_ID,
							CYCLE_COUNT_HEADER_NAME,
							ITEM_DESCRIPTION,
							ITEM,
							REVISION,
							SUBINVENTORY,
							LOCATOR,
							LOT,
							PRIMARY_UOM,
							PRIMARY_QTY,
							PRIMARY_COUNT_QTY,
							SCHEDULE_DATE,
							COUNT_DUE_DATE,
							COUNT_DATE,
							COUNT_TYPE_CODE,
							COUNT_QTY_UOM,
							COUNT_TYPE,
							COUNTER,
							APPROVAL_DATE,
							APPROVER,
							ADJ_QUANTITY,
							VALUE,
							VALUE_CHANGE,
							VALUE_CHANGE_DATE,
							CC_CLASS,
							ENTRY_STATUS_CODE,
							STATUS,
							HIT_MISS_TOLERANCE_POSITIVE,
							HIT_MISS_TOLERANCE_NEGATIVE,
							LAST_UPDATE_DATE,
							INVENTORY_ITEM_ID,
							ITEM_LAST_SCHEDULE_DATE,
							UNSCHEDULED_ITEM_DATE,
							OUTERMOST_LPN,
							COST_GROUP,
							HIT_MISS,
							LANGUAGE,
							CC_WORKFLOW_ENABLED_FLAG,cc_workflow_flag from inv_ecc_cycle_v  where language in ('US') )
        PIVOT (max(ITEM_DESCRIPTION) as ITEM_DESCRIPTION, max(COUNT_TYPE) as COUNT_TYPE, max(STATUS) as STATUS for LANGUAGE in ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Organization Code
x.org_code=:organization_code
LOV