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_NET_ACCRUAL_ENGINE_PVT dependencies on DUAL

Line 201: FROM DUAL

197: RETURN VARCHAR2
198: IS
199: CURSOR c_product_qualified IS
200: SELECT 'Y'
201: FROM DUAL
202: WHERE EXISTS(SELECT 1
203: FROM ozf_activity_products
204: WHERE item = p_inventory_item_id
205: AND item_type = 'PRICING_ATTRIBUTE1'

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

348: END LOOP; -- c_groups
349: --
350: ELSE
351: --
352: -- FND_DSQL.add_text('(SELECT -1 party_id,-1 cust_account_id, -1 cust_acct_site_id, -1 site_use_id,'' '' site_use_code FROM DUAL)');
353: 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)');
354: --
355: END IF;
356:

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

349: --
350: ELSE
351: --
352: -- FND_DSQL.add_text('(SELECT -1 party_id,-1 cust_account_id, -1 cust_acct_site_id, -1 site_use_id,'' '' site_use_code FROM DUAL)');
353: 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)');
354: --
355: END IF;
356:
357: IF p_calling_from_den = 'N' OR l_no_query_flag = 'N'

Line 638: FND_DSQL.add_text(' inventory_item_id FROM DUAL');

634: THEN
635: --
636: FND_DSQL.add_text('SELECT ');
637: FND_DSQL.add_bind(l_product.product_id);
638: FND_DSQL.add_text(' inventory_item_id FROM DUAL');
639: --
640: END IF;
641:
642: FOR l_exclusion IN c_exclusion(l_product.off_discount_product_id)

Line 652: FND_DSQL.add_text(' inventory_item_id FROM DUAL');

648: THEN
649: --
650: FND_DSQL.add_text('SELECT ');
651: FND_DSQL.add_bind(l_exclusion.product_id);
652: FND_DSQL.add_text(' inventory_item_id FROM DUAL');
653: --
654: ELSIF l_exclusion.product_level = 'FAMILY'
655: THEN
656: --

Line 818: FND_DSQL.add_text(' inventory_item_id FROM DUAL');

814: THEN
815: --
816: FND_DSQL.add_text('SELECT ');
817: FND_DSQL.add_bind(l_product.product_id);
818: FND_DSQL.add_text(' inventory_item_id FROM DUAL');
819: --
820: END IF;
821:
822: FND_DSQL.add_text(')');

Line 1216: FROM DUAL;

1212: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type)
1213: IS
1214: CURSOR c_na_conc_exception_id IS
1215: SELECT ozf_na_conc_exceptions_s.NEXTVAL
1216: FROM DUAL;
1217:
1218: CURSOR c_pk_exist(p_na_conc_exception_id NUMBER) IS
1219: SELECT 1
1220: FROM DUAL

Line 1220: FROM DUAL

1216: FROM DUAL;
1217:
1218: CURSOR c_pk_exist(p_na_conc_exception_id NUMBER) IS
1219: SELECT 1
1220: FROM DUAL
1221: WHERE EXISTS (SELECT 1
1222: FROM ozf_na_conc_exceptions
1223: WHERE na_conc_exception_id = p_na_conc_exception_id);
1224: