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.

[Home] [Help]

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 1337: ozf_denorm_queries b

1333: -- fix for bug no. 6058819
1334: CURSOR c_no_groups IS
1335: SELECT COUNT(*)
1336: FROM qp_qualifiers a,
1337: ozf_denorm_queries b
1338: WHERE a.list_header_id = p_list_header_id
1339: --AND a.active_flag = 'Y'
1340: AND a.qualifier_grouping_no = NVL(p_qnum, a.qualifier_grouping_no)
1341: AND a.qualifier_context = b.context

Line 1350: ozf_denorm_queries b

1346: CURSOR c_groups IS
1347: SELECT a.qualifier_id,
1348: a.qualifier_grouping_no
1349: FROM qp_qualifiers a,
1350: ozf_denorm_queries b
1351: WHERE a.list_header_id = p_list_header_id
1352: --AND a.active_flag = 'Y'
1353: AND a.qualifier_grouping_no = NVL(p_qnum, a.qualifier_grouping_no)
1354: AND a.qualifier_context = b.context

Line 1365: ozf_denorm_queries b

1361: a.qualifier_attr_value,
1362: a.comparison_operator_code,
1363: a.qualifier_id
1364: FROM qp_qualifiers a,
1365: ozf_denorm_queries b
1366: WHERE a.list_header_id = p_list_header_id
1367: AND a.qualifier_grouping_no = l_grouping_no
1368: AND a.qualifier_context = b.context
1369: AND a.qualifier_attribute = b.attribute

Line 1380: ozf_denorm_queries b

1376: a.qualifier_attr_value,
1377: a.comparison_operator_code,
1378: a.qualifier_id
1379: FROM qp_qualifiers a,
1380: ozf_denorm_queries b
1381: WHERE a.list_header_id = p_list_header_id
1382: AND a.qualifier_grouping_no = l_grouping_no
1383: AND a.qualifier_context = b.context
1384: AND a.qualifier_attribute = b.attribute

Line 1391: FROM qp_qualifiers a, ozf_denorm_queries b

1387: AND b.query_for = 'ELIG';
1388:
1389: CURSOR c_no_lines(l_grouping_no NUMBER) IS
1390: SELECT COUNT(*)
1391: FROM qp_qualifiers a, ozf_denorm_queries b
1392: WHERE a.list_header_id = p_list_header_id
1393: AND a.qualifier_context <> 'SOLD_BY'
1394: AND a.qualifier_grouping_no = l_grouping_no
1395: AND a.qualifier_context = b.context

Line 1401: FROM qp_qualifiers a, ozf_denorm_queries b

1397: AND b.query_for = 'ELIG';
1398:
1399: CURSOR c_no_soldby_lines(l_grouping_no NUMBER) IS
1400: SELECT COUNT(*)
1401: FROM qp_qualifiers a, ozf_denorm_queries b
1402: WHERE a.list_header_id = p_list_header_id
1403: AND a.qualifier_context = 'SOLD_BY'
1404: AND a.qualifier_grouping_no = l_grouping_no
1405: AND a.qualifier_context = b.context

Line 1596: FROM qp_qualifiers a, ozf_denorm_queries b

1592:
1593: /* Changing to join with denorm_queries as only those would be denormed */
1594: CURSOR c_groups IS
1595: SELECT DISTINCT a.qualifier_grouping_no
1596: FROM qp_qualifiers a, ozf_denorm_queries b
1597: WHERE a.list_header_id = p_list_header_id
1598: AND a.qualifier_grouping_no = NVL(p_qnum, a.qualifier_grouping_no)
1599: AND a.list_line_id = -1
1600: AND a.qualifier_context = b.context

Line 1611: FROM qp_qualifiers a,ozf_denorm_queries b

1607: a.qualifier_attr_value,
1608: a.qualifier_attr_value_to,
1609: a.comparison_operator_code,
1610: a.qualifier_id
1611: FROM qp_qualifiers a,ozf_denorm_queries b
1612: WHERE a.list_header_id = p_list_header_id
1613: AND a.qualifier_grouping_no = l_grouping_no
1614: AND a.list_line_id = -1 -- dont pick up line level qualifier
1615: AND a.qualifier_context = b.context

Line 1634: FROM ozf_denorm_queries

1630: WHERE list_header_id = p_list_header_id
1631: AND list_line_id = -1
1632: AND (qualifier_context,qualifier_attribute) IN
1633: (SELECT DISTINCT context,attribute
1634: FROM ozf_denorm_queries
1635: WHERE query_for = 'ELIG'
1636: AND active_flag = 'Y'));
1637:
1638:

Line 1641: FROM qp_qualifiers a, ozf_denorm_queries b

1637:
1638:
1639: CURSOR c_no_groups IS
1640: SELECT COUNT(DISTINCT a.qualifier_grouping_no)
1641: FROM qp_qualifiers a, ozf_denorm_queries b
1642: WHERE a.list_header_id = p_list_header_id
1643: AND a.qualifier_grouping_no = NVL(p_qnum,a.qualifier_grouping_no)
1644: AND a.list_line_id = -1
1645: AND a.qualifier_context = b.context

Line 1653: FROM qp_qualifiers a, ozf_denorm_queries b

1649:
1650: /* Removed the date restriction */
1651: CURSOR c_no_lines(l_grouping_no NUMBER) IS
1652: SELECT COUNT(*)
1653: FROM qp_qualifiers a, ozf_denorm_queries b
1654: WHERE list_header_id = p_list_header_id
1655: AND qualifier_grouping_no = l_grouping_no
1656: AND list_line_id = -1
1657: AND a.qualifier_context = b.context

Line 2638: FROM qp_qualifiers a, ozf_denorm_queries b

2634: CURSOR c_groups(ll_list_header_id NUMBER) IS
2635: select qnum from
2636: (
2637: SELECT DISTINCT a.qualifier_grouping_no qnum
2638: FROM qp_qualifiers a, ozf_denorm_queries b
2639: WHERE a.list_header_id = ll_list_header_id
2640: AND a.list_line_id = -1
2641: AND a.qualifier_context = b.context
2642: AND a.qualifier_attribute = b.attribute

Line 2663: FROM qp_qualifiers a, ozf_denorm_queries b

2659:
2660:
2661: CURSOR c_no_groups(ll_list_header_id NUMBER) IS
2662: SELECT COUNT(DISTINCT a.qualifier_grouping_no)
2663: FROM qp_qualifiers a, ozf_denorm_queries b
2664: WHERE a.list_header_id = ll_list_header_id
2665: AND a.list_line_id = -1
2666: AND a.qualifier_context = b.context
2667: AND a.qualifier_attribute = b.attribute

Line 2686: FROM ozf_denorm_queries

2682: WHERE list_header_id = ll_list_header_id
2683: AND list_line_id = -1
2684: AND (qualifier_context,qualifier_attribute) IN
2685: (SELECT DISTINCT context,attribute
2686: FROM ozf_denorm_queries
2687: WHERE query_for = 'ELIG'
2688: AND active_flag = 'Y'));
2689:
2690: