APPS.CTO_CONFIG_COST_PK dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 1074: c_po_valid_org financials_system_params_all.inventory_organization_id%type ;

1070: c_config_item_id bom_cto_src_orgs.model_item_id%type ;
1071: c_match_config_item_id bom_cto_src_orgs.model_item_id%type ;
1072: c_org_id bom_cto_src_orgs.rcv_org_id%type ;
1073: c_organization_id bom_cto_src_orgs.organization_id%type ;
1074: c_po_valid_org financials_system_params_all.inventory_organization_id%type ;
1075: c_oper_unit inv_organization_info_v.operating_unit%type ;
1076:
1077: v_buy_item_cost mtl_system_items.list_price_per_unit%type ;
1078:

Line 1438: from financials_system_params_All

1434: -- Added by Renga Kannan on 03/15/20067 to get the po validation org
1435:
1436: Select nvl(inventory_organization_id,0)
1437: into c_po_valid_org
1438: from financials_system_params_All
1439: where org_id = c_oper_unit;
1440:
1441:
1442: IF PG_DEBUG <> 0 THEN

Line 1984: c_po_valid_org financials_system_params_all.inventory_organization_id%type ;

1980: c_model_item_id bom_cto_src_orgs.model_item_id%type ;
1981: c_config_item_id bom_cto_src_orgs.model_item_id%type ;
1982: c_cost_org_id mtl_parameters.cost_organization_id%type ; -- 3116778
1983: c_organization_id bom_cto_src_orgs.organization_id%type ;
1984: c_po_valid_org financials_system_params_all.inventory_organization_id%type ;
1985: c_oper_unit inv_organization_info_v.operating_unit%type ;
1986:
1987: v_buy_item_cost mtl_system_items.list_price_per_unit%type ;
1988:

Line 2002: , financials_system_params_all fsp

1998: , nvl(fsp.inventory_organization_id,0) po_valid_org
1999: , nvl(org.operating_unit,0) oper_unit
2000: from bom_cto_src_orgs bcso
2001: , bom_cto_order_lines bcol
2002: , financials_system_params_all fsp
2003: , inv_organization_info_v org
2004: , cst_item_costs cic
2005: , mtl_parameters mp1 /* master organization */
2006: , mtl_parameters mp2