[Home] [Help]
22: 5. 24-Sep-2007 vkantamn 6083978 120.8 The org_id for the po has been changed to fetch from the
23: PO table.
24: Also New transaction source 'RECEIVING' has been added,
25: and the org_id has been picked from the
26: ja_in_rcv_transactions for the above invoices.
27: 6. 04-Oct-2007 CSahoo 6457710 120.9 Added a ELSIF block related to projects in the procedure extract_rgm_trxs.
28:
29: 7. 10-Oct-2007 CSahoo 6457710 120.10 Modified the follwing cursors in get_document_details procedure
30: c_get_po_line_loc_srvtyp
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
646: pha.segment1 po_num,
647: aia.invoice_date
648: from
649: po_headers_all pha,
650: rcv_transactions rt,
651: rcv_shipment_headers rsh,
652: ap_invoices_all aia
653: where
654: rsh.receipt_num=substr(aia.invoice_num,instr(aia.invoice_num,'/',1,1)+1,instr(aia.invoice_num,'/',1,2)-instr(aia.invoice_num,'/',1,1)-1) AND
1474: ,rsl.item_id inventory_item_id
1475: ,rsh.vendor_id party_id
1476: ,hl.inventory_organization_id organization_id
1477: ,rsl.ship_to_location_id location_id
1478: from rcv_transactions rta
1479: , rcv_shipment_headers rsh
1480: , rcv_shipment_lines rsl
1481: , po_lines_all pla
1482: , mtl_system_items msi
1625: is
1626: select service_type_code, sum(jrlt.tax_amount) service_tax_amount
1627: from JAI_PO_LINE_LOCATIONS jpoll
1628: ,jai_rcv_line_taxes jrlt
1629: ,rcv_transactions rt
1630: where jpoll.po_line_id = cp_po_line_id
1631: and rt.po_line_id = cp_po_line_id
1632: and rt.transaction_type = 'DELIVER'
1633: and rt.shipment_header_id = jrlt.shipment_header_id
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
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
1766: and rcv.shipment_line_id = rsl.shipment_line_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
3396: /* Cursor Added by vkantamn for Bug#6083978 */
3397: cursor c_rcv_trans(cp_rcv_trans_id number)
3398: is
3399: select shipment_header_id,shipment_line_id
3400: from rcv_transactions
3401: where transaction_id = cp_rcv_trans_id;
3402:
3403: /* Addition done by vkantamn for Bug#6083978 */
3404: