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.OE_VALIDATE_LINE dependencies on DUAL

Line 2438: SELECT p_sold_to_org_id FROM DUAL

2434: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
2435: AND SITE.STATUS = 'A'
2436: AND ACCT_SITE.STATUS ='A' AND --bug 2752321
2437: ACCT_SITE.CUST_ACCOUNT_ID in (
2438: SELECT p_sold_to_org_id FROM DUAL
2439: UNION
2440: SELECT CUST_ACCOUNT_ID FROM
2441: HZ_CUST_ACCT_RELATE_ALL h WHERE
2442: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id

Line 2520: SELECT p_sold_to_org_id FROM DUAL

2516: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
2517: AND SITE.STATUS = 'A'
2518: AND ACCT_SITE.STATUS ='A' AND --bug 2752321
2519: ACCT_SITE.CUST_ACCOUNT_ID in (
2520: SELECT p_sold_to_org_id FROM DUAL
2521: UNION
2522: SELECT CUST_ACCOUNT_ID FROM
2523: HZ_CUST_ACCT_RELATE_ALL h WHERE
2524: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id

Line 2616: from sys.dual

2612: and ratrx.cust_trx_type_id = ractt.cust_trx_type_id
2613: and ractt.org_id = p_line_rec.org_id)
2614: and ratrx.bill_to_customer_id
2615: in (select to_number(p_line_rec.sold_to_org_id )
2616: from sys.dual
2617: union
2618: select cust_account_id customer_id
2619: from hz_cust_acct_relate
2620: where related_cust_account_id = p_line_rec.sold_to_org_id

Line 2639: from sys.dual

2635: into l_exists
2636: from ra_customer_trx ratrx
2637: where ratrx.bill_to_customer_id in
2638: (select p_line_rec.sold_to_org_id
2639: from sys.dual
2640: union
2641: select cust_account_id customer_id
2642: from hz_cust_acct_relate_all h
2643: where related_cust_account_id = p_line_rec.sold_to_org_id

Line 4592: -- For a dual control process item, check qty1/2 both present and sync'd

4588: --end bug 3323610
4589: END IF; --bug3412008
4590:
4591: -- OPM 02/JUN/00 START
4592: -- For a dual control process item, check qty1/2 both present and sync'd
4593: -- =====================================================================
4594: IF l_debug_level > 0 THEN
4595: oe_debug_pub.add('Entity DUAL X-VAL start', 1);
4596: END IF;

Line 4595: oe_debug_pub.add('Entity DUAL X-VAL start', 1);

4591: -- OPM 02/JUN/00 START
4592: -- For a dual control process item, check qty1/2 both present and sync'd
4593: -- =====================================================================
4594: IF l_debug_level > 0 THEN
4595: oe_debug_pub.add('Entity DUAL X-VAL start', 1);
4596: END IF;
4597: IF OE_Line_Util.dual_uom_control
4598: (p_line_rec.inventory_item_id
4599: ,p_line_rec.ship_from_org_id

Line 4597: IF OE_Line_Util.dual_uom_control

4593: -- =====================================================================
4594: IF l_debug_level > 0 THEN
4595: oe_debug_pub.add('Entity DUAL X-VAL start', 1);
4596: END IF;
4597: IF OE_Line_Util.dual_uom_control
4598: (p_line_rec.inventory_item_id
4599: ,p_line_rec.ship_from_org_id
4600: ,l_item_rec)
4601: THEN

Line 4602: --IF l_item_rec.dualum_ind in (1,2,3) THEN INVCONV

4598: (p_line_rec.inventory_item_id
4599: ,p_line_rec.ship_from_org_id
4600: ,l_item_rec)
4601: THEN
4602: --IF l_item_rec.dualum_ind in (1,2,3) THEN INVCONV
4603: IF l_debug_level > 0 THEN
4604: oe_debug_pub.add('DUAL X-VAL dualum is true', 2);
4605: END IF;
4606:

Line 4604: oe_debug_pub.add('DUAL X-VAL dualum is true', 2);

4600: ,l_item_rec)
4601: THEN
4602: --IF l_item_rec.dualum_ind in (1,2,3) THEN INVCONV
4603: IF l_debug_level > 0 THEN
4604: oe_debug_pub.add('DUAL X-VAL dualum is true', 2);
4605: END IF;
4606:
4607: IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM OR
4608: p_line_rec.ordered_quantity IS NOT NULL) AND

Line 4612: oe_debug_pub.add('dual X-VAL qty 1 not empty', 2);

4608: p_line_rec.ordered_quantity IS NOT NULL) AND
4609: (p_line_rec.ordered_quantity2 = FND_API.G_MISS_NUM OR
4610: p_line_rec.ordered_quantity2 IS NULL) THEN
4611: IF l_debug_level > 0 THEN
4612: oe_debug_pub.add('dual X-VAL qty 1 not empty', 2);
4613: END IF;
4614: l_return_status := FND_API.G_RET_STS_ERROR;
4615: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4616: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity2');

Line 4634: oe_debug_pub.add('dual - start tolerance check', 2);

4630:
4631: /* If qty1/qty2 both populated, check tolerances
4632: ================================================*/
4633: IF l_debug_level > 0 THEN
4634: oe_debug_pub.add('dual - start tolerance check', 2);
4635: END IF;
4636:
4637: IF l_item_rec.secondary_default_ind in ('D','N') THEN -- INVCONV
4638: --IF l_item_rec.dualum_ind in (2,3) THEN

Line 4638: --IF l_item_rec.dualum_ind in (2,3) THEN

4634: oe_debug_pub.add('dual - start tolerance check', 2);
4635: END IF;
4636:
4637: IF l_item_rec.secondary_default_ind in ('D','N') THEN -- INVCONV
4638: --IF l_item_rec.dualum_ind in (2,3) THEN
4639: IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM AND
4640: p_line_rec.ordered_quantity IS NOT NULL) AND
4641: (p_line_rec.ordered_quantity2 <> FND_API.G_MISS_NUM AND
4642: p_line_rec.ordered_quantity2 IS NOT NULL)

Line 4649: oe_debug_pub.add('Entity - DUAL X-Val. ordered_quantity = ' || p_line_rec.ordered_quantity ,1);

4645:
4646: THEN
4647:
4648: IF l_debug_level > 0 THEN
4649: oe_debug_pub.add('Entity - DUAL X-Val. ordered_quantity = ' || p_line_rec.ordered_quantity ,1);
4650: oe_debug_pub.add('Entity - DUAL X-Val. ordered_quantity2 = ' || p_line_rec.ordered_quantity2 ,1);
4651: END IF;
4652: -- OPM BEGIN 06/22
4653: /* Get the OPM equivalent code for order_quantity_uom

Line 4650: oe_debug_pub.add('Entity - DUAL X-Val. ordered_quantity2 = ' || p_line_rec.ordered_quantity2 ,1);

4646: THEN
4647:
4648: IF l_debug_level > 0 THEN
4649: oe_debug_pub.add('Entity - DUAL X-Val. ordered_quantity = ' || p_line_rec.ordered_quantity ,1);
4650: oe_debug_pub.add('Entity - DUAL X-Val. ordered_quantity2 = ' || p_line_rec.ordered_quantity2 ,1);
4651: END IF;
4652: -- OPM BEGIN 06/22
4653: /* Get the OPM equivalent code for order_quantity_uom
4654: ===================================================== -- INVCONV

Line 4682: oe_debug_pub.add('Entity - dual UM with tolerance error 1. return = '|| l_return ,1);

4678:
4679: IF l_return = 0 -- (false)
4680: then
4681: IF l_debug_level > 0 THEN
4682: oe_debug_pub.add('Entity - dual UM with tolerance error 1. return = '|| l_return ,1);
4683: END IF;
4684:
4685: l_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
4686: p_encoded => 'F');

Line 4696: oe_debug_pub.add('Entity - dual UM with no tolerance error ',1);

4692:
4693: else
4694:
4695: IF l_debug_level > 0 THEN
4696: oe_debug_pub.add('Entity - dual UM with no tolerance error ',1);
4697: END IF; -- INVCONV
4698:
4699: --Begin Bug 2639667
4700: -- Code added till End Bug 2639667 comment.

Line 4755: oe_debug_pub.add('Entity - dual UM with tolerance error 2. return = '|| l_return ,1);

4751:
4752: IF l_return = 0 -- (false) -- INVCONV
4753: then
4754: IF l_debug_level > 0 THEN
4755: oe_debug_pub.add('Entity - dual UM with tolerance error 2. return = '|| l_return ,1);
4756: END IF;
4757:
4758: l_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
4759: p_encoded => 'F');

Line 5856: SELECT p_line_rec.sold_to_org_id FROM DUAL

5852: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
5853: AND SITE.STATUS = 'A'
5854: AND ACCT_SITE.STATUS ='A' AND --bug 2752321
5855: ACCT_SITE.CUST_ACCOUNT_ID in (
5856: SELECT p_line_rec.sold_to_org_id FROM DUAL
5857: UNION
5858: SELECT CUST_ACCOUNT_ID FROM
5859: HZ_CUST_ACCT_RELATE_ALL h WHERE
5860: RELATED_CUST_ACCOUNT_ID = p_line_rec.sold_to_org_id

Line 6476: FROM dual

6472:
6473: BEGIN
6474: SELECT 'VALID'
6475: INTO l_dummy
6476: FROM dual
6477: WHERE exists(
6478: select 'x' from
6479: hz_cust_acct_relate where
6480: related_cust_account_id = p_line_rec.sold_to_org_id

Line 6669: from dual

6665: FROM oe_agreements oa
6666: WHERE price_list_id = p_line_rec.price_list_id
6667: AND sold_to_org_id IN
6668: (select -1
6669: from dual
6670: union
6671: select p_line_rec.sold_to_org_id
6672: from dual
6673: union

Line 6672: from dual

6668: (select -1
6669: from dual
6670: union
6671: select p_line_rec.sold_to_org_id
6672: from dual
6673: union
6674: select r.cust_account_id
6675: from hz_cust_acct_relate r
6676: where r.related_cust_account_id = p_line_rec.sold_to_org_id);