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 1077: v_buy_item_cost mtl_system_items.list_price_per_unit%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.
1080: -- Repalcing org_organization_definitions with inv_organization_info_v
1081:

Line 1097: , mtl_system_items msi

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

Line 1125: from mtl_system_items msi

1121: select msi.inventory_item_id
1122: , msi.organization_id
1123: , cic.cost_type_id
1124: , cic.item_cost
1125: from mtl_system_items msi
1126: , cst_item_costs cic
1127: , mtl_parameters mp
1128: where msi.organization_id = cic.organization_id
1129: and msi.inventory_item_id = cic.inventory_item_id

Line 1150: from mtl_system_items msi

1146: )
1147: is
1148: select msi.inventory_item_id
1149: , mp.cost_organization_id rollup_org_id
1150: from mtl_system_items msi
1151: , mtl_parameters mp
1152: , cst_item_costs cic
1153: where msi.organization_id = mp.organization_id
1154: and mp.primary_cost_method = 1

Line 1486: from mtl_system_items

1482:
1483: lStmtNumber := 32;
1484: BEGIN
1485: select nvl(list_price_per_unit,0) into v_buy_item_cost
1486: from mtl_system_items
1487: where organization_id = c_po_valid_org
1488: and inventory_item_id = c_config_item_id ;
1489:
1490: EXCEPTION

Line 1530: from mtl_system_items_kfv

1526:
1527: l_token(3).token_name := 'MODEL_NAME';
1528:
1529: select concatenated_segments into v_model_name
1530: from mtl_system_items_kfv
1531: where inventory_item_id = ( select base_item_id
1532: from mtl_system_items where inventory_item_id = c_config_item_id and rownum = 1 )
1533: and rownum = 1 ;
1534:

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

1528:
1529: select concatenated_segments into v_model_name
1530: from mtl_system_items_kfv
1531: where inventory_item_id = ( select base_item_id
1532: from mtl_system_items where inventory_item_id = c_config_item_id and rownum = 1 )
1533: and rownum = 1 ;
1534:
1535: l_token(3).token_value := v_model_name ;
1536:

Line 1684: from mtl_system_items msi,

1680: sysdate,
1681: gUserId,
1682: sysdate,
1683: gUserId
1684: from mtl_system_items msi,
1685: mtl_parameters mp ,
1686: cst_item_costs cic
1687: where msi.costing_enabled_flag = 'Y'
1688: and mp.organization_id = msi.organization_id

Line 1987: v_buy_item_cost mtl_system_items.list_price_per_unit%type ;

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:
1990:
1991: cursor c_buy_items

Line 2272: from mtl_system_items

2268: BEGIN
2269:
2270:
2271: select nvl(list_price_per_unit,0) into v_buy_item_cost
2272: from mtl_system_items
2273: where organization_id = c_po_valid_org and inventory_item_id = c_config_item_id ;
2274:
2275:
2276: EXCEPTION

Line 2311: from mtl_system_items_kfv

2307:
2308: l_token(3).token_name := 'MODEL_NAME';
2309:
2310: select concatenated_segments into v_model_name
2311: from mtl_system_items_kfv
2312: where inventory_item_id = ( select base_item_id
2313: from mtl_system_items where inventory_item_id = c_config_item_id and rownum = 1 )
2314: and rownum = 1 ;
2315:

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

2309:
2310: select concatenated_segments into v_model_name
2311: from mtl_system_items_kfv
2312: where inventory_item_id = ( select base_item_id
2313: from mtl_system_items where inventory_item_id = c_config_item_id and rownum = 1 )
2314: and rownum = 1 ;
2315:
2316: l_token(3).token_value := v_model_name ;
2317:

Line 2414: mtl_system_items msi,

2410: gUserId,
2411: sysdate,
2412: gUserId
2413: from bom_cto_src_orgs bcso,
2414: mtl_system_items msi,
2415: mtl_parameters mp ,
2416: cst_item_costs cic
2417: where bcso.top_model_line_id = pTopAtoLineId
2418: and bcso.cost_rollup = 'Y'