WSH ITM Adapter Status

Description
Categories: BI Publisher
Columns: Service Provider, Error Type, Error Code, Interpreted Value, Count(*) ...
Application: Shipping Execution
Source: ITM Adapter Status Report (XML)
Short Name: WSHRDIST_XML
DB package: WSH_WSHRDIST_XMLP_PKG
SELECT    WIV.service_provider service_provider,
                WRH.Error_type error_type,
                WRH.Error_code error_code,
                NVL(WIRR.Interpreted_value_code,'DATA') interpreted_value,
                Count(*)
            FROM    WSH_ITM_VENDORS WIV,
                WSH_ITM_RESPONSE_RULES WIRR,
                WSH_ITM_RESPONSE_HEADERS WRH,
                WSH_ITM_REQUEST_CONTROL WRC
            WHERE   WRH.VENDOR_ID = WIV.VENDOR_ID
            AND WRH.ERROR_TYPE = WIRR.ERROR_TYPE(+)
            AND     WRH.ERROR_CODE = WIRR.ERROR_CODE(+)
            AND WRH.VENDOR_ID = WIRR.VENDOR_ID(+)
            AND     WRC.RESPONSE_HEADER_ID = WRH.RESPONSE_HEADER_ID
            AND           WRH.ERROR_TYPE IS NOT NULL
            AND           WRH.ERROR_CODE IS NOT NULL
            AND           WRC.PROCESS_FLAG <> 1
            &lp_application_id
            &lp_appl_user_id
            &lp_master_org_id
            &lp_organization_id
            &lp_vendor_id
            GROUP BY  WIV.service_provider,
                  WRH.Error_type,
                  WRH.Error_code,
                  WIRR.Interpreted_value_code
            UNION
            SELECT  WIV.service_provider service_provider,
                WRL.Error_type error_type,
                WRL.Error_code error_code,
                WIRR.Interpreted_value_code interpreted_value,
                Count(*)
            FROM    WSH_ITM_VENDORS WIV,
                WSH_ITM_RESPONSE_RULES WIRR,
                WSH_ITM_RESPONSE_LINES WRL,
                WSH_ITM_REQUEST_CONTROL WRC
            WHERE   WRL.RESPONSE_HEADER_ID = WRC.RESPONSE_HEADER_ID
            AND WRL.ERROR_TYPE = WIRR.ERROR_TYPE(+)
            AND     WRL.ERROR_CODE = WIRR.ERROR_CODE(+)
            AND           WRL.ERROR_CODE IS NOT NULL
            AND           WRL.ERROR_TYPE IS NOT NULL
            AND WIRR.VENDOR_ID = WIV.VENDOR_ID
            &lp_application_id
            &lp_appl_user_id
            &lp_master_org_id
            &lp_organization_id
            &lp_vendor_id
            GROUP BY WIV.service_provider,
                 WRL.Error_type,
                 WRL.Error_code,
                 WIRR.Interpreted_value_code
Parameter Name SQL text Validation
Application
 
LOV Oracle
Master Organization
 
LOV Oracle
Organization
 
LOV Oracle
Application User
 
LOV Oracle
Vendor
 
LOV Oracle