eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_SUP_TRX_PKG dependencies on JAI_OM_WSH_LINES_ALL

Line 706: jai_om_wsh_lines_all A

702: SUM(a.quantity), SUM(a.tax_amount),
703: a.selling_price, a.unit_code, a.tax_category_id,
704: a.picking_line_id, a.assessable_value
705: FROM
706: jai_om_wsh_lines_all A
707: WHERE
708: to_char(a.delivery_id) = p_interface_line_attribute3
709: AND to_char(a.order_line_id) = p_interface_line_attribute6
710: AND a.inventory_item_id = p_inventory_item_id

Line 751: - Query to fetch details from JAI_OM_WSH_LINES_ALL is modified by adding Order_line_id filter.

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
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.