APPS.OE_BULK_VALIDATE dependencies on OE_RA_RULES_V

Line 358: FROM OE_RA_RULES_V

354: FROM OE_HEADERS_IFACE_ALL b
355: WHERE batch_id = p_batch_id and
356: b.accounting_rule_id IS NOT NULL and
357: NOT EXISTS (SELECT RULE_ID
358: FROM OE_RA_RULES_V
359: WHERE RULE_ID = b.accounting_rule_id
360: AND STATUS = 'A'
361: AND TYPE in ('A', 'ACC_DUR','PP_DR_ALL','PP_DR_PP'));--bug 4893057
362:

Line 396: FROM OE_RA_RULES_V

392: FROM OE_HEADERS_IFACE_ALL
393: WHERE batch_id = p_batch_id)
394: AND b.accounting_rule_id IS NOT NULL and
395: NOT EXISTS (SELECT RULE_ID
396: FROM OE_RA_RULES_V
397: WHERE RULE_ID = b.accounting_rule_id
398: AND STATUS = 'A'
399: AND TYPE in ('A', 'ACC_DUR','PP_DR_ALL','PP_DR_PP'));--bug 4893057
400:

Line 747: FROM OE_RA_RULES_V

743: FROM OE_HEADERS_IFACE_ALL b
744: WHERE batch_id = p_batch_id and
745: b.invoicing_rule_id IS NOT NULL and
746: NOT EXISTS (SELECT RULE_ID
747: FROM OE_RA_RULES_V
748: WHERE RULE_ID = b.invoicing_rule_id
749: AND STATUS = 'A'
750: AND TYPE = 'I')
751: ;

Line 786: FROM OE_RA_RULES_V

782: FROM OE_HEADERS_IFACE_ALL
783: WHERE batch_id = p_batch_id)
784: AND b.invoicing_rule_id IS NOT NULL and
785: NOT EXISTS (SELECT RULE_ID
786: FROM OE_RA_RULES_V
787: WHERE RULE_ID = b.invoicing_rule_id
788: AND STATUS = 'A'
789: AND TYPE = 'I');
790: