DBA Data[Home] [Help]

APPS.OKC_REP_SEARCH_UTIL_PVT dependencies on ASO_QUOTE_STATUSES_B

Line 706: FROM aso_quote_statuses_b aqsb,

702: IF (p_doc_type_code = 'QUOTE')
703: THEN
704: SELECT aqsvl.meaning
705: INTO l_status
706: FROM aso_quote_statuses_b aqsb,
707: aso_quote_statuses_vl aqsvl
708: WHERE aqsb.status_code = p_status_code
709: AND aqsb.quote_status_id = aqsvl.quote_status_id;
710:

Line 1182: ,aso_quote_statuses_b sb

1178: CURSOR quote_status_csr IS
1179: SELECT sb.status_code AS contract_status_code
1180: FROM
1181: aso_quote_headers_all h
1182: ,aso_quote_statuses_b sb
1183: WHERE h.quote_header_id = p_document_id
1184: AND h.quote_status_id = sb.quote_status_id;
1185:
1186: CURSOR so_status_csr IS