eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_CONFIG_COST_PK dependencies on INV_ORGANIZATION_INFO_V

Line 1075: c_oper_unit inv_organization_info_v.operating_unit%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:
1079: -- rkaza. 3742393. 08/12/2004.

Line 1080: -- Repalcing org_organization_definitions with inv_organization_info_v

1076:
1077: v_buy_item_cost mtl_system_items.list_price_per_unit%type ;
1078:
1079: -- rkaza. 3742393. 08/12/2004.
1080: -- Repalcing org_organization_definitions with inv_organization_info_v
1081:
1082:
1083: -- For Performance reason, We are removing the join with financial_system_params_all table
1084: -- For some reason, this join is causing non mergable view or inv_organization_info_v.

Line 1084: -- For some reason, this join is causing non mergable view or inv_organization_info_v.

1080: -- Repalcing org_organization_definitions with inv_organization_info_v
1081:
1082:
1083: -- For Performance reason, We are removing the join with financial_system_params_all table
1084: -- For some reason, this join is causing non mergable view or inv_organization_info_v.
1085: -- We don't know the exact reason yet. But for now, we are planning to break the sql into two parts
1086: -- to avoid this performance issue.
1087: cursor c_buy_items( xcfg_itm_id number,
1088: xcfg_org_id number

Line 1096: from inv_organization_info_v org

1092: msi.base_item_id
1093: , msi.inventory_item_id
1094: , mp1.cost_organization_id -- 3116778
1095: , nvl(org.operating_unit,0) oper_unit
1096: from inv_organization_info_v org
1097: , mtl_system_items msi
1098: , cst_item_costs cic
1099: , mtl_parameters mp1
1100: where org.organization_id = msi.organization_id

Line 1985: c_oper_unit inv_organization_info_v.operating_unit%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:
1989:

Line 2003: , inv_organization_info_v 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
2007: where bcso.top_model_line_id = pTopAtoLineId