DBA Data[Home] [Help]

APPS.QP_UTIL_PUB dependencies on QP_LIST_HEADER_PHASES

Line 495: FROM qp_list_header_phases lhb, qp_list_headers_b qph, qp_price_req_sources_v qprs, qp_list_lines a

491: FROM qp_event_phases
492: WHERE pricing_phase_id > 1
493: AND ROWNUM < 7)
494: AND EXISTS (SELECT /*+ ORDERED */ 'x' -- [julin/4261562] added active_flag and PTE/SS filters
495: FROM qp_list_header_phases lhb, qp_list_headers_b qph, qp_price_req_sources_v qprs, qp_list_lines a
496: WHERE lhb.pricing_phase_id = b.pricing_phase_id
497: AND qph.list_header_id = lhb.list_header_id
498: AND qph.active_flag = 'Y'
499: AND qprs.request_type_code = p_request_type_code