ECC Inventory Management, Activities

Description
Categories: Enterprise Command Center
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: inv_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Run ECC Inventory Management, Activities and other Oracle EBS reports with Blitz Report™ on our demo environment
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_code=:organization_code
LOV
Blitz Report™