DBA Data[Home] [Help]

APPS.JAI_AP_RPT_PRRG_PKG dependencies on JAI_AP_MATCH_INV_TAXES

Line 137: from JAI_AP_MATCH_INV_TAXES

133: p_invoice_id number,
134: p_parent_distribution_id number,
135: p_po_distribution_id number) is
136: select distribution_line_number, tax_id,invoice_distribution_id /*Changed by nprashar for bug # 6803557 */
137: from JAI_AP_MATCH_INV_TAXES
138: where invoice_id = p_invoice_id
139: and parent_invoice_distribution_id = p_parent_distribution_id
140: and po_distribution_id = p_po_distribution_id
141: union

Line 143: from JAI_AP_MATCH_INV_TAXES

139: and parent_invoice_distribution_id = p_parent_distribution_id
140: and po_distribution_id = p_po_distribution_id
141: union
142: select distribution_line_number, tax_id,invoice_distribution_id /*Changed by nprashar for bug # 6803557 */
143: from JAI_AP_MATCH_INV_TAXES
144: where invoice_id = p_invoice_id
145: and parent_invoice_distribution_id is null
146: and po_distribution_id is null
147: and (po_header_id, po_line_id, line_location_id)

Line 187: from JAI_AP_MATCH_INV_TAXES

183: where transaction_id = p_rcv_transaction_id)
184: and A.tax_id not in
185: (
186: select tax_id
187: from JAI_AP_MATCH_INV_TAXES
188: where invoice_id = p_invoice_id
189: and parent_invoice_distribution_id = p_parent_distribution_id
190: and po_distribution_id = p_po_distribution_id
191: union

Line 193: from JAI_AP_MATCH_INV_TAXES

189: and parent_invoice_distribution_id = p_parent_distribution_id
190: and po_distribution_id = p_po_distribution_id
191: union
192: select tax_id
193: from JAI_AP_MATCH_INV_TAXES
194: where invoice_id = p_invoice_id
195: and parent_invoice_distribution_id is null
196: and po_distribution_id is null
197: and (po_header_id, po_line_id, line_location_id)

Line 228: from JAI_AP_MATCH_INV_TAXES

224: where po_distribution_id = p_po_distribution_id)
225: and A.tax_id not in
226: (
227: select tax_id
228: from JAI_AP_MATCH_INV_TAXES
229: where invoice_id = p_invoice_id
230: and parent_invoice_distribution_id = p_parent_distribution_id
231: and po_distribution_id = p_po_distribution_id
232: union

Line 234: from JAI_AP_MATCH_INV_TAXES

230: and parent_invoice_distribution_id = p_parent_distribution_id
231: and po_distribution_id = p_po_distribution_id
232: union
233: select tax_id
234: from JAI_AP_MATCH_INV_TAXES
235: where invoice_id = p_invoice_id
236: and parent_invoice_distribution_id is null
237: and po_distribution_id is null
238: and (po_header_id, po_line_id, line_location_id)