[Home] [Help]
1261: cfrb.WEIGHTED_AVG_PERIOD12,
1262: cpp.RECOMMEND_METHOD
1263: From CSP_PLANNING_PARAMETERS cpp,
1264: CSP_USAGE_HISTORIES cuh,
1265: CSP_SUPERSEDE_ITEMS csi,
1266: CSP_FORECAST_RULES_B cfrb
1267: Where cpp.level_id like P_Level_Id || '%'
1268: And cpp.node_type = 'SUBINVENTORY'
1269: And cpp.recommend_method in ('USAGE','USAGE_PNORM','USAGE_TNORM','PNORM','TNORM')
1337: cfrb.WEIGHTED_AVG_PERIOD12,
1338: cpp.RECOMMEND_METHOD
1339: From CSP_PLANNING_PARAMETERS cpp,
1340: CSP_USAGE_ORG_MV cuom,
1341: CSP_SUPERSEDE_ITEMS csi,
1342: CSP_FORECAST_RULES_B cfrb
1343: Where cpp.level_id like P_Level_Id || '%'
1344: And cpp.node_type = 'ORGANIZATION_WH'
1345: And cpp.recommend_method in ('USAGE','USAGE_PNORM','USAGE_TNORM','PNORM','TNORM')
1736: sysdate,
1737: fnd_global.user_id,
1738: fnd_global.conc_login_id
1739: from csp_product_populations_fr_v cppf,
1740: csp_supersede_items csi
1741: where cppf.level_id like p_level_id || '%'
1742: and cppf.node_type in ('ORGANIZATION_WH','SUBINVENTORY')
1743: and csi.inventory_item_id(+) = cppf.inventory_item_id
1744: and csi.organization_id (+) = cppf.organization_id
1869: sysdate,
1870: fnd_global.user_id,
1871: fnd_global.conc_login_id
1872: from csp_new_product_planning_v cnpp,
1873: csp_supersede_items csi
1874: where cnpp.level_id like p_level_id || '%'
1875: and csi.inventory_item_id(+) = cnpp.inventory_item_id
1876: and csi.organization_id (+) = cnpp.organization_id
1877: and csi.sub_inventory_code (+) = cnpp.secondary_inventory;
1998: sysdate,
1999: fnd_global.user_id,
2000: fnd_global.conc_login_id
2001: from csp_usage_reg_org_subinv_v curos,
2002: csp_supersede_items csi
2003: where curos.level_id like p_level_id || '%'
2004: and csi.inventory_item_id (+) = curos.inventory_item_id
2005: and csi.organization_id (+) = curos.organization_id
2006: and csi.sub_inventory_code(+) = curos.secondary_inventory