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_AR_SUP_LINES

Line 650: Amount in JAI_AR_SUP_LINES need to be rounded with

646: AND c.list_line_id = b.list_line_id
647: AND NVL(TRUNC(b.end_date_active),TRUNC(SYSDATE)) >= TRUNC(ADATE);
648:
649: /* Bug 4224466. Added by LGOPALSA.
650: Amount in JAI_AR_SUP_LINES need to be rounded with
651: respect to currency precision as the same is recorded
652: in ra_interface_lines_all */
653:
654: Cursor get_curr_prec( lv_currency_code varchar2) is

Line 720: SELECT JAI_AR_SUP_LINES_S.NEXTVAL

716:
717: /*Added the below by Bgowrava for Bug#6139693*/
718: CURSOR c_get_sup_seq_val
719: IS
720: SELECT JAI_AR_SUP_LINES_S.NEXTVAL
721: FROM DUAL;
722:
723: v_cust_trx_line_no_s NUMBER;
724: v_cust_trx_line_no_s1 NUMBER;

Line 817: JAI_AR_SUP_LINES_S. and this is used as the value for the customer_trx_line_id

813:
814:
815: 25-June-2007 Bgowrava for Bug#6139693, File Version 120.12
816: Added Cursor c_get_sup_seq_val which is used to generate sequence numbers from the sequence
817: JAI_AR_SUP_LINES_S. and this is used as the value for the customer_trx_line_id
818: of the table JAI_AR_SUP_LINES.
819:
820: 07-Jul-2007 Bgowrava for Bug#6139693, File Version 120.13
821: Added the NVL condition for the EXIST_NET_SALES_AMT fields in the update statements of

Line 818: of the table JAI_AR_SUP_LINES.

814:
815: 25-June-2007 Bgowrava for Bug#6139693, File Version 120.12
816: Added Cursor c_get_sup_seq_val which is used to generate sequence numbers from the sequence
817: JAI_AR_SUP_LINES_S. and this is used as the value for the customer_trx_line_id
818: of the table JAI_AR_SUP_LINES.
819:
820: 07-Jul-2007 Bgowrava for Bug#6139693, File Version 120.13
821: Added the NVL condition for the EXIST_NET_SALES_AMT fields in the update statements of
822: JAI_AR_SUP_HDRS_ALL.

Line 1091: INSERT INTO JAI_AR_SUP_LINES(

1087: OPEN c_get_sup_seq_val;
1088: FETCH c_get_sup_seq_val into v_cust_trx_line_no_s;
1089: CLOSE c_get_sup_seq_val;
1090:
1091: INSERT INTO JAI_AR_SUP_LINES(
1092: CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID, INVENTORY_ITEM_ID, LINE_NUMBER, SUP_INV_TYPE,
1093: DESCRIPTION, QUANTITY, UNIT_CODE, TAX_CATEGORY_ID,
1094: OLD_SELLING_PRICE, NEW_SELLING_PRICE, EXIST_LINE_AMT, NEW_LINE_AMT,
1095: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,

Line 1226: INSERT INTO JAI_AR_SUP_LINES(

1222: CLOSE CHECK_SUPP_ASSESS_INV;
1223:
1224: v_statement_id := '39';
1225:
1226: INSERT INTO JAI_AR_SUP_LINES(
1227: CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID, INVENTORY_ITEM_ID, LINE_NUMBER,
1228: DESCRIPTION, SUP_INV_TYPE, QUANTITY, UNIT_CODE,
1229: TAX_CATEGORY_ID, OLD_SELLING_PRICE, NEW_SELLING_PRICE,
1230: EXIST_LINE_AMT, NEW_LINE_AMT, LAST_UPDATE_DATE, LAST_UPDATED_BY,

Line 1568: SELECT 1 FROM JAI_AR_SUP_LINES

1564:
1565: v_statement_id := '72';
1566: DECLARE
1567: CURSOR CHECK_SUPP_LINES IS
1568: SELECT 1 FROM JAI_AR_SUP_LINES
1569: WHERE CUSTOMER_TRX_ID = FETCH_INV.CUSTOMER_TRX_ID
1570: AND CUSTOMER_TRX_LINE_ID = I.CUSTOMER_TRX_LINE_ID
1571: AND SUP_INV_TYPE = STATUS;
1572: BEGIN

Line 1594: INSERT INTO JAI_AR_SUP_LINES(

1590: CLOSE c_get_sup_seq_val;
1591:
1592: v_statement_id := '75';
1593:
1594: INSERT INTO JAI_AR_SUP_LINES(
1595: CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID, LINE_NUMBER, SUP_INV_TYPE,
1596: INVENTORY_ITEM_ID, DESCRIPTION, QUANTITY, UNIT_CODE,
1597: TAX_CATEGORY_ID, OLD_ASSESSABLE_VALUE, NEW_ASSESSABLE_VALUE, AL_MAPPING_ID,
1598: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY,interface_line_attribute2

Line 1612: UPDATE JAI_AR_SUP_LINES

1608: THEN
1609:
1610: v_statement_id := '76';
1611:
1612: UPDATE JAI_AR_SUP_LINES
1613: SET OLD_ASSESSABLE_VALUE = O_A_VAL,
1614: NEW_ASSESSABLE_VALUE = N_A_VAL,
1615: AL_MAPPING_ID = v_a_mapping_id
1616: WHERE CUSTOMER_TRX_ID = FETCH_INV.CUSTOMER_TRX_ID

Line 1717: UPDATE JAI_AR_SUP_LINES

1713: SELECT TAX_TYPE INTO NEW_TAX_TYPE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = B.TAX_ID;
1714:
1715: IF OLD_TAX_TYPE LIKE '%Excise%' THEN
1716: v_statement_id := '87';
1717: UPDATE JAI_AR_SUP_LINES
1718: SET EXIST_EXCISE_AMT = NVL(EXIST_EXCISE_AMT,0) + A.TAX_AMOUNT
1719: WHERE CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID
1720: AND SUP_INV_TYPE = STATUS;
1721:

Line 1730: UPDATE JAI_AR_SUP_LINES

1726: AND SUPP_INV_TYPE = STATUS;
1727:
1728: ELSIF OLD_TAX_TYPE NOT LIKE '%Excise%' THEN
1729: v_statement_id := '89';
1730: UPDATE JAI_AR_SUP_LINES
1731: SET EXIST_OTHER_AMT = NVL(EXIST_OTHER_AMT,0) + A.TAX_AMOUNT
1732: WHERE CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID
1733: AND SUP_INV_TYPE = STATUS;
1734:

Line 1745: UPDATE JAI_AR_SUP_LINES

1741: END IF;
1742:
1743: IF NEW_TAX_TYPE LIKE '%Excise%' THEN
1744: v_statement_id := '91';
1745: UPDATE JAI_AR_SUP_LINES
1746: SET NEW_EXCISE_AMT = NVL(NEW_EXCISE_AMT,0) + B.TAX_AMOUNT
1747: WHERE CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID
1748: AND SUP_INV_TYPE = STATUS;
1749:

Line 1760: UPDATE JAI_AR_SUP_LINES

1756:
1757: ELSIF OLD_TAX_TYPE NOT LIKE '%Excise%' THEN
1758:
1759: v_statement_id := '93';
1760: UPDATE JAI_AR_SUP_LINES
1761: SET NEW_OTHER_AMT = NVL(NEW_OTHER_AMT,0) + B.TAX_AMOUNT
1762: WHERE CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID
1763: AND SUP_INV_TYPE = STATUS;
1764:

Line 1778: UPDATE JAI_AR_SUP_LINES

1774:
1775: END IF;
1776:
1777: v_statement_id := '95';
1778: UPDATE JAI_AR_SUP_LINES
1779: SET EXCISE_DIFF_AMT = NVL(NEW_EXCISE_AMT,0) - NVL(EXIST_EXCISE_AMT,0),
1780: OTHER_DIFF_AMT = NVL(NEW_OTHER_AMT,0) - NVL(EXIST_OTHER_AMT,0)
1781: WHERE CUSTOMER_TRX_LINE_ID = v_cust_trx_line_no_s;
1782:

Line 1907: JAI_AR_SUP_LINES a,

1903: a.unit_code, --2001/04/10 Anuradha Parthasarathy
1904: c.organization_id, --2001/05/10 Anuradha Parthasarathy,
1905: a.interface_line_attribute2
1906: from JAI_AR_SUP_HDRS_ALL b,
1907: JAI_AR_SUP_LINES a,
1908: JAI_AR_TRXS c
1909: where a.customer_trx_id = b.customer_trx_id
1910: and a.customer_trx_id = c.customer_trx_id
1911: and a.sup_inv_type = b.supp_inv_type

Line 1940: JAI_AR_SUP_LINES a,

1936: B.supp_INV_TYPE ,
1937: a.INVENTORY_ITEM_ID,
1938: a.interface_line_attribute2
1939: from JAI_AR_SUP_HDRS_ALL b,
1940: JAI_AR_SUP_LINES a,
1941: RA_CUST_TRX_LINE_SALESREPS_ALL C
1942: where a.customer_trx_id = b.customer_trx_id
1943: and a.sup_inv_type = b.supp_inv_type
1944: and c.customer_trx_line_id = a.customer_Trx_line_id

Line 1967: JAI_AR_SUP_LINES a,

1963: B.supp_INV_TYPE ,
1964: INVENTORY_ITEM_ID,
1965: D.SALES_CREDIT_TYPE_ID
1966: from JAI_AR_SUP_HDRS_ALL b,
1967: JAI_AR_SUP_LINES a,
1968: RA_CUST_TRX_LINE_SALESREPS_ALL C,
1969: ra_salesreps_all d
1970: where a.customer_trx_id = b.customer_trx_id
1971: and a.sup_inv_type = b.supp_inv_type

Line 2005: FROM JAI_AR_SUP_LINES K

2001: k.exist_line_amt,
2002: k.new_line_amt,
2003: k.unit_code, --2001/04/10 Anuradha Parthasarathy
2004: k.interface_line_attribute2 --4499078
2005: FROM JAI_AR_SUP_LINES K
2006: WHERE K.CUSTOMER_TRX_ID = INV
2007: AND K.SUP_INV_TYPE = TYPE;
2008:
2009: CURSOR GET_SALES_CRDT(INVLNO NUMBER) IS

Line 2015: JAI_AR_SUP_LINES B,

2011: A.revenue_percent_split,
2012: C.sales_credit_type_id,
2013: A.cust_trx_line_salesrep_id
2014: FROM RA_CUST_TRX_LINE_SALESREPS_ALL A,
2015: JAI_AR_SUP_LINES B,
2016: RA_SALESREPS_ALL C
2017: WHERE A.CUSTOMER_TRX_LINE_ID =INVLNO
2018: AND C.salesrep_id = A.salesrep_id;
2019: