[Home] [Help]
1281: cfrb.WEIGHTED_AVG_PERIOD12,
1282: cpp.RECOMMEND_METHOD
1283: From CSP_PLANNING_PARAMETERS cpp,
1284: CSP_USAGE_HISTORIES cuh,
1285: CSP_SUPERSEDE_ITEMS csi,
1286: CSP_FORECAST_RULES_B cfrb
1287: Where cpp.level_id like P_Level_Id || '%'
1288: And cpp.node_type = 'SUBINVENTORY'
1289: And cpp.recommend_method in ('USAGE','USAGE_PNORM','USAGE_TNORM','PNORM','TNORM')
1357: cfrb.WEIGHTED_AVG_PERIOD12,
1358: cpp.RECOMMEND_METHOD
1359: From CSP_PLANNING_PARAMETERS cpp,
1360: CSP_USAGE_ORGS cuom,
1361: CSP_SUPERSEDE_ITEMS csi,
1362: CSP_FORECAST_RULES_B cfrb
1363: Where cpp.level_id like P_Level_Id || '%'
1364: And cpp.node_type = 'ORGANIZATION_WH'
1365: And cpp.recommend_method in ('USAGE','USAGE_PNORM','USAGE_TNORM','PNORM','TNORM')
1756: sysdate,
1757: fnd_global.user_id,
1758: fnd_global.conc_login_id
1759: from csp_product_populations_fr_v cppf,
1760: csp_supersede_items csi
1761: where cppf.level_id like p_level_id || '%'
1762: and cppf.node_type in ('ORGANIZATION_WH','SUBINVENTORY')
1763: and csi.inventory_item_id(+) = cppf.inventory_item_id
1764: and csi.organization_id (+) = cppf.organization_id
1889: sysdate,
1890: fnd_global.user_id,
1891: fnd_global.conc_login_id
1892: from csp_new_product_planning_v cnpp,
1893: csp_supersede_items csi
1894: where cnpp.level_id like p_level_id || '%'
1895: and csi.inventory_item_id(+) = cnpp.inventory_item_id
1896: and csi.organization_id (+) = cnpp.organization_id
1897: and csi.sub_inventory_code (+) = cnpp.secondary_inventory;
2018: sysdate,
2019: fnd_global.user_id,
2020: fnd_global.conc_login_id
2021: from csp_usage_reg_org_subinv_v curos,
2022: csp_supersede_items csi
2023: where curos.level_id like p_level_id || '%'
2024: and csi.inventory_item_id (+) = curos.inventory_item_id
2025: and csi.organization_id (+) = curos.organization_id
2026: and csi.sub_inventory_code(+) = curos.secondary_inventory