eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 297: je_gr_trnovr_rule_lines irl,

293: and cgld.gl_posted_date is not null
294: and CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
295: and (nvl(CUST_ACCT.CUSTOMER_CLASS_CODE ,'X') not in ( select lookup_code
296: from
297: je_gr_trnovr_rule_lines irl,
298: je_gr_trnovr_rules ir
299: where
300: ir.trnovr_rule_id = p_rule_id
301: and irl.trnovr_rule_id = ir.trnovr_rule_id

Line 306: je_gr_trnovr_rule_lines irl,

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

Line 315: je_gr_trnovr_rule_lines irl,

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