ODI Program Dependency
Go to primary content
Oracle® Retail Insights Cloud Service Suite Operations Guide
Release 18.0.001
F17010-01
  Go To Table Of Contents
Contents
Previous
Previous 		 Next
Next		  
Type of Program (SIL, PLP) Table Name Program Name (Shell Script Name) Dependency (Source System Program or other SIL or PLP program) Comments
Universal Adapter RI Staging Seed Load W_RTL_PROMO_COMP_TYPE_DS rtluasil.ksh  W_RTL_PROMO_COMP_TYPE_DS W_RTL_PROMO_COMP_TYPE_DS.dat File Location: $MMHOME/data/staging
(The data loading process for table W_RTL_PROMO_COMP_TYPE_D should be considered as seeding process instead of daily batch so Universal Adapter load for W_RTL_PROMO_COMP_TYPE_DS should also be considered as seed and run once.
Universal Adapter RI Staging Table Seed Load W_XACT_TYPE_DS rtluasil.ksh  W_XACT_TYPE_DS W_XACT_TYPE_DS.dat File Location: $MMHOME/data/staging
(The data loading process for table W_XACT_TYPE_D should be considered as seeding process instead of daily batch so Universal Adapter load for W_XACT_TYPE_DS should also be considered as seed and run once.
 Universal Adapter Daily Load 
Universal Adapter RI Staging Table Load W_MCAL_PERIOD_DS rtluasil.ksh  W_MCAL_PERIOD_DS W_MCAL_PERIOD_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_SEASON_DS rtluasil.ksh  W_RTL_SEASON_DS W_RTL_SEASON_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_PRODUCT_DS rtluasil.ksh  W_PRODUCT_DS W_PRODUCT_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_PRODUCT_ATTR_DS rtluasil.ksh  W_PRODUCT_ATTR_DS W_PRODUCT_ATTR_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_PRODUCT_DS_TL rtluasil.ksh  W_PRODUCT_DS_TL W_PRODUCT_DS_TL.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_HOUSEHOLD_DS rtluasil.ksh  W_HOUSEHOLD_DS W_HOUSEHOLD_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_PARTY_PER_DS rtluasil.ksh  W_PARTY_PER_DS W_PARTY_PER_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PROD_HIER_IMAGE_DS rtluasil.ksh  W_RTL_PROD_HIER_IMAGE_DS W_RTL_PROD_HIER_IMAGE_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PRODUCT_ATTR_IMG_DS rtluasil.ksh  W_RTL_PRODUCT_ATTR_IMG_DS W_RTL_PRODUCT_ATTR_IMG_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_PROD_CAT_DHS rtluasil.ksh  W_PROD_CAT_DHS W_PROD_CAT_DHS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PROD_HIER_ATTR_LKP_DHS rtluasil.ksh  W_RTL_PROD_HIER_ATTR_LKP_DHS W_RTL_PROD_HIER_ATTR_LKP_DHS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_ITEM_GRP1_DS rtluasil.ksh  W_RTL_ITEM_GRP1_DS W_RTL_ITEM_GRP1_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_INT_ORG_DHS rtluasil.ksh  W_INT_ORG_DHS W_INT_ORG_DHS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_ITEM_GRP2_DS rtluasil.ksh  W_RTL_ITEM_GRP2_DS W_RTL_ITEM_GRP2_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_IT_SUPPLIER_DS rtluasil.ksh  W_RTL_IT_SUPPLIER_DS W_RTL_IT_SUPPLIER_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_SEASON_IT_DS rtluasil.ksh  W_RTL_SEASON_IT_DS W_RTL_SEASON_IT_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_INVENTORY_PRODUCT_DS rtluasil.ksh  W_INVENTORY_PRODUCT_DS W_INVENTORY_PRODUCT_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_INVENTORY_PRODUCT_ATTR_DS rtluasil.ksh  W_INVENTORY_PRODUCT_ATTR_DS W_INVENTORY_PRODUCT_ATTR_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_LOC_LIST_DS rtluasil.ksh  W_RTL_LOC_LIST_DS W_RTL_LOC_LIST_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_LOC_TRAIT_DS rtluasil.ksh  W_RTL_LOC_TRAIT_DS W_RTL_LOC_TRAIT_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PROMO_DS rtluasil.ksh  W_RTL_PROMO_DS W_RTL_PROMO_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PROMO_DS_TL rtluasil.ksh  W_RTL_PROMO_DS_TL W_RTL_PROMO_DS_TL.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_SEASON_PHASE_DS rtluasil.ksh  W_RTL_SEASON_PHASE_DS W_RTL_SEASON_PHASE_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_ORG_FIN_DS rtluasil.ksh  W_RTL_ORG_FIN_DS W_RTL_ORG_FIN_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CHANNEL_DS rtluasil.ksh  W_RTL_CHANNEL_DS W_RTL_CHANNEL_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_EMPLOYEE_DS rtluasil.ksh  W_EMPLOYEE_DS W_EMPLOYEE_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_EXCH_RATE_GS rtluasil.ksh  W_EXCH_RATE_GS W_EXCH_RATE_GS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_INT_ORG_DS rtluasil.ksh  W_INT_ORG_DS W_INT_ORG_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_INT_ORG_ATTR_DS rtluasil.ksh  W_INT_ORG_ATTR_DS W_INT_ORG_ATTR_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_INT_ORG_DS_TL rtluasil.ksh  W_INT_ORG_DS_TL W_INT_ORG_DS_TL.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_PARTY_ORG_DS rtluasil.ksh  W_PARTY_ORG_DS W_PARTY_ORG_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_PARTY_ATTR_DS rtluasil.ksh  W_PARTY_ATTR_DS W_PARTY_ATTR_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_SUPPLIER_TRAIT_DS rtluasil.ksh  W_RTL_SUPPLIER_TRAIT_DS W_RTL_SUPPLIER_TRAIT_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_DOMAIN_MEMBER_DS_TL rtluasil.ksh  W_DOMAIN_MEMBER_DS_TL W_DOMAIN_MEMBER_DS_TL.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_LOY_SCORE_BAND_DS rtluasil.ksh  W_RTL_LOY_SCORE_BAND_DS W_RTL_LOY_SCORE_BAND_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_TNDR_TYPE_DS rtluasil.ksh  W_RTL_TNDR_TYPE_DS W_RTL_TNDR_TYPE_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PRODUCT_IMAGE_DS rtluasil.ksh  W_RTL_PRODUCT_IMAGE_DS W_RTL_PRODUCT_IMAGE_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_REASON_DS rtluasil.ksh  W_REASON_DS W_REASON_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_STATUS_DS rtluasil.ksh  W_STATUS_DS W_STATUS_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_IT_LC_DS rtluasil.ksh  W_RTL_IT_LC_DS W_RTL_IT_LC_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PRODUCT_COLOR_DS rtluasil.ksh  W_RTL_PRODUCT_COLOR_DS W_RTL_PRODUCT_COLOR_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PRODUCT_ATTR_DS rtluasil.ksh  W_RTL_PRODUCT_ATTR_DS W_RTL_PRODUCT_ATTR_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PRODUCT_ATTR_DS_TL rtluasil.ksh  W_RTL_PRODUCT_ATTR_DS_TL W_RTL_PRODUCT_ATTR_DS_TL.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PRODUCT_BRAND_DS rtluasil.ksh  W_RTL_PRODUCT_BRAND_DS W_RTL_PRODUCT_BRAND_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PRODUCT_BRAND_DS_TL rtluasil.ksh  W_RTL_PRODUCT_BRAND_DS_TL W_RTL_PRODUCT_BRAND_DS_TL.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CMG_PRODUCT_MTX_DS rtluasil.ksh  W_RTL_CMG_PRODUCT_MTX_DS W_RTL_CMG_PRODUCT_MTX_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CNG_CNSG_DS rtluasil.ksh  W_RTL_CNG_CNSG_DS W_RTL_CNG_CNSG_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CNSG_CUSTSEG_DS rtluasil.ksh  W_RTL_CNSG_CUSTSEG_DS W_RTL_CNSG_CUSTSEG_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CONSUMERSEG_DS rtluasil.ksh  W_RTL_CONSUMERSEG_DS W_RTL_CONSUMERSEG_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CONSUMER_GRP_DS rtluasil.ksh  W_RTL_CONSUMER_GRP_DS W_RTL_CONSUMER_GRP_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_COPR_HEAD_LC_DY_FS rtluasil.ksh  W_RTL_COPR_HEAD_LC_DY_FS W_RTL_COPR_HEAD_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_COPR_LINE_IT_LC_DY_FS rtluasil.ksh  W_RTL_COPR_LINE_IT_LC_DY_FS W_RTL_COPR_LINE_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CO_HEAD_DS rtluasil.ksh  W_RTL_CO_HEAD_DS W_RTL_CO_HEAD_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CO_HEAD_STATUS_FS rtluasil.ksh  W_RTL_CO_HEAD_STATUS_FS W_RTL_CO_HEAD_STATUS_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CO_HEAD_TNDR_LC_DY_FS rtluasil.ksh  W_RTL_CO_HEAD_TNDR_LC_DY_FS W_RTL_CO_HEAD_TNDR_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CO_HEAD_TP_LC_DY_FS rtluasil.ksh  W_RTL_CO_HEAD_TP_LC_DY_FS W_RTL_CO_HEAD_TP_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CO_LINE_DS rtluasil.ksh  W_RTL_CO_LINE_DS W_RTL_CO_LINE_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CO_LINE_FL_IT_LC_DY_FS rtluasil.ksh  W_RTL_CO_LINE_FL_IT_LC_DY_FS W_RTL_CO_LINE_FL_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CO_LINE_STATUS_FS rtluasil.ksh  W_RTL_CO_LINE_STATUS_FS W_RTL_CO_LINE_STATUS_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CO_SHIP_METHOD_DS rtluasil.ksh  W_RTL_CO_SHIP_METHOD_DS W_RTL_CO_SHIP_METHOD_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CO_SHIP_TYPE_DS rtluasil.ksh  W_RTL_CO_SHIP_TYPE_DS W_RTL_CO_SHIP_TYPE_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CUSTSEG_ALLOC_DS rtluasil.ksh  W_RTL_CUSTSEG_ALLOC_DS W_RTL_CUSTSEG_ALLOC_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CUST_ADDRESS_DS rtluasil.ksh  W_RTL_CUST_ADDRESS_DS W_RTL_CUST_ADDRESS_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CUST_HOUSEHOLD_DS rtluasil.ksh  W_RTL_CUST_HOUSEHOLD_DS W_RTL_CUST_HOUSEHOLD_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_HG_CNSG_DS rtluasil.ksh  W_RTL_HG_CNSG_DS W_RTL_HG_CNSG_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_HOUSEHOLD_COMP_DS rtluasil.ksh  W_RTL_HOUSEHOLD_COMP_DS W_RTL_HOUSEHOLD_COMP_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_HOUSEHOLD_GRP_DS rtluasil.ksh  W_RTL_HOUSEHOLD_GRP_DS W_RTL_HOUSEHOLD_GRP_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_LOY_CUSTSEG_CL_LC_WK_FS rtluasil.ksh  W_RTL_LOY_CUSTSEG_CL_LC_WK_FS W_RTL_LOY_CUSTSEG_CL_LC_WK_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_LOY_CUSTSEG_DP_LC_WK_FS rtluasil.ksh  W_RTL_LOY_CUSTSEG_DP_LC_WK_FS W_RTL_LOY_CUSTSEG_DP_LC_WK_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_LOY_CUSTSEG_LC_WK_FS rtluasil.ksh  W_RTL_LOY_CUSTSEG_LC_WK_FS W_RTL_LOY_CUSTSEG_LC_WK_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_LOY_CUSTSEG_SC_LC_WK_FS rtluasil.ksh  W_RTL_LOY_CUSTSEG_SC_LC_WK_FS W_RTL_LOY_CUSTSEG_SC_LC_WK_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_LOY_CUST_CL_LC_MH_FS rtluasil.ksh  W_RTL_LOY_CUST_CL_LC_MH_FS W_RTL_LOY_CUST_CL_LC_MH_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_LOY_CUST_DP_LC_MH_FS rtluasil.ksh  W_RTL_LOY_CUST_DP_LC_MH_FS W_RTL_LOY_CUST_DP_LC_MH_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_LOY_CUST_LC_MH_FS rtluasil.ksh  W_RTL_LOY_CUST_LC_MH_FS W_RTL_LOY_CUST_LC_MH_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MARKET_PRODUCT_DS rtluasil.ksh  W_RTL_MARKET_PRODUCT_DS W_RTL_MARKET_PRODUCT_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MARKET_PROD_DHS rtluasil.ksh  W_RTL_MARKET_PROD_DHS W_RTL_MARKET_PROD_DHS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MARKET_PRODUCT_DS_TL rtluasil.ksh  W_RTL_MARKET_PRODUCT_DS_TL W_RTL_MARKET_PRODUCT_DS_TL.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MARKET_PROD_BRAND_DS_TL rtluasil.ksh  W_RTL_MARKET_PROD_BRAND_DS_TL W_RTL_MARKET_PROD_BRAND_DS_TL.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MARKET_PRODUCT_MTX_DS rtluasil.ksh  W_RTL_MARKET_PRODUCT_MTX_DS W_RTL_MARKET_PRODUCT_MTX_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MARKET_PROD_ATTR_DS rtluasil.ksh  W_RTL_MARKET_PROD_ATTR_DS W_RTL_MARKET_PROD_ATTR_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MARKET_PROD_ATTR_MTX_DS rtluasil.ksh  W_RTL_MARKET_PROD_ATTR_MTX_DS W_RTL_MARKET_PROD_ATTR_MTX_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MARKET_PROD_BRAND_DS rtluasil.ksh  W_RTL_MARKET_PROD_BRAND_DS W_RTL_MARKET_PROD_BRAND_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MARKET_PROD_DH_MTX_DS rtluasil.ksh  W_RTL_MARKET_PROD_DH_MTX_DS W_RTL_MARKET_PROD_DH_MTX_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MKTSLS_TA_CH_CNG_WK_FS rtluasil.ksh  W_RTL_MKTSLS_TA_CH_CNG_WK_FS W_RTL_MKTSLS_TA_CH_CNG_WK_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MKTSLS_TA_CH_HG_WK_FS rtluasil.ksh  W_RTL_MKTSLS_TA_CH_HG_WK_FS W_RTL_MKTSLS_TA_CH_HG_WK_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PRACT_IT_LC_DY_FS rtluasil.ksh  W_RTL_PRACT_IT_LC_DY_FS W_RTL_PRACT_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PRBDGT_IT_LC_FS rtluasil.ksh  W_RTL_PRBDGT_IT_LC_FS W_RTL_PRBDGT_IT_LC_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_SLSPRFC_PC_CS_DY_FS rtluasil.ksh  W_RTL_SLSPRFC_PC_CS_DY_FS W_RTL_SLSPRFC_PC_CS_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_SLSPRFC_PC_CS_WK_FS rtluasil.ksh  W_RTL_SLSPRFC_PC_CS_WK_FS W_RTL_SLSPRFC_PC_CS_WK_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_TRADE_AREA_DS rtluasil.ksh  W_RTL_TRADE_AREA_DS W_RTL_TRADE_AREA_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_TRADE_AREA_LOC_MTX_DS rtluasil.ksh  W_RTL_TRADE_AREA_LOC_MTX_DS W_RTL_TRADE_AREA_LOC_MTX_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_SUPP_IVC_PO_IT_FS rtluasil.ksh  W_RTL_SUPP_IVC_PO_IT_FS W_RTL_SUPP_IVC_PO_IT_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_SLS_TRX_IT_LC_DY_FS rtluasil.ksh  W_RTL_SLS_TRX_IT_LC_DY_FS W_RTL_SLS_TRX_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_SLSPK_IT_LC_DY_FS rtluasil.ksh  W_RTL_SLSPK_IT_LC_DY_FS W_RTL_SLSPK_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MKDN_IT_LC_DY_FS rtluasil.ksh  W_RTL_MKDN_IT_LC_DY_FS W_RTL_MKDN_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_SLSFC_IT_LC_DY_FS rtluasil.ksh  W_RTL_SLSFC_IT_LC_DY_FS W_RTL_SLSFC_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_SLSFC_IT_LC_WK_FS rtluasil.ksh  W_RTL_SLSFC_IT_LC_WK_FS W_RTL_SLSFC_IT_LC_WK_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_BCOST_IT_LC_DY_FS rtluasil.ksh  W_RTL_BCOST_IT_LC_DY_FS W_RTL_BCOST_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_INV_IT_LC_DY_FS rtluasil.ksh  W_RTL_INV_IT_LC_DY_FS W_RTL_INV_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_NCOST_IT_LC_DY_FS rtluasil.ksh  W_RTL_NCOST_IT_LC_DY_FS W_RTL_NCOST_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PRICE_IT_LC_DY_FS rtluasil.ksh  W_RTL_PRICE_IT_LC_DY_FS W_RTL_PRICE_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_STCKLDGR_SC_LC_WK_FS rtluasil.ksh  W_RTL_STCKLDGR_SC_LC_WK_FS W_RTL_STCKLDGR_SC_LC_WK_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_SUPPCM_IT_LC_DY_FS rtluasil.ksh  W_RTL_SUPPCM_IT_LC_DY_FS W_RTL_SUPPCM_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_SUPPCMUF_LC_DY_FS rtluasil.ksh  W_RTL_SUPPCMUF_LC_DY_FS W_RTL_SUPPCMUF_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_SLSWF_IT_LC_DY_FS rtluasil.ksh  W_RTL_SLSWF_IT_LC_DY_FS W_RTL_SLSWF_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_STCKLDGR_SC_LC_MH_FS rtluasil.ksh  W_RTL_STCKLDGR_SC_LC_MH_FS W_RTL_STCKLDGR_SC_LC_MH_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_INVRC_IT_LC_DY_FS rtluasil.ksh  W_RTL_INVRC_IT_LC_DY_FS W_RTL_INVRC_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_INVTSF_IT_LC_DY_FS rtluasil.ksh  W_RTL_INVTSF_IT_LC_DY_FS W_RTL_INVTSF_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_INVADJ_IT_LC_DY_FS rtluasil.ksh  W_RTL_INVADJ_IT_LC_DY_FS W_RTL_INVADJ_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_INVRTV_IT_LC_DY_FS rtluasil.ksh  W_RTL_INVRTV_IT_LC_DY_FS W_RTL_INVRTV_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_BUYER_DS rtluasil.ksh  W_RTL_BUYER_DS W_RTL_BUYER_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_LOC_COMP_MTX_DS rtluasil.ksh  W_RTL_LOC_COMP_MTX_DS W_RTL_LOC_COMP_MTX_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PO_DETAILS_DS rtluasil.ksh  W_RTL_PO_DETAILS_DS W_RTL_PO_DETAILS_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_ALC_DETAILS_DS rtluasil.ksh  W_RTL_ALC_DETAILS_DS W_RTL_ALC_DETAILS_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_STTRFC_LC_DY_MI_FS rtluasil.ksh  W_RTL_STTRFC_LC_DY_MI_FS W_RTL_STTRFC_LC_DY_MI_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_TRX_TNDR_LC_DY_FS rtluasil.ksh  W_RTL_TRX_TNDR_LC_DY_FS W_RTL_TRX_TNDR_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_GCN_TRX_LC_DY_FS rtluasil.ksh  W_RTL_GCN_TRX_LC_DY_FS W_RTL_GCN_TRX_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_SLSDSC_TRX_IT_LC_DY_FS rtluasil.ksh  W_RTL_SLSDSC_TRX_IT_LC_DY_FS W_RTL_SLSDSC_TRX_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CFPCP_LC_DY_FS rtluasil.ksh  W_RTL_CFPCP_LC_DY_FS W_RTL_CFPCP_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_LFPCP_LC_DY_FS rtluasil.ksh  W_RTL_LFPCP_LC_DY_FS W_RTL_LFPCP_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MFPCP_PROD1_LC1_T1_FS rtluasil.ksh  W_RTL_MFPCP_PROD1_LC1_T1_FS W_RTL_MFPCP_PROD1_LC1_T1_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MFPOP_PROD1_LC1_T1_FS rtluasil.ksh  W_RTL_MFPOP_PROD1_LC1_T1_FS W_RTL_MFPOP_PROD1_LC1_T1_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MFPCP_PROD2_LC2_T2_FS rtluasil.ksh  W_RTL_MFPCP_PROD2_LC2_T2_FS W_RTL_MFPCP_PROD2_LC2_T2_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MFPOP_PROD2_LC2_T2_FS rtluasil.ksh  W_RTL_MFPOP_PROD2_LC2_T2_FS W_RTL_MFPOP_PROD2_LC2_T2_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MFPCP_PROD3_LC3_T3_FS rtluasil.ksh  W_RTL_MFPCP_PROD3_LC3_T3_FS W_RTL_MFPCP_PROD3_LC3_T3_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MFPOP_PROD3_LC3_T3_FS rtluasil.ksh  W_RTL_MFPOP_PROD3_LC3_T3_FS W_RTL_MFPOP_PROD3_LC3_T3_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PO_ONORD_IT_LC_DY_FS rtluasil.ksh  W_RTL_PO_ONORD_IT_LC_DY_FS W_RTL_PO_ONORD_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PO_ONALC_IT_LC_DY_FS rtluasil.ksh  W_RTL_PO_ONALC_IT_LC_DY_FS W_RTL_PO_ONALC_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_COMP_PRICE_IT_LC_DY_FS rtluasil.ksh  W_RTL_COMP_PRICE_IT_LC_DY_FS W_RTL_COMP_PRICE_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PARTY_PER_ATTR_DS rtluasil.ksh  W_RTL_PARTY_PER_ATTR_DS W_RTL_PARTY_PER_ATTR_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CUSTSEG_ATTR_DS rtluasil.ksh  W_RTL_CUSTSEG_ATTR_DS W_RTL_CUSTSEG_ATTR_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CUSTSEG_BEHAVIOR_DS rtluasil.ksh  W_RTL_CUSTSEG_BEHAVIOR_DS W_RTL_CUSTSEG_BEHAVIOR_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CUSTSEG_DS rtluasil.ksh  W_RTL_CUSTSEG_DS W_RTL_CUSTSEG_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CUST_CUSTSEG_DS rtluasil.ksh  W_RTL_CUST_CUSTSEG_DS W_RTL_CUST_CUSTSEG_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_CODE_DS rtluasil.ksh  W_CODE_DS W_CODE_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Batch User Table Load W_RTL_RECLASS_IT_SC_CL_TMP rabeuasil.ksh  W_RTL_RECLASS_IT_SC_CL_TMP.dat File Location: $MMHOME/data/staging
W_RTL_RECLASS_IT_SC_CL_TMP
 
Universal Adapter RI Batch User Table Load W_RTL_IT_LC_DEL_TMP rabeuasil.ksh W_RTL_IT_LC_DEL_TMP W_RTL_IT_LC_DEL_TMP.dat File Location: $MMHOME/data/staging
Universal Adapter RI Batch User Table Load W_RTL_RECLASS_DP_GP_TMP rabeuasil.ksh W_RTL_RECLASS_DP_GP_TMP  W_RTL_RECLASS_DP_GP_TMP.dat File Location: $MMHOME/data/staging
Universal Adapter RI Batch User Table Load W_RTL_ITEM_DEL_TMP rabeuasil.ksh W_RTL_ITEM_DEL_TMP  W_RTL_ITEM_DEL_TMP.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CUST_LYL_PROG_DS rtluasil.ksh  W_RTL_CUST_LYL_PROG_DS W_RTL_CUST_LYL_PROG_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CUST_LYL_ACCT_DS rtluasil.ksh  W_RTL_CUST_LYL_ACCT_DS W_RTL_CUST_LYL_ACCT_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CUST_LYL_TRX_LC_DY_FS rtluasil.ksh  W_RTL_CUST_LYL_TRX_LC_DY_FS W_RTL_CUST_LYL_TRX_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CUST_LYL_AWD_TRX_DY_FS rtluasil.ksh  W_RTL_CUST_LYL_AWD_TRX_DY_FS W_RTL_CUST_LYL_AWD_TRX_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PLAN1_PROD1_LC1_T1_FS rtluasil.ksh W_RTL_PLAN1_PROD1_LC1_T1_FS W_RTL_PLAN1_PROD1_LC1_T1_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PLAN2_PROD2_LC2_T2_FS rtluasil.ksh W_RTL_PLAN2_PROD2_LC2_T2_FS W_RTL_PLAN2_PROD2_LC2_T2_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PLAN3_PROD3_LC3_T3_FS rtluasil.ksh
W_RTL_PLAN3_PROD3_LC3_T3_FS		 W_RTL_PLAN3_PROD3_LC3_T3_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PLAN4_PROD4_LC4_T4_FS rtluasil.ksh W_RTL_PLAN4_PROD4_LC4_T4_FS W_RTL_PLAN4_PROD4_LC4_T4_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MCAL_DAY_SHIFT_DS rtluasil.ksh
W_RTL_MCAL_DAY_SHIFT_DS		 W_RTL_MCAL_DAY_SHIFT_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MCAL_DAY_UNSHIFT_DS rtluasil.ksh
W_RTL_MCAL_DAY_UNSHIFT_DS		 W_RTL_MCAL_DAY_UNSHIFT_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MCAL_WEEK_SHIFT_DS rtluasil.ksh
W_RTL_MCAL_WEEK_SHIFT_DS		 W_RTL_MCAL_WEEK_SHIFT_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MCAL_WEEK_UNSHIFT_DS rtluasil.ksh
W_RTL_MCAL_WEEK_UNSHIFT_DS		 W_RTL_MCAL_WEEK_UNSHIFT_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_MCAL_DAY_GUNSHIFT_DS rtluasil.ksh
W_RTL_MCAL_DAY_GUNSHIFT_DS		 W_RTL_MCAL_DAY_GUNSHIFT_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_COMP_STORE_DS rtluasil.ksh
W_RTL_COMP_STORE_DS		 W_RTL_COMP_STORE_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_LOCALIZED_STRING_GS rtluasil.ksh
W_LOCALIZED_STRING_GS		 W_LOCALIZED_STRING_GS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_LOC_STOCK_CNT_DS rtluasil.ksh
W_RTL_LOC_STOCK_CNT_DS		 W_RTL_LOC_STOCK_CNT_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CLSTR_GRP_DS rtluasil.ksh
W_RTL_CLSTR_GRP_DS		 W_RTL_CLSTR_GRP_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CLSTR_HDR_DS rtluasil.ksh
W_RTL_CLSTR_HDR_DS		 W_RTL_CLSTR_HDR_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CLSTR_GRP_HDR_LC_DS rtluasil.ksh
W_RTL_CLSTR_GRP_HDR_LC_DS		 W_RTL_CLSTR_GRP_HDR_LC_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_CLSTR_GRP_PRD_DS rtluasil.ksh
W_RTL_CLSTR_GRP_PRD_DS		 W_RTL_CLSTR_GRP_PRD_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_INVSS_CNT_IT_LC_DY_FS rtluasil.ksh
W_RTL_INVSS_CNT_IT_LC_DY_FS		 W_RTL_INVSS_CNT_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_INVPS_CNT_IT_LC_DY_FS rtluasil.ksh
W_RTL_INVPS_CNT_IT_LC_DY_FS		 W_RTL_INVPS_CNT_IT_LC_DY_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PROMO_CE_DS rtluasil.ksh
W_RTL_PROMO_CE_DS		 W_RTL_PROMO_CE_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PROMO_EXT_DS rtluasil.ksh
W_RTL_PROMO_EXT_DS		 W_RTL_PROMO_EXT_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_PRICE_CLR_IT_LC_DS rtluasil.ksh
W_RTL_PRICE_CLR_IT_LC_DS		 W_RTL_PRICE_CLR_IT_LC_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_FLEXFACT_FS rtluasil.ksh
W_RTL_FLEXFACT_FS		 W_RTL_FLEXFACT_FS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_DISCOUNT_TYPE_DS rtluasil.ksh
W_RTL_DISCOUNT_TYPE_DS		 W_RTL_DISCOUNT_TYPE_DS.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_PRODUCT_DS_CFA rtluasil.ksh
W_PRODUCT_DS_CFA		 W_PRODUCT_DS_CFA.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_INT_ORG_DS_CFA rtluasil.ksh
W_INT_ORG_DS_CFA		 W_INT_ORG_DS_CFA.dat File Location: $MMHOME/data/staging
Universal Adapter RI Staging Table Load W_RTL_IT_LC_DS_CFA rtluasil.ksh
W_RTL_IT_LC_DS_CFA		 W_RTL_IT_LC_DS_CFA.dat File Location: $MMHOME/data/staging
 
 
SDE Dimension Load
SDE W_RTL_CLSTR_GRP_HDR_LC_G clsrtgrphdrlcsde.ksh    
SDE W_RTL_CLSTR_GRP_PRD_G clsrtgrpprodsde.ksh    
SDE W_RTL_CLSTR_HDR_G clsrthdrsde.ksh    
SDE W_RTL_CLSTR_GRP_G clstrgrpsde.ksh    
SDE W_DOMAIN_MEMBER_DS_TL domianmemlkuprsesde.ksh    
SDE W_RTL_CUSTSEG_DS custsegsde.ksh    
SDE W_RTL_CUSTSEG_ATTR_DS custsegsde.ksh    
SDE W_RTL_CUSTSEG_BEHAVIOR _DS custsegsde.ksh    
SDE W_RTL_CUST_CUSTSEG_DS custcustsegsde.ksh    
SDE W_RTL_CDT_ORG_MTX_G cdtlocmtxsde.ksh    
SDE W_RTL_PROD_ATTR_SIM_CDT_G prdattrsimsde.ksh    
SDE W_RTL_PROD_SIM_IT_CDT_G prdsimsde.ksh    
SIL Dimension Load
SIL DIMENSION W_TIME_OF_DAY_D timedaysil.ksh Loads from a CSV file, "file_time_of_day.csv". File Location: $$MMHOME/data/srcfiles
This program should be executed on demand only and not scheduled for daily run.
SIL DIMENSION W_DAY_D gregcaldaysil.ksh Loads from a CSV file, "file_date_counter.csv File Location: $$MMHOME/data/srcfiles
This program should be executed on demand only and not scheduled for daily run.
SIL DIMENSION W_YEAR_D gregcalyearsil.ksh gregcaldaysil.ksh This program should be executed on demand only and not scheduled for daily run.
Loads from a view ""RA_W_DAY_D1_YEAR_V
SIL DIMENSION W_MONTH_D gregcalmthsil.ksh gregcaldaysil.ksh This program should be executed on demand only and not scheduled for daily run.
Loads from a view ""RA_SQ_W_DAY_D_V
SIL DIMENSION W_QTR_D gregcalqtrsil.ksh gregcaldaysil.ksh This program should be executed on demand only and not scheduled for daily run.
Loads from a view ""RA_W_DAY_D_QUARTER_V
SIL DIMENSION W_WEEK_D gregcalweeksil.ksh gregcaldaysil.ksh This program should be executed on demand only and not scheduled for daily run.
gregcalyearsil.ksh
Loads from a view ""RA_SQTRANS_V
SIL DIMENSION W_MINUTE_OF_DAY_D timeminutedaysil.ksh timedaysil.ksh This program should be executed on demand only and not scheduled for daily run.
SIL DIMENSION W_MCAL_CONFIG_G mcalcfgsil.ksh Loads from a CSV file, "file_mcal_config_g.csv File Location: $$MMHOME/file/ra/install
This program is only executed during installation."
SIL DIMENSION W_MCAL_CAL_D mcalsil.ksh mcalcfgsil.ksh This program is only executed during installation.
SIL DIMENSION W_MCAL_PERIOD_D mcalperiodsil.ksh mcalsil.ksh This program should be executed on demand only and not scheduled for daily run.
SIL DIMENSION W_MCAL_DAY_D mcaldaysil.ksh mcalperiodsil.ksh This program should be executed on demand only and not scheduled for daily run.
gregcaldaysil.ksh
SIL DIMENSION W_MCAL_WEEK_D mcalwk454sil.ksh mcaldaysil.ksh This program should be executed on demand only and not scheduled for daily run.
SIL DIMENSION W_MCAL_YEAR_D mcalyrsil.ksh mcalperiodsil.ksh This program should be executed on demand only and not scheduled for daily run.
Loads from a view W_MCAL_YEAR_V
SIL DIMENSION W_MCAL_QTR_D mcalqtrsil.ksh mcalperiodsil.ksh This program should be executed on demand only and not scheduled for daily run.
Loads from a view W_MCAL_QTR_V
SIL DIMENSION W_MCAL_PERIOD_D mcal13periodsil.ksh Loads from a CSV file, "ra_time_13.csv". File Location: $$MMHOME/data/srcfiles
Note: Source file should be provided by the Client
This program should be executed on demand only and not scheduled for daily run."
SIL DIMENSION W_RTL_PROMO_COMP_TYPE_DS      
SIL DIMENSION  
The following programs (SIL dimensions, Facts and Aggregates) are scheduled daily and it is expected that all the Calendar dimension tables are populated based on the above schedule before any of the following daily programs can be executed
PLP Seeding all the compressed positional fact tables factopenplp.ksh genlogfileplp.ksh This is the first load program on RA database
Mandatory
This program should be executed after calendar dimension tables are loaded.
This program should not be executed in the first batch cycle.
PLP Close reclassified old records in all the compressed positional fact tables factcloseplp.ksh factopenplp.ksh This program should not be executed in the first batch cycle.
PLP None genlogfileplp.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_RTL_CURR_MCAL_G etlrefreshgenplp.ksh factcloseplp.ksh  
C_LOAD_DATES
SIL DIMENSION W_INT_ORG_DH orghiersil.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_INT_ORG_D orgsil.ksh orghiersil.ksh  
W_INT_ORG_D_TL
SIL DIMENSION W_INT_ORG_DH_RTL_TMP orgdimlkuptmpplp.ksh    
SIL DIMENSION W_RTL_LOC_LIST_D orglolsil.ksh orgsil.ksh  
SIL DIMENSION W_RTL_LOC_TRAIT_D orgltmsil.ksh orgsil.ksh  
SIL DIMENSION W_RTL_PROMO_D_TL promosil.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_RTL_ORG_FIN_D orgfinsil.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_RTL_CHANNEL_D orgchnsil.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_XACT_TYPE_D ttltypsil.ksh etlrefreshgenplp.ksh The data loading process for table W_XACT_TYPE_D should be considered as seeding process instead of daily batch.
rtluasil.ksh W_XACT_TYPE_DS
SIL DIMENSION W_EXCH_RATE_G exchratesil.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_EMPLOYEE_D emplysil.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_PROD_CAT_DH prdhiersil.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_PRODUCT_D prditmsil.ksh prdhiersil.ksh  
SIL DIMENSION W_PRODUCT_D_RTL_TMP prddimlkuptmpplp.ksh proddimreclassinitialtmpplp.ksh This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
SIL DIMENSION W_PRODUCT_ATTR_D prditmsil.ksh   Programs loading W_PRODUCT_ATTR_D cannot be executed in parallel. 
SIL DIMENSION W_PRODUCT_ATTR_D prditimsil.ksh prditmsil.ksh Programs loading W_PRODUCT_ATTR_D cannot be executed in parallel. 
SIL DIMENSION W_RTL_PROD_RECLASS_TMP proddimreclassinitialtmpplp.ksh prditmsil.ksh  
SIL DIMENSION W_RTL_PROD_RECLASS_TMP proddimreclassfinaltmpplp.ksh prddimlkuptmpplp.ksh This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
SIL DIMENSION W_INVENTORY_PRODUCT_D invprdattrsil.ksh prditmsil.ksh  
W_INVENTORY_PRODUCT_ATTR_D orgsil.ksh
SIL DIMENSION W_RTL_SEASON_IT_D prditmsmsil.ksh prddimlkuptmpplp.ksh  
SIL DIMENSION W_RTL_ITEM_GRP2_D prdpimsil.ksh prddimlkuptmpplp.ksh  
SIL DIMENSION W_RTL_ITEM_GRP1_D prditmlsil.ksh prddimlkuptmpplp.ksh All Programs loading "W_RTL_ITEM_GRP1_D" can not be executed in parallel but can be executed in any sequential order
SIL DIMENSION W_RTL_ITEM_GRP1_D prditmudsil.ksh prddimlkuptmpplp.ksh All Programs loading "W_RTL_ITEM_GRP1_D" can not be executed in parallel but can be executed in any sequential order
SIL DIMENSION W_RTL_ITEM_GRP1_D proddiffsil.ksh prddimlkuptmpplp.ksh All Programs loading "W_RTL_ITEM_GRP1_D" can not be executed in parallel but can be executed in any sequential order
SIL DIMENSION W_RTL_ITEM_GRP1_D proddiffbrndsil.ksh prddimlkuptmpplp.ksh All Programs loading "W_RTL_ITEM_GRP1_D" can not be executed in parallel but can be executed in any sequential order
SIL DIMENSION W_RTL_ITEM_GRP1_D proddiffclrsil.ksh prddimlkuptmpplp.ksh All Programs loading "W_RTL_ITEM_GRP1_D" can not be executed in parallel but can be executed in any sequential order
SIL DIMENSION W_RTL_ITEM_GRP1_D proddifffabsil.ksh prddimlkuptmpplp.ksh All Programs loading "W_RTL_ITEM_GRP1_D" can not be executed in parallel but can be executed in any sequential order
SIL DIMENSION W_RTL_ITEM_GRP1_D proddiffflvsil.ksh prddimlkuptmpplp.ksh All Programs loading "W_RTL_ITEM_GRP1_D" can not be executed in parallel but can be executed in any sequential order
SIL DIMENSION W_RTL_ITEM_GRP1_D proddiffscesil.ksh prddimlkuptmpplp.ksh All Programs loading "W_RTL_ITEM_GRP1_D" can not be executed in parallel but can be executed in any sequential order
SIL DIMENSION W_RTL_ITEM_GRP1_D proddiffstysil.ksh prddimlkuptmpplp.ksh All Programs loading "W_RTL_ITEM_GRP1_D" can not be executed in parallel but can be executed in any sequential order
SIL DIMENSION W_RTL_ITEM_GRP1_D proddiffszesil.ksh prddimlkuptmpplp.ksh All Programs loading "W_RTL_ITEM_GRP1_D" can not be executed in parallel but can be executed in any sequential order
SIL DIMENSION W_RTL_PHASE_D phasesil.ksh prditmsmsil.ksh  
SIL DIMENSION W_PARTY_ORG_D partyorgsil.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_PARTY_ATTR_D orgpartysil.ksh etlrefreshgenplp.ksh  
SIL DIMESNION W_PARTY_ATTR_D custudasil.ksh partypersil.ksh  
SIL DIMENSION W_RTL_IT_SUPPLIER_D prditmsupsil.ksh prddimlkuptmpplp.ksh  
partyorgsil.ksh
SIL DIMENSION W_RTL_SUPPLIER_TRAIT_D suptrsil.ksh etlrefreshgenplp.ksh  
partyorgsil.ksh
SIL DIMENSION W_DOMAIN_MEMBER_LKP_TL domianmemlkupsil.ksh   This should be scheduled after all the SIL dimensions have successfully completed.
SIL DIMENSION W_RTL_LOC_WK_D orglocwkplp.ksh orgsil.ksh  
SIL DIMENSION W_RTL_ORG_RECLASS_TMP orgdimreclassplp.ksh orgdimlkuptmpplp.ksh This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
SIL DIMENSION W_RTL_SEASON_D seasnsil.ksh    
SIL DIMENSION W_PROMO_D_RTL_TMP prmdimlkuptmpplp.ksh promosil.ksh  
SIL DIMENSION W_PARTY_PER_D partypersil.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_HOUSEHOLD_D silhouseholddim.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_RTL_CUSTSEG_D silcustsegdim.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_RTL_LOY_SCORE_BAND_D silloyscorebanddim.ksh   This should be scheduled after the SDE dimension has successfully completed.
SIL DIMENSION W_RTL_CUST_HOUSEHOLD_D silcusthouseholddim.ksh partypersil.ksh  
silhouseholddim.ksh
SIL DIMENSION W_RTL_CUST_CUSTSEG_D silcustcustsegdim.ksh partypersil.ksh  
silcustsegdim.ksh
SIL DIMENSION W_RTL_CUSTSEG_ALLOC_D silcustsegallocdim.ksh silcustsegdim.ksh  
orgchnsil.ksh
orghiersil.ksh
prditmsil.ksh
prdhiersil.ksh
SIL DIMENSION W_RTL_CUST_ADDRESS_D silcustaddrdim.ksh partypersil.ksh  
SIL DIMENSION W_RTL_PROMO_COMP_TYPE_D prmcmptypsil.ksh etlrefreshgenplp.ksh The data loading process for table W_RTL_PROMO_COMP_TYPE_D should be considered as seeding process instead of daily batch.
rtluasil.ksh  W_RTL_PROMO_COMP_TYPE_DS
SIL DIMENSION W_RTL_PRODUCT_BRAND_D prdbrndsil.ksh    
W_RTL_PRODUCT_BRAND_D_TL
SIL DIMENSION W_RTL_CLSTR_GRP_HDR_LC_D clsgrphdrlcsil.ksh clstrgrpsil.ksh  
clstrhdrsil.ksh
orgsil.ksh
mcaldaysil.ksh
SIL DIMENSION W_RTL_CLSTR_HDR_CS_D clshdrconsil.ksh clstrhdrsil.ksh,  
consgsil.ksh
silcustsegdim.ksh
SIL DIMENSION W_RTL_CLSTR_GRP_IT_D clstrgrpitsil.ksh clstrgrpsil.ksh  
prddimlkuptmpplp.ksh
SIL DIMENSION W_RTL_CLSTR_GRP_D clstrgrpsil.ksh    
SIL DIMENSION W_RTL_CLSTR_HDR_D clstrhdrsil.ksh    
SIL DIMENSION W_RTL_CMG_PRODUCT_MTX_D cmgrprdmtxsil.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_RTL_CNG_CNSG_D cngcnsgsil.ksh consgsil.ksh  
congrpsil.ksh
SIL DIMENSION W_RTL_CO_HEAD_D coheadsil.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_RTL_CO_LINE_D colinesil.ksh prditmsil.ksh  
SIL DIMENSION W_RTL_CONSUMER_GRP_D congrpsil.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_RTL_CNSG_CUSTSEG_D consgcustsgsil.ksh consgsil.ksh,  
silcustsegdim.ksh
SIL DIMENSION W_RTL_CONSUMERSEG_D consgsil.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_RTL_CO_SHIP_METHOD_D coshmtsil.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_RTL_CO_SHIP_TYPE_D coshptypsil.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_RTL_HG_CNSG_D hgconsgsil.ksh consgsil.ksh,  
hhgrpsil.ksh
SIL DIMENSION W_RTL_HOUSEHOLD_GRP_D hhgrpsil.ksh householdcompsil.ksh  
SIL DIMENSION W_RTL_HOUSEHOLD_COMP_D householdcompsil.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_RTL_METADATA_G metadatamapsil.ksh On Demand scheduling This program can be used for loading Oracle BI EE metadata file into a DB table. The target table for this program is not used for ODI or Oracle BI EE code is only a reference list of dimension attributes in RA DB schema
SIL DIMENSION W_RTL_MARKET_PROD_ATTR_MTX_D mktprdatrmtxsil.ksh mktprdsil.ksh  
mktprdatrsil.ksh
mktprdbrndsil.ksh
SIL DIMENSION W_RTL_MARKET_PROD_ATTR_D mktprdatrsil.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_RTL_MARKET_PROD_BRAND_D mktprdbrndsil.ksh    
W_RTL_MARKET_PROD_BRAND_D_TL
SIL DIMENSION W_RTL_MARKET_PROD_DH mktprddhsil.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_RTL_MARKET_PROD_DH_MTX_D mktprdhmtxsil.ksh prdhiersil.ksh  
mktprddhsil.ksh
SIL DIMENSION W_RTL_MARKET_PRODUCT_MTX_D mktprdmtxsil.ksh prddimlkuptmpplp.ksh  
mktprdsil.ksh
SIL DIMENSION W_RTL_MARKET_PRODUCT_D mktprdsil.ksh mktprddhsil.ksh  
W_RTL_MARKET_PRODUCT_D_TL
SIL DIMENSION W_RTL_PRODUCT_ATTR_D prdattrsil.ksh    
W_RTL_PRODUCT_ATTR_D_TL
SIL DIMENSION W_REASON_D reasonsil.ksh    
SIL DIMENSION W_RTL_IT_LC_D rtlilsil.ksh prddimlkuptmpplp.ksh,  
orgdimlkuptmpplp.ksh
SIL DIMENSION W_RTL_PRODUCT_COLOR_D rtlprodcolorsil.ksh    
SIL DIMENSION W_STATUS_D statussil.ksh    
SIL DIMENSION W_RTL_TNDR_TYPE_D tndtypsil.ksh    
SIL DIMENSION W_RTL_TRADE_AREA_D trdareasil.ksh etlrefreshgenplp.ksh  
SIL DIMENSION W_RTL_TRADE_AREA_LOC_MTX_D trdarlcmtxsil.ksh orgdimlkuptmpplp.ksh  
trdareasil.ksh
SIL DIMENSION W_RTL_CDT_ORG_MTX_D cdtlocmtxsil.ksh cdtlocmtxsde.ksh  
prditmlsil.ksh
prditmudsil.ksh
proddiffsil.ksh
proddiffbrndsil.ksh
proddiffclrsil.ksh
proddifffabsil.ksh
proddiffflvsil.ksh
proddiffscesil.ksh
proddiffstysil.ksh
proddiffszesil.ksh
SIL DIMENSION W_RTL_COUPON_D couponsil.ksh    
SIL DIMENSION W_RTL_BUYER_D buyersil.ksh    
SIL DIMENSION W_RTL_LOC_COMP_MTX_D orgcomplocsil.ksh orgdimlkuptmpplp.ksh  
SIL DIMENSION W_RTL_PO_DETAILS_D podetailssil.ksh    
SIL DIMENSION W_RTL_ALC_DETAILS_D alcdetailssil.ksh    
SIL DIMENSION W_RTL_COMP_STORE_D csdsil.ksh    
SIL DIMENSION W_CODE_D codesil.ksh    
SIL DIMENSION W_RTL_CUST_LYL_PROG_D custlylprogsil.ksh    
SIL DIMENSION W_RTL_CUST_LYL_ACCT_D custlylacctsil.ksh    
SIL DIMENSION W_RTL_PRODUCT_AGGR_D prdaggrsil.ksh prditimsil.ksh  
SIL DIMENSION W_RTL_MCAL_DAY_SHIFT_D mcalday53shiftsil.ksh mcalperiodsil.ksh  
SIL DIMENSION W_RTL_MCAL_DAY_UNSHIFT_D mcalday53unshiftsil.ksh mcalperiodsil.ksh  
SIL DIMENSION W_RTL_MCAL_WEEK_SHIFT_D mcalweek53shiftsil.ksh mcalperiodsil.ksh  
SIL DIMENSION W_RTL_MCAL_WEEK_UNSHIFT_D mcalweek53unshiftsil.ksh mcalperiodsil.ksh  
SIL DIMENSION W_RTL_MCAL_PERIOD_SHIFT_D mcalperiod53shiftsil.ksh mcalperiodsil.ksh  
SIL DIMENSION W_RTL_MCAL_PERIOD_UNSHIFT_D mcalperiod53unshiftsil.ksh mcalperiodsil.ksh  
SIL DIMENSION W_RTL_MCAL_DAY_GUNSHIFT_D mcalday53gunshiftsil.ksh mcalday53gunshiftsil.ksh  
SIL DIMENSION W_RTL_LOC_STOCK_CNT_D locstkcntsil.ksh orgsil.ksh This is stock count dimension program that is location dependent
SIL DIMENSION W_RTL_DISCOUNT_TYPE_D dsctypsil.ksh    
SIL DIMENSION W_RTL_PRICE_CLR_IT_LC_D clrpricesil.ksh prddimlkuptmpplp.ksh
orgsil.ksh
partyorgsil.ksh		  
SIL DIMENSION W_PRODUCT_D_CFA itemcfasil.ksh prddimlkuptmpplp.ksh  
SIL DIMENSION W_INT_ORG_D_CFA loccfasil.ksh orgdimlkuptmpplp.ksh  
SIL DIMENSION W_RTL_IT_LC_D_CFA itemloccfasil.ksh prddimlkuptmpplp.ksh
orgdimlkuptmpplp.ksh		  
SIL DIMENSION W_LOCALIZED_STRING_G rbcmergestrings.ksh    
   
   
SIL Fact Load
SIL Fact Load W_RTL_SUPP_IVC_PO_IT_F sinvcstilsdsil.ksh prddimlkuptmpplp.ksh  
 orgdimlkuptmpplp.ksh
 partyorgsil.ksh
SIL Fact Load W_RTL_SLS_TRX_IT_LC_DY_F slsilsil.ksh prddimlkuptmpplp.ksh  
 ttltypsil.ksh
 orgdimlkuptmpplp.ksh
 emplysil.ksh
SIL Fact Load W_RTL_SLSFC_IT_LC_DY_F slsildfcsil.ksh prddimlkuptmpplp.ksh  
 orgdimlkuptmpplp.ksh
SIL Fact Load W_RTL_SLSFC_IT_LC_WK_F slsilwfcsil.ksh prddimlkuptmpplp.ksh  
 orgdimlkuptmpplp.ksh
SIL Fact Load W_RTL_MKDN_IT_LC_DY_F slsmkdnildsil.ksh prddimlkuptmpplp.ksh  
 ttltypsil.ksh
 orgdimlkuptmpplp.ksh
SIL Fact Load W_RTL_INVRC_IT_LC_DY_F ivrcpilsil.ksh prddimlkuptmpplp.ksh  
 orgdimlkuptmpplp.ksh
SIL Fact Load W_RTL_BCOST_IT_LC_DY_F cstisldsil.ksh prddimlkuptmpplp.ksh  
& W_RTL_BCOST_IT_LC_G  orgdimlkuptmpplp.ksh
   partyorgsil.ksh
SIL Fact Load W_RTL_INV_IT_LC_DY_F invildsil.ksh prddimlkuptmpplp.ksh  
& W_RTL_INV_IT_LC_G  orgdimlkuptmpplp.ksh
SIL Fact Load W_RTL_NCOST_IT_LC_DY_F ncstildsil.ksh prddimlkuptmpplp.ksh  
& W_RTL_NCOST_IT_LC_G  orgdimlkuptmpplp.ksh
   partyorgsil.ksh
SIL Fact Load W_RTL_PRICE_IT_LC_DY_F prcilsil.ksh prddimlkuptmpplp.ksh  
& W_RTL_PRICE_IT_LC_G  orgdimlkuptmpplp.ksh
SIL Fact Load W_RTL_SLSPK_IT_LC_DY_F slspkildsil.ksh prddimlkuptmpplp.ksh  
 ttltypsil.ksh
 orgdimlkuptmpplp.ksh
SIL Fact Load W_RTL_SUPPCMUF_LC_DY_F scmplufildsil.ksh orgdimlkuptmpplp.ksh  
 partyorgsil.ksh
SIL Fact Load W_RTL_SUPPCM_IT_LC_DY_F scmplildsil.ksh orgdimlkuptmpplp.ksh  
 partyorgsil.ksh
SIL Fact Load W_RTL_SLSWF_IT_LC_DY_F wfslsildsil.ksh prddimlkuptmpplp.ksh  
 orgdimlkuptmpplp.ksh
SIL Fact Load W_RTL_STCKLDGR_SC_LC_WK_F stlblwsil.ksh orgdimlkuptmpplp.ksh  
 prddimlkuptmpplp.ksh
 orgfinsil.ksh
SIL Fact Load W_RTL_STCKLDGR_SC_LC_MH_F (454 calendar) stlblmth454sil.ksh orgdimlkuptmpplp.ksh  
 prddimlkuptmpplp.ksh
 orgfinsil.ksh
SIL Fact Load W_RTL_STCKLDGR_SC_LC_MH_F (gregorian calendar) stlblmthgregsil.ksh orgdimlkuptmpplp.ksh  
 prddimlkuptmpplp.ksh
orgfinsil.ksh
SIL Fact Load W_RTL_SLSPR_TRX_IT_LC_DY_F slsprmildsil.ksh prddimlkuptmpplp.ksh exchratesil.ksh
prmdimlkuptmpplp.ksh
orgdimlkuptmpplp.ksh
SIL Fact Load W_RTL_LOY_CUSTSEG_DP_LC_WK_F silretailcustsegloydplcwkfact.ksh prddimlkuptmpplp.ksh  
orgdimlkuptmpplp.ksh
silcustsegdim.ksh
prmcmptypsil.ksh
SIL Fact Load W_RTL_LOY_CUSTSEG_CL_LC_WK_F custsegloycllcwksil.ksh prddimlkuptmpplp.ksh  
orgdimlkuptmpplp.ksh
silcustsegdim.ksh
prmcmptypsil.ksh
SIL Fact Load W_RTL_LOY_CUSTSEG_SC_LC_WK_F custsegloyslwsil.ksh prddimlkuptmpplp.ksh  
orgdimlkuptmpplp.ksh
silcustsegdim.ksh
prmcmptypsil.ksh
SIL Fact Load W_RTL_LOY_CUSTSEG_LC_WK_F silretailcustomerseglcfact.ksh prddimlkuptmpplp.ksh  
orgdimlkuptmpplp.ksh
silcustsegdim.ksh
prmcmptypsil.ksh
prdbrndsil.ksh
SIL Fact Load W_RTL_LOY_CUST_DP_LC_MH_F rtlcustdp454sil.ksh prddimlkuptmpplp.ksh  
orgdimlkuptmpplp.ksh
partypersil.ksh
prmcmptypsil.ksh
SIL Fact Load W_RTL_LOY_CUST_DP_LC_MH_F rtlcustdpgregsil.ksh prddimlkuptmpplp.ksh  
orgdimlkuptmpplp.ksh
partypersil.ksh
prmcmptypsil.ksh
SIL Fact Load W_RTL_LOY_CUST_CL_LC_MH_F rtlcustcl454sil.ksh prddimlkuptmpplp.ksh  
orgdimlkuptmpplp.ksh
partypersil.ksh
prmcmptypsil.ksh
SIL Fact Load W_RTL_LOY_CUST_CL_LC_MH_F rtlcustclgregsil.ksh prddimlkuptmpplp.ksh  
orgdimlkuptmpplp.ksh
partypersil.ksh
prmcmptypsil.ksh
SIL Fact Load W_RTL_LOY_CUST_LC_MH_F rtlcustlcmonthfact454sil.ksh prddimlkuptmpplp.ksh  
orgdimlkuptmpplp.ksh
partypersil.ksh
prmcmptypsil.ksh
prdbrndsil.ksh 
SIL Fact Load W_RTL_LOY_CUST_LC_MH_F rtlcustlcmonthfactgregsil.ksh prddimlkuptmpplp.ksh  
orgdimlkuptmpplp.ksh
partypersil.ksh
prmcmptypsil.ksh
prdbrndsil.ksh
SIL Fact Load W_RTL_PRACT_IT_LC_DY_F retailpromotionactualssil.ksh prddimlkuptmpplp.ksh  
orgdimlkuptmpplp.ksh
promosil.ksh
SIL Fact Load W_RTL_PRBDGT_IT_LC_F retailpromotionbudgetsil.ksh prddimlkuptmpplp.ksh  
orgdimlkuptmpplp.ksh
promosil.ksh
SIL Fact Load W_RTL_SLSPRFC_PC_CS_DY_F salespromotiondayforecastsil.ksh    promosil.ksh  
silcustsegdim.ksh
SIL Fact Load W_RTL_SLSPRFC_PC_CS_WK_F salespromotionweekforecastsil.ksh   promosil.ksh  
silcustsegdim.ksh
SIL Fact Load W_RTL_MKTSLS_TA_CH_CNG_WK_F cgmktslssil.ksh mcaldaysil.ksh,  
orgchnsil.ksh,
consgsil.ksh,
mktprdsil.ksh,
trdareasil.ksh
SIL Fact Load W_RTL_CO_HEAD_TNDR_LC_DY_F cohdtndlsil.ksh emplysil.ksh  
SIL_RetailLoadControlSeedData.ksh
orgdimlkuptmpplp.ksh
mcaldaysil.ksh
orgchnsil.ksh
coheadsil.ksh
tndtypsil.ksh
SIL Fact Load W_RTL_CO_HEAD_TP_LC_DY_F cohdtplsil.ksh mcaldaysil.ksh,  
orgdimlkuptmpplp.ksh,
orgdimlkuptmppl,
orgchnsil.ksh,
coheadsil.ksh
SIL Fact Load   coheadlsil.ksh coheadsil.ksh  
  timeminutedaysil.ksh
  SIL_RetailLoadControlSeedData.ksh
  coshmtsil.ksh
  orgdimlkuptmpplp.ksh
  emplysil.ksh
  mcalwk454sil.ksh
  orgchnsil.ksh
  mcaldaysil.ksh
W_RTL_CO_HEAD_LC_DY_F coshptypsil.ksh
W_RTL_CO_HEAD_STATUS_G coheadlsil.ksh
SIL Fact Load   colineilsil.ksh emplysil.ksh  
  orgdimlkuptmpplp.ksh
  mcaldaysil.ksh
  mcalwk454sil.ksh
  prddimlkuptmpplp.ksh
  reasonsil.ksh
  orgchnsil.ksh
  coheadsil.ksh
  coshmtsil.ksh
  colineilsil.ksh
  coshptypsil.ksh
  ttltypsil.ksh
W_RTL_CO_LINE_IT_LC_DY_F statussil.ksh
W_RTL_CO_LINE_STATUS_G timeminutedaysil.ksh
SIL Fact Load W_RTL_CO_LINE_FL_IT_LC_DY_F colnfilsil.ksh emplysil.ksh  
orgdimlkuptmpplp.ksh
mcaldaysil.ksh
mcalwk454sil.ksh
prddimlkuptmpplp.ksh
SIL_RetailLoadControlSeedData.ksh
coheadsil.ksh
colinesil.ksh
ttltypsil.ksh
SIL Fact Load W_RTL_CO_LINE_STATUS_F colnstsil.ksh colineilsil.ksh  
SIL Fact Load   coprhdlsil.ksh mcaldaysil.ksh,  
  orgdimlkuptmpplp.ksh,
  orgdimlkuptmppl,
  prmdimlkuptmpplp.ksh,
W_RTL_COPR_HEAD_LC_DY_F orgchnsil.ksh,
W_RTL_COPR_HEAD_LC_G coheadsil.ksh
SIL Fact Load   coprlnilsil.ksh emplysil.ksh  
  SIL_RetailLoadControlSeedData.ksh
  prddimlkuptmpplp.ksh
  mcaldaysil.ksh
  orgdimlkuptmpplp.ksh
  mcalwk454sil.ksh
  prddimlkuptmpplp.ksh
  prmdimlkuptmpplp.ksh
  orgchnsil.ksh
W_RTL_COPR_LINE_IT_LC_DY_F coheadsil.ksh
W_RTL_COPR_LINE_IT_LC_G colinesil.ksh
SIL Fact Load W_RTL_MKTSLS_TA_CH_HG_WK_F hhgrpmktslssil.ksh mcaldaysil.ksh,  
orgchnsil.ksh,
hhgrpsil.ksh,
mktprdsil.ksh,
trdareasil.ksh
SIL Fact Load W_RTL_INVADJ_IT_LC_DY_F ivadjildsil.ksh prddimlkuptmpplp.ksh  
orgdimlkuptmpplp.ksh
reasonsil.ksh
SIL Fact Load W_RTL_INVRTV_IT_LC_DY_F ivrtvildsil.ksh prddimlkuptmpplp.ksh  
orgdimlkuptmpplp.ksh
statussil.ksh
reasonsil.ksh
SIL Fact Load W_RTL_INVTSF_IT_LC_DY_F ivtsfildsil.ksh prddimlkuptmpplp.ksh  
orgdimlkuptmpplp.ksh
SIL Fact Load W_RTL_SLS_TRX_IMEI_LC_DY_F slsilimeisil.ksh prddimlkuptmpplp.ksh  
orgdimlkuptmpplp.ksh
slsilsil.ksh
SIL Fact Load W_RTL_SLSPR_TRX_IMEI_LC_DY_F slsprmildimeisil.ksh prddimlkuptmpplp.ksh  
orgdimlkuptmpplp.ksh
slsprmildsil.ksh
SIL Fact Load W_RTL_PROD_ATTR_SIM_CDT_F prdattrsimsil.ksh prdattrsimsde.ksh Mandatory
prdhiersil.ksh
SIL Fact Load W_RTL_PROD_SIM_IT_CDT_F prdsimsil.ksh prdsimsde.ksh Mandatory
prdhiersil.ksh
SIL Fact Load W_RTL_STTRFC_LC_DY_MI_F sttrfcldmsil.ksh timeminutedaysil.ksh  
orgdimlkuptmpplp.ksh
mcaldaysil.ksh
orgdimlkuptmpplp.ksh
mcalwk454sil.ksh
SIL Fact Load W_RTL_TRX_TNDR_LC_DY_F tndrtrxldsil.ksh emplysil.ksh  
orgdimlkuptmpplp.ksh
mcaldaysil.ksh
mcalwk454sil.ksh
coheadsil.ksh
colinesil.ksh
statussil.ksh
tndtypsil.ksh
SIL Fact Load W_RTL_GCN_TRX_LC_DY_F gcnldsil.ksh orgdimlkuptmpplp.ksh  
mcaldaysil.ksh
mcalwk454sil.ksh
coheadsil.ksh
colinesil.ksh
SIL Fact Load W_RTL_SLSDSC_TRX_IT_LC_DY_F slsdisctrxldsil.ksh orgdimlkuptmpplp.ksh  
mcaldaysil.ksh
mcalwk454sil.ksh
prddimlkuptmpplp.ksh
coheadsil.ksh
colinesil.ksh
ttltypsil.ksh
couponsil.ksh
SIL Fact Load W_RTL_CFPCP_LC_DY_F mfpcmpcpsil.ksh    
SIL Fact Load W_RTL_LFPCP_LC_DY_F mfplccpsil.ksh    
SIL Fact Load W_RTL_MFPCP_PROD1_LC1_T1_F mfpcpop1sil.ksh    
SIL Fact Load W_RTL_MFPOP_PROD1_LC1_T1_F mfpopop1sil.ksh    
SIL Fact Load W_RTL_MFPCP_PROD2_LC2_T2_F mfpcpop2sil.ksh    
SIL Fact Load W_RTL_MFPOP_PROD2_LC2_T2_F mfpopop2sil.ksh    
SIL Fact Load W_RTL_MFPCP_PROD3_LC3_T3_F mfpcpop3sil.ksh    
SIL Fact Load W_RTL_MFPOP_PROD3_LC3_T3_F mfpopop3sil.ksh    
SIL Fact Load W_RTL_PO_ONORD_IT_LC_DY_F poonordildsil.ksh podetailssil.ksh  
alcdetailssil.ksh
buyersil.ksh
orgdimlkuptmpplp.ksh
mcaldaysil.ksh
mcalwk454sil.ksh
prddimlkuptmpplp.ksh
 
 
SIL Fact Load W_RTL_PO_ONALC_IT_LC_DY_F poonalcildsil.ksh podetailssil.ksh  
alcdetailssil.ksh
buyersil.ksh
orgdimlkuptmpplp.ksh
mcaldaysil.ksh
mcalwk454sil.ksh
prddimlkuptmpplp.ksh
SIL Fact Load W_RTL_COMP_PRICE_IT_LC_DY_F cprcfsil.ksh orgdimlkuptmpplp.ksh  
mcaldaysil.ksh
mcalwk454sil.ksh
prddimlkuptmpplp.ksh
csdsil.ksh
 
SIL Fact Load W_RTL_CUST_LYL_TRX_LC_DY_F custlyltrxsil.ksh timeminutedaysil.ksh
mcaldaysil.ksh
mcalwk454sil.ksh
orgdimlkuptmpplp.ksh
partypersil.ksh
custlylprogsil.ksh
custlylacctsil.ksh		  
SIL Fact Load W_RTL_CUST_LYL_AWD_TRX_DY_F custlylawdtrxsil.ksh timeminutedaysil.ksh
mcaldaysil.ksh
mcalwk454sil.ksh
orgdimlkuptmpplp.ksh
partypersil.ksh
custlylprogsil.ksh
custlylacctsil.ksh
promosil.ksh
couponsil.ksh		  
SIL Fact Load W_RTL_PLAN1_PROD1_LC1_T1_F mfpplan1sil.ksh    
SIL Fact Load W_RTL_PLAN2_PROD2_LC2_T2_F mfpplan2sil.ksh    
SIL Fact Load W_RTL_PLAN3_PROD3_LC3_T3_F mfpplan3sil.ksh    
SIL Fact Load W_RTL_PLAN4_PROD4_LC4_T4_F mfpplan4sil.ksh    
SIL Fact Load W_RTL_INVSS_CNT_IT_LC_DY_F stkcntsyssnapsil.ksh    
SIL Fact Load W_RTL_INVPS_CNT_IT_LC_DY_F stkcntperpsnapsil.ksh    
SIL Fact Load W_RTL_FLEXFACT_F flexfactsil.ksh    
   
PLP Aggregate Loading
Sales Transaction  
PLP (Sales Transaction) W_RTL_SLS_IT_LC_DY_TMP slsildtmpplp.ksh slsilsil.ksh Mandatory
PLP (Sales Transaction) W_RTL_SLS_IT_LC_DY_A slsildtmpplp.ksh slsilsil.ksh Mandatory
PLP (Sales Transaction) W_RTL_SLS_IT_LC_WK_A slsildtmpplp.ksh slsilsil.ksh Mandatory
PLP (Sales Transaction) W_RTL_SLS_SC_LC_DY_A slssldplp.ksh slsildtmpplp.ksh Mandatory
PLP (Sales Transaction) W_RTL_SLS_SC_LC_WK_A slsslwplp.ksh slssldplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_CL_LC_DY_A slscldplp.ksh slssldplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_CL_LC_WK_A slsclwplp.ksh slssldplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_DP_LC_DY_A slsdldplp.ksh slssldplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_DP_LC_WK_A slsdlwplp.ksh slssldplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_IT_DY_A slsiltdplp.ksh slsildtmpplp.ksh Mandatory
PLP (Sales Transaction) W_RTL_SLS_IT_WK_A slsiltwplp.ksh slsiltdplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_SC_DY_A slssdplp.ksh slsiltdplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_SC_WK_A slsswplp.ksh slsiltdplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_LC_DY_A slsldplp.ksh slsildtmpplp.ksh Mandatory
PLP (Sales Transaction) W_RTL_SLS_LC_WK_A slslwplp.ksh slsldplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_IT_LC_DY_SN_A slsildsnplp.ksh slsildtmpplp.ksh Mandatory
prditmsmsil.ksh
PLP (Sales Transaction) W_RTL_SLS_IT_LC_WK_SN_A slsilwsnplp.ksh slsildsnplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_IT_DY_SN_A slsidsnplp.ksh slsildsnplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_IT_WK_SN_A slsiwsnplp.ksh slsildsnplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_SC_LC_DY_CUR_A slssldcurrrcplp.ksh   Mandatory
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section."
PLP (Sales Transaction) W_RTL_SLS_SC_LC_WK_CUR_A slsslwcurrrcplp.ksh slssldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Sales Transaction) W_RTL_SLS_CL_LC_DY_CUR_A slscldcurrrcplp.ksh slssldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Sales Transaction) W_RTL_SLS_CL_LC_WK_CUR_A slsclwcurrrcplp.ksh slssldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Sales Transaction) W_RTL_SLS_DP_LC_DY_CUR_A slsdldcurrrcplp.ksh slssldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Sales Transaction) W_RTL_SLS_DP_LC_WK_CUR_A slsdlwcurrrcplp.ksh slssldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Sales Transaction) W_RTL_SLS_SC_DY_CUR_A slscurrrcsdplp.ksh slssldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Sales Transaction) W_RTL_SLS_SC_WK_CUR_A slscurrrcswplp.ksh slssldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Sales Transaction) W_RTL_SLS_CL_DY_CUR_A slscurrrccdplp.ksh slssldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Sales Transaction) W_RTL_SLS_CL_WK_CUR_A slscurrrccwplp.ksh slssldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Sales Transaction) W_RTL_SLS_DP_DY_CUR_A slscurrrcddplp.ksh slssldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Sales Transaction) W_RTL_SLS_DP_WK_CUR_A slscurrrcdwplp.ksh slssldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Sales Transaction) W_RTL_SLS_SC_LC_DY_CUR_A slssldcurrplp.ksh slssldplp.ksh Mandatory
PLP (Sales Transaction) W_RTL_SLS_SC_LC_WK_CUR_A slsslwcurrplp.ksh slssldcurrplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_CL_LC_DY_CUR_A slscldcurrplp.ksh slssldcurrplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_DP_LC_DY_CUR_A slsdldcurrplp.ksh slssldcurrplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_CL_LC_WK_CUR_A slsclwcurrplp.ksh slssldcurrplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_DP_LC_WK_CUR_A slsdlwcurrplp.ksh slssldcurrplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_SC_DY_CUR_A slscurrsdplp.ksh slssldcurrplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_CL_DY_CUR_A slscurrcdplp.ksh slssldcurrplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_DP_DY_CUR_A slscurrddplp.ksh slssldcurrplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_SC_WK_CUR_A slscurrswplp.ksh slssldcurrplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_CL_WK_CUR_A slscurrcwplp.ksh slssldcurrplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_DP_WK_CUR_A slscurrdwplp.ksh slssldcurrplp.ksh Optional
PLP (Sales Transaction) W_RTL_SLS_ID_LC_DY_TMP
W_RTL_SLS_ID_LC_DY_A		 slsidldplp.ksh prditimsil.ksh
prdaggrsil.ksh		  
PLP (Sales Transaction) W_RTL_SLS_ID_LC_WK_A slsidlwplp.ksh slsidldplp.ksh  
PLP (Sales Transaction) W_RTL_SLS_IL1_LC_DY_TMP
W_RTL_SLS_IL1_LC_DY_A		 slsil1ldplp.ksh prditmsil.ksh  
PLP (Sales Transaction) W_RTL_SLS_IL1_LC_WK_A slsil1lwplp.ksh slsil1ldplp.ksh  
Markdown
PLP (Markdown) W_RTL_MKDN_IT_LC_WK_A slsmkdnilwplp.ksh slsmkdnildsil.ksh  Optional
PLP (Markdown) W_RTL_MKDN_SC_LC_DY_A slsmkdnsldplp.ksh slsmkdnildsil.ksh  Mandatory
PLP (Markdown) W_RTL_MKDN_CL_LC_DY_A slsmkdncldplp.ksh slsmkdnsldplp.ksh Optional
PLP (Markdown) W_RTL_MKDN_DP_LC_DY_A slsmkdndldplp.ksh slsmkdnsldplp.ksh Optional
PLP (Markdown) W_RTL_MKDN_SC_LC_WK_A slsmkdnslwplp.ksh slsmkdnsldplp.ksh Optional
PLP (Markdown) W_RTL_MKDN_CL_LC_WK_A slsmkdnclwplp.ksh slsmkdnsldplp.ksh Optional
PLP (Markdown) W_RTL_MKDN_DP_LC_WK_A slsmkdndlwplp.ksh slsmkdnsldplp.ksh Optional
PLP (Markdown) W_RTL_MKDN_IT_DY_A slsmkdnidplp.ksh slsmkdnildsil.ksh  Mandatory
PLP (Markdown) W_RTL_MKDN_IT_WK_A slsmkdniwplp.ksh slsmkdnidplp.ksh Optional
PLP (Markdown) W_RTL_MKDN_SC_DY_A slsmkdnsdplp.ksh slsmkdnidplp.ksh Optional
PLP (Markdown) W_RTL_MKDN_SC_WK_A slsmkdnswplp.ksh slsmkdnidplp.ksh Optional
PLP (Markdown) W_RTL_MKDN_IT_LC_DY_SN_A slsmkdnildsnplp.ksh slsmkdnildsil.ksh Mandatory
 prditmsmsil.ksh
PLP (Markdown) W_RTL_MKDN_IT_LC_WK_SN_A slsmkdnilwsnplp.ksh slsmkdnildsnplp.ksh Optional
PLP (Markdown) W_RTL_MKDN_IT_DY_SN_A slsmkdnidsnplp.ksh slsmkdnildsnplp.ksh Optional
PLP (Markdown) W_RTL_MKDN_IT_WK_SN_A slsmkdniwsnplp.ksh slsmkdnildsnplp.ksh Optional
PLP (Markdown) W_RTL_MKDN_SC_LC_DY_CUR_A slsmkdnsldcurrplp.ksh slsmkdnildsil.ksh Mandatory
PLP (Markdown) W_RTL_MKDN_CL_LC_DY_CUR_A slsmkdncldcurrplp.ksh slsmkdnsldcurrplp.ksh Optional
PLP (Markdown) W_RTL_MKDN_DP_LC_DY_CUR_A slsmkdndldcurrplp.ksh slsmkdnsldcurrplp.ksh Optional
PLP (Markdown) W_RTL_MKDN_SC_LC_WK_CUR_A slsmkdnslwcurrplp.ksh slsmkdnsldcurrplp.ksh Optional
PLP (Markdown) W_RTL_MKDN_CL_LC_WK_CUR_A slsmkdnclwcurrplp.ksh slsmkdnsldcurrplp.ksh Optional
PLP (Markdown) W_RTL_MKDN_DP_LC_WK_CUR_A slsmkdndlwcurrplp.ksh slsmkdnsldcurrplp.ksh Optional
PLP (Markdown) W_RTL_MKDN_SC_DY_CUR_A slsmkdnsdcurrplp.ksh slsmkdnsldcurrplp.ksh Optional
PLP (Markdown) W_RTL_MKDN_SC_WK_CUR_A slsmkdnswcurrplp.ksh slsmkdnsldcurrplp.ksh Optional
PLP (Markdown) W_RTL_MKDN_SC_LC_DY_CUR_A slsmkdnsldcurrrcplp.ksh   Mandatory
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section."
PLP (Markdown) W_RTL_MKDN_CL_LC_DY_CUR_A slsmkdncldcurrrcplp.ksh slsmkdnsldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Markdown) W_RTL_MKDN_DP_LC_DY_CUR_A slsmkdndldcurrrcplp.ksh slsmkdnsldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Markdown) W_RTL_MKDN_SC_LC_WK_CUR_A slsmkdnslwcurrrcplp.ksh slsmkdnsldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Markdown) W_RTL_MKDN_CL_LC_WK_CUR_A slsmkdnclwcurrrcplp.ksh slsmkdnsldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Markdown) W_RTL_MKDN_DP_LC_WK_CUR_A slsmkdndlwcurrrcplp.ksh slsmkdnsldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Markdown) W_RTL_MKDN_SC_DY_CUR_A slsmkdnsdrccurrplp.ksh slsmkdnsldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Markdown) W_RTL_MKDN_SC_WK_CUR_A slsmkdnswrccurrplp.ksh slsmkdnsldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP(Markdown) W_RTL_MKDN_ID_LC_DY_TMP
W_RTL_MKDN_ID_LC_DY_A		 slsmkdnidldplp.ksh prditimsil.ksh
prdaggrsil.ksh		  
PLP(Markdown) W_RTL_MKDN_ID_LC_WK_A slsmkdnidlwplp.ksh slsmkdnidldplp.ksh  
PLP(Markdown) W_RTL_MKDN_IL1_LC_DY_TMP
W_RTL_MKDN_IL1_LC_DY_A		 slsmkdnil1lwplp.ksh prditmsil.ksh  
PLP(Markdown) W_RTL_MKDN_IL1_LC_WK_A slsmkdnil1ldplp.ksh slsmkdnil1lwplp.ksh  
Sales Forecast
PLP (Sales Forecast) W_RTL_SLSFC_SC_LC_DY_A slsfcsldplp.ksh slsildfcsil.ksh Mandatory
PLP (Sales Forecast) W_RTL_SLSFC_SC_LC_WK_A slsfcslwplp.ksh slsilwfcsil.ksh Mandatory
PLP (Sales Forecast) W_RTL_SLSFC_IT_DY_A slsfcidplp.ksh slsildfcsil.ksh Mandatory
PLP (Sales Forecast) W_RTL_SLSFC_SC_DY_A slsfcsdplp.ksh slsfcidplp.ksh Optional
PLP (Sales Forecast) W_RTL_SLSFC_IT_WK_A slsfciwplp.ksh slsilwfcsil.ksh Mandatory
PLP (Sales Forecast) W_RTL_SLSFC_SC_WK_A slsfcswplp.ksh slsfciwplp.ksh Optional
PLP (Sales Forecast) W_RTL_SLSFC_IT_LC_DY_SN_A slsfcildsnplp.ksh  slsildfcsil.ksh Mandatory
prditmsmsil.ksh
PLP (Sales Forecast) W_RTL_SLSFC_IT_DY_SN_A slsfcidsnplp.ksh slsfcildsnplp.ksh Optional
PLP (Sales Forecast) W_RTL_SLSFC_IT_LC_WK_SN_A slsfcilwsnplp.ksh slsilwfcsil.ksh Mandatory
prditmsmsil.ksh
PLP (Sales Forecast) W_RTL_SLSFC_IT_WK_SN_A slsfciwsnplp.ksh slsfcilwsnplp.ksh Optional
PLP (Sales Forecast) W_RTL_SLSFC_SC_LC_DY_CUR_A slsfcrcsldcurrplp.ksh Mandatory
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Sales Forecast) W_RTL_SLSFC_SC_LC_WK_CUR_A slsfcrcslwcurrplp.ksh   Mandatory
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section."
PLP (Sales Forecast) W_RTL_SLSFC_SC_LC_DY_CUR_A slsfcsldcurrplp.ksh slsildfcsil.ksh Mandatory
slsfcsldplp.ksh
PLP (Sales Forecast) W_RTL_SLSFC_SC_LC_WK_CUR_A slsfcslwcurrplp.ksh  slsilwfcsil.ksh Optional
slsfcslwplp.ksh
PLP (Sales Forecast) W_RTL_SLSFC_SC_DY_CUR_A slsfccurrsdrcplp.ksh slsfcrcsldcurrplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Sales Forecast) W_RTL_SLSFC_SC_WK_CUR_A slsfccurrswrcplp.ksh slsfcrcslwcurrplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Sales Forecast) W_RTL_SLSFC_SC_DY_CUR_A slsfccurrsdplp.ksh slsildfcsil.ksh Optional
slsfcidplp.ksh
PLP (Sales Forecast) W_RTL_SLSFC_SC_WK_CUR_A slsfccurrswplp.ksh slsilwfcsil.ksh Optional
slsfciwplp.ksh
PLP W_RTL_SLSPR_PP_CUST_LC_DY_A slsprcustlcdyplp.ksh slsprmildsil.ksh Mandatory
PLP W_RTL_SLS_CUST_LC_DY_A slscslcdyaplp.ksh slsilsil.ksh Mandatory
PLP W_RTL_SLSPR_PC_CS_IT_LC_DY_A slsprcsitlcdyplp.ksh slsprmildsil.ksh Optional
silcustcustsegdim.ksh
PLP W_RTL_SLSPR_PC_HH_WK_A prmtrlrptplp.ksh slsprmildsil.ksh Mandatory
silcusthouseholddim.ksh
PLP W_RTL_SLS_CS_IT_LC_DY_A rtlslscsitlcdyplp.ksh slsilsil.ksh Mandatory
silcustcustsegdim.ksh
Inventory Receipt
PLP (Inventory Receipt) W_RTL_INVRC_IT_LC_WK_A ivrcpilwplp.ksh ivrcpilsil.ksh Optional
PLP (Inventory Receipt) W_RTL_INVRC_SC_LC_DY_A ivrcpsldplp.ksh ivrcpilsil.ksh Mandatory
PLP (Inventory Receipt) W_RTL_INVRC_CL_LC_DY_A ivrcpcldplp.ksh ivrcpsldplp.ksh Optional
PLP (Inventory Receipt) W_RTL_INVRC_DP_LC_DY_A ivrcpdldplp.ksh ivrcpsldplp.ksh Optional
PLP (Inventory Receipt) W_RTL_INVRC_SC_LC_WK_A ivrcpslwplp.ksh ivrcpsldplp.ksh Optional
PLP (Inventory Receipt) W_RTL_INVRC_CL_LC_WK_A ivrcpclwplp.ksh ivrcpsldplp.ksh Optional
PLP (Inventory Receipt) W_RTL_INVRC_DP_LC_WK_A ivrcpdlwplp.ksh ivrcpsldplp.ksh Optional
PLP (Inventory Receipt) W_RTL_INVRC_IT_DY_A ivrcpidplp.ksh ivrcpilsil.ksh Mandatory
PLP (Inventory Receipt) W_RTL_INVRC_SC_DY_A ivrcpsdplp.ksh ivrcpidplp.ksh Optional
PLP (Inventory Receipt) W_RTL_INVRC_SC_WK_A ivrcpswplp.ksh ivrcpidplp.ksh Optional
PLP (Inventory Receipt) W_RTL_INVRC_IT_WK_A ivrcpiwplp.ksh ivrcpidplp.ksh Optional
PLP (Inventory Receipt) W_RTL_INVRC_IT_LC_DY_SN_A ivildrcpsnplp.ksh ivrcpilsil.ksh Mandatory
prditmsmsil.ksh
PLP (Inventory Receipt) W_RTL_INVRC_IT_LC_WK_SN_A ivilwrcpsnplp.ksh ivildrcpsnplp.ksh Optional
PLP (Inventory Receipt) W_RTL_INVRC_IT_DY_SN_A ividrcpsnplp.ksh ivildrcpsnplp.ksh Optional
PLP (Inventory Receipt) W_RTL_INVRC_IT_WK_SN_A iviwrcpsnplp.ksh ivildrcpsnplp.ksh Optional
PLP (Inventory Receipt) W_RTL_INVRC_SC_LC_DY_CUR_A ivrcpcurrsldrcplp.ksh   Mandatory
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section."
PLP (Inventory Receipt) W_RTL_INVRC_SC_LC_WK_CUR_A ivrcpcurrslwrcplp.ksh ivrcpcurrsldrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Inventory Receipt) W_RTL_INVRC_SC_LC_DY_CUR_A ivrcpcurrsldplp.ksh ivrcpilsil.ksh Mandatory
proddimreclassfinaltmpplp.ksh
PLP (Inventory Receipt) W_RTL_INVRC_SC_LC_WK_CUR_A ivrcpcurrslwplp.ksh ivrcpcurrsldplp.ksh Optional
PLP (Inventory Receipt) W_RTL_INVRC_SC_DY_CUR_A ivrcpcurrsdrcplp.ksh ivrcpcurrsldrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Inventory Receipt) W_RTL_INVRC_SC_WK_CUR_A ivrcpcurrswrcplp.ksh ivrcpcurrsldrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Inventory Receipt) W_RTL_INVRC_SC_DY_CUR_A ivrcpcurrsdplp.ksh ivrcpcurrsldplp.ksh Optional
PLP (Inventory Receipt) W_RTL_INVRC_SC_WK_CUR_A ivrcpcurrswplp.ksh ivrcpcurrsldplp.ksh Optional
PLP (Inventory Receipt) W_RTL_INVRC_ID_LC_DY_TMP
W_RTL_INVRC_ID_LC_DY_A		 ivrcpidldplp.ksh prditimsil.ksh
prdaggrsil.ksh		  
PLP (Inventory Receipt) W_RTL_INVRC_ID_LC_WK_A ivrcpidlwplp.ksh ivrcpidldplp.ksh  
PLP (Inventory Receipt) W_RTL_INVRC_IL1_LC_DY_TMP
W_RTL_INVRC_IL1_LC_DY_A		 ivrcpil1ldplp.ksh prditmsil.ksh  
PLP (Inventory Receipt) W_RTL_INVRC_IL1_LC_WK_A ivrcpil1lwplp.ksh ivrcpil1ldplp.ksh  
Inventory Position
PLP(Inventory Position) W_RTL_INV_IT_LC_WK_A invilwplp.ksh invildsil.ksh Optional
PLP(Inventory Position) W_RTL_INV_IT_DY_A invidplp.ksh invildsil.ksh Mandatory
PLP(Inventory Position) W_RTL_INV_IT_WK_A inviwplp.ksh invidplp.ksh Optional
PLP(Inventory Position) W_RTL_INV_SC_DY_A invsdplp.ksh invidplp.ksh Optional
PLP(Inventory Position) W_RTL_INV_SC_WK_A invswplp.ksh invidplp.ksh Optional
PLP(Inventory Position) W_RTL_INV_SC_DY_CUR_A invicursdplp.ksh invidplp.ksh Mandatory
proddimreclassfinaltmpplp.ksh
PLP(Inventory Position) W_RTL_INV_SC_WK_CUR_A invicurswplp.ksh invicursdplp.ksh Mandatory
PLP(Inventory Position) W_RTL_INV_SC_DY_CUR_A invicurrcsdplp.ksh Mandatory
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section."
PLP(Inventory Position) W_RTL_INV_SC_WK_CUR_A invicurrcswplp.ksh invicurrcsdplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP(Inventory Position) W_RTL_INV_SC_LC_DY_A invilsdplp.ksh invildsil.ksh Mandatory
PLP(Inventory Position) W_RTL_INV_CL_LC_DY_A invilcdplp.ksh invilsdplp.ksh Optional
PLP(Inventory Position) W_RTL_INV_DP_LC_DY_A invilddplp.ksh invilsdplp.ksh Optional
PLP(Inventory Position) W_RTL_INV_SC_LC_WK_A invilswplp.ksh invilsdplp.ksh Optional
PLP(Inventory Position) W_RTL_INV_CL_LC_WK_A invilcwplp.ksh invilsdplp.ksh Optional
PLP(Inventory Position) W_RTL_INV_DP_LC_WK_A invildwplp.ksh invilsdplp.ksh Optional
PLP(Inventory Position) W_RTL_INV_ID_LC_DY_TMP
W_RTL_INV_ID_LC_DY_A		 invidldplp.ksh prditimsil.ksh
prdaggrsil.ksh		  
PLP(Inventory Position) W_RTL_INV_ID_LC_WK_A invidlwplp.ksh invidldplp.ksh  
PLP(Inventory Position) W_RTL_INV_IL1_LC_DY_TMP
W_RTL_INV_IL1_LC_DY_A		 invil1ldplp.ksh prditmsil.ksh  
PLP(Inventory Position) W_RTL_INV_IL1_LC_WK_A invil1lwplp.ksh invil1ldplp.ksh  
Base Cost
PLP(Base Cost) W_RTL_BCOST_IT_DY_A cstislplp.ksh cstisldsil.ksh Mandatory
Net Cost
PLP(Net Cost) W_RTL_NCOST_IT_DY_A ncstuidplp.ksh ncstildsil.ksh Mandatory
Net Profit
PLP(Net Profit) W_RTL_NPROF_IT_LC_DY_F nprftildplp.ksh slsilsil.ksh Mandatory
ncstildsil.ksh
PLP(Net Profit) W_RTL_NPROF_IT_LC_WK_A nprftilwplp.ksh nprftildplp.ksh Optional
PLP(Net Profit) W_RTL_NPROF_SC_LC_DY_A nprftsldplp.ksh nprftildplp.ksh Mandatory
PLP(Net Profit) W_RTL_NPROF_CL_LC_DY_A nprftcldplp.ksh nprftsldplp.ksh Optional
PLP(Net Profit) W_RTL_NPROF_DP_LC_DY_A nprftdldplp.ksh nprftsldplp.ksh Optional
PLP(Net Profit) W_RTL_NPROF_SC_LC_WK_A nprftslwplp.ksh nprftsldplp.ksh Optional
PLP(Net Profit) W_RTL_NPROF_CL_LC_WK_A nprftclwplp.ksh nprftsldplp.ksh Optional
PLP(Net Profit) W_RTL_NPROF_DP_LC_WK_A nprftdlwplp.ksh nprftsldplp.ksh Optional
PLP(Net Profit) W_RTL_NPROF_IT_DY_A nprftidplp.ksh nprftildplp.ksh Mandatory
PLP(Net Profit) W_RTL_NPROF_IT_WK_A nprftiwplp.ksh nprftidplp.ksh Optional
PLP(Net Profit) W_RTL_NPROF_SC_DY_A nprftsdplp.ksh nprftidplp.ksh Optional
PLP(Net Profit) W_RTL_NPROF_SC_WK_A nprftswplp.ksh nprftidplp.ksh Optional
Price Fact
PLP(Price Fact) W_RTL_PRICE_IT_DY_A prcidplp.ksh prcilsil.ksh Mandatory
Sales Pack
PLP(Sales Pack) W_RTL_SLSPK_IT_LC_WK_A slspkilwplp.ksh slspkildsil.ksh Optional
PLP(Sales Pack) W_RTL_SLSPK_IT_DY_A slspkidplp.ksh slspkildsil.ksh Mandatory
PLP(Sales Pack) W_RTL_SLSPK_IT_WK_A slspkiwplp.ksh slspkidplp.ksh Optional
PLP(Sales Pack) W_RTL_SLSPK_IT_LC_DY_SN_A slspkildsnplp.ksh slspkildsil.ksh Mandatory
 prditmsmsil.ksh
PLP(Sales Pack) W_RTL_SLSPK_IT_LC_WK_SN_A slspkilwsnplp.ksh slspkildsnplp.ksh Optional
PLP(Sales Pack) W_RTL_SLSPK_IT_DY_SN_A slspkidsnplp.ksh slspkildsnplp.ksh Optional
PLP(Sales Pack) W_RTL_SLSPK_IT_WK_SN_A slspkiwsnplp.ksh slspkildsnplp.ksh Optional
Supplier Compliance
PLP(Supplier Compliance) W_RTL_SUPPCM_IT_LC_WK_A scrtilwplp.ksh scmplildsil.ksh Mandatory
PLP(Supplier Compliance) W_RTL_SUPPCMUF_LC_WK_A scrtuilwplp.ksh scmplufildsil.ksh Mandatory
Wholesale Franchise
PLP(Wholesale Franchise) W_RTL_SLSWF_IT_DY_A wfslsidplp.ksh wfslsildsil.ksh Mandatory
PLP(Wholesale Franchise) W_RTL_SLSWF_IT_WK_A wfslsiwplp.ksh wfslsidplp.ksh Optional
PLP(Wholesale Franchise) W_RTL_SLSWF_SC_LC_DY_A wfslssldplp.ksh wfslsildsil.ksh Mandatory
PLP(Wholesale Franchise) W_RTL_SLSWF_SC_LC_WK_A wfslsslwplp.ksh wfslssldplp.ksh Optional
PLP(Wholesale Franchise) W_RTL_SLSWF_SC_LC_DY_CUR_A wfslssldcurrplp.ksh wfslsildsil.ksh Mandatory
proddimreclassfinaltmpplp.ksh
PLP(Wholesale Franchise) W_RTL_SLSWF_SC_LC_WK_CUR_A wfslsslwcurrplp.ksh wfslssldcurrplp.ksh Optional
PLP(Wholesale Franchise) W_RTL_SLSWF_SC_LC_DY_CUR_A wfslssldcurrrcplp.ksh   Mandatory
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP(Wholesale Franchise) W_RTL_SLSWF_SC_LC_WK_CUR_A wfslsslwcurrrcplp.ksh wfslssldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP(Wholesale Franchise) W_RTL_SLSWF_IT_LC_WK_A wfslsilwplp.ksh wfslsildsil.ksh Mandatory
Sales Promotion
PLP(Sales Promotion) W_RTL_SLSPR_PC_IT_LC_DY_A slsprmcildplp.ksh slsprmildsil.ksh Mandatory
PLP(Sales Promotion) W_RTL_SLSPR_PE_IT_LC_DY_A slsprmeildplp.ksh slsprmildsil.ksh Mandatory
PLP(Sales Promotion) W_RTL_SLSPR_PP_IT_LC_DY_A slsprmpildplp.ksh slsprmildsil.ksh Mandatory
Market Basket (Data Mining)
PLP(Data Mining) C_LOAD_DATES etlrefreshwkgenplp.ksh slslwplp.ksh  
slsprmildsil.ksh
PLP(Data Mining) C_LOAD_DATES mbetlrefreshgenplp.ksh etlrefreshwkgenplp.ksh  
PLP(Data Mining) C_LOAD_DATES mbbletlrefreshgenplp.ksh mbetlrefreshgenplp.ksh  
PLP(Data Mining) W_RTL_DMS_PRODUCT_G prodhierarchyplp.ksh mbbletlrefreshgenplp.ksh  
PLP(Data Mining) W_RTL_DMS_ORG_DH_G orgdhierarchyplp.ksh mbbletlrefreshgenplp.ksh  
PLP(Data Mining) W_RTL_DMS_INT_ORG_DH_G mbintorghierplp.ksh mbbletlrefreshgenplp.ksh  
PLP(Data Mining) None rseprocedurecallplp.ksh CORE_ETL_MBA mbintorghierplp.ksh  
orgdhierarchyplp.ksh
prodhierarchyplp.ksh
PLP(Data Mining) None rseprocedurecallplp.ksh CORE_ETL rseprocedurecallplp.ksh CORE_ETL_MBA  
PLP(Data Mining) W_RTL_DMO_SLS_SC_WK_G rseprocedurecallplp.ksh ARM_TOP10 rseprocedurecallplp.ksh CORE_ETL  
W_RTL_DMO_SLS_CL_WK_G
W_RTL_DMO_SLS_DP_WK_G
PLP(Data Mining) W_RTL_DMO_SLS_SC_WK_SUP_G rseprocedurecallplp.ksh ARM_ANC_SC rseprocedurecallplp.ksh CORE_ETL  
PLP(Data Mining) W_RTL_DMO_SLSPR_SC_WK_G rseprocedurecallplp.ksh ARM_TOP10_PROMO rseprocedurecallplp.ksh CORE_ETL  
PLP(Data Mining) W_RTL_DMO_SLSPR_CUST_SC_WK_G rseprocedurecallplp.ksh ARM_CUST_PROMO rseprocedurecallplp.ksh CORE_ETL  
PLP(Data Mining) W_RTL_DMO_SLSPR_SC_WK_SUP_G rseprocedurecallplp.ksh ARM_ANC_SC_PROMO rseprocedurecallplp.ksh CORE_ETL  
PLP(Data Mining) None rseprocedurecallplp.ksh ARM rseprocedurecallplp.ksh CORE_ETL rseprocedurecallplp.ksh ARM_TOP10
rseprocedurecallplp.ksh ARM_ANC_SC
rseprocedurecallplp.ksh ARM_TOP10_PROMO
rseprocedurecallplp.ksh ARM_CUST_PROMO
rseprocedurecallplp.ksh ARM_ANC_SC_PROMO
PLP(Data Mining) W_RTL_DMO_SLS_BL_PC_IT_LC_WK_G rseprocedurecallplp.ksh BL mbintorghierplp.ksh  
orgdhierarchyplp.ksh
prodhierarchyplp.ksh
PLP(Market Basket) W_RTL_MB_SLSPR_CUST_SC_WK_A mbslsprcustscwkplp.ksh rseprocedurecallplp.ksh ARM_CUST_PROMO Mandatory
PLP(Market Basket) W_RTL_MB_SLSPR_SC_WK_SUP_A mbslsprscwksupplp.ksh rseprocedurecallplp.ksh ARM_ANC_SC_PROMO Mandatory
PLP(Market Basket) W_RTL_MB_SLSPR_SC_WK_A mbslsprscwkplp.ksh rseprocedurecallplp.ksh ARM_TOP10_PROMO Mandatory
PLP(Market Basket) W_RTL_MB_SLS_DP_WK_A mbslsdpwkplp.ksh rseprocedurecallplp.ksh ARM_TOP10 Mandatory
PLP(Market Basket) W_RTL_MB_SLS_CL_WK_A mbslsclwkplp.ksh rseprocedurecallplp.ksh ARM_TOP10 Mandatory
PLP(Market Basket) W_RTL_MB_SLS_SC_WK_A mbslsscwkplp.ksh rseprocedurecallplp.ksh ARM_TOP10 Mandatory
PLP(Market Basket) W_RTL_MB_SLS_SC_WK_SUP_A mbslsscwksupplp.ksh rseprocedurecallplp.ksh ARM_ANC_SC Mandatory
PLP(Market Basket) W_RTL_DMO_SLSPR_BL_PC_IT_LC_WK_A mbslsblitlcwkplp.ksh rseprocedurecallplp.ksh BL Mandatory
Commerce Anywhere
PLP (Commerce Anywhere) W_RTL_COFL_IT_CH_DY_A coflichdplp.ksh coflildplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_COFL_IT_CH_DY_SN_A coflichdsnplp.ksh coflildplp.kshprditmsmsil.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_COFL_IT_CH_WK_A coflichwplp.ksh coflichdplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_COFL_IT_CH_WK_SN_A coflichwsnplp.ksh coflichdsnplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_COFL_IT_LC_DY_A coflildplp.ksh orgsil.ksh, Mandatory
orgchnsil.ksh,
colnfilsil.ksh
PLP (Commerce Anywhere) W_RTL_COFL_IT_LC_DY_SN_A coflildsnplp.ksh coflichdsnplp.ksh Mandatory
coflildplp.ksh
PLP (Commerce Anywhere) W_RTL_COFL_IT_LC_WK_A coflilwplp.ksh coflildplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_COFL_IT_LC_WK_SN_A coflilwsnplp.ksh coflichdsnplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_COFL_SC_CH_DY_CUR_A coflschdcurrplp.ksh coflsldcurrplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_COFL_SC_CH_DY_CUR_A coflschdcurrrcplp.ksh coflsldcurrrcplp.ksh Mandatory
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Commerce Anywhere) W_RTL_COFL_SC_CH_DY_A coflschdplp.ksh coflichdplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_COFL_SC_CH_WK_CUR_A coflschwcurrplp.ksh coflsldcurrplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_COFL_SC_CH_WK_CUR_A coflschwcurrrcplp.ksh coflsldcurrrcplp.ksh Mandatory
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Commerce Anywhere) W_RTL_COFL_SC_CH_WK_A coflschwplp.ksh coflichdplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_COFL_SC_LC_DY_CUR_A coflsldcurrplp.ksh coflsldcurrplp.ksh  Mandatory
PLP (Commerce Anywhere) W_RTL_COFL_SC_LC_DY_CUR_A coflsldcurrrcplp.ksh prddimlkuptmpplp.ksh Mandatory
coflildplp.ksh This program should not be executed during the first batch cycle
orgsil.ksh This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
orgdimlkuptmpplp.ksh  
mcaldaysil.ksh  
mcalwk454sil.ksh  
orgchnsil.ksh  
coflildplp.ksh  
proddimreclassfinaltmpplp.ksh  
ttltypsil.ksh  
PLP (Commerce Anywhere) W_RTL_COFL_SC_LC_DY_A coflsldplp.ksh coflildplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_COFL_SC_LC_WK_CUR_A coflslwcurrplp.ksh coflsldcurrplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_COFL_SC_LC_WK_CUR_A coflslwcurrrcplp.ksh coflsldcurrrcplp.ksh Mandatory
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Commerce Anywhere) W_RTL_COFL_SC_LC_WK_A coflslwplp.ksh coflsldplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_IT_CH_DY_A coicdplp.ksh coitlcchdyplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_IT_CH_DY_SN_A coichdsnplp.ksh coilchdsnplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_IT_CH_WK_SN_A coichwsnplp.ksh coilchdsnplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_IT_CH_WK_A coicwplp.ksh coicdplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_IT_LC_CH_DY_SN_A coilchdsnplp.ksh coitlcchdyplp.ksh Mandatory
prditmsmsil.ksh
PLP (Commerce Anywhere) W_RTL_CO_IT_LC_CH_WK_SN_A coilchwsnplp.ksh coilchdsnplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_IT_LC_CH_DY_A coitlcchdyplp.ksh colineilsil.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_IT_LC_CH_WK_A coitlcchwkplp.ksh coitlcchdyplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_SC_CH_DY_A coscdplp.ksh coicdplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_SC_CH_DY_CUR_A coschdcurplp.ksh cosclcchcurrdplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_SC_CH_DY_CUR_A coschdcurrcplp.ksh cosclcchcrcldplp.ksh Mandatory
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Commerce Anywhere) W_RTL_CO_SC_CH_WK_CUR_A coschwcurplp.ksh cosclcchcurrdplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_SC_CH_WK_CUR_A coschwcurrcplp.ksh cosclcchcrcldplp.ksh Mandatory
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Commerce Anywhere) W_RTL_CO_SC_CH_WK_A coscwplp.ksh coicdplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_SC_LC_CH_DY_A coslchdplp.ksh coitlcchdyplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_SC_LC_CH_WK_A coslchwplp.ksh coslchdplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_STATUS_IT_CH_DY_A costtichdplp.ksh costtilchdplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_STATUS_IT_CH_WK_A costtichwplp.ksh costtichdplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_STATUS_IT_LC_CH_DY_A costtilchdplp.ksh prddimlkuptmpplp.ksh Mandatory
orgdimlkuptmpplp.ksh
mcaldaysil.ksh
coitlcchdyplp.ksh
mcalwk454sil.ksh
PLP (Commerce Anywhere) W_RTL_CO_STATUS_IT_LC_CH_WK_A costtilchwplp.ksh costtilchdplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_STATUS_SC_CH_DY_CUR_A costtschdcurplp.ksh costtichdplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_STATUS_SC_CH_DY_CUR_A costtschdcurrcplp.ksh mcaldaysil.ksh Mandatory
mcalwk454sil.ksh This program should not be executed during the first batch cycle
orgchnsil.ksh This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
costtichdplp.ksh  
proddimreclassfinaltmpplp.ksh  
PLP (Commerce Anywhere) W_RTL_CO_STATUS_SC_CH_DY_A costtschdplp.ksh costtichdplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_STATUS_SC_CH_WK_CUR_A costtschwcurplp.ksh costtichdplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_STATUS_SC_CH_WK_CUR_A costtschwcurrcplp.ksh mcalwk454sil.ksh Mandatory
orgchnsil.ksh This program should not be executed during the first batch cycle
costtichwplp.ksh This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
proddimreclassfinaltmpplp.ksh  
PLP (Commerce Anywhere) W_RTL_CO_STATUS_SC_CH_WK_A costtschwplp.ksh costtichdplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_STATUS_SC_LC_CH_DY_A costtslchdplp.ksh costtilchdplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_STATUS_SC_LC_CH_WK_A costtslchwplp.ksh costtslchdplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_SC_LC_CH_DY_CUR_A cosclcchcrcldplp.ksh orgdimlkuptmpplp.ksh Mandatory
mcaldaysil.ksh
mcalwk454sil.ksh
orgchnsil.ksh
coitlcchdyplp.ksh
proddimreclassfinaltmpplp.ksh
ttltypsil.ksh
PLP (Commerce Anywhere) W_RTL_CO_SC_LC_CH_DY_CUR_A cosclcchcurrdplp.ksh prddimlkuptmpplp.ksh Mandatory
coitlcchdyplp.ksh This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Commerce Anywhere) W_RTL_CO_SC_LC_CH_WK_CUR_A cosclcchcrclwplp.ksh cosclcchcrcldplp.ksh Mandatory
PLP (Commerce Anywhere) W_RTL_CO_SC_LC_CH_WK_CUR_A cosclcchcurrwplp.ksh cosclcchcurrdplp.ksh Mandatory
This program should not be executed during the first batch cycle
This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Inventory Adjustment) W_RTL_INVADJ_IT_LC_WK_A ivadjilwplp.ksh ivadjildsil.ksh Optional
PLP (Inventory Adjustment) W_RTL_INVADJ_SC_LC_DY_A ivadjsldplp.ksh ivadjildsil.ksh Mandatory
PLP (Inventory Adjustment) W_RTL_INVADJ_SC_LC_DY_CUR_A ivadjsldcurrplp.ksh ivadjildsil.ksh Mandatory
proddimreclassfinaltmpplp.ksh
PLP (Inventory Adjustment) W_RTL_INVADJ_SC_LC_DY_CUR_A ivadjsldcurrrcplp.ksh   Mandatory
This program should not be executed during the first batch cycle This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Inventory Adjustment) W_RTL_INVADJ_SC_LC_WK_A ivadjslwplp.ksh ivadjsldplp.ksh Optional
PLP (Inventory Adjustment) W_RTL_INVADJ_SC_LC_WK_CUR_A ivadjslwcurrplp.ksh ivadjsldcurrplp.ksh Optional
PLP (Inventory Adjustment) W_RTL_INVADJ_SC_LC_WK_CUR_A ivadjslwcurrrcplp.ksh ivadjsldcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Inventory Adjustment) W_RTL_INVADJ_IT_LC_DY_SN_A ivadjildsnplp.ksh ivadjildsil.ksh Mandatory
prditmsmsil.ksh
PLP (Inventory Transfers) W_RTL_INVTSF_IT_LC_WK_A ivtsfilwplp.ksh ivtsfildsil.ksh Optional
PLP (Inventory Transfers) W_RTL_INVTSF_SC_LC_DY_A ivtsfsldplp.ksh ivtsfildsil.ksh Mandatory
PLP (Inventory Transfers) W_RTL_INVTSF_SC_LC_DY_CUR_A ivtsfsldcurrplp.ksh ivtsfildsil.ksh Mandatory
proddimreclassfinaltmpplp.ksh
PLP (Inventory Transfers) W_RTL_INVTSF_SC_LC_DY_CUR_A ivtsfsldcurrrcplp.ksh   Mandatory
This program should not be executed during the first batch cycle This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Inventory Transfers) W_RTL_INVTSF_SC_LC_WK_A ivtsfslwplp.ksh ivtsfilwplp.ksh Optional
PLP (Inventory Transfers) W_RTL_INVTSF_SC_LC_WK_CUR_A ivtsfslwcurrplp.ksh ivtsfsldplp.ksh Optional
PLP (Inventory Transfers) W_RTL_INVTSF_SC_LC_WK_CUR_A ivtsfslwcurrrcplp.ksh ivtsfsldcurrplp.ksh Optional
This program should not be executed during the first batch cycle This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP (Inventory Transfers) W_RTL_INVTSF_IT_LC_DY_SN_A ivtsfildsnplp.ksh ivtsfildsil.ksh Mandatory
prditmsmsil.ksh
PLP(Consumer Spend) W_RTL_MKTSLS_TA_CMG_CS_QR_A mktslstacmgcnsqtrplp.ksh cgmktslssil.ksh Mandatory
prddimlkuptmpplp.ksh
cmgrprdmtxsil.ksh
mcaldaysil.ksh
cngcnsgsil.ksh
PLP(Consumer Spend) W_RTL_MKTSLS_TA_CMG_QR_A mktslstacmgqtrplp.ksh mktslstacmgcnsqtrplp.ksh Mandatory
PLP(Consumer Spend) W_RTL_MKTSLS_TA_CL_CS_QR_CUR_A mktslstaprdcnsqtrcurrplp.ksh cgmktslssil.ksh Mandatory
prddimlkuptmpplp.ksh
mcaldaysil.ksh
cngcnsgsil.ksh
PLP(Consumer Spend) W_RTL_MKTSLS_TA_CL_CS_QR_CUR_A mktslstaprdcnsqtrcurrrcplp.ksh   Optional
This program should not be executed during the first batch cycle This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP(Consumer Spend) W_RTL_MKTSLS_TA_CL_QR_CUR_A mktslstaprdqtrcurrplp.ksh mktslstaprdcnsqtrcurrplp.ksh Mandatory
PLP(Consumer Spend) W_RTL_MKTSLS_TA_CL_QR_CUR_A mktslstaprdqtrcurrrcplp.ksh mktslstaprdcnsqtrcurrrcplp.ksh Optional
This program should not be executed during the first batch cycle This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP( MFP) W_RTL_MFPCP_PROD1_LC1_T1_F, W_RTL_MFPCP_PROD2_LC2_T2_F, W_RTL_MFPCP_PROD3_LC3_T3_F mfpcprcplp.ksh   Optional
This program should not be executed during the first batch cycle This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP( MFP) W_RTL_MFPOP_PROD1_LC1_T1_F,W_RTL_MFPOP_PROD2_LC2_T2_F,W_RTL_MFPOP_PROD3_LC3_T3_F mfpoprcplp.ksh   Optional
This program should not be executed during the first batch cycle This program should be executed before etlrefreshgenplp.ksh is started.Please see the note on scheduling reclass as is programs in the beginning of this section.
PLP( Inventory Ageing) W_RTL_INVAGE_DP_LC_DY_A invagdldplp.ksh   Optional: Only required when you are interested in Inventory Ageing Analysis.
PLP( MFP) W_RTL_MFPCP_PROD2_LC2_T2_F mfpcpop1to2plp.ksh    
PLP( MFP) W_RTL_MFPCP_PROD3_LC3_T3_F mfpcpop2to3plp.ksh   mfpcpop1to3plp.ksh
PLP( MFP) W_RTL_MFPCP_PROD3_LC3_T3_F mfpcpop1to3plp.ksh   mfpcpop1to2plp.ksh
PLP( MFP) W_RTL_MFPOP_PROD2_LC2_T2_F mfpopop1to2plp.ksh    
PLP( MFP) W_RTL_MFPOP_PROD3_LC3_T3_F mfpopop1to3plp.ksh   mfpopop1to2plp.ksh
PLP( MFP) W_RTL_MFPOP_PROD3_LC3_T3_F mfpopop2to3plp.ksh   mfpopop1to3plp.ksh
None None run_grant_access.ksh  Grant Access to  E$ tables to RAFEDM01  
None None run_create_synonym.ksh create Synonmyns for all tables of RAFEDM01