DBA Data[Home] [Help]

APPS.OKC_REP_SEARCH_UTIL_PVT dependencies on ASO_QUOTE_STATUSES_B

Line 700: FROM aso_quote_statuses_b aqsb,

696: IF (p_doc_type_code = 'QUOTE')
697: THEN
698: SELECT aqsvl.meaning
699: INTO l_status
700: FROM aso_quote_statuses_b aqsb,
701: aso_quote_statuses_vl aqsvl
702: WHERE aqsb.status_code = p_status_code
703: AND aqsb.quote_status_id = aqsvl.quote_status_id;
704:

Line 1176: ,aso_quote_statuses_b sb

1172: CURSOR quote_status_csr IS
1173: SELECT sb.status_code AS contract_status_code
1174: FROM
1175: aso_quote_headers_all h
1176: ,aso_quote_statuses_b sb
1177: WHERE h.quote_header_id = p_document_id
1178: AND h.quote_status_id = sb.quote_status_id;
1179:
1180: CURSOR so_status_csr IS