APPS.PKG_GMP_BUCKET_DATA dependencies on MR_TRAN_TBL

Line 11: TYPE trans_date_type IS TABLE OF mr_tran_tbl.trans_date%TYPE

7: V_whse_list VARCHAR2, /* List with seperat */
8: V_on_hand NUMBER,
9: V_total_ss NUMBER,
10: V_matl_rep_id NUMBER) RETURN NUMBER IS
11: TYPE trans_date_type IS TABLE OF mr_tran_tbl.trans_date%TYPE
12: INDEX BY BINARY_INTEGER;
13: TYPE document_type IS TABLE OF sy_docs_mst.doc_type%TYPE
14: INDEX BY BINARY_INTEGER;
15: TYPE trans_qty_type IS TABLE OF mr_tran_tbl.trans_qty%TYPE

Line 15: TYPE trans_qty_type IS TABLE OF mr_tran_tbl.trans_qty%TYPE

11: TYPE trans_date_type IS TABLE OF mr_tran_tbl.trans_date%TYPE
12: INDEX BY BINARY_INTEGER;
13: TYPE document_type IS TABLE OF sy_docs_mst.doc_type%TYPE
14: INDEX BY BINARY_INTEGER;
15: TYPE trans_qty_type IS TABLE OF mr_tran_tbl.trans_qty%TYPE
16: INDEX BY BINARY_INTEGER;
17: TYPE orgn_code_type IS TABLE OF sy_orgn_mst.orgn_code%TYPE
18: INDEX BY BINARY_INTEGER;
19: TYPE period_start_date_type IS TABLE OF ps_matl_dtl.perd_end_date%TYPE

Line 35: FROM mr_tran_tbl

31: period_name_tab PERIOD_NAME_TYPE;
32:
33: CURSOR Cur_trans_dtl IS
34: SELECT doc_type,trans_date,orgn_code,trans_qty
35: FROM mr_tran_tbl
36: WHERE mrp_id =V_mrp_id
37: AND item_id =V_item_id
38: AND INSTR(V_whse_list, whse_code) <> 0
39: ORDER BY trans_date asc, trans_qty desc;