APPS.OE_VALIDATE_LINE dependencies on OE_AGREEMENTS

Line 6403: FROM oe_agreements_v

6399:
6400: BEGIN
6401: SELECT name ,sold_to_org_id , price_list_id
6402: INTO l_agreement_name,l_sold_to_org,l_price_list_id
6403: FROM oe_agreements_v
6404: WHERE agreement_id = p_line_rec.agreement_id
6405: AND trunc(nvl(p_line_rec.pricing_date,sysdate)) between
6406: trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))
6407: AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000)));

Line 6658: FROM oe_agreements oa

6654: IF l_list_type_code = 'AGR' THEN
6655: IF lcustomer_relations = 'N' THEN
6656: SELECT 'Y'
6657: INTO l_dummy
6658: FROM oe_agreements oa
6659: WHERE price_list_id = p_line_rec.price_list_id
6660: AND (sold_to_org_id = -1
6661: OR sold_to_org_id = p_line_rec.sold_to_org_id);
6662: ELSIF lcustomer_relations = 'Y' THEN

Line 6665: FROM oe_agreements oa

6661: OR sold_to_org_id = p_line_rec.sold_to_org_id);
6662: ELSIF lcustomer_relations = 'Y' THEN
6663: SELECT 'Y'
6664: INTO l_dummy
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

Line 6872: FROM oe_agreements_vl

6868: END IF;
6869:
6870: SELECT name
6871: INTO l_agreement_name
6872: FROM oe_agreements_vl
6873: WHERE agreement_id = p_line_rec.agreement_id
6874: AND trunc(nvl(p_line_rec.pricing_date,sysdate)) BETWEEN
6875: trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))
6876: AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000)));