APPS.QP_UTIL_PUB dependencies on QP_PTE_SOURCE_SYSTEMS

Line 1330: FROM qp_pte_source_systems qpss

1326: AND l_agreement_id IS NULL
1327: --AND qdt.to_currency_code = NVL(:order.transactional_curr_code, qdt.to_currency_code)
1328: --AND qdt.to_currency_code = NVL(l_order_transac_curr_code, qdt.to_currency_code)
1329: AND qlhv.source_system_code IN (SELECT qpss.application_short_name
1330: FROM qp_pte_source_systems qpss
1331: WHERE qpss.pte_code = Fnd_Profile.value('QP_PRICING_TRANSACTION_ENTITY'))
1332: UNION
1333: SELECT DISTINCT qlhv.list_header_id price_list_id
1334: ,qlhv.name name

Line 1389: FROM qp_pte_source_systems qpss

1385: --AND qdt.to_currency_code = NVL(:order.transactional_curr_code, qdt.to_currency_code)
1386: --AND qdt.to_currency_code = NVL(l_order_transac_curr_code, qdt.to_currency_code)
1387: AND qdt.to_currency_code = NVL(l_currency_code, qdt.to_currency_code)
1388: AND qlhv.source_system_code IN (SELECT qpss.application_short_name
1389: FROM qp_pte_source_systems qpss
1390: WHERE qpss.pte_code = Fnd_Profile.value('QP_PRICING_TRANSACTION_ENTITY'))
1391: UNION
1392: SELECT DISTINCT qlhv.list_header_id price_list_id
1393: ,qlhv.name name

Line 1450: FROM qp_pte_source_systems qpss

1446: hz_cust_acct_relate r
1447: WHERE r.related_cust_account_id = l_sold_to_org_id AND
1448: r.status = 'A' AND l_cust_relation_flag = 'Y'))
1449: AND qlhv.source_system_code IN (SELECT qpss.application_short_name
1450: FROM qp_pte_source_systems qpss
1451: WHERE qpss.pte_code = Fnd_Profile.value('QP_PRICING_TRANSACTION_ENTITY'))
1452: ORDER BY name;
1453:
1454:

Line 1498: FROM qp_pte_source_systems qpss

1494: AND l_agreement_id IS NULL
1495: --AND currency_code = NVL(l_order_transac_curr_code, currency_code)
1496: AND currency_code = NVL(l_currency_code, currency_code)
1497: AND qlhv.source_system_code IN (SELECT qpss.application_short_name
1498: FROM qp_pte_source_systems qpss
1499: WHERE qpss.pte_code = Fnd_Profile.value('QP_PRICING_TRANSACTION_ENTITY'))
1500: UNION
1501: SELECT
1502: qlhv.list_header_id price_list_id

Line 1549: FROM qp_pte_source_systems qpss

1545: AND l_agreement_id IS NOT NULL
1546: --AND currency_code = NVL(l_order_transac_curr_code, currency_code)
1547: AND currency_code = NVL(l_currency_code, currency_code)
1548: AND qlhv.source_system_code IN (SELECT qpss.application_short_name
1549: FROM qp_pte_source_systems qpss
1550: WHERE qpss.pte_code = Fnd_Profile.value('QP_PRICING_TRANSACTION_ENTITY'))
1551: UNION
1552: SELECT
1553: qlhv.list_header_id price_list_id

Line 1604: FROM qp_pte_source_systems qpss

1600: hz_cust_acct_relate r
1601: WHERE r.related_cust_account_id = l_sold_to_org_id AND
1602: r.status = 'A' AND l_cust_relation_flag = 'Y'))
1603: AND qlhv.source_system_code IN (SELECT qpss.application_short_name
1604: FROM qp_pte_source_systems qpss
1605: WHERE qpss.pte_code = Fnd_Profile.value('QP_PRICING_TRANSACTION_ENTITY'))
1606: ORDER BY name;
1607:
1608: l_price_list_multi c_price_list_multi%ROWTYPE;

Line 1737: FROM qp_pte_source_systems qpss

1733: --commented out below 2 lines for MOAC as the ORG_ID check is built into the view qp_list_headers_vl
1734: -- (((nvl(global_flag,'Y') = 'Y' or orig_org_id = fnd_profile.Value('ORG_ID'))
1735: -- and qp_security.security_on = 'Y') or qp_security.security_on = 'N')
1736: AND source_system_code IN (SELECT qpss.application_short_name
1737: FROM qp_pte_source_systems qpss
1738: WHERE qpss.pte_code = Fnd_Profile.value('QP_PRICING_TRANSACTION_ENTITY'))
1739: ORDER BY name;
1740:
1741: CURSOR c_price_list_ttyp

Line 1759: FROM qp_pte_source_systems qpss

1755: AND TRUNC(l_temp_date) BETWEEN NVL(TRUNC(start_date_active), TRUNC(l_temp_date)) AND
1756: NVL(TRUNC(end_date_active), TRUNC(l_temp_date)) AND
1757: list_type_code = 'PRL'
1758: AND source_system_code IN (SELECT qpss.application_short_name
1759: FROM qp_pte_source_systems qpss
1760: WHERE qpss.pte_code = Fnd_Profile.value('QP_PRICING_TRANSACTION_ENTITY'))
1761: ORDER BY name;
1762:
1763: l_price_list_ttyp c_price_list_ttyp%ROWTYPE;