[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
232: pha.segment1 po_num,
233: aia.invoice_date
234: from
235: po_headers_all pha,
236: rcv_transactions rt,
237: rcv_shipment_headers rsh,
238: ap_invoices_all aia
239: where
240: 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
1069: select rcv.organization_id organization_id
1070: ,rcv.location_id location_id
1071: ,rsl.po_header_id po_header_id
1072: ,rsl.po_line_id po_line_id
1073: from jai_rcv_transactions rcv,
1074: rcv_shipment_lines rsl
1075: where
1076: rcv.shipment_header_id = rsl.shipment_header_id
1077: and rcv.shipment_line_id = rsl.shipment_line_id
1562: jrti.vendor_site_id vendor_site_id,
1563: row_number() over(
1564: ORDER BY jrtxl.shipment_line_id,jrtxl.tax_line_no) rn
1565: FROM jai_rcv_lines jrt,
1566: rcv_transactions jirt,
1567: jai_rcv_tp_invoices jrti,
1568: jai_rcv_line_taxes jrtxl -- join to ja_in_receipt_tax_lines added by vumaasha for 6856213
1569: WHERE jrt.shipment_header_id = jrti.shipment_header_id
1570: AND jrti.invoice_id = p_invoice_id
1996: /* Cursor Added by vkantamn for Bug#6083978 */
1997: cursor c_rcv_trans(cp_rcv_trans_id number)
1998: is
1999: select shipment_header_id,shipment_line_id
2000: from rcv_transactions
2001: where transaction_id = cp_rcv_trans_id;
2002:
2003: /* Addition done by vkantamn for Bug#6083978 */
2004: