[Home] [Help]
86: trunc(nvl(rec_date_to,ARA.APPLY_DATE + 1)) )
87: AND rac.interface_header_attribute1 = prj.segment1
88: AND rac.interface_header_attribute2 = TO_CHAR ( pdi.draft_invoice_num ) ---- Modified the exists clause for bug#12404156
89: AND rac.interface_header_context = ( SELECT NAME
90: FROM RA_BATCH_SOURCES RBS ,
91: PA_IMPLEMENTATIONS PI
92: WHERE PI.INVOICE_BATCH_SOURCE_ID = BATCH_SOURCE_ID )))
93:
94: UNION
123: and trunc(ARA.APPLY_DATE) between trunc(nvl(rec_date_from,ARA.APPLY_DATE-1)) and trunc(nvl(rec_date_to,ARA.APPLY_DATE + 1)))
124: AND rac.interface_header_attribute1 = prj.segment1
125: AND rac.interface_header_attribute2 = TO_CHAR ( pdi.draft_invoice_num ) ---- Modified the exists clause for bug#12404156
126: AND rac.interface_header_context = ( SELECT NAME
127: FROM RA_BATCH_SOURCES RBS ,
128: PA_IMPLEMENTATIONS PI
129: WHERE PI.INVOICE_BATCH_SOURCE_ID = BATCH_SOURCE_ID )))
130: ;
131:
175: AND rac.interface_header_attribute1 = prj.segment1
176: AND rac.interface_header_attribute2 = TO_CHAR(pdi.draft_invoice_num)
177: AND rac.interface_header_context = ( SELECT NAME
178: FROM
179: RA_BATCH_SOURCES RBS
180: ,PA_IMPLEMENTATIONS PI
181: WHERE
182: PI.INVOICE_BATCH_SOURCE_ID = BATCH_SOURCE_ID
183: ) --Bug 8204634
780: AND RAC.INTERFACE_HEADER_ATTRIBUTE1 = PRJ.SEGMENT1
781: AND RAC.INTERFACE_HEADER_ATTRIBUTE2 = TO_CHAR(PDII.DRAFT_INVOICE_NUM)
782: AND RAC.INTERFACE_HEADER_CONTEXT = ( SELECT NAME
783: FROM
784: RA_BATCH_SOURCES RBS
785: ,PA_IMPLEMENTATIONS PI
786: WHERE
787: PI.INVOICE_BATCH_SOURCE_ID = BATCH_SOURCE_ID
788: ) --Bug 8204634
811: AND RAC.INTERFACE_HEADER_ATTRIBUTE1 = PRJ.SEGMENT1
812: AND RAC.INTERFACE_HEADER_ATTRIBUTE2 = TO_CHAR(PDI.DRAFT_INVOICE_NUM)
813: AND RAC.INTERFACE_HEADER_CONTEXT = ( SELECT NAME
814: FROM
815: RA_BATCH_SOURCES RBS
816: ,PA_IMPLEMENTATIONS PI
817: WHERE
818: PI.INVOICE_BATCH_SOURCE_ID = BATCH_SOURCE_ID
819: )--Bug 8204634