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 DUAL

Line 136: --FND_DSQL.add_text(') product_id FROM DUAL');

132: IF l_stmt_1 is not null then
133: IF INSTR(l_stmt_1, '*') > 0 OR INSTR(l_stmt_1, '?') > 0 THEN
134: FND_DSQL.add_text('SELECT null items_category, TO_NUMBER(');
135: FND_DSQL.add_bind(p_attr_value_from);
136: --FND_DSQL.add_text(') product_id FROM DUAL');
137: FND_DSQL.add_text(') product_id,''PRICING_ATTRIBUTE1'' product_type FROM DUAL');
138: ELSE
139: IF p_context = 'ITEM' then
140: IF l_category is null then

Line 137: FND_DSQL.add_text(') product_id,''PRICING_ATTRIBUTE1'' product_type FROM DUAL');

133: IF INSTR(l_stmt_1, '*') > 0 OR INSTR(l_stmt_1, '?') > 0 THEN
134: FND_DSQL.add_text('SELECT null items_category, TO_NUMBER(');
135: FND_DSQL.add_bind(p_attr_value_from);
136: --FND_DSQL.add_text(') product_id FROM DUAL');
137: FND_DSQL.add_text(') product_id,''PRICING_ATTRIBUTE1'' product_type FROM DUAL');
138: ELSE
139: IF p_context = 'ITEM' then
140: IF l_category is null then
141: --ozf_utility_pvt.write_conc_log ('In getSQL : l_category is null condition ');

Line 424: --FND_DSQL.add_text(') product_id FROM DUAL');

420:
421: IF INSTR(l_stmt_1, '*') > 0 OR INSTR(l_stmt_1, '?') > 0 THEN
422: FND_DSQL.add_text('SELECT TO_NUMBER(');
423: FND_DSQL.add_bind(p_attr_value_from);
424: --FND_DSQL.add_text(') product_id FROM DUAL');
425: FND_DSQL.add_text(') product_id,''PRICING_ATTRIBUTE1'' product_type FROM DUAL');
426: ELSE
427: IF p_qualifier_id is not null then
428: l_stmt_1 := 'select '||

Line 425: FND_DSQL.add_text(') product_id,''PRICING_ATTRIBUTE1'' product_type FROM DUAL');

421: IF INSTR(l_stmt_1, '*') > 0 OR INSTR(l_stmt_1, '?') > 0 THEN
422: FND_DSQL.add_text('SELECT TO_NUMBER(');
423: FND_DSQL.add_bind(p_attr_value_from);
424: --FND_DSQL.add_text(') product_id FROM DUAL');
425: FND_DSQL.add_text(') product_id,''PRICING_ATTRIBUTE1'' product_type FROM DUAL');
426: ELSE
427: IF p_qualifier_id is not null then
428: l_stmt_1 := 'select '||
429: p_qualifier_id ||

Line 665: FND_DSQL.add_text('(SELECT -1 qp_qualifier_id, -1 qp_qualifier_group, -1 party_id,-1 cust_account_id, -1 cust_acct_site_id, -1 site_use_id,'' '' site_use_code FROM DUAL)');

661: l_group_index := l_group_index + 1;
662: END IF;
663: END LOOP;
664: ELSE
665: FND_DSQL.add_text('(SELECT -1 qp_qualifier_id, -1 qp_qualifier_group, -1 party_id,-1 cust_account_id, -1 cust_acct_site_id, -1 site_use_id,'' '' site_use_code FROM DUAL)');
666: END IF;
667:
668: IF p_calling_from_den = 'N' OR l_no_query_flag = 'N' THEN
669: x_party_stmt := FND_DSQL.get_text(FALSE);

Line 1253: FND_DSQL.add_text('(SELECT -1 qp_qualifier_id, -1 qp_qualifier_group, -1 party_id,-1 cust_account_id, -1 cust_acct_site_id, -1 site_use_id,'' '' site_use_code FROM DUAL)');

1249: END IF;
1250:
1251: FND_DSQL.add_text(')');
1252: ELSE
1253: FND_DSQL.add_text('(SELECT -1 qp_qualifier_id, -1 qp_qualifier_group, -1 party_id,-1 cust_account_id, -1 cust_acct_site_id, -1 site_use_id,'' '' site_use_code FROM DUAL)');
1254: END IF;
1255:
1256: IF p_calling_from_den = 'N' OR l_no_query_flag = 'N' THEN
1257: x_party_stmt := FND_DSQL.get_text(FALSE);

Line 1513: FND_DSQL.add_text('(SELECT -1 qp_qualifier_id, -1 qp_qualifier_group, -1 party_id,-1 cust_account_id, -1 cust_acct_site_id, -1 site_use_id,'' '' site_use_code FROM DUAL)');

1509: l_group_index := l_group_index + 1;
1510: END IF;
1511: END LOOP;
1512: ELSE
1513: FND_DSQL.add_text('(SELECT -1 qp_qualifier_id, -1 qp_qualifier_group, -1 party_id,-1 cust_account_id, -1 cust_acct_site_id, -1 site_use_id,'' '' site_use_code FROM DUAL)');
1514: END IF;
1515:
1516: IF p_calling_from_den = 'N' OR l_no_query_flag = 'N' THEN
1517: x_party_stmt := FND_DSQL.get_text(FALSE);

Line 1608: FROM DUAL

1604:
1605:
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

Line 1779: FND_DSQL.add_text('(SELECT -1 qp_qualifier_id, -1 qp_qualifier_group, -1 party_id,-1 cust_account_id, -1 cust_acct_site_id, -1 site_use_id,'' '' site_use_code FROM DUAL)');

1775: END IF;
1776: */
1777: END LOOP;
1778: ELSE
1779: FND_DSQL.add_text('(SELECT -1 qp_qualifier_id, -1 qp_qualifier_group, -1 party_id,-1 cust_account_id, -1 cust_acct_site_id, -1 site_use_id,'' '' site_use_code FROM DUAL)');
1780: END IF;
1781: END IF;
1782: IF p_calling_from_den = 'N' OR l_no_query_flag = 'N' THEN
1783: x_party_stmt := FND_DSQL.get_text(FALSE);

Line 2281: FROM DUAL

2277: IS
2278:
2279: CURSOR c_party_denormed(l_date DATE, l_id NUMBER) IS
2280: SELECT 'Y'
2281: FROM DUAL
2282: WHERE EXISTS (
2283: SELECT 1
2284: FROM ozf_activity_customers
2285: WHERE last_update_date > l_date

Line 2291: FROM DUAL

2287: );
2288:
2289: CURSOR c_product_denormed(l_date DATE, l_id NUMBER) IS
2290: SELECT 'Y'
2291: FROM DUAL
2292: WHERE EXISTS (
2293: SELECT 1
2294: FROM ozf_activity_products
2295: WHERE last_update_date > l_date

Line 2353: FROM DUAL

2349: AND (last_update_date > l_date OR qualifier_deleted = 'Y');
2350:
2351: CURSOR c_qualifier_changed(l_list_header_id NUMBER, l_date DATE) IS
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

Line 2383: FROM DUAL

2379: );
2380:
2381: CURSOR c_product_changed(l_list_header_id NUMBER, l_date DATE) IS
2382: SELECT 'Y'
2383: FROM DUAL
2384: WHERE EXISTS (
2385: SELECT 1
2386: FROM qp_pricing_attributes
2387: WHERE last_update_date > l_date

Line 2600: FROM dual

2596: WHERE qp_list_header_id = ll_list_header_id
2597: AND offer_type in ('SCAN_DATA', 'LUMPSUM')
2598: UNION
2599: select -99 qnum
2600: FROM dual
2601: ) order by qnum desc;
2602:
2603:
2604: CURSOR c_no_groups(ll_list_header_id NUMBER) IS

Line 2622: FROM DUAL

2618:
2619:
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