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 722: Amount in JAI_AR_SUP_LINES need to be rounded with

718: AND c.list_line_id = b.list_line_id
719: AND NVL(TRUNC(b.end_date_active),TRUNC(SYSDATE)) >= TRUNC(ADATE);
720:
721: /* Bug 4224466. Added by LGOPALSA.
722: Amount in JAI_AR_SUP_LINES need to be rounded with
723: respect to currency precision as the same is recorded
724: in ra_interface_lines_all */
725:
726: Cursor get_curr_prec( lv_currency_code varchar2) is

Line 792: SELECT JAI_AR_SUP_LINES_S.NEXTVAL

788: /*Commented below by JMEENA for bug#7567647 */
789: /*Added the below by Bgowrava for Bug#6139693
790: CURSOR c_get_sup_seq_val
791: IS
792: SELECT JAI_AR_SUP_LINES_S.NEXTVAL
793: FROM DUAL;
794:
795: v_cust_trx_line_no_s NUMBER;
796: v_cust_trx_line_no_s1 NUMBER;

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

885:
886:
887: 25-June-2007 Bgowrava for Bug#6139693, File Version 120.12
888: Added Cursor c_get_sup_seq_val which is used to generate sequence numbers from the sequence
889: JAI_AR_SUP_LINES_S. and this is used as the value for the customer_trx_line_id
890: of the table JAI_AR_SUP_LINES.
891:
892: 07-Jul-2007 Bgowrava for Bug#6139693, File Version 120.13
893: Added the NVL condition for the EXIST_NET_SALES_AMT fields in the update statements of

Line 890: of the table JAI_AR_SUP_LINES.

886:
887: 25-June-2007 Bgowrava for Bug#6139693, File Version 120.12
888: Added Cursor c_get_sup_seq_val which is used to generate sequence numbers from the sequence
889: JAI_AR_SUP_LINES_S. and this is used as the value for the customer_trx_line_id
890: of the table JAI_AR_SUP_LINES.
891:
892: 07-Jul-2007 Bgowrava for Bug#6139693, File Version 120.13
893: Added the NVL condition for the EXIST_NET_SALES_AMT fields in the update statements of
894: JAI_AR_SUP_HDRS_ALL.

Line 1194: INSERT INTO JAI_AR_SUP_LINES(

1190: OPEN c_get_sup_seq_val;
1191: FETCH c_get_sup_seq_val into v_cust_trx_line_no_s;
1192: CLOSE c_get_sup_seq_val; */
1193: /*bug#7567647 Replaced v_cust_trx_line_no_s with I.CUSTOMER_TRX_LINE_ID to insert in column CUSTOMER_TRX_LINE_ID and interface_line_Attribute2*/
1194: INSERT INTO JAI_AR_SUP_LINES(
1195: CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID, INVENTORY_ITEM_ID, LINE_NUMBER, SUP_INV_TYPE,
1196: DESCRIPTION, QUANTITY, UNIT_CODE, TAX_CATEGORY_ID,
1197: OLD_SELLING_PRICE, NEW_SELLING_PRICE, EXIST_LINE_AMT, NEW_LINE_AMT,
1198: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,

Line 1337: INSERT INTO JAI_AR_SUP_LINES(

1333: CLOSE CHECK_SUPP_ASSESS_INV;
1334:
1335: v_statement_id := '39';
1336: /*bug#7567647 Replaced v_cust_trx_line_no_s with I.CUSTOMER_TRX_LINE_ID to insert in column CUSTOMER_TRX_LINE_ID and interface_line_Attribute2*/
1337: INSERT INTO JAI_AR_SUP_LINES(
1338: CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID, INVENTORY_ITEM_ID, LINE_NUMBER,
1339: DESCRIPTION, SUP_INV_TYPE, QUANTITY, UNIT_CODE,
1340: TAX_CATEGORY_ID, OLD_SELLING_PRICE, NEW_SELLING_PRICE,
1341: EXIST_LINE_AMT, NEW_LINE_AMT, LAST_UPDATE_DATE, LAST_UPDATED_BY,

Line 1693: SELECT 1 FROM JAI_AR_SUP_LINES

1689:
1690: v_statement_id := '72';
1691: DECLARE
1692: CURSOR CHECK_SUPP_LINES IS
1693: SELECT 1 FROM JAI_AR_SUP_LINES
1694: WHERE CUSTOMER_TRX_ID = FETCH_INV.CUSTOMER_TRX_ID
1695: AND CUSTOMER_TRX_LINE_ID = I.CUSTOMER_TRX_LINE_ID
1696: AND SUP_INV_TYPE = STATUS;
1697: BEGIN

Line 1721: INSERT INTO JAI_AR_SUP_LINES(

1717:
1718:
1719: v_statement_id := '75';
1720: /*bug#7567647 Replaced v_cust_trx_line_no_s with I.CUSTOMER_TRX_LINE_ID to insert in column CUSTOMER_TRX_LINE_ID and interface_line_Attribute2*/
1721: INSERT INTO JAI_AR_SUP_LINES(
1722: CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID, LINE_NUMBER, SUP_INV_TYPE,
1723: INVENTORY_ITEM_ID, DESCRIPTION, QUANTITY, UNIT_CODE,
1724: TAX_CATEGORY_ID, OLD_ASSESSABLE_VALUE, NEW_ASSESSABLE_VALUE, AL_MAPPING_ID,
1725: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY,interface_line_attribute2

Line 1739: UPDATE JAI_AR_SUP_LINES

1735: THEN
1736:
1737: v_statement_id := '76';
1738:
1739: UPDATE JAI_AR_SUP_LINES
1740: SET OLD_ASSESSABLE_VALUE = O_A_VAL,
1741: NEW_ASSESSABLE_VALUE = N_A_VAL,
1742: AL_MAPPING_ID = v_a_mapping_id
1743: WHERE CUSTOMER_TRX_ID = FETCH_INV.CUSTOMER_TRX_ID

Line 1844: UPDATE JAI_AR_SUP_LINES

1840: SELECT TAX_TYPE INTO NEW_TAX_TYPE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = B.TAX_ID;
1841:
1842: IF UPPER(OLD_TAX_TYPE) LIKE '%EXCISE%' THEN /*Added UPPER to include all excise type of taxes by mmurtuza for bug 16580917*/
1843: v_statement_id := '87';
1844: UPDATE JAI_AR_SUP_LINES
1845: SET EXIST_EXCISE_AMT = NVL(EXIST_EXCISE_AMT,0) + A.TAX_AMOUNT
1846: WHERE CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID
1847: AND SUP_INV_TYPE = STATUS;
1848:

Line 1857: UPDATE JAI_AR_SUP_LINES

1853: AND SUPP_INV_TYPE = STATUS;
1854:
1855: ELSIF UPPER(OLD_TAX_TYPE) NOT LIKE '%EXCISE%' THEN /*Added UPPER to exclude all excise type of taxes by mmurtuza for bug 16580917*/
1856: v_statement_id := '89';
1857: UPDATE JAI_AR_SUP_LINES
1858: SET EXIST_OTHER_AMT = NVL(EXIST_OTHER_AMT,0) + A.TAX_AMOUNT
1859: WHERE CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID
1860: AND SUP_INV_TYPE = STATUS;
1861:

Line 1872: UPDATE JAI_AR_SUP_LINES

1868: END IF;
1869:
1870: IF UPPER(NEW_TAX_TYPE) LIKE '%EXCISE%' THEN /*Added UPPER to include all excise type of taxes by mmurtuza for bug 16580917*/
1871: v_statement_id := '91';
1872: UPDATE JAI_AR_SUP_LINES
1873: SET NEW_EXCISE_AMT = NVL(NEW_EXCISE_AMT,0) + B.TAX_AMOUNT
1874: WHERE CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID
1875: AND SUP_INV_TYPE = STATUS;
1876:

Line 1887: UPDATE JAI_AR_SUP_LINES

1883:
1884: ELSIF UPPER(OLD_TAX_TYPE) NOT LIKE '%EXCISE%' THEN /*Added UPPER to exclude all excise type of taxes by mmurtuza for bug 16580917*/
1885:
1886: v_statement_id := '93';
1887: UPDATE JAI_AR_SUP_LINES
1888: SET NEW_OTHER_AMT = NVL(NEW_OTHER_AMT,0) + B.TAX_AMOUNT
1889: WHERE CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID
1890: AND SUP_INV_TYPE = STATUS;
1891:

Line 1906: UPDATE JAI_AR_SUP_LINES

1902: END IF;
1903:
1904: v_statement_id := '95';
1905: /* Replaced v_cust_trx_line_no_s with A.LINK_TO_CUST_TRX_LINE_ID for bug 7567647 by JMEENA */
1906: UPDATE JAI_AR_SUP_LINES
1907: SET EXCISE_DIFF_AMT = NVL(NEW_EXCISE_AMT,0) - NVL(EXIST_EXCISE_AMT,0),
1908: OTHER_DIFF_AMT = NVL(NEW_OTHER_AMT,0) - NVL(EXIST_OTHER_AMT,0)
1909: WHERE CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID;
1910:

Line 2035: JAI_AR_SUP_LINES a,

2031: a.unit_code, --2001/04/10 Anuradha Parthasarathy
2032: c.organization_id, --2001/05/10 Anuradha Parthasarathy,
2033: a.interface_line_attribute2
2034: from JAI_AR_SUP_HDRS_ALL b,
2035: JAI_AR_SUP_LINES a,
2036: JAI_AR_TRXS c
2037: where a.customer_trx_id = b.customer_trx_id
2038: and a.customer_trx_id = c.customer_trx_id
2039: and a.sup_inv_type = b.supp_inv_type

Line 2069: JAI_AR_SUP_LINES a,

2065: B.supp_INV_TYPE ,
2066: a.INVENTORY_ITEM_ID,
2067: a.interface_line_attribute2
2068: from JAI_AR_SUP_HDRS_ALL b,
2069: JAI_AR_SUP_LINES a,
2070: RA_CUST_TRX_LINE_SALESREPS_ALL C
2071: where a.customer_trx_id = b.customer_trx_id
2072: and a.sup_inv_type = b.supp_inv_type
2073: and c.customer_trx_line_id = a.customer_Trx_line_id

Line 2096: JAI_AR_SUP_LINES a,

2092: B.supp_INV_TYPE ,
2093: INVENTORY_ITEM_ID,
2094: D.SALES_CREDIT_TYPE_ID
2095: from JAI_AR_SUP_HDRS_ALL b,
2096: JAI_AR_SUP_LINES a,
2097: RA_CUST_TRX_LINE_SALESREPS_ALL C,
2098: ra_salesreps_all d
2099: where a.customer_trx_id = b.customer_trx_id
2100: and a.sup_inv_type = b.supp_inv_type

Line 2134: FROM JAI_AR_SUP_LINES K

2130: k.exist_line_amt,
2131: k.new_line_amt,
2132: k.unit_code, --2001/04/10 Anuradha Parthasarathy
2133: k.interface_line_attribute2 --4499078
2134: FROM JAI_AR_SUP_LINES K
2135: WHERE K.CUSTOMER_TRX_ID = INV
2136: AND K.SUP_INV_TYPE = TYPE;
2137:
2138: CURSOR GET_SALES_CRDT(INVLNO NUMBER) IS

Line 2144: JAI_AR_SUP_LINES B,

2140: A.revenue_percent_split,
2141: C.sales_credit_type_id,
2142: A.cust_trx_line_salesrep_id
2143: FROM RA_CUST_TRX_LINE_SALESREPS_ALL A,
2144: JAI_AR_SUP_LINES B,
2145: RA_SALESREPS_ALL C
2146: WHERE A.CUSTOMER_TRX_LINE_ID =INVLNO
2147: AND C.salesrep_id = A.salesrep_id;
2148: