eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_UTIL_PUB dependencies on STANDARD

Line 1297: -- If there is a blanket reference show all standard pricelist and

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
1298: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1299: -- Otherwise show only standard PL's.
1300: AND (
1301: ( l_blanket_reference_id IS NULL

Line 1299: -- Otherwise show only standard PL's.

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
1298: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1299: -- Otherwise show only standard PL's.
1300: AND (
1301: ( l_blanket_reference_id IS NULL
1302: AND NVL(qlhv.list_source_code,' ') <> 'BSO'
1303: )

Line 1347: -- If there is a blanket reference show all standard pricelist and

1343: OR
1344: qlhv.list_type_code = 'PRL'
1345: )
1346: AND qlhv.active_flag = 'Y'
1347: -- If there is a blanket reference show all standard pricelist and
1348: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1349: -- Otherwise show only standard PL's.
1350: AND (
1351: ( l_blanket_reference_id IS NULL

Line 1349: -- Otherwise show only standard PL's.

1345: )
1346: AND qlhv.active_flag = 'Y'
1347: -- If there is a blanket reference show all standard pricelist and
1348: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1349: -- Otherwise show only standard PL's.
1350: AND (
1351: ( l_blanket_reference_id IS NULL
1352: AND NVL(qlhv.list_source_code,' ') <> 'BSO'
1353: )

Line 1406: -- If there is a blanket reference show all standard pricelist and

1402: OR
1403: qlhv.list_type_code = 'PRL'
1404: )
1405: AND qlhv.active_flag = 'Y'
1406: -- If there is a blanket reference show all standard pricelist and
1407: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1408: -- Otherwise show only standard PL's.
1409: AND (
1410: ( l_blanket_reference_id IS NULL

Line 1408: -- Otherwise show only standard PL's.

1404: )
1405: AND qlhv.active_flag = 'Y'
1406: -- If there is a blanket reference show all standard pricelist and
1407: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1408: -- Otherwise show only standard PL's.
1409: AND (
1410: ( l_blanket_reference_id IS NULL
1411: AND NVL(qlhv.list_source_code,' ') <> 'BSO'
1412: )

Line 1471: -- If there is a blanket reference show all standard pricelist and

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
1472: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1473: -- Otherwise show only standard PL's.
1474: AND (
1475: ( l_blanket_reference_id IS NULL

Line 1473: -- Otherwise show only standard PL's.

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
1472: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1473: -- Otherwise show only standard PL's.
1474: AND (
1475: ( l_blanket_reference_id IS NULL
1476: AND NVL(qlhv.list_source_code,' ') <> 'BSO'
1477: )

Line 1516: -- If there is a blanket reference show all standard pricelist and

1512: OR
1513: qlhv.list_type_code = 'PRL'
1514: )
1515: --AND NVL(to_date(:parameter.lov_char_param1), TRUNC(sysdate)) BETWEEN
1516: -- If there is a blanket reference show all standard pricelist and
1517: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1518: -- Otherwise show only standard PL's.
1519: AND (
1520: ( l_blanket_reference_id IS NULL

Line 1518: -- Otherwise show only standard PL's.

1514: )
1515: --AND NVL(to_date(:parameter.lov_char_param1), TRUNC(sysdate)) BETWEEN
1516: -- If there is a blanket reference show all standard pricelist and
1517: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1518: -- Otherwise show only standard PL's.
1519: AND (
1520: ( l_blanket_reference_id IS NULL
1521: AND NVL(qlhv.list_source_code,' ') <> 'BSO'
1522: )

Line 1566: -- If there is a blanket reference show all standard pricelist and

1562: qlhv.list_type_code IN ('PRL', 'AGR'))
1563: OR
1564: qlhv.list_type_code = 'PRL'
1565: )
1566: -- If there is a blanket reference show all standard pricelist and
1567: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1568: -- Otherwise show only standard PL's.
1569: AND (
1570: ( l_blanket_reference_id IS NULL

Line 1568: -- Otherwise show only standard PL's.

1564: qlhv.list_type_code = 'PRL'
1565: )
1566: -- If there is a blanket reference show all standard pricelist and
1567: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1568: -- Otherwise show only standard PL's.
1569: AND (
1570: ( l_blanket_reference_id IS NULL
1571: AND NVL(qlhv.list_source_code,' ') <> 'BSO'
1572: )