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.GMI_RESERVATION_PVT dependencies on IC_SUMM_INV

Line 1934: FROM ic_summ_inv s

1930: SELECT SUM(nvl(s.onhand_order_qty,0)),
1931: SUM(nvl(s.onhand_order_qty2,0)),
1932: SUM(nvl(s.committedsales_qty,0)),
1933: SUM(nvl(s.committedsales_qty2,0))
1934: FROM ic_summ_inv s
1935: WHERE s.item_id = p_item_id
1936: AND s.whse_code = l_whse_code;
1937:
1938: -- Get whse information

Line 2481: FROM ic_summ_inv s

2477: SELECT SUM(nvl(s.onhand_order_qty,0)),
2478: SUM(nvl(s.onhand_order_qty2,0)),
2479: SUM(nvl(s.committedsales_qty,0)),
2480: SUM(nvl(s.committedsales_qty2,0))
2481: FROM ic_summ_inv s
2482: WHERE s.item_id = p_item_id
2483: AND s.whse_code = l_whse_code;
2484:
2485: -- Get whse information

Line 2533: FROM ic_summ_inv s

2529: SELECT SUM(nvl(s.onhand_order_qty,0)),
2530: SUM(nvl(s.onhand_order_qty2,0)),
2531: SUM(nvl(s.committedsales_qty,0)),
2532: SUM(nvl(s.committedsales_qty2,0))
2533: FROM ic_summ_inv s
2534: WHERE s.item_id = p_item_id
2535: AND s.whse_code = l_whse_code
2536: AND s.qc_grade = l_qc_grade
2537: ;

Line 3018: FROM ic_summ_inv s

3014: SELECT SUM(nvl(s.onhand_order_qty,0)),
3015: SUM(nvl(s.onhand_order_qty2,0)),
3016: SUM(nvl(s.committedsales_qty,0)),
3017: SUM(nvl(s.committedsales_qty2,0))
3018: FROM ic_summ_inv s
3019: WHERE s.item_id = l_opm_itm_id
3020: AND s.whse_code = l_whse_code;
3021:
3022: --Bug 3551144