DBA Data[Home] [Help]

APPS.OE_BULK_CACHE dependencies on OE_RA_RULES_V

Line 229: ,oe_ra_rules_v i

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

Line 230: ,oe_ra_rules_v a

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

Line 495: ,oe_ra_rules_v i

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

Line 496: ,oe_ra_rules_v ac

492: ,G_AGREEMENT_TBL(p_key).invoice_to_org_id
493: ,G_AGREEMENT_TBL(p_key).default_attributes
494: FROM oe_agreements_vl a
495: ,oe_ra_rules_v i
496: ,oe_ra_rules_v ac
497: ,oe_ra_terms_v term
498: ,ra_salesreps s
499: WHERE a.agreement_id = p_key
500: AND a.invoicing_rule_id = i.rule_id(+)