DBA Data[Home] [Help]

APPS.OE_BULK_CACHE dependencies on OE_AGREEMENTS_VL

Line 495: FROM oe_agreements_vl a

491: ,G_AGREEMENT_TBL(p_key).cust_po_number
492: ,G_AGREEMENT_TBL(p_key).invoice_to_contact_id
493: ,G_AGREEMENT_TBL(p_key).invoice_to_org_id
494: ,G_AGREEMENT_TBL(p_key).default_attributes
495: FROM oe_agreements_vl a
496: ,oe_ra_rules_v i
497: ,oe_ra_rules_v ac
498: ,oe_ra_terms_v term
499: ,ra_salesreps s

Line 531: FROM oe_agreements_vl a

527: ,G_AGREEMENT_TBL(p_key).end_date_active
528: ,G_AGREEMENT_TBL(p_key).revision
529: ,G_AGREEMENT_TBL(p_key).sold_to_org_id
530: ,G_AGREEMENT_TBL(p_key).price_list_id
531: FROM oe_agreements_vl a
532: WHERE a.agreement_id = p_key;
533:
534: END IF;
535: