APPS.OE_CNCL_VALIDATE_LINE dependencies on DUAL

Line 906: Select p_sold_to_org_id from dual

902: From oe_ship_to_orgs_v
903: WHERE site_use_id = p_ship_to_org_id
904: AND status = 'A' AND
905: customer_id in (
906: Select p_sold_to_org_id from dual
907: union
908: select CUST_ACCOUNT_ID from
909: HZ_CUST_ACCT_RELATE
910: where RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id

Line 984: SELECT p_sold_to_org_id FROM DUAL

980: WHERE SITE.SITE_USE_ID = p_deliver_to_org_id
981: AND SITE.SITE_USE_CODE ='DELIVER_TO'
982: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
983: AND ACCT_SITE.CUST_ACCOUNT_ID in (
984: SELECT p_sold_to_org_id FROM DUAL
985: UNION
986: SELECT CUST_ACCOUNT_ID FROM
987: HZ_CUST_ACCT_RELATE_ALL R WHERE
988: R.ORG_ID = ACCT_SITE.ORG_ID

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

1368: ,l_item_rec)
1369: THEN
1370: */
1371: IF l_tracking_quantity_ind = 'PS' then
1372: -- IF l_item_rec.dualum_ind in (1,2,3) THEN INVCONV
1373: oe_debug_pub.add('Primary and Secondary X-VAL - tracking_quantity_ind PS', 2);
1374:
1375: IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM OR
1376: p_line_rec.ordered_quantity IS NOT NULL) AND

Line 1396: END IF; -- IF l_item_rec.tracking_quantity_ind = 'PS' IF l_item_rec.dualum_ind in (1,2,3) THEN

1392: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1393: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity');
1394: OE_MSG_PUB.Add;
1395: END IF; -- IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM OR
1396: END IF; -- IF l_item_rec.tracking_quantity_ind = 'PS' IF l_item_rec.dualum_ind in (1,2,3) THEN
1397:
1398: /* If qty1/qty2 both populated, check tolerances
1399: ================================================*/
1400: oe_debug_pub.add('Primary and Secondary X-VAL - tolerance check', 2);

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

1399: ================================================*/
1400: oe_debug_pub.add('Primary and Secondary X-VAL - tolerance check', 2);
1401:
1402: IF l_secondary_default_ind in ('N','D') then -- INVCONV
1403: -- IF l_item_rec.dualum_ind in (2,3) THEN
1404: IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM AND
1405: p_line_rec.ordered_quantity IS NOT NULL) AND
1406: (p_line_rec.ordered_quantity2 <> FND_API.G_MISS_NUM AND
1407: p_line_rec.ordered_quantity2 IS NOT NULL) THEN

Line 1474: END IF; -- IF l_item_rec.tracking_quantity_ind = 'PS' IF l_item_rec.dualum_ind in (2,3) THEN INVCONV

1470:
1471: END IF; -- IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM AND
1472:
1473:
1474: END IF; -- IF l_item_rec.tracking_quantity_ind = 'PS' IF l_item_rec.dualum_ind in (2,3) THEN INVCONV
1475:
1476: -- END IF; -- IF OE_Line_Util.Process_Characteristics INVCONV
1477:
1478: -- Return Error if a required quantity validation fails

Line 2110: Select p_line_rec.sold_to_org_id from dual

2106: From oe_invoice_to_orgs_v
2107: WHERE site_use_id = p_line_rec.invoice_to_org_id
2108: AND status = 'A' AND
2109: customer_id in (
2110: Select p_line_rec.sold_to_org_id from dual
2111: union
2112: select CUST_ACCOUNT_ID from
2113: HZ_CUST_ACCT_RELATE
2114: where RELATED_CUST_ACCOUNT_ID = p_line_rec.sold_to_org_id

Line 2568: FROM dual

2564:
2565: BEGIN
2566: SELECT 'VALID'
2567: INTO l_dummy
2568: FROM dual
2569: WHERE exists(
2570: select 'x' from
2571: HZ_CUST_ACCT_RELATE
2572: where RELATED_CUST_ACCOUNT_ID = p_line_rec.sold_to_org_id