DBA Data[Home] [Help]

APPS.ASO_VALIDATE_PVT dependencies on QP_LIST_HEADERS_B

Line 5667: ,qp_list_headers_b c

5663: (
5664: SELECT d.currency_code currency_code
5665: FROM Fnd_currencies d
5666: ,qp_currency_details b
5667: ,qp_list_headers_b c
5668: WHERE c.list_header_id = p_price_list_id
5669: AND b.currency_header_id = c.currency_header_id
5670: AND d.currency_code = b.to_currency_code
5671: AND c.list_type_code IN ('PRL', 'AGR')

Line 5680: FROM fnd_currencies b,qp_list_headers_b c

5676: and trunc(sysdate) between trunc(nvl(b.start_date_active,sysdate)) and trunc(nvl(b.end_date_active,sysdate))
5677: AND d.currency_code = p_currency_code
5678: UNION
5679: SELECT b.currency_code currency_code
5680: FROM fnd_currencies b,qp_list_headers_b c
5681: WHERE c.currency_code = b.currency_code
5682: AND c.list_header_id = p_price_list_id
5683: AND c.list_type_code IN ('PRL', 'AGR')
5684: AND b.currency_flag = 'Y'