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.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on OZF_DENORM_QUERIES

Line 75: FROM ozf_denorm_queries

71: sql_validation_7,
72: sql_validation_8,
73: condition_name_column,
74: condition_id_column
75: FROM ozf_denorm_queries
76: WHERE context = p_context
77: AND attribute = p_attribute
78: AND query_for = p_type
79: AND active_flag = 'Y'

Line 82: FROM ozf_denorm_queries

78: AND query_for = p_type
79: AND active_flag = 'Y'
80: AND LAST_UPDATE_DATE = (
81: SELECT MAX(LAST_UPDATE_DATE)
82: FROM ozf_denorm_queries
83: WHERE context = p_context
84: AND attribute = p_attribute
85: AND query_for = p_type
86: AND active_flag = 'Y');

Line 255: FROM ozf_denorm_queries

251: )
252: IS
253: CURSOR c_prod_stmt IS
254: SELECT sql_validation_1 || sql_validation_2 || sql_validation_3 || sql_validation_4 || sql_validation_5 || sql_validation_6 || sql_validation_7 || sql_validation_8, condition_id_column
255: FROM ozf_denorm_queries
256: WHERE context = p_context
257: AND attribute = p_attribute
258: AND query_for = 'PROD'
259: AND active_flag = 'Y'

Line 262: FROM ozf_denorm_queries

258: AND query_for = 'PROD'
259: AND active_flag = 'Y'
260: AND LAST_UPDATE_DATE = (
261: SELECT MAX(LAST_UPDATE_DATE)
262: FROM ozf_denorm_queries
263: WHERE context = p_context
264: AND attribute = p_attribute
265: AND query_for = 'PROD'
266: AND active_flag = 'Y');

Line 378: FROM ozf_denorm_queries

374: sql_validation_7,
375: sql_validation_8,
376: condition_name_column,
377: condition_id_column
378: FROM ozf_denorm_queries
379: WHERE context = p_context
380: AND attribute = p_attribute
381: AND query_for = p_type
382: AND active_flag = 'Y'

Line 385: FROM ozf_denorm_queries

381: AND query_for = p_type
382: AND active_flag = 'Y'
383: AND LAST_UPDATE_DATE = (
384: SELECT MAX(LAST_UPDATE_DATE)
385: FROM ozf_denorm_queries
386: WHERE context = p_context
387: AND attribute = p_attribute
388: AND query_for = p_type
389: AND active_flag = 'Y');

Line 1317: ozf_denorm_queries b

1313: -- fix for bug no. 6058819
1314: CURSOR c_no_groups IS
1315: SELECT COUNT(*)
1316: FROM qp_qualifiers a,
1317: ozf_denorm_queries b
1318: WHERE a.list_header_id = p_list_header_id
1319: --AND a.active_flag = 'Y'
1320: AND a.qualifier_grouping_no = NVL(p_qnum, a.qualifier_grouping_no)
1321: AND a.qualifier_context = b.context

Line 1330: ozf_denorm_queries b

1326: CURSOR c_groups IS
1327: SELECT a.qualifier_id,
1328: a.qualifier_grouping_no
1329: FROM qp_qualifiers a,
1330: ozf_denorm_queries b
1331: WHERE a.list_header_id = p_list_header_id
1332: --AND a.active_flag = 'Y'
1333: AND a.qualifier_grouping_no = NVL(p_qnum, a.qualifier_grouping_no)
1334: AND a.qualifier_context = b.context

Line 1345: ozf_denorm_queries b

1341: a.qualifier_attr_value,
1342: a.comparison_operator_code,
1343: a.qualifier_id
1344: FROM qp_qualifiers a,
1345: ozf_denorm_queries b
1346: WHERE a.list_header_id = p_list_header_id
1347: AND a.qualifier_grouping_no = l_grouping_no
1348: AND a.qualifier_context = b.context
1349: AND a.qualifier_attribute = b.attribute

Line 1360: ozf_denorm_queries b

1356: a.qualifier_attr_value,
1357: a.comparison_operator_code,
1358: a.qualifier_id
1359: FROM qp_qualifiers a,
1360: ozf_denorm_queries b
1361: WHERE a.list_header_id = p_list_header_id
1362: AND a.qualifier_grouping_no = l_grouping_no
1363: AND a.qualifier_context = b.context
1364: AND a.qualifier_attribute = b.attribute

Line 1371: FROM qp_qualifiers a, ozf_denorm_queries b

1367: AND b.query_for = 'ELIG';
1368:
1369: CURSOR c_no_lines(l_grouping_no NUMBER) IS
1370: SELECT COUNT(*)
1371: FROM qp_qualifiers a, ozf_denorm_queries b
1372: WHERE a.list_header_id = p_list_header_id
1373: AND a.qualifier_context <> 'SOLD_BY'
1374: AND a.qualifier_grouping_no = l_grouping_no
1375: AND a.qualifier_context = b.context

Line 1381: FROM qp_qualifiers a, ozf_denorm_queries b

1377: AND b.query_for = 'ELIG';
1378:
1379: CURSOR c_no_soldby_lines(l_grouping_no NUMBER) IS
1380: SELECT COUNT(*)
1381: FROM qp_qualifiers a, ozf_denorm_queries b
1382: WHERE a.list_header_id = p_list_header_id
1383: AND a.qualifier_context = 'SOLD_BY'
1384: AND a.qualifier_grouping_no = l_grouping_no
1385: AND a.qualifier_context = b.context

Line 1577: FROM qp_qualifiers a, ozf_denorm_queries b

1573:
1574: /* Changing to join with denorm_queries as only those would be denormed */
1575: CURSOR c_groups IS
1576: SELECT DISTINCT a.qualifier_grouping_no
1577: FROM qp_qualifiers a, ozf_denorm_queries b
1578: WHERE a.list_header_id = p_list_header_id
1579: AND a.qualifier_grouping_no = NVL(p_qnum, a.qualifier_grouping_no)
1580: AND a.list_line_id = -1
1581: AND a.qualifier_context = b.context

Line 1592: FROM qp_qualifiers a,ozf_denorm_queries b

1588: a.qualifier_attr_value,
1589: a.qualifier_attr_value_to,
1590: a.comparison_operator_code,
1591: a.qualifier_id
1592: FROM qp_qualifiers a,ozf_denorm_queries b
1593: WHERE a.list_header_id = p_list_header_id
1594: AND a.qualifier_grouping_no = l_grouping_no
1595: AND a.list_line_id = -1 -- dont pick up line level qualifier
1596: AND a.qualifier_context = b.context

Line 1615: FROM ozf_denorm_queries

1611: WHERE list_header_id = p_list_header_id
1612: AND list_line_id = -1
1613: AND (qualifier_context,qualifier_attribute) IN
1614: (SELECT DISTINCT context,attribute
1615: FROM ozf_denorm_queries
1616: WHERE query_for = 'ELIG'
1617: AND active_flag = 'Y'));
1618:
1619:

Line 1622: FROM qp_qualifiers a, ozf_denorm_queries b

1618:
1619:
1620: CURSOR c_no_groups IS
1621: SELECT COUNT(DISTINCT a.qualifier_grouping_no)
1622: FROM qp_qualifiers a, ozf_denorm_queries b
1623: WHERE a.list_header_id = p_list_header_id
1624: AND a.qualifier_grouping_no = NVL(p_qnum,a.qualifier_grouping_no)
1625: AND a.list_line_id = -1
1626: AND a.qualifier_context = b.context

Line 1634: FROM qp_qualifiers a, ozf_denorm_queries b

1630:
1631: /* Removed the date restriction */
1632: CURSOR c_no_lines(l_grouping_no NUMBER) IS
1633: SELECT COUNT(*)
1634: FROM qp_qualifiers a, ozf_denorm_queries b
1635: WHERE list_header_id = p_list_header_id
1636: AND qualifier_grouping_no = l_grouping_no
1637: AND list_line_id = -1
1638: AND a.qualifier_context = b.context

Line 2581: FROM qp_qualifiers a, ozf_denorm_queries b

2577: CURSOR c_groups(ll_list_header_id NUMBER) IS
2578: select qnum from
2579: (
2580: SELECT DISTINCT a.qualifier_grouping_no qnum
2581: FROM qp_qualifiers a, ozf_denorm_queries b
2582: WHERE a.list_header_id = ll_list_header_id
2583: AND a.list_line_id = -1
2584: AND a.qualifier_context = b.context
2585: AND a.qualifier_attribute = b.attribute

Line 2606: FROM qp_qualifiers a, ozf_denorm_queries b

2602:
2603:
2604: CURSOR c_no_groups(ll_list_header_id NUMBER) IS
2605: SELECT COUNT(DISTINCT a.qualifier_grouping_no)
2606: FROM qp_qualifiers a, ozf_denorm_queries b
2607: WHERE a.list_header_id = ll_list_header_id
2608: AND a.list_line_id = -1
2609: AND a.qualifier_context = b.context
2610: AND a.qualifier_attribute = b.attribute

Line 2629: FROM ozf_denorm_queries

2625: WHERE list_header_id = ll_list_header_id
2626: AND list_line_id = -1
2627: AND (qualifier_context,qualifier_attribute) IN
2628: (SELECT DISTINCT context,attribute
2629: FROM ozf_denorm_queries
2630: WHERE query_for = 'ELIG'
2631: AND active_flag = 'Y'));
2632:
2633: