ECC Inventory Management, Activities

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Transaction Date, Activity Id, Activity Detail Id, Operation Id, Organization Id, Organization Code, User Id, User Name, Equipment Id ...
Imported from Enterprise Command Center
Description: Activity Details
Dataset Key: inv-activity
Query Procedure: INV_ECC_ACTIVITY_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure:
select
x.*
from
(
SELECT * FROM (SELECT * FROM inv_ecc_activity_v
	 WHERE language in ('US'))
	 	 PIVOT (MAX(SOURCE_ZONE) AS SOURCE_ZONE
   ,MAX(DESTINATION_ZONE) AS DESTINATION_ZONE
   ,MAX(ACTIVITY) AS ACTIVITY
   ,MAX(ACTIVITY_DETAIL) AS ACTIVITY_DETAIL
   ,MAX(OPERATION) AS OPERATION
   ,MAX(TRANSACTION_TYPE) AS TRANSACTION_TYPE
   ,MAX(EXECUTIONMODES) AS EXECUTIONMODES
   ,MAX(TASKMETHOD) AS TASKMETHOD
   for LANGUAGE in ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Organization Code
x.organization_id in (select mp.organization_id from mtl_parameters mp where mp.organization_code=:organization_code)
LOV