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 BOM_CTO_SRC_ORGS

Line 1087: c_line_id bom_cto_src_orgs.line_id%type ;

1083:
1084: v_cto_cost_type_id cst_cost_types.cost_type_id%type ;
1085: v_buy_cost_type_id cst_cost_types.cost_type_id%type ;
1086: v_buy_cost number ;
1087: c_line_id bom_cto_src_orgs.line_id%type ;
1088: c_model_item_id bom_cto_src_orgs.model_item_id%type ;
1089: c_config_item_id bom_cto_src_orgs.model_item_id%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 ;

Line 1088: c_model_item_id bom_cto_src_orgs.model_item_id%type ;

1084: v_cto_cost_type_id cst_cost_types.cost_type_id%type ;
1085: v_buy_cost_type_id cst_cost_types.cost_type_id%type ;
1086: v_buy_cost number ;
1087: c_line_id bom_cto_src_orgs.line_id%type ;
1088: c_model_item_id bom_cto_src_orgs.model_item_id%type ;
1089: c_config_item_id bom_cto_src_orgs.model_item_id%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 ;

Line 1089: c_config_item_id bom_cto_src_orgs.model_item_id%type ;

1085: v_buy_cost_type_id cst_cost_types.cost_type_id%type ;
1086: v_buy_cost number ;
1087: c_line_id bom_cto_src_orgs.line_id%type ;
1088: c_model_item_id bom_cto_src_orgs.model_item_id%type ;
1089: c_config_item_id bom_cto_src_orgs.model_item_id%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 ;

Line 1090: c_match_config_item_id bom_cto_src_orgs.model_item_id%type ;

1086: v_buy_cost number ;
1087: c_line_id bom_cto_src_orgs.line_id%type ;
1088: c_model_item_id bom_cto_src_orgs.model_item_id%type ;
1089: c_config_item_id bom_cto_src_orgs.model_item_id%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 ;

Line 1091: c_org_id bom_cto_src_orgs.rcv_org_id%type ;

1087: c_line_id bom_cto_src_orgs.line_id%type ;
1088: c_model_item_id bom_cto_src_orgs.model_item_id%type ;
1089: c_config_item_id bom_cto_src_orgs.model_item_id%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:

Line 1092: c_organization_id bom_cto_src_orgs.organization_id%type ;

1088: c_model_item_id bom_cto_src_orgs.model_item_id%type ;
1089: c_config_item_id bom_cto_src_orgs.model_item_id%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 ;

Line 2100: c_line_id bom_cto_src_orgs.line_id%type ;

2096:
2097: v_cto_cost_type_id cst_cost_types.cost_type_id%type ;
2098: v_buy_cost_type_id cst_cost_types.cost_type_id%type ;
2099: v_buy_cost number ;
2100: c_line_id bom_cto_src_orgs.line_id%type ;
2101: c_model_item_id bom_cto_src_orgs.model_item_id%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 ;

Line 2101: c_model_item_id bom_cto_src_orgs.model_item_id%type ;

2097: v_cto_cost_type_id cst_cost_types.cost_type_id%type ;
2098: v_buy_cost_type_id cst_cost_types.cost_type_id%type ;
2099: v_buy_cost number ;
2100: c_line_id bom_cto_src_orgs.line_id%type ;
2101: c_model_item_id bom_cto_src_orgs.model_item_id%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 ;

Line 2102: c_config_item_id bom_cto_src_orgs.model_item_id%type ;

2098: v_buy_cost_type_id cst_cost_types.cost_type_id%type ;
2099: v_buy_cost number ;
2100: c_line_id bom_cto_src_orgs.line_id%type ;
2101: c_model_item_id bom_cto_src_orgs.model_item_id%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 ;

Line 2104: c_organization_id bom_cto_src_orgs.organization_id%type ;

2100: c_line_id bom_cto_src_orgs.line_id%type ;
2101: c_model_item_id bom_cto_src_orgs.model_item_id%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 ;

Line 2121: from bom_cto_src_orgs bcso

2117: -- 3116778 , bcso.rcv_org_id
2118: , mp2.cost_organization_id -- 3116778
2119: , nvl(fsp.inventory_organization_id,0) po_valid_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

Line 2155: from bom_cto_src_orgs bcso

2151: is
2152: select distinct -- bug 3931290
2153: bcso.config_item_id
2154: , mp1.cost_organization_id rollup_org_id
2155: from bom_cto_src_orgs bcso
2156: , mtl_parameters mp1
2157: , mtl_parameters mp2
2158: , cst_item_costs cic
2159: where bcso.top_model_line_id = pTopAtoLineId

Line 2538: from bom_cto_src_orgs bcso,

2534: sysdate,
2535: gUserId,
2536: sysdate,
2537: gUserId
2538: from bom_cto_src_orgs bcso,
2539: mtl_system_items msi,
2540: mtl_parameters mp ,
2541: cst_item_costs cic
2542: where bcso.top_model_line_id = pTopAtoLineId