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 639: FND_DSQL.add_text(' inventory_item_id FROM DUAL');

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

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

663: THEN
664: --
665: FND_DSQL.add_text('SELECT ');
666: FND_DSQL.add_bind(l_exclusion.product_id);
667: FND_DSQL.add_text(' inventory_item_id FROM DUAL');
668: --
669: ELSIF l_exclusion.product_level = 'FAMILY'
670: THEN
671: --

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

852: THEN
853: --
854: FND_DSQL.add_text('SELECT ');
855: FND_DSQL.add_bind(l_product.product_id);
856: FND_DSQL.add_text(' inventory_item_id FROM DUAL');
857: --
858: END IF;
859:
860: --amitamku - Added for Bug fix 13510229

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

882: THEN
883: --
884: FND_DSQL.add_text('SELECT ');
885: FND_DSQL.add_bind(l_exclusion.product_id);
886: FND_DSQL.add_text(' inventory_item_id FROM DUAL');
887: --
888: ELSIF l_exclusion.product_level = 'FAMILY'
889: THEN
890: --

Line 1313: FROM DUAL;

1309: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type)
1310: IS
1311: CURSOR c_na_conc_exception_id IS
1312: SELECT ozf_na_conc_exceptions_s.NEXTVAL
1313: FROM DUAL;
1314:
1315: CURSOR c_pk_exist(p_na_conc_exception_id NUMBER) IS
1316: SELECT 1
1317: FROM DUAL

Line 1317: FROM DUAL

1313: FROM DUAL;
1314:
1315: CURSOR c_pk_exist(p_na_conc_exception_id NUMBER) IS
1316: SELECT 1
1317: FROM DUAL
1318: WHERE EXISTS (SELECT 1
1319: FROM ozf_na_conc_exceptions
1320: WHERE na_conc_exception_id = p_na_conc_exception_id);
1321:

Line 2714: l_order_line_tbl(i).fulfillment_base := OE_DUAL_UOM_UTIL.get_fulfillment_base(l_order_line_tbl(i).line_id) ;

2710: x_cw_quantity => l_cw_quantity,
2711: x_cw_quantity_uom => l_cw_quantity_uom );*/
2712:
2713: -- getting fulfillment_base from OE API. In case of performance issue can think of using fulfillment_base from existing cursor
2714: l_order_line_tbl(i).fulfillment_base := OE_DUAL_UOM_UTIL.get_fulfillment_base(l_order_line_tbl(i).line_id) ;
2715:
2716: IF l_order_line_tbl(i).fulfillment_base = 'S' THEN
2717: l_cw_quantity := l_order_line_tbl(i).shipping_quantity;
2718: l_cw_quantity_uom := l_order_line_tbl(i).shipping_quantity_uom;

Line 3816: l_fulfillment_base := OE_DUAL_UOM_UTIL.get_fulfillment_base(l_order_line_id) ;

3812: x_cw_quantity => l_cw_quantity,
3813: x_cw_quantity_uom => l_cw_quantity_uom );*/
3814:
3815: -- getting fulfillment_base from OE API. In case of performance issue can think of using fulfillment_base from existing cursor
3816: l_fulfillment_base := OE_DUAL_UOM_UTIL.get_fulfillment_base(l_order_line_id) ;
3817:
3818: IF l_fulfillment_base = 'S' THEN
3819: l_cw_quantity := l_shipping_quantity;
3820: l_cw_quantity_uom := l_shipping_quantity_uom;