DBA Data[Home] [Help]

APPS.QP_UTIL_PUB dependencies on QP_LIST_HEADER_PHASES

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

559: FROM qp_event_phases
560: WHERE pricing_phase_id > 1
561: AND ROWNUM < 7)
562: AND EXISTS (SELECT /*+ ORDERED */ 'x' -- [julin/4261562] added active_flag and PTE/SS filters
563: FROM qp_list_header_phases lhb, qp_list_headers_b qph, qp_price_req_sources_v qprs, qp_list_lines a
564: WHERE lhb.pricing_phase_id = b.pricing_phase_id
565: AND qph.list_header_id = lhb.list_header_id
566: AND qph.active_flag = 'Y'
567: AND qprs.request_type_code = p_request_type_code

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

803: FROM qp_event_phases
804: WHERE pricing_phase_id > 1
805: AND ROWNUM < 7)
806: AND EXISTS (SELECT /*+ ORDERED */ 'x' -- [julin/4261562] added active_flag and PTE/SS filters
807: FROM qp_list_header_phases lhb, qp_list_headers_b qph, qp_price_req_sources_v qprs, qp_list_lines a
808: WHERE lhb.pricing_phase_id = b.pricing_phase_id
809: AND qph.list_header_id = lhb.list_header_id
810: AND qph.active_flag = 'Y'
811: AND qprs.request_type_code = p_request_type_code