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 1316: FROM qp_qualifiers a,

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

Line 1329: FROM qp_qualifiers a,

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

Line 1344: FROM qp_qualifiers a,

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

Line 1359: FROM qp_qualifiers a,

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

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

1606: CURSOR c_elig_exists IS
1607: SELECT 'Y'
1608: FROM DUAL
1609: WHERE EXISTS (SELECT 1
1610: FROM qp_qualifiers
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

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

2352: SELECT 'Y'
2353: FROM DUAL
2354: WHERE EXISTS (
2355: SELECT 1
2356: FROM qp_qualifiers
2357: WHERE list_header_id = l_list_header_id
2358: AND (
2359: last_update_date > l_date -- changed qualifiers
2360: OR ( -- changed lists

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

2620: CURSOR c_elig_exists(ll_list_header_id NUMBER) IS
2621: SELECT 'Y'
2622: FROM DUAL
2623: WHERE EXISTS (SELECT 1
2624: FROM qp_qualifiers
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

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

2882: 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, ');
2883: -- FND_DSQL.add_text(' UNION select -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
2884: FND_DSQL.add_text(' to_number(qualifier_attr_value) site_use_id, ');
2885: FND_DSQL.add_text(' qualifier_context||'':''||qualifier_attribute site_use_code ');
2886: FND_DSQL.add_text(' FROM qp_qualifiers WHERE list_header_id = ');
2887: FND_DSQL.add_bind(i.object_id);
2888: FND_DSQL.add_text(' AND qualifier_grouping_no = ');
2889: FND_DSQL.add_bind(z.qnum);
2890: FND_DSQL.add_text(' and qualifier_context||'':''||qualifier_attribute not in ');

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

3231: 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, ');
3232: -- FND_DSQL.add_text(' UNION select -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
3233: FND_DSQL.add_text(' to_number(qualifier_attr_value) site_use_id, ');
3234: FND_DSQL.add_text(' qualifier_context||'':''||qualifier_attribute site_use_code ');
3235: FND_DSQL.add_text(' FROM qp_qualifiers WHERE list_header_id = ');
3236: FND_DSQL.add_bind(i.object_id);
3237: FND_DSQL.add_text(' AND qualifier_grouping_no = ');
3238: FND_DSQL.add_bind(z.qnum);
3239: FND_DSQL.add_text(' and qualifier_context||'':''||qualifier_attribute not in ');

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

3443: 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, ');
3444: -- FND_DSQL.add_text(' UNION select -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
3445: FND_DSQL.add_text(' to_number(qualifier_attr_value) site_use_id, ');
3446: FND_DSQL.add_text('qualifier_context||'':''||qualifier_attribute site_use_code ');
3447: FND_DSQL.add_text(' FROM qp_qualifiers WHERE list_header_id = ');
3448: FND_DSQL.add_bind(i.object_id);
3449: FND_DSQL.add_text(' AND qualifier_grouping_no = ');
3450: FND_DSQL.add_bind(z.qnum);
3451: FND_DSQL.add_text(' and qualifier_context||'':''||qualifier_attribute not in ');