DBA Data[Home] [Help]

APPS.OKC_OC_INT_KTQ_PVT dependencies on OKX_QUOTE_LINES_V

Line 2847: CURSOR c_ql (g_quote_id IN okx_quote_lines_v.quote_header_id%TYPE ) IS

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:

Line 2849: FROM okx_quote_lines_v

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

Line 2852: CURSOR c_sl (id1 IN okx_quote_lines_v.ID1%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
2854: FROM okx_qte_shipments_v
2855: WHERE quote_line_id = id1;
2856:

Line 2858: CURSOR c_qdl(id1 IN okx_quote_lines_v.ID1%TYPE ) IS

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: