APPS.RLM_VALIDATEDEMAND_SV dependencies on OE_AGREEMENTS

Line 5084: FROM oe_agreements oea

5080:
5081: SELECT oea.price_list_id, oea.purchase_order_num
5082: INTO x_lines_rec.price_list_id,
5083: v_OE_Purchase_Order
5084: FROM oe_agreements oea
5085: WHERE oea.agreement_id = v_agreement_id
5086: AND v_start_date between nvl(oea.start_date_active, to_date('01/01/1900','dd/mm/yyyy'))
5087: and nvl(oea.end_date_active, to_date('31/12/4712','dd/mm/yyyy'));
5088: --

Line 5117: FROM oe_agreements oea

5113: --
5114: SELECT oea.price_list_id, oea.purchase_order_num
5115: INTO x_lines_rec.price_list_id,
5116: v_OE_Purchase_Order
5117: FROM oe_agreements oea
5118: WHERE agreement_id = v_fut_agreement_id
5119: AND v_start_date between nvl(oea.start_date_active, to_date('01/01/1900','dd/mm/yyyy') )
5120: and nvl(oea.end_date_active, to_date('31/12/4712','dd/mm/yyyy'));
5121: --

Line 5230: FROM oe_agreements oea

5226: oea.price_list_id,oea.start_date_active,
5227: oea.end_date_active
5228: INTO x_lines_rec.agreement_id, v_agreement_name,
5229: x_lines_rec.price_list_id, v_start_date, v_end_date
5230: FROM oe_agreements oea
5231: WHERE purchase_order_num = x_lines_rec.cust_po_number
5232: AND x_lines_rec.start_date_time
5233: BETWEEN oea.start_date_active AND
5234: nvl(oea.end_date_active,

Line 5237: FROM oe_agreements oem

5233: BETWEEN oea.start_date_active AND
5234: nvl(oea.end_date_active,
5235: to_date('31/12/4712','dd/mm/yyyy'))
5236: AND revision = (Select MAX(oem.revision)
5237: FROM oe_agreements oem
5238: WHERE oem.purchase_order_num =
5239: x_lines_rec.cust_po_number);
5240: --
5241: IF (l_debug <> -1) THEN