[Home] [Help]
549: WHERE customer_trx_id = NO
550: AND supp_inv_type = STAT;
551:
552: CURSOR get_inv_line( ino NUMBER,
553: cp_line_type RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE
554: )
555: IS /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
556: SELECT
557: b.customer_trx_line_id,
576: d.new_type_id,
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
692: || If the split has happened at the time of shipment, this cursor will take care of the multiple lines
693: || to get the total quantity and total tax amount
694: */
695: CURSOR c_get_so_picking_lines(
696: p_interface_line_attribute3 RA_CUSTOMER_TRX_LINES_ALL.interface_line_attribute3%TYPE ,
697: p_interface_line_attribute6 RA_CUSTOMER_TRX_LINES_ALL.interface_line_attribute6%TYPE ,
698: p_inventory_item_id RA_CUSTOMER_TRX_LINES_ALL.inventory_item_id%TYPE
699: )
700: IS
693: || to get the total quantity and total tax amount
694: */
695: CURSOR c_get_so_picking_lines(
696: p_interface_line_attribute3 RA_CUSTOMER_TRX_LINES_ALL.interface_line_attribute3%TYPE ,
697: p_interface_line_attribute6 RA_CUSTOMER_TRX_LINES_ALL.interface_line_attribute6%TYPE ,
698: p_inventory_item_id RA_CUSTOMER_TRX_LINES_ALL.inventory_item_id%TYPE
699: )
700: IS
701: SELECT
694: */
695: CURSOR c_get_so_picking_lines(
696: p_interface_line_attribute3 RA_CUSTOMER_TRX_LINES_ALL.interface_line_attribute3%TYPE ,
697: p_interface_line_attribute6 RA_CUSTOMER_TRX_LINES_ALL.interface_line_attribute6%TYPE ,
698: p_inventory_item_id RA_CUSTOMER_TRX_LINES_ALL.inventory_item_id%TYPE
699: )
700: IS
701: SELECT
702: SUM(a.quantity), SUM(a.tax_amount),
742: Supplementary invoices in Ar are generated for all items in the invoice even though they are not part of the new price list. This has been rectified
743: by adding joins between the inventory item of the invoice and inventory item in the pricelist for price list types of mapping.
744:
745: 4. 28/03/2004 Vijay Shankar for bug # 3515883, Version: 619.1
746: - modified cursor GET_INV_LINE to filter out Modifier lines from RA_CUSTOMER_TRX_LINES_ALL table and added a
747: seperate code that reduces/adds discounts/surcharges from actual item price.
748: Added Cursor c_adjustment_details and required variables for discounts/surchages calculation
749: - Cursor C_PRICE_LIST_INFO is modified to use qp_list_lines_v View instead of qp_list_lines and qp_pricing_attributes tables.
750: Added inventory_item_id, Start and end date checks to where clause on qp_list_lines_v
748: Added Cursor c_adjustment_details and required variables for discounts/surchages calculation
749: - Cursor C_PRICE_LIST_INFO is modified to use qp_list_lines_v View instead of qp_list_lines and qp_pricing_attributes tables.
750: Added inventory_item_id, Start and end date checks to where clause on qp_list_lines_v
751: - Query to fetch details from JAI_OM_WSH_LINES_ALL is modified by adding Order_line_id filter.
752: Also removed the usage of RA_CUSTOMER_TRX_LINES_ALL table from the query which is redundant
753:
754: 5. 15/03/2005 Bug 4224466. Added by LGOPALSA. Version 115.2
755: Added rounding code for Exist and new Sales amount.
756:
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:
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:
815: 25-June-2007 Bgowrava for Bug#6139693, File Version 120.12
1007: v_modifier_percentage := 0;
1008: v_statement_id := '16';
1009: FOR dis IN (SELECT customer_trx_line_id, to_number(interface_line_attribute11) price_adjustment_id
1010: --, line_number, unit_standard_price, unit_selling_price, extended_amount, revenue_amount
1011: FROM ra_customer_trx_lines_all
1012: WHERE interface_line_attribute11 <> '0'
1013: AND interface_line_attribute6 = I.interface_line_attribute6
1014: AND customer_trx_id = fetch_inv.customer_trx_id
1015: AND line_type = 'LINE')