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 1371: -- IF l_item_rec.dualum_ind in (1,2,3) THEN INVCONV

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

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

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

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

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

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

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

Line 2109: Select p_line_rec.sold_to_org_id from dual

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

Line 2548: FROM dual

2544:
2545: BEGIN
2546: SELECT 'VALID'
2547: INTO l_dummy
2548: FROM dual
2549: WHERE exists(
2550: select 'x' from
2551: HZ_CUST_ACCT_RELATE
2552: where RELATED_CUST_ACCOUNT_ID = p_line_rec.sold_to_org_id