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 967: -- If there is a blanket reference show all standard pricelist and

963: --commented out below 2 lines for MOAC as the ORG_ID check is built into the view qp_list_headers_vl
964: --AND (((nvl(qlhv.global_flag,'Y') = 'Y' or qlhv.orig_org_id = fnd_profile.Value('ORG_ID')) and
965: -- qp_security.security_on = 'Y') or qp_security.security_on = 'N')
966: AND qlhv.list_type_code = 'PRL'
967: -- If there is a blanket reference show all standard pricelist and
968: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
969: -- Otherwise show only standard PL's.
970: AND (
971: ( l_blanket_reference_id IS NULL

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

965: -- qp_security.security_on = 'Y') or qp_security.security_on = 'N')
966: AND qlhv.list_type_code = 'PRL'
967: -- If there is a blanket reference show all standard pricelist and
968: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
969: -- Otherwise show only standard PL's.
970: AND (
971: ( l_blanket_reference_id IS NULL
972: AND NVL(qlhv.list_source_code,' ') <> 'BSO'
973: )

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

1013: OR
1014: qlhv.list_type_code = 'PRL'
1015: )
1016: AND qlhv.active_flag = 'Y'
1017: -- If there is a blanket reference show all standard pricelist and
1018: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1019: -- Otherwise show only standard PL's.
1020: AND (
1021: ( l_blanket_reference_id IS NULL

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

1015: )
1016: AND qlhv.active_flag = 'Y'
1017: -- If there is a blanket reference show all standard pricelist and
1018: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1019: -- Otherwise show only standard PL's.
1020: AND (
1021: ( l_blanket_reference_id IS NULL
1022: AND NVL(qlhv.list_source_code,' ') <> 'BSO'
1023: )

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

1072: OR
1073: qlhv.list_type_code = 'PRL'
1074: )
1075: AND qlhv.active_flag = 'Y'
1076: -- If there is a blanket reference show all standard pricelist and
1077: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1078: -- Otherwise show only standard PL's.
1079: AND (
1080: ( l_blanket_reference_id IS NULL

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

1074: )
1075: AND qlhv.active_flag = 'Y'
1076: -- If there is a blanket reference show all standard pricelist and
1077: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1078: -- Otherwise show only standard PL's.
1079: AND (
1080: ( l_blanket_reference_id IS NULL
1081: AND NVL(qlhv.list_source_code,' ') <> 'BSO'
1082: )

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

1137: --commented out below 2 lines for MOAC as the ORG_ID check is built into the view qp_list_headers_vl
1138: --AND (((nvl(qlhv.global_flag,'Y') = 'Y' or qlhv.orig_org_id = fnd_profile.Value('ORG_ID')) and
1139: -- qp_security.security_on = 'Y') or qp_security.security_on = 'N')
1140: --AND NVL(to_date(:parameter.lov_char_param1), TRUNC(sysdate))
1141: -- If there is a blanket reference show all standard pricelist and
1142: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1143: -- Otherwise show only standard PL's.
1144: AND (
1145: ( l_blanket_reference_id IS NULL

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

1139: -- qp_security.security_on = 'Y') or qp_security.security_on = 'N')
1140: --AND NVL(to_date(:parameter.lov_char_param1), TRUNC(sysdate))
1141: -- If there is a blanket reference show all standard pricelist and
1142: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1143: -- Otherwise show only standard PL's.
1144: AND (
1145: ( l_blanket_reference_id IS NULL
1146: AND NVL(qlhv.list_source_code,' ') <> 'BSO'
1147: )

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

1182: OR
1183: qlhv.list_type_code = 'PRL'
1184: )
1185: --AND NVL(to_date(:parameter.lov_char_param1), TRUNC(sysdate)) BETWEEN
1186: -- If there is a blanket reference show all standard pricelist and
1187: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1188: -- Otherwise show only standard PL's.
1189: AND (
1190: ( l_blanket_reference_id IS NULL

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

1184: )
1185: --AND NVL(to_date(:parameter.lov_char_param1), TRUNC(sysdate)) BETWEEN
1186: -- If there is a blanket reference show all standard pricelist and
1187: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1188: -- Otherwise show only standard PL's.
1189: AND (
1190: ( l_blanket_reference_id IS NULL
1191: AND NVL(qlhv.list_source_code,' ') <> 'BSO'
1192: )

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

1232: qlhv.list_type_code IN ('PRL', 'AGR'))
1233: OR
1234: qlhv.list_type_code = 'PRL'
1235: )
1236: -- If there is a blanket reference show all standard pricelist and
1237: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1238: -- Otherwise show only standard PL's.
1239: AND (
1240: ( l_blanket_reference_id IS NULL

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

1234: qlhv.list_type_code = 'PRL'
1235: )
1236: -- If there is a blanket reference show all standard pricelist and
1237: -- all shareable BSO PL's and all PL's attached to the referenced blanket.
1238: -- Otherwise show only standard PL's.
1239: AND (
1240: ( l_blanket_reference_id IS NULL
1241: AND NVL(qlhv.list_source_code,' ') <> 'BSO'
1242: )