DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE_BILLING dependencies on XLA_AE_HEADERS

Line 100: from xla_ae_headers xh, xla_ae_lines xl, xla_distribution_links xdl

96: and nvl(imp.INTERFACE_REVENUE_TO_GL_FLAG,'N')<>'Y')
97: or (imp.INTERFACE_REVENUE_TO_GL_FLAG = 'Y'
98: and ((nvl(dr.unearned_revenue_cr,0) <> 0
99: and exists (select 'In XLA AE Lines'
100: from xla_ae_headers xh, xla_ae_lines xl, xla_distribution_links xdl
101: where xh.event_id = dr.event_id
102: and xl.ae_header_id = xh.ae_header_id
103: and xl.ae_header_id = xdl.ae_header_id
104: and xl.ae_line_num = xdl.ae_line_num

Line 111: from xla_ae_headers xh, xla_ae_lines xl, xla_distribution_links xdl

107: and xdl.SOURCE_DISTRIBUTION_ID_NUM_2 = dr.draft_revenue_num
108: and xh.accounting_entry_status_code <> 'F' ))
109: or (nvl(dr.unbilled_receivable_dr,0) <> 0
110: and exists (select 'In XLA AE Lines'
111: from xla_ae_headers xh, xla_ae_lines xl, xla_distribution_links xdl
112: where xh.event_id = dr.event_id
113: and xl.ae_header_id = xh.ae_header_id
114: and xl.ae_header_id = xdl.ae_header_id
115: and xl.ae_line_num = xdl.ae_line_num