ECC Channel Revenue Management, Closed Claims
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Description: Data Set for Channel Closed Claims
Dataset Key: ozf-closed-claim
Query Procedure: OZF_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: OZF_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
Description: Data Set for Channel Closed Claims
Dataset Key: ozf-closed-claim
Query Procedure: OZF_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: OZF_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
Run
ECC Channel Revenue Management, Closed Claims and other Oracle EBS reports with Blitz Report™ on our demo environment
select x.* from ( SELECT * FROM (SELECT ECC_SPEC_ID, dfv.*, FC_ORG_ID,FC_CLAIM_OU,FC_CLAIM_ID,ECC_LAST_UPDATE_DATE,FC_CLAIM_NUMBER,DR_REASON_NAME,FC_CLAIM_TYPE_ID,DT_NAME,DT_DESCRIPTION, DR_CLAIM_CLASS_NAME,FC_STATUS_CODE,FC_STATUS,FC_PAYMENT_STATUS,DR_PAYMENT_STATUS_NAME,FC_COMMENTS,FC_VENDOR_ID,FC_VENDOR_NAME, FC_VENDOR_SITE_ID,FC_VENDOR_SITE_CODE,FC_VENDOR_ADDRESS,FC_CUSTOMER_REASON,FC_AMOUNT,FC_ACCTD_AMOUNT,FC_CONVERTED_ACCTD_AMT,FC_COMN_CURR_CODE, FC_ACCTD_AMOUNT_CUR,FC_ACCTD_AMT_REMAINING,FC_FUNC_AMOUNT,FC_BROKER_NAME,FC_SALES_REP_NAME,FC_OWNER_NAME,FC_CLAIM_DATE,DC_PARTY_NAME,DC_PARTY_ID, FC_CUST_ACCOUNT_ID,DC_ACCT_NUMBER,FC_BILLTO_ACCT_SITE_ID,FC_BILL_TO_SITE_NAME,FC_BILL_TO_ADDR,FC_SHIP_TO_CUST,FC_SHIP_TO_ACCT_NUMBER, FC_SHIP_TO_SITE_NAME,FC_SHIP_TO_ADDR,FC_CUST_REF_NUMBER,FC_CUST_REF_DATE,FC_RECEIPT_NUMBER,FC_INVOICE_NUMBER,FC_SETTLED_DATE,FC_PAYMENT_METHOD, FC_ACCTD_AMT_SETTLED,FC_DAYS_TO_SETTLE,FC_IS_PROMOTIONAL,DO_OFFER_CODE,FC_SPLIT_AMOUNT,DI_ITEM,DI_ITEM_NAME,DI_ITEM_DEC, DDS_MONTH_NAME,DDS_QTR_NAME,DDS_YEAR_NAME,FC_TRANSACTION_TYPE,FC_TRANSACTION_NUMBER,FC_ACTIVITY_NAME,TEAM, DO_OFFER_KEY,FC_TRANS_AMOUNT,FC_TRANS_CURRENCY,FC_WRITEOFF_AMOUNT,LANGUAGE_CODE FROM OZF_ECC_F_CLOSE_CLAIMS_V cla , (select "ROW_ID" "'OZFCLA_ROW_ID'","CONTEXT_VALUE" "'OZFCLA_CONTEXT_VALUE'","CONCATENATED_SEGMENTS" "'OZFCLA_CONCATENATED_SEGMENTS'" from OZF_CLAIMS_ALL_DFV) dfv WHERE cla.cla_rowid = dfv."'OZFCLA_ROW_ID'"(+)) PIVOT (max(FC_CLAIM_OU) as FC_CLAIM_OU, max(DR_REASON_NAME) as DR_REASON_NAME, max(DT_NAME) as DT_NAME, max(DT_DESCRIPTION) as DT_DESCRIPTION, max(DR_CLAIM_CLASS_NAME) as DR_CLAIM_CLASS_NAME, max(FC_STATUS) as FC_STATUS, max(DR_PAYMENT_STATUS_NAME) as DR_PAYMENT_STATUS_NAME, max(FC_COMN_CURR_CODE) as FC_COMN_CURR_CODE, max(FC_OWNER_NAME) as FC_OWNER_NAME, max(FC_PAYMENT_METHOD) as FC_PAYMENT_METHOD, max(DO_OFFER_CODE) as DO_OFFER_CODE, max(DI_ITEM_NAME) as DI_ITEM_NAME, max(DI_ITEM_DEC) as DI_ITEM_DEC, max(FC_ACTIVITY_NAME) as FC_ACTIVITY_NAME, max(FC_TRANS_CURRENCY) as FC_TRANS_CURRENCY for LANGUAGE_CODE in ('US' "US")) ) x where 2=2 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Operating Unit |
|
LOV |