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.MSC_GET_BIS_VALUES dependencies on MSC_BIS_INV_DETAIL

Line 62: FROM msc_bis_inv_detail mbis

58: sum(nvl(production_cost,0)),
59: sum(nvl(purchasing_cost,0)),
60: sum(nvl(demand_penalty_cost,0)+nvl(supplier_overcap_cost,0)),
61: sum(nvl(carrying_cost,0))
62: FROM msc_bis_inv_detail mbis
63: WHERE mbis.organization_id = l_org_id
64: AND mbis.sr_instance_id = l_instance_id
65: AND mbis.plan_id = l_plan_id
66: AND nvl(mbis.period_type,0) = 0 --mbis.mfg period changes

Line 82: FROM msc_bis_inv_detail mbis

78: sum(nvl(production_cost,0)),
79: sum(nvl(purchasing_cost,0)),
80: sum(nvl(demand_penalty_cost,0)+nvl(supplier_overcap_cost,0)),
81: sum(nvl(carrying_cost,0))
82: FROM msc_bis_inv_detail mbis
83: where mbis.plan_id = l_plan_id
84: AND nvl(mbis.period_type,0) = 0 --mbis.mfg period changes
85: and exists ( select 1
86: from msc_bom_components mbc

Line 104: FROM msc_bis_inv_detail mbis

100: sum(nvl(production_cost,0)),
101: sum(nvl(purchasing_cost,0)),
102: sum(nvl(demand_penalty_cost,0)+nvl(supplier_overcap_cost,0)),
103: sum(nvl(carrying_cost,0))
104: FROM msc_bis_inv_detail mbis
105: WHERE mbis.organization_id = l_org_id
106: AND mbis.sr_instance_id = l_instance_id
107: AND nvl(mbis.period_type,0) = 0 --mbis.mfg period changes
108: and mbis.detail_date between v_start_date and v_end_date

Line 127: FROM msc_bis_inv_detail mbis

123: sum(nvl(production_cost,0)),
124: sum(nvl(purchasing_cost,0)),
125: sum(nvl(demand_penalty_cost,0)+nvl(supplier_overcap_cost,0)),
126: sum(nvl(carrying_cost,0))
127: FROM msc_bis_inv_detail mbis
128: where mbis.detail_date between v_start_date and v_end_date
129: AND mbis.plan_id = l_plan_id
130: AND nvl(mbis.period_type,0) = 0 --mbis.mfg period changes
131: and exists ( select 1

Line 196: FROM msc_bis_inv_detail mbi

192: v_start_date DATE ,
193: v_end_date DATE) IS
194: SELECT SUM(nvl(mbi.inventory_value,0)),
195: SUM(NVL(mbi.mds_price,0)), SUM(NVL(mbi.mds_cost,0))
196: FROM msc_bis_inv_detail mbi
197: WHERE mbi.plan_id = v_plan_id
198: AND nvl(mbi.period_type,0) = 0 --bis.mfg period changes
199: and mbi.inventory_item_id = nvl(v_item_id,mbi.inventory_item_id)
200: and mbi.detail_date between nvl(v_start_date, mbi.detail_date-1) and

Line 212: FROM msc_bis_inv_detail mbi

208: v_start_date DATE ,
209: v_end_date DATE) IS
210: SELECT SUM(nvl(mbi.inventory_value,0)),
211: SUM(NVL(mbi.mds_price,0)), SUM(NVL(mbi.mds_cost,0))
212: FROM msc_bis_inv_detail mbi
213: WHERE mbi.plan_id = v_plan_id
214: AND mbi.organization_id = v_org_id
215: AND mbi.sr_instance_id = v_instance_id
216: AND nvl(mbi.period_type,0) = 0 --bis.mfg period changes

Line 436: FROM msc_bis_inv_detail

432:
433: SELECT sum(nvl(production_cost,0)),
434: sum(nvl(purchasing_cost,0)),
435: sum(nvl(carrying_cost,0))
436: FROM msc_bis_inv_detail
437: WHERE organization_id = l_org_id
438: AND sr_instance_id = l_instance_id
439: AND plan_id = l_plan_id
440: AND nvl(period_type,0) = 0 --bis.mfg period changes

Line 448: FROM msc_bis_inv_detail

444: l_item_id number) IS
445: SELECT sum(nvl(production_cost,0)),
446: sum(nvl(purchasing_cost,0)),
447: sum(nvl(carrying_cost,0))
448: FROM msc_bis_inv_detail
449: where plan_id = l_plan_id
450: AND nvl(period_type,0) = 0 --bis.mfg period changes
451: and inventory_item_id = l_item_id;
452:

Line 600: FROM msc_bis_inv_detail

596:
597: SELECT sum(nvl(production_cost,0)),
598: sum(nvl(purchasing_cost,0)),
599: sum(nvl(carrying_cost,0))
600: FROM msc_bis_inv_detail
601: WHERE organization_id = l_org_id
602: AND sr_instance_id = l_instance_id
603: AND plan_id = l_plan_id
604: AND nvl(period_type,0) = 0 --bis.mfg period changes

Line 613: FROM msc_bis_inv_detail

609: l_item_id number) IS
610: SELECT sum(nvl(production_cost,0)),
611: sum(nvl(purchasing_cost,0)),
612: sum(nvl(carrying_cost,0))
613: FROM msc_bis_inv_detail
614: where plan_id = l_plan_id
615: and inventory_item_id = l_item_id
616: AND nvl(period_type,0) = 0 --bis.mfg period changes
617: and detail_date between l_start_date and l_end_date;

Line 753: FROM msc_bis_inv_detail profit

749: SELECT msc_get_name.org_code(profit.organization_id,
750: profit.sr_instance_id),
751: SUM(NVL(profit.mds_price,0)),
752: SUM(NVL(profit.mds_cost,0))
753: FROM msc_bis_inv_detail profit
754: WHERE profit.plan_id = p_plan_id
755: AND nvl(profit.period_type,0) = 0 --bis.mfg period changes
756: GROUP BY 1;
757:

Line 1003: ' FROM msc_bis_inv_detail mbis' ||

999: else
1000:
1001: sql_statement := ' SELECT '||
1002: ' SUM(nvl(mbis.mds_cost,0)) '||
1003: ' FROM msc_bis_inv_detail mbis' ||
1004: ' WHERE mbis.plan_id = :1 and nvl(mbis.period_type,0) = 0';
1005: sql_statement := sql_statement ||
1006: construct_bis_where(false,p_organization_id, p_instance_id,
1007: p_inventory_item_id, p_project_id, p_task_id,

Line 1066: ' FROM msc_bis_inv_detail mbis ' ||

1062:
1063: else
1064: sql_statement := ' SELECT '||
1065: ' SUM(nvl(mbis.inventory_cost,0)) '||
1066: ' FROM msc_bis_inv_detail mbis ' ||
1067: ' WHERE mbis.plan_id = :1 and nvl(mbis.period_type,0) = 0 '||
1068: ' AND mbis.detail_date = :7 ';
1069:
1070: sql_statement := sql_statement ||

Line 1396: ' FROM msc_bis_inv_detail mbis' ||

1392: IF i = 1 THEN
1393:
1394: sql_statement := ' SELECT '||
1395: ' SUM(nvl(mds_cost,0)) '||
1396: ' FROM msc_bis_inv_detail mbis' ||
1397: ' WHERE mbis.plan_id = :1 '||
1398: ' AND mbis.detail_date between :7 AND :8 and nvl(mbis.period_type,0) = 0 ';
1399:
1400: sql_statement := sql_statement ||

Line 1555: ' FROM msc_bis_inv_detail mbis' ||

1551:
1552:
1553: inv_statement := ' SELECT '||
1554: ' SUM(nvl(mbis.inventory_cost,0)) '||
1555: ' FROM msc_bis_inv_detail mbis' ||
1556: ' WHERE mbis.plan_id = :1 '||
1557: ' AND mbis.detail_date =:7 and nvl(mbis.period_type,0) = 0 ';
1558:
1559: inv_statement := inv_statement ||

Line 2940: from msc_bis_inv_detail mbid,

2936: mbid.sr_instance_id,
2937: mbid.detail_date,
2938: sum(nvl(mbid.inventory_value,0)),
2939: msi.planner_code
2940: from msc_bis_inv_detail mbid,
2941: msc_system_items msi
2942: where mbid.plan_id = p_plan_id
2943: and nvl(mbid.period_type,0) = 0
2944: and mbid.organization_id = msi.organization_id

Line 2990: from msc_bis_inv_detail

2986: plan_id,
2987: organization_id,
2988: sr_instance_id,
2989: detail_date
2990: from msc_bis_inv_detail
2991: where plan_id = p_plan_id
2992: and nvl(period_type,0) = 0
2993: group by plan_id,
2994: organization_id,

Line 3044: from msc_bis_inv_detail mbis,

3040: mit.sr_category_id,
3041: mit.category_name,
3042: mit.category_set_id,
3043: mbis.detail_date
3044: from msc_bis_inv_detail mbis,
3045: msc_item_categories mit
3046: where mbis.plan_id = p_plan_id
3047: and mit.organization_id = mbis.organization_id
3048: and mit.sr_instance_id = mbis.sr_instance_id