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 778: jai_om_wsh_lines_all A

774: SUM(a.quantity), SUM(a.tax_amount),
775: a.selling_price, a.unit_code, a.tax_category_id,
776: a.picking_line_id, a.assessable_value
777: FROM
778: jai_om_wsh_lines_all A
779: WHERE
780: to_char(a.delivery_id) = p_interface_line_attribute3
781: AND to_char(a.order_line_id) = p_interface_line_attribute6
782: AND a.inventory_item_id = p_inventory_item_id

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

819: seperate code that reduces/adds discounts/surcharges from actual item price.
820: Added Cursor c_adjustment_details and required variables for discounts/surchages calculation
821: - Cursor C_PRICE_LIST_INFO is modified to use qp_list_lines_v View instead of qp_list_lines and qp_pricing_attributes tables.
822: Added inventory_item_id, Start and end date checks to where clause on qp_list_lines_v
823: - Query to fetch details from JAI_OM_WSH_LINES_ALL is modified by adding Order_line_id filter.
824: Also removed the usage of RA_CUSTOMER_TRX_LINES_ALL table from the query which is redundant
825:
826: 5. 15/03/2005 Bug 4224466. Added by LGOPALSA. Version 115.2
827: Added rounding code for Exist and new Sales amount.