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_RCTA_TRIGGER_PKG dependencies on JAI_AR_TRX_LINES

Line 336: from JAI_AR_TRX_LINES

332: from JAI_AR_TRX_TAX_LINES
333: where link_to_cust_trx_line_id
334: in
335: (select customer_trx_line_id
336: from JAI_AR_TRX_LINES
337: where customer_trx_id = pr_new.customer_trx_id
338: )
339: and tax_id in
340: (select tax_id

Line 582: Update JAI_AR_TRX_LINES

578: THEN
579: Update JAI_AR_TRXS
580: Set Customer_Trx_ID = pr_new.Customer_Trx_ID
581: Where Customer_Trx_ID = pr_old.Customer_Trx_ID;
582: Update JAI_AR_TRX_LINES
583: Set Customer_Trx_Id = pr_new.Customer_Trx_ID
584: Where Customer_Trx_ID = pr_old.Customer_Trx_ID;
585: END IF;
586:

Line 687: JAI_AR_TRX_LINES jctl,

683: regime_id ,
684: regime_code
685: FROM
686: JAI_AR_TRX_TAX_LINES jcttl,
687: JAI_AR_TRX_LINES jctl,
688: JAI_CMN_TAXES_ALL jtc ,
689: jai_regime_tax_types_v jrttv
690: WHERE
691: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND

Line 729: JAI_AR_TRX_LINES jctl,

725: SELECT
726: 1
727: FROM
728: JAI_AR_TRX_TAX_LINES jcttl,
729: JAI_AR_TRX_LINES jctl,
730: JAI_CMN_TAXES_ALL jtc
731: WHERE
732: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
733: jctl.customer_trx_id = pr_new.customer_trx_id AND

Line 1103: FROM JAI_AR_TRX_LINES

1099:
1100: CURSOR line_cur IS
1101: SELECT customer_trx_line_id, inventory_item_id, quantity,line_number,
1102: excise_exempt_type, assessable_value
1103: FROM JAI_AR_TRX_LINES
1104: WHERE customer_trx_id = v_customer_trx_id
1105: ORDER BY customer_trx_line_id;
1106:
1107: CURSOR matched_qty_cur (p_customer_trx_line_id NUMBER) IS

Line 1233: JAI_AR_TRX_LINES jtl,

1229: --3661746
1230: CURSOR c_total_Excise_amt IS
1231: SELECT nvl(sum(jrtl.func_tax_amount),0)
1232: FROM JAI_AR_TRXS jtrx,
1233: JAI_AR_TRX_LINES jtl,
1234: JAI_AR_TRX_TAX_LINES jrtl,
1235: JAI_CMN_TAXES_ALL jtc ,
1236: JAI_INV_ITM_SETUPS jmtl
1237: WHERE jrtl.tax_id = jtc.tax_id

Line 1261: FROM JAI_AR_TRX_LINES

1257: JAI_CMN_TAXES_ALL jtc
1258: WHERE jtc.tax_id = jrctl.tax_id
1259: AND link_to_cust_trx_line_id IN
1260: (SELECT customer_trx_line_id
1261: FROM JAI_AR_TRX_LINES
1262: WHERE customer_trx_id = pr_new.customer_trx_id
1263: )
1264: AND upper(jtc.tax_type) IN (upper(jai_constants.tax_type_cvd_edu_cess), upper(jai_constants.tax_type_exc_edu_cess));
1265:

Line 1297: JAI_AR_TRX_LINES jctl,

1293: regime_id ,
1294: regime_code
1295: FROM
1296: JAI_AR_TRX_TAX_LINES jcttl,
1297: JAI_AR_TRX_LINES jctl,
1298: JAI_CMN_TAXES_ALL jtc ,
1299: jai_regime_tax_types_v jrttv
1300: WHERE
1301: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND

Line 1318: JAI_AR_TRX_LINES jctl,

1314: SELECT
1315: 1
1316: FROM
1317: JAI_AR_TRX_TAX_LINES jcttl,
1318: JAI_AR_TRX_LINES jctl,
1319: JAI_CMN_TAXES_ALL jtc
1320: WHERE
1321: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
1322: jctl.customer_trx_id = pr_new.customer_trx_id AND

Line 1366: JAI_AR_TRX_LINES

1362: IS
1363: SELECT
1364: excise_invoice_no
1365: FROM
1366: JAI_AR_TRX_LINES
1367: WHERE
1368: customer_trx_id = pr_new.customer_trx_id ;
1369:
1370:

Line 1755: UPDATE JAI_AR_TRX_LINES

1751: END IF;
1752:
1753: IF NVL(v_item_class,'~') not in ('OTIN') THEN
1754:
1755: UPDATE JAI_AR_TRX_LINES
1756: SET EXCISE_INVOICE_NO = v_invoice_no ,
1757: EXCISE_INVOICE_DATE = SYSDATE
1758: WHERE CUSTOMER_TRX_LINE_ID = LINE_REC.customer_trx_line_id AND
1759: INVENTORY_ITEM_ID = LINE_REC.inventory_item_id AND

Line 2011: UPDATE JAI_AR_TRX_LINES

2007: /*
2008: Ends here
2009: */
2010:
2011: UPDATE JAI_AR_TRX_LINES
2012: SET PAYMENT_REGISTER = v_excise_paid_register
2013: WHERE CUSTOMER_TRX_LINE_ID = LINE_REC.customer_trx_line_id AND
2014: INVENTORY_ITEM_ID = LINE_REC.inventory_item_id AND
2015: CUSTOMER_TRX_ID = v_customer_trx_id;

Line 2124: UPDATE JAI_AR_TRX_LINES

2120: END;
2121: /*
2122: Ends here - Additions by Sriram
2123: */
2124: UPDATE JAI_AR_TRX_LINES
2125: SET PAYMENT_REGISTER = v_excise_paid_register
2126: WHERE CUSTOMER_TRX_LINE_ID = LINE_REC.customer_trx_line_id AND
2127: INVENTORY_ITEM_ID = LINE_REC.inventory_item_id AND
2128: CUSTOMER_TRX_ID = v_customer_trx_id;

Line 2436: SELECT * FROM JAI_AR_TRX_LINES

2432: -- CURSOR ADDED BY SRIRAM - BUG # 2654567
2433:
2434: CURSOR C_GET_TRX_DETAILS
2435: IS
2436: SELECT * FROM JAI_AR_TRX_LINES
2437: WHERE CUSTOMER_TRX_ID = pr_new.CUSTOMER_TRX_ID;
2438:
2439:
2440: CURSOR C_GET_TRX_COUNT

Line 2519: JAI_AR_TRX_LINES jctl,

2515: SELECT
2516: 1
2517: FROM
2518: JAI_AR_TRX_TAX_LINES jcttl,
2519: JAI_AR_TRX_LINES jctl,
2520: JAI_CMN_TAXES_ALL jtc
2521: WHERE
2522: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
2523: jctl.customer_trx_id = pr_new.customer_trx_id AND

Line 2858: From JAI_AR_TRX_LINES

2854: -- And NVL(a.org_id,0) = v_org_id;
2855:
2856: Cursor Ar_Line_Cur IS
2857: Select Customer_Trx_Line_ID, Inventory_Item_ID, Unit_Code, Line_Amount, Quantity,unit_selling_price
2858: From JAI_AR_TRX_LINES
2859: Where Customer_Trx_ID = v_header_id;
2860:
2861: /* Bug 5243532. Added by Lakshmi Gopalsami
2862: Removed the reference to set_of_books_cur

Line 2866: ln_vat_assessable_value JAI_AR_TRX_LINES.VAT_ASSESSABLE_VALUE%TYPE;

2862: Removed the reference to set_of_books_cur
2863: which is selecting SOB from org_organization_definitions
2864: as the SOB will never by null in base table.
2865: */
2866: ln_vat_assessable_value JAI_AR_TRX_LINES.VAT_ASSESSABLE_VALUE%TYPE;
2867:
2868: -- Added by sacsethi for bug 5631784 on 30-01-2007
2869: -- START 5631784
2870: LN_TCS_EXISTS NUMBER;

Line 3192: UPDATE JAI_AR_TRX_LINES

3188:
3189: END IF;
3190:
3191: v_service_type:=JAI_AR_RCTLA_TRIGGER_PKG.get_service_type( v_customer_id,v_ship_to_site_use_id ,'C'); --added by csahoo for Bug#5879769
3192: UPDATE JAI_AR_TRX_LINES
3193: SET tax_category_id = v_tax_category_id,
3194: service_type_code = v_service_type, --added by csahoo for Bug#5879769
3195: assessable_value = nvl(v_price_list,0),
3196: vat_assessable_value = ln_vat_assessable_value,

Line 3388: FROM JAI_AR_TRX_LINES

3384: CURSOR LINES_INFO_CUR(p_parent_header_id IN Number) IS
3385: SELECT customer_trx_line_id, line_number, description, inventory_item_id, unit_code, quantity, tax_category_id,
3386: auto_invoice_flag, unit_selling_price, line_amount, gl_date,
3387: tax_amount,total_amount,assessable_value
3388: FROM JAI_AR_TRX_LINES
3389: WHERE customer_trx_id = p_parent_header_id
3390: ORDER BY customer_trx_line_id;
3391:
3392: CURSOR TAX_INFO_CUR(p_parent_line_id IN NUMBER) IS

Line 3469: INSERT INTO JAI_AR_TRX_LINES

3465: LOOP
3466:
3467: -- SELECT ra_customer_trx_lines_s.nextval INTO v_customer_trx_line_id FROM Dual;
3468:
3469: INSERT INTO JAI_AR_TRX_LINES
3470: (customer_trx_line_id, line_number,
3471: customer_trx_id, description,
3472: inventory_item_id, unit_code,
3473: quantity, tax_category_id,auto_invoice_flag ,

Line 3524: UPDATE JAI_AR_TRX_LINES

3520: v_header_tax_amount := nvl(v_header_tax_amount,0) + nvl(rec1.tax_amount,0);
3521: END IF;
3522:
3523: END LOOP;
3524: UPDATE JAI_AR_TRX_LINES
3525: SET tax_amount = v_line_tax_amount,
3526: total_amount = nvl(line_amount,0) + v_line_tax_amount
3527: WHERE customer_trx_line_id = v_customer_trx_line_id;
3528: v_line_tax_amount := 0;