[Home] [Help]
577: /* Bug 4224466. Added by LGOPALSA */
578: a.invoice_currency_code
579: FROM ra_customer_trx_all a,
580: ra_customer_trx_lines_all b,
581: mtl_system_items c,
582: jai_ar_trx_sup_inv_t d, -- added by sriram - bug # 3143813 - 19/09/2003
583: jai_ar_trxs jat /* added the table and join condition - aiyer for the fwd porting bug 5225768*/
584: WHERE a.customer_trx_id = b.customer_trx_id
585: AND b.inventory_item_id = c.inventory_item_id
805: Commented the Select..Into statment and added a Cursor. Added the cursor c_get_so_picking_lines which considers all the lines
806: (result of split) to get the Total Quantity and Total Tax Amount. (11i bug 4764676, Fwd porting bug 4955151)
807:
808: 4. Bug 5104197:-
809: Modified the cursor get_inv_line. Removed the join condition for organization_id of mtl_system_items and
810: warehouse_id of ra_customer_trx_lines_all. Included a join condition for organization_id of mtl_system_items and jai_ar_trx.
811: This has been done because there are cases where the warehouse_id in the ra_customer_trx_lines_all is null. Hence removed that link.
812: (11i bug 5104197, fwd porting bug 5225768)
813:
806: (result of split) to get the Total Quantity and Total Tax Amount. (11i bug 4764676, Fwd porting bug 4955151)
807:
808: 4. Bug 5104197:-
809: Modified the cursor get_inv_line. Removed the join condition for organization_id of mtl_system_items and
810: warehouse_id of ra_customer_trx_lines_all. Included a join condition for organization_id of mtl_system_items and jai_ar_trx.
811: This has been done because there are cases where the warehouse_id in the ra_customer_trx_lines_all is null. Hence removed that link.
812: (11i bug 5104197, fwd porting bug 5225768)
813:
814: