2843: FROM okx_quote_line_detail_v
2844: WHERE QUOTE_LINE_ID = p_qte_line_id;
2845:
2846:
2847: CURSOR c_ql (g_quote_id IN okx_quote_lines_v.quote_header_id%TYPE ) IS
2848: SELECT id1
2849: FROM okx_quote_lines_v
2850: WHERE quote_header_id = g_quote_id;
2851:
2845:
2846:
2847: CURSOR c_ql (g_quote_id IN okx_quote_lines_v.quote_header_id%TYPE ) IS
2848: SELECT id1
2849: FROM okx_quote_lines_v
2850: WHERE quote_header_id = g_quote_id;
2851:
2852: CURSOR c_sl (id1 IN okx_quote_lines_v.ID1%TYPE ) IS
2853: SELECT shipment_id
2848: SELECT id1
2849: FROM okx_quote_lines_v
2850: WHERE quote_header_id = g_quote_id;
2851:
2852: CURSOR c_sl (id1 IN okx_quote_lines_v.ID1%TYPE ) IS
2853: SELECT shipment_id
2854: FROM okx_qte_shipments_v
2855: WHERE quote_line_id = id1;
2856:
2854: FROM okx_qte_shipments_v
2855: WHERE quote_line_id = id1;
2856:
2857:
2858: CURSOR c_qdl(id1 IN okx_quote_lines_v.ID1%TYPE ) IS
2859: SELECT id1
2860: FROM okx_quote_line_detail_v
2861: WHERE quote_line_id = id1;
2862: