APPS.GME_PICKING_PVT dependencies on GME_INGRED_PICK_VW

Line 53: TYPE l_picking_tab IS TABLE OF gme_ingred_pick_vw%ROWTYPE

49: l_msg_data VARCHAR2 (2000);
50: l_conc_request_id NUMBER;
51: l_msg_count NUMBER;
52:
53: TYPE l_picking_tab IS TABLE OF gme_ingred_pick_vw%ROWTYPE
54: INDEX BY BINARY_INTEGER;
55:
56: l_picking_tbl l_picking_tab;
57: l_mat_req_tbl gme_picking_pvt.mtl_req_tab;

Line 103: l_sql_stmt := 'SELECT * FROM gme_ingred_pick_vw WHERE ' || l_where;

99: || ' AND concatenated_segments LIKE :ingredient_no)))'
100: || ' AND material_requirement_date <= SYSDATE + NVL(:days_forward, 100000)'
101: || ' AND material_requirement_date >= NVL(:from_req_date, material_requirement_date)'
102: || ' AND material_requirement_date <= NVL(:to_req_date, material_requirement_date)';
103: l_sql_stmt := 'SELECT * FROM gme_ingred_pick_vw WHERE ' || l_where;
104: IF g_debug <= gme_debug.g_log_statement THEN
105: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| l_sql_stmt);
106: END IF;
107: OPEN l_pick_cursor FOR l_sql_stmt