DBA Data[Home] [Help]

APPS.OE_BULK_CACHE dependencies on OE_RA_RULES_V

Line 230: ,oe_ra_rules_v i

226: ,G_ORDER_TYPE_TBL(p_key).tax_calculation_flag
227: ,G_ORDER_TYPE_TBL(p_key).cust_trx_type_id
228: FROM oe_transaction_types_all o
229: ,oe_transaction_types_tl otl
230: ,oe_ra_rules_v i
231: ,oe_ra_rules_v a
232: ,qp_list_headers_vl pl
233: ,oe_lookups sp
234: ,oe_ship_methods_v sm

Line 231: ,oe_ra_rules_v a

227: ,G_ORDER_TYPE_TBL(p_key).cust_trx_type_id
228: FROM oe_transaction_types_all o
229: ,oe_transaction_types_tl otl
230: ,oe_ra_rules_v i
231: ,oe_ra_rules_v a
232: ,qp_list_headers_vl pl
233: ,oe_lookups sp
234: ,oe_ship_methods_v sm
235: ,oe_ar_lookups_v fp

Line 496: ,oe_ra_rules_v i

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
500: WHERE a.agreement_id = p_key

Line 497: ,oe_ra_rules_v ac

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
500: WHERE a.agreement_id = p_key
501: AND a.invoicing_rule_id = i.rule_id(+)