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 934: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,

930: A.func_tax_amount,
931: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
932: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
933: b.vat_invoice_no,b.vat_invoice_date
934: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,
935: JAI_CMN_TAXES_ALL c, wsh_new_deliveries D
936: WHERE A.delivery_detail_id = b.delivery_detail_id
937: AND A.tax_id=c.tax_id
938: and c.tax_type <> 'Modvat Recovery'/*Bug 4881426 bduvarag*/

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

944: CURSOR SO_PICKING_TAX_AMT(p_tax_id NUMBER) IS
945: SELECT SUM(A.base_tax_amount) base_tax_amount,
946: SUM(A.tax_amount) tax_amount,
947: SUM(A.func_tax_amount) func_tax_amount
948: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,WSH_NEW_DELIVERIES C
949: WHERE A.delivery_detail_id = b.delivery_detail_id
950: AND b.delivery_id = c.delivery_id
951: -- AND c.NAME = v_interface_line_attribute3 -- commented for bug 14459402
952: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6)

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

1057: AND A.customer_trx_id = b.customer_trx_id;
1058:
1059: CURSOR SO_PICKING_TAX_RECORD_CHECK IS
1060: SELECT DISTINCT 1
1061: FROM JAI_OM_WSH_LINE_TAXES A, JAI_OM_WSH_LINES_ALL b, WSH_NEW_DELIVERIES C
1062: WHERE A.delivery_detail_id = b.delivery_detail_id
1063: AND b.delivery_id = C.DELIVERY_ID AND
1064: c.NAME = v_interface_line_attribute3
1065: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002

Line 3895: Check if taxes exist in JAI_OM_WSH_LINE_TAXES tables.

3891: FETCH so_picking_tax_record_check INTO v_exist_flag;
3892: CLOSE so_picking_tax_record_check;
3893:
3894: /*
3895: Check if taxes exist in JAI_OM_WSH_LINE_TAXES tables.
3896: IF yes then insert all the taxes into ja_in_ra_cust_trx_lines_all table
3897: IF no then check the same in ja_in_so_tax_lines_table.
3898:
3899: (

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

4122:
4123:
4124: ELSE /* ELSE OF IF NVL(v_exist_flag,0) = 1 */
4125: /*
4126: If records do not exist in JAI_OM_WSH_LINE_TAXES table then control comes to this portion of the code
4127: */
4128: OPEN ja_so_lines_tax_record_check ;
4129: FETCH ja_so_lines_tax_record_check INTO v_exist_flag;
4130: CLOSE ja_so_lines_tax_record_check;

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

4219:
4220: ELSE /* ELSE FOR IF NVL(v_exist_flag,0) = 1 */
4221: /*
4222: Update done by aiyer for the bug #3328871
4223: If taxes do not exist in JAI_OM_WSH_LINE_TAXES and JAI_OM_OE_SO_TAXES then control
4224: would come here.
4225: 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
4226: for the given line_id.
4227: */