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 1094: c_oper_unit inv_organization_info_v.operating_unit%type ;

1090: c_match_config_item_id bom_cto_src_orgs.model_item_id%type ;
1091: c_org_id bom_cto_src_orgs.rcv_org_id%type ;
1092: c_organization_id bom_cto_src_orgs.organization_id%type ;
1093: c_po_valid_org financials_system_params_all.inventory_organization_id%type ;
1094: c_oper_unit inv_organization_info_v.operating_unit%type ;
1095:
1096: v_buy_item_cost mtl_system_items.list_price_per_unit%type ;
1097:
1098: -- rkaza. 3742393. 08/12/2004.

Line 1099: -- Repalcing org_organization_definitions with inv_organization_info_v

1095:
1096: v_buy_item_cost mtl_system_items.list_price_per_unit%type ;
1097:
1098: -- rkaza. 3742393. 08/12/2004.
1099: -- Repalcing org_organization_definitions with inv_organization_info_v
1100:
1101:
1102: -- For Performance reason, We are removing the join with financial_system_params_all table
1103: -- For some reason, this join is causing non mergable view or inv_organization_info_v.

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

1099: -- Repalcing org_organization_definitions with inv_organization_info_v
1100:
1101:
1102: -- For Performance reason, We are removing the join with financial_system_params_all table
1103: -- For some reason, this join is causing non mergable view or inv_organization_info_v.
1104: -- We don't know the exact reason yet. But for now, we are planning to break the sql into two parts
1105: -- to avoid this performance issue.
1106: cursor c_buy_items( xcfg_itm_id number,
1107: xcfg_org_id number

Line 1115: from inv_organization_info_v org

1111: msi.base_item_id
1112: , msi.inventory_item_id
1113: , mp1.cost_organization_id -- 3116778
1114: , nvl(org.operating_unit,0) oper_unit
1115: from inv_organization_info_v org
1116: , mtl_system_items msi
1117: , cst_item_costs cic
1118: , mtl_parameters mp1
1119: where org.organization_id = msi.organization_id

Line 2106: c_oper_unit inv_organization_info_v.operating_unit%type ;

2102: c_config_item_id bom_cto_src_orgs.model_item_id%type ;
2103: c_cost_org_id mtl_parameters.cost_organization_id%type ; -- 3116778
2104: c_organization_id bom_cto_src_orgs.organization_id%type ;
2105: c_po_valid_org financials_system_params_all.inventory_organization_id%type ;
2106: c_oper_unit inv_organization_info_v.operating_unit%type ;
2107:
2108: v_buy_item_cost mtl_system_items.list_price_per_unit%type ;
2109:
2110:

Line 2124: , inv_organization_info_v org

2120: , nvl(org.operating_unit,0) oper_unit
2121: from bom_cto_src_orgs bcso
2122: , bom_cto_order_lines bcol
2123: , financials_system_params_all fsp
2124: , inv_organization_info_v org
2125: , cst_item_costs cic
2126: , mtl_parameters mp1 /* master organization */
2127: , mtl_parameters mp2
2128: where bcso.top_model_line_id = pTopAtoLineId