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 QP_QUALIFIERS

Line 1336: FROM qp_qualifiers a,

1332:
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)

Line 1349: FROM qp_qualifiers a,

1345:
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)

Line 1364: FROM qp_qualifiers a,

1360: a.qualifier_attribute,
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

Line 1379: FROM qp_qualifiers a,

1375: a.qualifier_attribute,
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

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 1629: FROM qp_qualifiers

1625: CURSOR c_elig_exists IS
1626: SELECT 'Y'
1627: FROM DUAL
1628: WHERE EXISTS (SELECT 1
1629: FROM qp_qualifiers
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

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 2413: FROM qp_qualifiers

2409: SELECT 'Y'
2410: FROM DUAL
2411: WHERE EXISTS (
2412: SELECT 1
2413: FROM qp_qualifiers
2414: WHERE list_header_id = l_list_header_id
2415: AND (
2416: last_update_date > l_date -- changed qualifiers
2417: OR ( -- changed lists

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 2681: FROM qp_qualifiers

2677: CURSOR c_elig_exists(ll_list_header_id NUMBER) IS
2678: SELECT 'Y'
2679: FROM DUAL
2680: WHERE EXISTS (SELECT 1
2681: FROM qp_qualifiers
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

Line 2943: FND_DSQL.add_text(' FROM qp_qualifiers WHERE list_header_id = ');

2939: FND_DSQL.add_text(' UNION select -1 qp_qualifier_id, -1 qp_qualifier_group,-1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
2940: -- FND_DSQL.add_text(' UNION select -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
2941: FND_DSQL.add_text(' to_number(qualifier_attr_value) site_use_id, ');
2942: FND_DSQL.add_text(' qualifier_context||'':''||qualifier_attribute site_use_code ');
2943: FND_DSQL.add_text(' FROM qp_qualifiers WHERE list_header_id = ');
2944: FND_DSQL.add_bind(i.object_id);
2945: FND_DSQL.add_text(' AND qualifier_grouping_no = ');
2946: FND_DSQL.add_bind(z.qnum);
2947: FND_DSQL.add_text(' and qualifier_context||'':''||qualifier_attribute not in ');

Line 3295: FND_DSQL.add_text(' FROM qp_qualifiers WHERE list_header_id = ');

3291: FND_DSQL.add_text(' UNION select -1 qp_qualifier_id,-1 qp_qualifier_group,-1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
3292: -- FND_DSQL.add_text(' UNION select -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
3293: FND_DSQL.add_text(' to_number(qualifier_attr_value) site_use_id, ');
3294: FND_DSQL.add_text(' qualifier_context||'':''||qualifier_attribute site_use_code ');
3295: FND_DSQL.add_text(' FROM qp_qualifiers WHERE list_header_id = ');
3296: FND_DSQL.add_bind(i.object_id);
3297: FND_DSQL.add_text(' AND qualifier_grouping_no = ');
3298: FND_DSQL.add_bind(z.qnum);
3299: FND_DSQL.add_text(' and qualifier_context||'':''||qualifier_attribute not in ');

Line 3507: FND_DSQL.add_text(' FROM qp_qualifiers WHERE list_header_id = ');

3503: FND_DSQL.add_text(' UNION select -1 qp_qualifier_id, -1 qp_qualifier_group,-1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
3504: -- FND_DSQL.add_text(' UNION select -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
3505: FND_DSQL.add_text(' to_number(qualifier_attr_value) site_use_id, ');
3506: FND_DSQL.add_text('qualifier_context||'':''||qualifier_attribute site_use_code ');
3507: FND_DSQL.add_text(' FROM qp_qualifiers WHERE list_header_id = ');
3508: FND_DSQL.add_bind(i.object_id);
3509: FND_DSQL.add_text(' AND qualifier_grouping_no = ');
3510: FND_DSQL.add_bind(z.qnum);
3511: FND_DSQL.add_text(' and qualifier_context||'':''||qualifier_attribute not in ');