[Home] [Help]
81: /* Modified the cursor get_match_item_cur for bug 14507573 */
82: CURSOR get_match_item_cur IS
83:
84: SELECT line.match_type,line.line_number
85: FROM ap_invoice_lines_all line, jai_ap_match_inv_taxes jamt
86: WHERE line.invoice_id = pr_new.invoice_id
87: and jamt.invoice_id=line.invoice_id
88: and jamt.invoice_distribution_id=nvl(pr_new.parent_reversal_id,pr_new.invoice_distribution_id) /*Modified for bug 16393213 */
89: and jamt.po_distribution_id=pr_new.po_distribution_id
123: AND parent_invoice_line_number IS NULL;
124:
125: CURSOR get_po_matched_org_cur(pn_line_number NUMBER) IS
126: SELECT po.ship_to_organization_id, po.ship_to_location_id
127: FROM po_line_locations_all po,ap_invoice_lines_all ap
128: WHERE po.line_location_id = ap.po_line_location_id
129: AND ap.invoice_id = pr_new.invoice_id
130: AND ap.line_number = pn_line_number;
131:
130: AND ap.line_number = pn_line_number;
131:
132: CURSOR get_rcpt_matched_org_cur(pn_line_number NUMBER) IS
133: SELECT rcv.organization_id, rcv.location_id
134: FROM jai_rcv_transactions rcv, ap_invoice_lines_all ap
135: WHERE ap.rcv_transaction_id = rcv.transaction_id
136: AND ap.invoice_id = pr_new.invoice_id
137: AND ap.line_number = pn_line_number;
138:
369: 20. 20-DEC-2012 Qiong for reverse charge bug#16001407.
370:
371: 20. 31-Aug-2012 amandali for bug 14507573
372: Description:Service Tax accounting not happening for PO matched invoice having multiple distributions
373: Fix:Modified the cursor get_match_item_cur as the po_distribution_id would be null in ap_invoice_lines_all for a PO line having multiple distributions.
374:
375: 21. 18-Feb-2013 amandali for bug 16241506.
376: issue: STandard line accounting is not happening for a cancelled invoice when the accounting
377: is run after cancellation only.
1154:
1155:
1156: Cursor get_line_amt(cp_invoice_id number,cp_inv_lineno number) is
1157: select nvl(amount,0)
1158: from ap_invoice_lines_all
1159: where invoice_id = cp_invoice_id
1160: and line_number=cp_inv_lineno;
1161:
1162: