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 MTL_SYSTEM_ITEMS

Line 1096: v_buy_item_cost mtl_system_items.list_price_per_unit%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.
1099: -- Repalcing org_organization_definitions with inv_organization_info_v
1100:

Line 1116: , mtl_system_items msi

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
1120: and cic.inventory_item_id = msi.inventory_item_id

Line 1144: from mtl_system_items msi

1140: select msi.inventory_item_id
1141: , msi.organization_id
1142: , cic.cost_type_id
1143: , cic.item_cost
1144: from mtl_system_items msi
1145: , cst_item_costs cic
1146: , mtl_parameters mp
1147: where msi.organization_id = cic.organization_id
1148: and msi.inventory_item_id = cic.inventory_item_id

Line 1169: from mtl_system_items msi

1165: )
1166: is
1167: select msi.inventory_item_id
1168: , mp.cost_organization_id rollup_org_id
1169: from mtl_system_items msi
1170: , mtl_parameters mp
1171: , cst_item_costs cic
1172: where msi.organization_id = mp.organization_id
1173: and mp.primary_cost_method = 1

Line 1538: from mtl_system_items

1534:
1535: lStmtNumber := 32;
1536: BEGIN
1537: select nvl(list_price_per_unit,0) into v_buy_item_cost
1538: from mtl_system_items
1539: where organization_id = c_po_valid_org
1540: and inventory_item_id = c_config_item_id ;
1541:
1542: EXCEPTION

Line 1582: from mtl_system_items_kfv

1578:
1579: l_token(3).token_name := 'MODEL_NAME';
1580:
1581: select concatenated_segments into v_model_name
1582: from mtl_system_items_kfv
1583: where inventory_item_id = ( select base_item_id
1584: from mtl_system_items where inventory_item_id = c_config_item_id and rownum = 1 )
1585: and rownum = 1 ;
1586:

Line 1584: from mtl_system_items where inventory_item_id = c_config_item_id and rownum = 1 )

1580:
1581: select concatenated_segments into v_model_name
1582: from mtl_system_items_kfv
1583: where inventory_item_id = ( select base_item_id
1584: from mtl_system_items where inventory_item_id = c_config_item_id and rownum = 1 )
1585: and rownum = 1 ;
1586:
1587: l_token(3).token_value := v_model_name ;
1588:

Line 1736: from mtl_system_items msi,

1732: sysdate,
1733: gUserId,
1734: sysdate,
1735: gUserId
1736: from mtl_system_items msi,
1737: mtl_parameters mp ,
1738: cst_item_costs cic
1739: where msi.costing_enabled_flag = 'Y'
1740: and mp.organization_id = msi.organization_id

Line 2108: v_buy_item_cost mtl_system_items.list_price_per_unit%type ;

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:
2111:
2112: cursor c_buy_items

Line 2397: from mtl_system_items

2393: BEGIN
2394:
2395:
2396: select nvl(list_price_per_unit,0) into v_buy_item_cost
2397: from mtl_system_items
2398: where organization_id = c_po_valid_org and inventory_item_id = c_config_item_id ;
2399:
2400:
2401: EXCEPTION

Line 2436: from mtl_system_items_kfv

2432:
2433: l_token(3).token_name := 'MODEL_NAME';
2434:
2435: select concatenated_segments into v_model_name
2436: from mtl_system_items_kfv
2437: where inventory_item_id = ( select base_item_id
2438: from mtl_system_items where inventory_item_id = c_config_item_id and rownum = 1 )
2439: and rownum = 1 ;
2440:

Line 2438: from mtl_system_items where inventory_item_id = c_config_item_id and rownum = 1 )

2434:
2435: select concatenated_segments into v_model_name
2436: from mtl_system_items_kfv
2437: where inventory_item_id = ( select base_item_id
2438: from mtl_system_items where inventory_item_id = c_config_item_id and rownum = 1 )
2439: and rownum = 1 ;
2440:
2441: l_token(3).token_value := v_model_name ;
2442:

Line 2539: mtl_system_items msi,

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
2543: and bcso.cost_rollup = 'Y'