[Home] [Help]
67: jai_trx_repo_extract_gt for standalone invoice.
68:
69: 15. 08-Oct-2009 CSahoo for bug#8965721, File Version 120.19.12010000.7
70: Issue: TST1212.XB2.QA:SERVICE TAX CREDIT NOT ACCOUNTED FOR GOODS TRANSPORT OPERATORS
71: Fix: Modified the cursor c_get_doc_details. Replaced rcv_transactions by jai_rcv_transactions
72:
73: 16. 09-Dec-2009 CSahoo for bug#9192752, File Version 120.19.12010000.8
74: Issue: INTCUS:SERVCIE TAX PROCESSING LOG IS SHOWN ERROR MESSAGE
75: FIX: Modified the code in the procedure derrive_doc_from_ref. Moved the CLOSE cursor code
1757: ,rsl.po_header_id po_header_id
1758: ,rsl.po_line_id po_line_id
1759: ,rcv.transaction_id /*Bug 12902363*/
1760: from
1761: --jai_rcv_transactions rcv, 12560704
1762: rcv_transactions rcv ,
1763: rcv_shipment_lines rsl
1764: where
1765: rcv.shipment_header_id = rsl.shipment_header_id
2093: AND ap.line_number = pn_line_number;
2094:
2095: CURSOR get_rcpt_matched_org_cur(pn_line_number NUMBER) IS
2096: SELECT rcv.organization_id, rcv.location_id
2097: FROM jai_rcv_transactions rcv, ap_invoice_lines_all ap
2098: WHERE ap.rcv_transaction_id = rcv.transaction_id
2099: AND ap.invoice_id = p_document_id
2100: AND ap.line_number = pn_line_number;
2101:
2957: jrti.vendor_site_id vendor_site_id,
2958: row_number() over(
2959: ORDER BY jrtxl.shipment_line_id,jrtxl.tax_line_no) rn
2960: FROM jai_rcv_lines jrt,
2961: jai_rcv_transactions jirt,/* modified by vumaasha for bug 8965721 */
2962: jai_rcv_tp_invoices jrti,
2963: jai_rcv_line_taxes jrtxl -- join to ja_in_receipt_tax_lines added by vumaasha for 6856213
2964: WHERE jrt.shipment_header_id = jrti.shipment_header_id
2965: AND jrti.invoice_id = p_invoice_id