APPS.GMPMRRP dependencies on MR_TRAN_TBL

Line 279: ||' FROM mr_tran_tbl WHERE mrp_id= to_char(:6) )' ;

275: X_where := X_where||' AND i.item_no <= :5 ' ;
276: END IF;
277: IF (G_mrp_id IS NOT NULL) THEN
278: X_where:= X_where||' AND i.item_id in (select distinct item_id '
279: ||' FROM mr_tran_tbl WHERE mrp_id= to_char(:6) )' ;
280: END IF;
281:
282: cur_planning := dbms_sql.open_cursor;
283: dbms_sql.parse (cur_planning, X_where,dbms_sql.NATIVE);

Line 506: FROM mr_tran_tbl trn, ps_whse_eff whs

502:
503: IF nvl(G_whse_security,'N') = 'N' THEN
504: OPEN Cur_matl_act for
505: SELECT distinct trn.whse_code, whs.whse_item_id
506: FROM mr_tran_tbl trn, ps_whse_eff whs
507: WHERE mrp_id = G_mrp_id
508: AND item_id = V_item_id
509: AND trn.whse_code >= X_fwhse_code
510: AND trn.whse_code <= X_twhse_code

Line 519: FROM mr_tran_tbl trn, ps_whse_eff whs, sy_orgn_usr org

515: ORDER BY 1;
516: ELSE
517: OPEN Cur_matl_act for
518: SELECT distinct trn.whse_code, whs.whse_item_id --Bug 3168907 Added ps.whse_item_id
519: FROM mr_tran_tbl trn, ps_whse_eff whs, sy_orgn_usr org
520: WHERE mrp_id =G_mrp_id
521: AND item_id = V_item_id
522: AND trn.whse_code >= X_fwhse_code
523: AND trn.whse_code <= X_twhse_code

Line 592: ' FROM mr_tran_tbl mr'||

588: cur_balance NUMBER;
589: X_row_count NUMBER(5);
590: BEGIN
591: X_select1 :='SELECT sum(trans_qty) total'||
592: ' FROM mr_tran_tbl mr'||
593: ' WHERE mrp_id= to_char(:1) AND item_id = to_char(:2) ' ||
594: ' AND whse_code in ( ' || G_whse_list || ' ) ' ||
595: ' and doc_type='||''''||'BAL'||''''||
596: ' group by mr.doc_type';