[Home] [Help]
6367: l_ps_group_by VARCHAR2(2000) := ' GROUP BY ';
6368:
6369: l_mmtt_sql_where VARCHAR2(2000) := '';
6370: l_mmtt_sql_base VARCHAR2(2000) := 'SELECT mmtt.transaction_temp_id'
6371: || ' , inv_salesorder.get_salesorder_for_oeheader(wdd.oe_header_id)'
6372: || ' , wdd.oe_line_id'
6373: || ' FROM mtl_material_transactions_temp mmtt'
6374: || ' , mtl_txn_request_lines mtrl'
6375: || ' , wsh_inv_delivery_details_v wdd '
6669: WHERE pick_grouping_rule_id = p_pgr_id;
6670:
6671: CURSOR c_mold IS
6672: SELECT mmtt.transaction_temp_id
6673: , inv_salesorder.get_salesorder_for_oeheader(wdd.oe_header_id)
6674: , wdd.oe_line_id
6675: FROM mtl_material_transactions_temp mmtt
6676: , mtl_txn_request_lines mol
6677: , wsh_inv_delivery_details_v wdd