APPS.OE_VALIDATE_LINE dependencies on OE_AGREEMENTS

Line 6031: FROM oe_agreements_v

6027:
6028: BEGIN
6029: SELECT name ,sold_to_org_id , price_list_id
6030: INTO l_agreement_name,l_sold_to_org,l_price_list_id
6031: FROM oe_agreements_v
6032: WHERE agreement_id = p_line_rec.agreement_id
6033: AND trunc(nvl(p_line_rec.pricing_date,sysdate)) between
6034: trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))
6035: AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000)));

Line 6286: FROM oe_agreements oa

6282: IF l_list_type_code = 'AGR' THEN
6283: IF lcustomer_relations = 'N' THEN
6284: SELECT 'Y'
6285: INTO l_dummy
6286: FROM oe_agreements oa
6287: WHERE price_list_id = p_line_rec.price_list_id
6288: AND (sold_to_org_id = -1
6289: OR sold_to_org_id = p_line_rec.sold_to_org_id);
6290: ELSIF lcustomer_relations = 'Y' THEN

Line 6293: FROM oe_agreements oa

6289: OR sold_to_org_id = p_line_rec.sold_to_org_id);
6290: ELSIF lcustomer_relations = 'Y' THEN
6291: SELECT 'Y'
6292: INTO l_dummy
6293: FROM oe_agreements oa
6294: WHERE price_list_id = p_line_rec.price_list_id
6295: AND sold_to_org_id IN
6296: (select -1
6297: from dual

Line 6500: FROM oe_agreements_vl

6496: END IF;
6497:
6498: SELECT name
6499: INTO l_agreement_name
6500: FROM oe_agreements_vl
6501: WHERE agreement_id = p_line_rec.agreement_id
6502: AND trunc(nvl(p_line_rec.pricing_date,sysdate)) BETWEEN
6503: trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))
6504: AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000)));