[Home] [Help]
648: a.invoice_currency_code
649: ,b.global_attribute_category --Added by zhiwei for Bug#12615714
650: FROM ra_customer_trx_all a,
651: ra_customer_trx_lines_all b,
652: mtl_system_items c,
653: jai_ar_trx_sup_inv_t d, -- added by sriram - bug # 3143813 - 19/09/2003
654: jai_ar_trxs jat /* added the table and join condition - aiyer for the fwd porting bug 5225768*/
655: WHERE a.customer_trx_id = b.customer_trx_id
656: AND b.inventory_item_id = c.inventory_item_id
877: Commented the Select..Into statment and added a Cursor. Added the cursor c_get_so_picking_lines which considers all the lines
878: (result of split) to get the Total Quantity and Total Tax Amount. (11i bug 4764676, Fwd porting bug 4955151)
879:
880: 4. Bug 5104197:-
881: Modified the cursor get_inv_line. Removed the join condition for organization_id of mtl_system_items and
882: warehouse_id of ra_customer_trx_lines_all. Included a join condition for organization_id of mtl_system_items and jai_ar_trx.
883: 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.
884: (11i bug 5104197, fwd porting bug 5225768)
885:
878: (result of split) to get the Total Quantity and Total Tax Amount. (11i bug 4764676, Fwd porting bug 4955151)
879:
880: 4. Bug 5104197:-
881: Modified the cursor get_inv_line. Removed the join condition for organization_id of mtl_system_items and
882: warehouse_id of ra_customer_trx_lines_all. Included a join condition for organization_id of mtl_system_items and jai_ar_trx.
883: 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.
884: (11i bug 5104197, fwd porting bug 5225768)
885:
886: