ECC Channel Revenue Management, Closed Claims
Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, 'Ozfcla Row Id', 'Ozfcla Context Value', 'Ozfcla Concatenated Segments', Fc Org Id, Fc Claim Id, Ecc Last Update Date, Fc Claim Number, Fc Claim Type Id, Fc Status Code ...
Columns: Ecc Spec Id, 'Ozfcla Row Id', 'Ozfcla Context Value', 'Ozfcla Concatenated Segments', Fc Org Id, Fc Claim Id, Ecc Last Update Date, Fc Claim Number, Fc Claim Type Id, Fc Status Code ...
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
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 |