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_RCTLA_TRIGGER_PKG dependencies on JAI_OM_WSH_LINE_TAXES

Line 866: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,

862: A.func_tax_amount,
863: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
864: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
865: b.vat_invoice_no,b.vat_invoice_date
866: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,
867: JAI_CMN_TAXES_ALL c, wsh_new_deliveries D
868: WHERE A.delivery_detail_id = b.delivery_detail_id
869: AND A.tax_id=c.tax_id
870: and c.tax_type <> 'Modvat Recovery'/*Bug 4881426 bduvarag*/

Line 880: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,WSH_NEW_DELIVERIES C

876: CURSOR SO_PICKING_TAX_AMT(p_tax_id NUMBER) IS
877: SELECT SUM(A.base_tax_amount) base_tax_amount,
878: SUM(A.tax_amount) tax_amount,
879: SUM(A.func_tax_amount) func_tax_amount
880: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,WSH_NEW_DELIVERIES C
881: WHERE A.delivery_detail_id = b.delivery_detail_id
882: AND b.delivery_id = c.delivery_id
883: AND c.NAME = v_interface_line_attribute3
884: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6)

Line 993: FROM JAI_OM_WSH_LINE_TAXES A, JAI_OM_WSH_LINES_ALL b, WSH_NEW_DELIVERIES C

989: AND A.customer_trx_id = b.customer_trx_id;
990:
991: CURSOR SO_PICKING_TAX_RECORD_CHECK IS
992: SELECT DISTINCT 1
993: FROM JAI_OM_WSH_LINE_TAXES A, JAI_OM_WSH_LINES_ALL b, WSH_NEW_DELIVERIES C
994: WHERE A.delivery_detail_id = b.delivery_detail_id
995: AND b.delivery_id = C.DELIVERY_ID AND
996: c.NAME = v_interface_line_attribute3
997: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002

Line 3610: Check if taxes exist in JAI_OM_WSH_LINE_TAXES tables.

3606: FETCH so_picking_tax_record_check INTO v_exist_flag;
3607: CLOSE so_picking_tax_record_check;
3608:
3609: /*
3610: Check if taxes exist in JAI_OM_WSH_LINE_TAXES tables.
3611: IF yes then insert all the taxes into ja_in_ra_cust_trx_lines_all table
3612: IF no then check the same in ja_in_so_tax_lines_table.
3613:
3614: (

Line 3832: If records do not exist in JAI_OM_WSH_LINE_TAXES table then control comes to this portion of the code

3828:
3829:
3830: ELSE /* ELSE OF IF NVL(v_exist_flag,0) = 1 */
3831: /*
3832: If records do not exist in JAI_OM_WSH_LINE_TAXES table then control comes to this portion of the code
3833: */
3834: OPEN ja_so_lines_tax_record_check ;
3835: FETCH ja_so_lines_tax_record_check INTO v_exist_flag;
3836: CLOSE ja_so_lines_tax_record_check;

Line 3917: If taxes do not exist in JAI_OM_WSH_LINE_TAXES and JAI_OM_OE_SO_TAXES then control

3913:
3914: ELSE /* ELSE FOR IF NVL(v_exist_flag,0) = 1 */
3915: /*
3916: Update done by aiyer for the bug #3328871
3917: If taxes do not exist in JAI_OM_WSH_LINE_TAXES and JAI_OM_OE_SO_TAXES then control
3918: would come here.
3919: Code should return only in case of an RMA i.e return only when a line does not exist in JAI_OM_OE_SO_LINES table
3920: for the given line_id.
3921: */