APPS.GME_PICKING_PVT dependencies on GME_INGRED_PICK_VW

Line 72: TYPE l_picking_tab IS TABLE OF gme_ingred_pick_vw%ROWTYPE

68: l_msg_data VARCHAR2 (2000);
69: l_conc_request_id NUMBER;
70: l_msg_count NUMBER;
71:
72: TYPE l_picking_tab IS TABLE OF gme_ingred_pick_vw%ROWTYPE
73: INDEX BY BINARY_INTEGER;
74:
75: l_picking_tbl l_picking_tab;
76: l_mat_req_tbl gme_picking_pvt.mtl_req_tab;

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

118: || ' AND concatenated_segments LIKE :ingredient_no)))'
119: || ' AND material_requirement_date <= SYSDATE + NVL(:days_forward, 100000)'
120: || ' AND material_requirement_date >= NVL(:from_req_date, material_requirement_date)'
121: || ' AND material_requirement_date <= NVL(:to_req_date, material_requirement_date)';
122: l_sql_stmt := 'SELECT * FROM gme_ingred_pick_vw WHERE ' || l_where;
123: IF g_debug <= gme_debug.g_log_statement THEN
124: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| l_sql_stmt);
125: END IF;
126: OPEN l_pick_cursor FOR l_sql_stmt