APPS.OKC_OC_INT_KTQ_PVT dependencies on OKX_QTE_SHIPMENTS_V

Line 2526: okx_qte_shipments_v

2522:
2523: CURSOR c_q_shipment(b_qh_id NUMBER, b_ql_id NUMBER) IS
2524: SELECT 'Y'
2525: FROM
2526: okx_qte_shipments_v
2527: WHERE
2528: quote_header_id = b_qh_id
2529: AND (( b_ql_id IS NULL AND quote_line_id IS NULL) OR
2530: (b_ql_id IS NOT NULL AND quote_line_id = b_ql_id));

Line 2854: FROM okx_qte_shipments_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:
2857:
2858: CURSOR c_qdl(id1 IN okx_quote_lines_v.ID1%TYPE ) IS

Line 2869: okx_qte_shipments_v

2865: --
2866: CURSOR c_q_shipment(b_ql_id NUMBER) IS
2867: SELECT 'Y'
2868: FROM
2869: okx_qte_shipments_v
2870: WHERE quote_line_id = b_ql_id;
2871:
2872: BEGIN
2873: IF (l_debug = 'Y') THEN