APPS.JERX_TO dependencies on JE_GR_TRNOVR_RULE_LINES

Line 88: from je_gr_trnovr_rule_lines irl,

84: aid.accounting_date <= TO_DATE(p_period_end_date,'DD/MM/YYYY HH24:MI:SS') and
85: (aid.posted_flag = 'Y' or aid.ACCRUAL_POSTED_FLAG = 'Y' or
86: aid.CASH_POSTED_FLAG = 'Y') and
87: (nvl(pv.vendor_type_lookup_code,'X') not in (select lookup_code
88: from je_gr_trnovr_rule_lines irl,
89: je_gr_trnovr_rules ir
90: where ir.trnovr_rule_id = p_rule_id
91: and irl.trnovr_rule_id = ir.trnovr_rule_id
92: and irl.lookup_type = 'VENDOR TYPE'

Line 95: from je_gr_trnovr_rule_lines irl,

91: and irl.trnovr_rule_id = ir.trnovr_rule_id
92: and irl.lookup_type = 'VENDOR TYPE'
93: and irl.exclude_flag = 'Y' )) AND
94: (ai.invoice_type_lookup_code not in (select lookup_code
95: from je_gr_trnovr_rule_lines irl,
96: je_gr_trnovr_rules ir
97: where ir.trnovr_rule_id = p_rule_id
98: and irl.trnovr_rule_id = ir.trnovr_rule_id
99: and irl.lookup_type = 'INVOICE TYPE'

Line 102: from je_gr_trnovr_rule_lines irl,

98: and irl.trnovr_rule_id = ir.trnovr_rule_id
99: and irl.lookup_type = 'INVOICE TYPE'
100: and irl.exclude_flag = 'Y')) AND
101: (aid.line_type_lookup_code not in (select lookup_code
102: from je_gr_trnovr_rule_lines irl,
103: je_gr_trnovr_rules ir
104: where ir.trnovr_rule_id = p_rule_id
105: and irl.trnovr_rule_id = ir.trnovr_rule_id
106: and irl.lookup_type = 'INVOICE DISTRIBUTION TYPE'

Line 299: from je_gr_trnovr_rule_lines irl,

295: and cgld.gl_date >= TO_DATE(p_period_start_date,'DD/MM/YYYY HH24:MI:SS')
296: and cgld.gl_date <= TO_DATE(p_period_end_date,'DD/MM/YYYY HH24:MI:SS')
297: and cgld.gl_posted_date is not null
298: and (nvl(CUST_ACCT.CUSTOMER_CLASS_CODE ,'X') not in ( select lookup_code
299: from je_gr_trnovr_rule_lines irl,
300: je_gr_trnovr_rules ir
301: where ir.trnovr_rule_id = p_rule_id
302: and irl.trnovr_rule_id = ir.trnovr_rule_id
303: and irl.lookup_type = 'CUSTOMER CLASS'

Line 306: from je_gr_trnovr_rule_lines irl,

302: and irl.trnovr_rule_id = ir.trnovr_rule_id
303: and irl.lookup_type = 'CUSTOMER CLASS'
304: and irl.exclude_flag = 'Y'))
305: and (ctt.type not in ( select lookup_code
306: from je_gr_trnovr_rule_lines irl,
307: je_gr_trnovr_rules ir
308: where ir.trnovr_rule_id = p_rule_id
309: and irl.trnovr_rule_id = ir.trnovr_rule_id
310: and irl.lookup_type = 'INV/CM'

Line 313: from je_gr_trnovr_rule_lines irl,

309: and irl.trnovr_rule_id = ir.trnovr_rule_id
310: and irl.lookup_type = 'INV/CM'
311: and irl.exclude_flag = 'Y'))
312: and (ctl.line_type not in ( select lookup_code
313: from je_gr_trnovr_rule_lines irl,
314: je_gr_trnovr_rules ir
315: where ir.trnovr_rule_id = p_rule_id
316: and irl.trnovr_rule_id = ir.trnovr_rule_id
317: and irl.lookup_type = 'STD_LINE_TYPE'