[Home] [Help]
1283: ,qlhv.name name
1284: ,qlhv.description description
1285: ,qlhv.start_date_active start_date_active
1286: ,qlhv.end_date_active end_date_active
1287: FROM qp_list_headers_vl qlhv
1288: ,qp_currency_details qdt
1289: WHERE qlhv.currency_header_id = qdt.currency_header_id
1290: AND qdt.to_currency_code = l_currency_code
1291: AND qlhv.active_flag = 'Y'
1289: WHERE qlhv.currency_header_id = qdt.currency_header_id
1290: AND qdt.to_currency_code = l_currency_code
1291: AND qlhv.active_flag = 'Y'
1292: --added for MOAC
1293: --commented out below 2 lines for MOAC as the ORG_ID check is built into the view qp_list_headers_vl
1294: --AND (((nvl(qlhv.global_flag,'Y') = 'Y' or qlhv.orig_org_id = fnd_profile.Value('ORG_ID')) and
1295: -- qp_security.security_on = 'Y') or qp_security.security_on = 'N')
1296: AND qlhv.list_type_code = 'PRL'
1297: -- If there is a blanket reference show all standard pricelist and
1334: ,qlhv.name name
1335: ,qlhv.description description
1336: ,qlhv.start_date_active start_date_active
1337: ,qlhv.end_date_active end_date_active
1338: FROM qp_list_headers_vl qlhv
1339: ,oe_agreements oa
1340: ,qp_currency_details qdt
1341: WHERE ( ( oa.price_list_id = qlhv.list_header_id
1342: AND qlhv.list_type_code IN ('PRL', 'AGR') )
1362: )
1363: )
1364: ) -- Blanket Pricing
1365: --added for MOAC
1366: --commented out below 2 lines for MOAC as the ORG_ID check is built into the view qp_list_headers_vl
1367: --AND (((nvl(qlhv.global_flag,'Y') = 'Y' or qlhv.orig_org_id = fnd_profile.Value('ORG_ID')) and
1368: -- qp_security.security_on = 'Y') or qp_security.security_on = 'N')
1369: AND qlhv.currency_header_id = qdt.currency_header_id
1370: AND qdt.to_currency_code = l_currency_code
1393: ,qlhv.name name
1394: ,qlhv.description description
1395: ,qlhv.start_date_active start_date_active
1396: ,qlhv.end_date_active end_date_active
1397: FROM qp_list_headers_vl qlhv
1398: ,oe_agreements oa
1399: ,qp_currency_details qdt
1400: WHERE ( ( oa.price_list_id = qlhv.list_header_id
1401: AND qlhv.list_type_code IN ('PRL', 'AGR') )
1421: )
1422: )
1423: ) -- Blanket Pricing
1424: --added for MOAC
1425: --commented out below 2 lines for MOAC as the ORG_ID check is built into the view qp_list_headers_vl
1426: --AND (((nvl(qlhv.global_flag,'Y') = 'Y' or qlhv.orig_org_id = fnd_profile.Value('ORG_ID')) and
1427: -- qp_security.security_on = 'Y') or qp_security.security_on = 'N')
1428: AND qlhv.currency_header_id = qdt.currency_header_id
1429: AND qdt.to_currency_code = l_currency_code
1459: ,qlhv.name name
1460: ,qlhv.description description
1461: ,qlhv.start_date_active start_date_active
1462: ,qlhv.end_date_active end_date_active
1463: FROM qp_list_headers_vl qlhv
1464: WHERE list_type_code = 'PRL'
1465: AND qlhv.active_flag = 'Y'
1466: --added for MOAC
1467: --commented out below 2 lines for MOAC as the ORG_ID check is built into the view qp_list_headers_vl
1463: FROM qp_list_headers_vl qlhv
1464: WHERE list_type_code = 'PRL'
1465: AND qlhv.active_flag = 'Y'
1466: --added for MOAC
1467: --commented out below 2 lines for MOAC as the ORG_ID check is built into the view qp_list_headers_vl
1468: --AND (((nvl(qlhv.global_flag,'Y') = 'Y' or qlhv.orig_org_id = fnd_profile.Value('ORG_ID')) and
1469: -- qp_security.security_on = 'Y') or qp_security.security_on = 'N')
1470: --AND NVL(to_date(:parameter.lov_char_param1), TRUNC(sysdate))
1471: -- If there is a blanket reference show all standard pricelist and
1504: ,qlhv.description description
1505: ,qlhv.start_date_active start_date_active
1506: ,qlhv.end_date_active end_date_active
1507: FROM
1508: qp_list_headers_vl qlhv
1509: ,oe_agreements oa
1510: WHERE ( (oa.price_list_id = qlhv.list_header_id AND
1511: qlhv.list_type_code IN ('PRL', 'AGR'))
1512: OR
1531: )
1532: )
1533: ) -- Blanket Pricing
1534: --added for MOAC
1535: --commented out below 2 lines for MOAC as the ORG_ID check is built into the view qp_list_headers_vl
1536: --AND (((nvl(qlhv.global_flag,'Y') = 'Y' or qlhv.orig_org_id = fnd_profile.Value('ORG_ID')) and
1537: -- qp_security.security_on = 'Y') or qp_security.security_on = 'N')
1538: AND l_temp_date
1539: BETWEEN
1555: ,qlhv.description description
1556: ,qlhv.start_date_active start_date_active
1557: ,qlhv.end_date_active end_date_active
1558: FROM
1559: qp_list_headers_vl qlhv
1560: ,oe_agreements oa
1561: WHERE ( (oa.price_list_id = qlhv.list_header_id AND
1562: qlhv.list_type_code IN ('PRL', 'AGR'))
1563: OR
1581: )
1582: )
1583: ) -- Blanket Pricing
1584: --added for MOAC
1585: --commented out below 2 lines for MOAC as the ORG_ID check is built into the view qp_list_headers_vl
1586: --AND (((nvl(qlhv.global_flag,'Y') = 'Y' or qlhv.orig_org_id = fnd_profile.Value('ORG_ID')) and
1587: -- qp_security.security_on = 'Y') or qp_security.security_on = 'N')
1588: AND l_temp_date
1589: BETWEEN
1725: description description,
1726: -rounding_factor rounding_factor,
1727: start_date_active start_date_active,
1728: end_date_active end_date_active
1729: FROM qp_list_headers_vl
1730: WHERE list_type_code IN ('PRL' ,'AGR') AND
1731: NVL(active_flag,'N') ='Y'
1732: --added for MOAC
1733: --commented out below 2 lines for MOAC as the ORG_ID check is built into the view qp_list_headers_vl
1729: FROM qp_list_headers_vl
1730: WHERE list_type_code IN ('PRL' ,'AGR') AND
1731: NVL(active_flag,'N') ='Y'
1732: --added for MOAC
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
1745: description description,
1746: -rounding_factor rounding_factor,
1747: start_date_active start_date_active,
1748: end_date_active end_date_active
1749: FROM qp_list_headers_vl
1750: WHERE currency_code = p_currency_code
1751: --added for MOAC
1752: --commented out below 2 lines for MOAC as the ORG_ID check is built into the view qp_list_headers_vl
1753: -- (((nvl(global_flag,'Y') = 'Y' or orig_org_id = fnd_profile.Value('ORG_ID'))
1748: end_date_active end_date_active
1749: FROM qp_list_headers_vl
1750: WHERE currency_code = p_currency_code
1751: --added for MOAC
1752: --commented out below 2 lines for MOAC as the ORG_ID check is built into the view qp_list_headers_vl
1753: -- (((nvl(global_flag,'Y') = 'Y' or orig_org_id = fnd_profile.Value('ORG_ID'))
1754: -- and qp_security.security_on = 'Y') or qp_security.security_on = 'N') and
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
1860: IS
1861: SELECT SUBSTRB(a.agreement_name,1,300) agreement_name, a.agreement_id agreement_id,
1862: a.agreement_type, q.name price_list_name, p.party_name customer_name,
1863: t.name payment_term_name, a.start_date_active, a.end_date_active
1864: FROM oe_agreements_lov_v a, qp_list_headers_vl q,
1865: hz_parties p, hz_cust_accounts c, ra_terms_tl t,
1866: -- qp_list_headers_b l,
1867: oe_transaction_types_all ot
1868: WHERE a.sold_to_org_id IN (
1878: TRUNC(NVL(a.start_date_active, ADD_MONTHS(SYSDATE, -10000))) AND
1879: TRUNC(NVL(a.end_date_active, ADD_MONTHS(SYSDATE, +10000))) AND
1880: a.price_list_id = q.list_header_id
1881: --added for MOAC
1882: --commented out below 2 lines for MOAC as the ORG_ID check is built into the view qp_list_headers_vl
1883: -- (((nvl(q.global_flag,'Y') = 'Y' or q.orig_org_id = fnd_profile.Value('ORG_ID')) and
1884: -- qp_security.security_on = 'Y') or qp_security.security_on = 'N') and
1885: AND a.price_list_id = q.list_header_id AND
1886: -- q.language = userenv('LANG') and
1899: IS
1900: select substr(a.agreement_name,1,300) agreement_name, a.agreement_id agreement_id,
1901: a.agreement_type, q.name price_list_name, null customer_name,
1902: t.name payment_term_name, a.start_date_active, a.end_date_active
1903: from oe_agreements_lov_v a, qp_list_headers_vl q, ra_terms_tl t,
1904: oe_transaction_types_all ot
1905: where l_temp_date between
1906: trunc(nvl(a.start_date_active, add_months(sysdate, -10000))) and
1907: trunc(nvl(a.end_date_active, add_months(sysdate, +10000))) and
1921: IS
1922: select substr(a.agreement_name,1,300) agreement_name, a.agreement_id agreement_id,
1923: a.agreement_type, q.name price_list_name, p.party_name customer_name,
1924: null payment_term_name, a.start_date_active, a.end_date_active
1925: from oe_agreements_lov_v a, qp_list_headers_vl q,
1926: hz_parties p, hz_cust_accounts c --, qp_list_headers_b l
1927: where a.sold_to_org_id in (
1928: select to_number(p_sold_to_org_id) from dual
1929: union
1953: IS
1954: SELECT SUBSTRB(a.agreement_name,1,300) agreement_name, a.agreement_id agreement_id,
1955: a.agreement_type, q.name price_list_name, NULL customer_name,
1956: NULL payment_term_name, a.start_date_active, a.end_date_active
1957: FROM oe_agreements_lov_v a, qp_list_headers_vl q
1958: --, qp_list_headers_b l
1959: WHERE l_temp_date BETWEEN
1960: TRUNC(NVL(a.start_date_active, ADD_MONTHS(SYSDATE, -10000))) AND
1961: TRUNC(NVL(a.end_date_active, ADD_MONTHS(SYSDATE, +10000))) AND
1960: TRUNC(NVL(a.start_date_active, ADD_MONTHS(SYSDATE, -10000))) AND
1961: TRUNC(NVL(a.end_date_active, ADD_MONTHS(SYSDATE, +10000))) AND
1962: a.price_list_id = q.list_header_id
1963: --added for MOAC
1964: --commented out below 2 lines for MOAC as the ORG_ID check is built into the view qp_list_headers_vl
1965: -- (((nvl(q.global_flag,'Y') = 'Y' or q.orig_org_id = fnd_profile.Value('ORG_ID')) and
1966: -- qp_security.security_on = 'Y') or qp_security.security_on = 'N') and
1967: AND a.price_list_id = q.list_header_id
1968: -- q.language = userenv('LANG')