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 1274: 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)');

1270: END IF;
1271:
1272: FND_DSQL.add_text(')');
1273: ELSE
1274: 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)');
1275: END IF;
1276:
1277:
1278: IF p_calling_from_den = 'N' OR l_no_query_flag = 'N' THEN

Line 1533: 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)');

1529: l_group_index := l_group_index + 1;
1530: END IF;
1531: END LOOP;
1532: ELSE
1533: 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)');
1534: END IF;
1535:
1536:
1537: IF p_calling_from_den = 'N' OR l_no_query_flag = 'N' THEN

Line 1627: FROM DUAL

1623:
1624:
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

Line 1799: 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)');

1795: END IF;
1796: */
1797: END LOOP;
1798: ELSE
1799: 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)');
1800: END IF;
1801: END IF;
1802:
1803:

Line 2338: FROM DUAL

2334: IS
2335:
2336: CURSOR c_party_denormed(l_date DATE, l_id NUMBER) IS
2337: SELECT 'Y'
2338: FROM DUAL
2339: WHERE EXISTS (
2340: SELECT 1
2341: FROM ozf_activity_customers
2342: WHERE last_update_date > l_date

Line 2348: FROM DUAL

2344: );
2345:
2346: CURSOR c_product_denormed(l_date DATE, l_id NUMBER) IS
2347: SELECT 'Y'
2348: FROM DUAL
2349: WHERE EXISTS (
2350: SELECT 1
2351: FROM ozf_activity_products
2352: WHERE last_update_date > l_date

Line 2410: FROM DUAL

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

Line 2440: FROM DUAL

2436: );
2437:
2438: CURSOR c_product_changed(l_list_header_id NUMBER, l_date DATE) IS
2439: SELECT 'Y'
2440: FROM DUAL
2441: WHERE EXISTS (
2442: SELECT 1
2443: FROM qp_pricing_attributes
2444: WHERE last_update_date > l_date

Line 2657: FROM dual

2653: WHERE qp_list_header_id = ll_list_header_id
2654: AND offer_type in ('SCAN_DATA', 'LUMPSUM')
2655: UNION
2656: select -99 qnum
2657: FROM dual
2658: ) order by qnum desc;
2659:
2660:
2661: CURSOR c_no_groups(ll_list_header_id NUMBER) IS

Line 2679: FROM DUAL

2675:
2676:
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