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_RCV_RND_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 94: v_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;

90: v_last_update_login NUMBER ; --File.Sql.35 Cbabu := nvl(FND_GLOBAL.LOGIN_ID,- 1);
91: v_today DATE ; --File.Sql.35 Cbabu := trunc(SYSDATE);
92:
93: v_shipment_header_id NUMBER;
94: v_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
95: v_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;
96: v_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;
97: v_line_type_a_cnt NUMBER ; --File.Sql.35 Cbabu := 0;
98: v_line_type_c_cnt NUMBER ; --File.Sql.35 Cbabu := 0;

Line 95: v_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;

91: v_today DATE ; --File.Sql.35 Cbabu := trunc(SYSDATE);
92:
93: v_shipment_header_id NUMBER;
94: v_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
95: v_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;
96: v_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;
97: v_line_type_a_cnt NUMBER ; --File.Sql.35 Cbabu := 0;
98: v_line_type_c_cnt NUMBER ; --File.Sql.35 Cbabu := 0;
99: v_tot_lines_cnt NUMBER ; --File.Sql.35 Cbabu := 0;

Line 96: v_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;

92:
93: v_shipment_header_id NUMBER;
94: v_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
95: v_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;
96: v_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;
97: v_line_type_a_cnt NUMBER ; --File.Sql.35 Cbabu := 0;
98: v_line_type_c_cnt NUMBER ; --File.Sql.35 Cbabu := 0;
99: v_tot_lines_cnt NUMBER ; --File.Sql.35 Cbabu := 0;
100:

Line 135: FROM JAI_CMN_RG_23AC_II_TRXS

131:
132: CURSOR c_slno_balance(p_organization_id IN NUMBER, p_location_id IN NUMBER,
133: p_fin_year IN NUMBER, p_register_type IN VARCHAR2) IS
134: SELECT slno, closing_balance
135: FROM JAI_CMN_RG_23AC_II_TRXS
136: WHERE organization_id = p_organization_id
137: AND location_id = p_location_id
138: AND fin_year = p_fin_year
139: AND register_type = p_register_type

Line 141: FROM JAI_CMN_RG_23AC_II_TRXS

137: AND location_id = p_location_id
138: AND fin_year = p_fin_year
139: AND register_type = p_register_type
140: AND slno = (SELECT max(slno) slno
141: FROM JAI_CMN_RG_23AC_II_TRXS
142: WHERE organization_id = p_organization_id
143: AND location_id = p_location_id
144: AND fin_year = p_fin_year
145: AND register_type = p_register_type);

Line 155: Where a.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS

151: p_register_type IN VARCHAR2,
152: p_tax_type IN VARCHAR2) is
153: Select nvl(a.closing_balance,0) closing_balance
154: from JAI_CMN_RG_OTHERS a
155: Where a.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS
156: AND a.source_register = DECODE(p_register_type,'A',jai_constants.reg_rg23a_2, 'C', jai_constants.reg_rg23c_2) --'RG23A_P2','C','RG23C_P2')
157: and a.tax_type = p_tax_type
158: AND abs(a.source_register_id) IN (Select max(abs(c.source_register_id))
159: from JAI_CMN_RG_23AC_II_TRXS b,

Line 159: from JAI_CMN_RG_23AC_II_TRXS b,

155: Where a.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS
156: AND a.source_register = DECODE(p_register_type,'A',jai_constants.reg_rg23a_2, 'C', jai_constants.reg_rg23c_2) --'RG23A_P2','C','RG23C_P2')
157: and a.tax_type = p_tax_type
158: AND abs(a.source_register_id) IN (Select max(abs(c.source_register_id))
159: from JAI_CMN_RG_23AC_II_TRXS b,
160: JAI_CMN_RG_OTHERS c
161: Where c.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS
162: AND c.source_register = DECODE(p_register_type,'A',jai_constants.reg_rg23a_2, 'C', jai_constants.reg_rg23c_2) --'RG23A_P2','C','RG23C_P2')
163: AND b.register_id = c.source_register_id

Line 161: Where c.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS

157: and a.tax_type = p_tax_type
158: AND abs(a.source_register_id) IN (Select max(abs(c.source_register_id))
159: from JAI_CMN_RG_23AC_II_TRXS b,
160: JAI_CMN_RG_OTHERS c
161: Where c.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS
162: AND c.source_register = DECODE(p_register_type,'A',jai_constants.reg_rg23a_2, 'C', jai_constants.reg_rg23c_2) --'RG23A_P2','C','RG23C_P2')
163: AND b.register_id = c.source_register_id
164: AND b.organization_id = p_organization_id
165: and b.location_id = p_location_id

Line 290: are modified to select JAI_CMN_RG_ROUND_LINES_S.nextval, the all the required data and punch Rounding_id in JAI_CMN_RG_23AC_II_TRXS in CORRECT RG records also

286: all the other scenarios only one rounding entry is passed
287:
288: 2 31/08/2004 Vijay Shankar for Bug# 3496408 Version : 115.1
289: Modified the code to consider CORRECTions of RECEIVE to round the CENVAT amount. Related Selects and Updates
290: are modified to select JAI_CMN_RG_ROUND_LINES_S.nextval, the all the required data and punch Rounding_id in JAI_CMN_RG_23AC_II_TRXS in CORRECT RG records also
291:
292: 3 21/01/2005 Sanjikum for Bug #4049363 Version 116.0 (115.2)
293: Modified the Code to consider the rounding for each tax type instead of total excise amount
294: Changed a lot of code. Can be searched with Bug#4049363

Line 327: update of JAI_CMN_RG_23AC_II_TRXS and subquery checking

323: GL Sources and GL Categories got changed. Refer bug for the details
324:
325: 10. 31-Jan-2006 Bug 4930048. Added by Lakshmi Gopalsami version 120.2
326: (1) Changed transaction_source_num to transaction_id in
327: update of JAI_CMN_RG_23AC_II_TRXS and subquery checking
328: for the existence in jai_rcv_transactions
329: (2) Changed transaction_source_num to transaction_id in
330: update of JAI_CMN_RG_PLA_TRXS and subquery checking
331: for the existence in jai_rcv_transactions

Line 333: update of JAI_CMN_RG_23AC_II_TRXS and subquery checking

329: (2) Changed transaction_source_num to transaction_id in
330: update of JAI_CMN_RG_PLA_TRXS and subquery checking
331: for the existence in jai_rcv_transactions
332: (3) Changed transaction_source_num to transaction_id in
333: update of JAI_CMN_RG_23AC_II_TRXS and subquery checking
334: for the existence in rcv_transactions
335: (4) Added proper alias names and changed
336: transaction_source_num to transaction_id while
337: checking data in rcv_transactions in update to

Line 338: JAI_CMN_RG_23AC_II_TRXS. This is done in 2 places.

334: for the existence in rcv_transactions
335: (4) Added proper alias names and changed
336: transaction_source_num to transaction_id while
337: checking data in rcv_transactions in update to
338: JAI_CMN_RG_23AC_II_TRXS. This is done in 2 places.
339:
340:
341: DEPENDENCY
342: ----------

Line 362: While inserting rounding for excise into JAI_CMN_RG_23AC_II_TRXS table the varibale v_register_type was

358: The rounding entries for CESS are hitting wrong register.
359:
360: Fix:
361:
362: While inserting rounding for excise into JAI_CMN_RG_23AC_II_TRXS table the varibale v_register_type was
363: used for register_type column. But for jai_rg_others while inserting the corresponding CESS the
364: parameter p_register_type is used for source_register and so the discrepancy. Replaced p_register_type with
365: v_register_type while inserting into jai_rg_others.
366:

Line 523: from JAI_CMN_RG_23AC_II_TRXS a, rcv_transactions b

519: sum(a.dr_basic_ed) dr_basic_ed,
520: sum(a.dr_additional_ed) dr_additional_ed,
521: sum(a.dr_additional_cvd) dr_additional_cvd, /*Column added by SACSETHI for the bug 5228046 - Additional CVD Enhancement */
522: sum(a.dr_other_ed) dr_other_ed
523: from JAI_CMN_RG_23AC_II_TRXS a, rcv_transactions b
524: where a.RECEIPT_REF = b.transaction_id
525: AND a.organization_id = p_organization_id
526: AND (
527: (p_ex_invoice_from_date IS NULL AND p_ex_invoice_to_date IS NULL)

Line 647: UPDATE JAI_CMN_RG_23AC_II_TRXS jcrg23ac

643:
644: IF v_proceed_for_2nd_claim = 'N' THEN
645: -- punching the rounding id found above in these transactions, so that they will not be considered again
646: v_statement_no := '1.2';
647: UPDATE JAI_CMN_RG_23AC_II_TRXS jcrg23ac
648: SET jcrg23ac.rounding_id = v_already_rounded_chk
649: WHERE jcrg23ac.excise_invoice_no = v_excise_invoice_no
650: AND jcrg23ac.excise_invoice_date = v_excise_invoice_date
651: AND nvl(vendor_id,-999) = nvl(r.vendor_id,-999)/*bgowrava for forward porting bug#5674376*/

Line 1057: UPDATE JAI_CMN_RG_23AC_II_TRXS jcrg23ac

1053: /* Bug 4930048. Added by Lakshmi Gopalsami
1054: Added proper alias names and changed transaction_source_num
1055: to transaction_id while checking data in rcv_transactions.
1056: */
1057: UPDATE JAI_CMN_RG_23AC_II_TRXS jcrg23ac
1058: SET jcrg23ac.rounding_id = 0
1059: WHERE jcrg23ac.organization_id = p_organization_id
1060: AND jcrg23ac.excise_invoice_no = v_excise_invoice_no
1061: AND jcrg23ac.excise_invoice_date = v_excise_invoice_date

Line 1241: INSERT INTO JAI_CMN_RG_23AC_II_TRXS(

1237: END IF;
1238:
1239: v_statement_no := '8.1';
1240:
1241: INSERT INTO JAI_CMN_RG_23AC_II_TRXS(
1242: REGISTER_ID, ORGANIZATION_ID, LOCATION_ID, FIN_YEAR, INVENTORY_ITEM_ID, SLNO,
1243: CR_BASIC_ED, DR_BASIC_ED,
1244: CR_ADDITIONAL_ED, DR_ADDITIONAL_ED, --Added by Sanjikum for Bug #4049363
1245: CR_ADDITIONAL_CVD,DR_ADDITIONAL_CVD, /* ADDED THE COLUMNS CR_ADDITIONAL_CVD,DR_ADDITIONAL_CVD FOR THE ENHANCEMENT 5228046 */

Line 1254: JAI_CMN_RG_23AC_II_TRXS_S.nextval, p_organization_id, r.location_id , v_fin_year, 0, v_slno,

1250: OPENING_BALANCE, CLOSING_BALANCE, CHARGE_ACCOUNT_ID,
1251: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN
1252: , TRANSACTION_DATE, OTHER_TAX_CREDIT, OTHER_TAX_DEBIT--Added by Sanjikum
1253: ) VALUES (
1254: JAI_CMN_RG_23AC_II_TRXS_S.nextval, p_organization_id, r.location_id , v_fin_year, 0, v_slno,
1255: --Added by Sanjikum for Bug #4049363
1256: v_rounded_cr_rg23_amount.basic, v_rounded_dr_rg23_amount.basic,
1257: v_rounded_cr_rg23_amount.additional, v_rounded_dr_rg23_amount.additional,
1258: v_rounded_cr_rg23_amount.additional_cvd, v_rounded_dr_rg23_amount.additional_cvd,/* added for the enhancement 5228046 */

Line 1507: UPDATE JAI_CMN_RG_23AC_II_TRXS jcrg23ac

1503: /* Bug 5207827. Added by Lakshmi Gopalsami
1504: Fixed performance issue for sql id - 17699668
1505: Removed EXISTS and added IN clause
1506: */
1507: UPDATE JAI_CMN_RG_23AC_II_TRXS jcrg23ac
1508: SET jcrg23ac.rounding_id = v_rounding_id
1509: WHERE jcrg23ac.organization_id = p_organization_id
1510: AND jcrg23ac.excise_invoice_no = v_excise_invoice_no
1511: AND jcrg23ac.excise_invoice_date = v_excise_invoice_date

Line 1530: select min(register_id) from JAI_CMN_RG_23AC_II_TRXS

1526: )
1527: )
1528: )
1529: AND register_id IN (
1530: select min(register_id) from JAI_CMN_RG_23AC_II_TRXS
1531: WHERE organization_id = p_organization_id
1532: AND excise_invoice_no = v_excise_invoice_no
1533: AND excise_invoice_date = v_excise_invoice_date
1534: AND nvl(vendor_id,-999) = nvl(r.vendor_id,-999)/*bgowrava for forward porting bug#5674376*/

Line 1551: UPDATE JAI_CMN_RG_23AC_II_TRXS jcrg23ac

1547: Added proper aliases and changed transaction_source_num
1548: to transaction_id
1549: */
1550:
1551: UPDATE JAI_CMN_RG_23AC_II_TRXS jcrg23ac
1552: SET jcrg23ac.rounding_id = v_rounding_id
1553: WHERE jcrg23ac.organization_id = p_organization_id
1554: AND jcrg23ac.excise_invoice_no = v_excise_invoice_no
1555: AND jcrg23ac.excise_invoice_date = v_excise_invoice_date

Line 1683: FROM JAI_CMN_RG_23AC_II_TRXS

1679: SELECT
1680: register_type, organization_id, location_id, excise_invoice_no, excise_invoice_date,
1681: receipt_ref shipment_header_id,
1682: vendor_id,vendor_site_id/*bgowrava for forward porting bug#5674376*/
1683: FROM JAI_CMN_RG_23AC_II_TRXS
1684: WHERE register_id = cp_register_id;
1685: r_part_ii_rec c_part_ii_record%ROWTYPE;
1686:
1687: -- this cursor excludes rounding entries

Line 1692: FROM JAI_CMN_RG_23AC_II_TRXS

1688: CURSOR c_parent_part_ii_rec( cp_register_type IN VARCHAR2, cp_organization_id IN NUMBER, cp_location_id IN NUMBER,
1689: cp_excise_invoice_no IN VARCHAR2, cp_excise_invoice_date IN DATE,
1690: cp_vendor_id NUMBER,cp_vendor_site_id NUMBER,cp_shipment_header_id NUMBER) IS
1691: SELECT min(register_id) register_id
1692: FROM JAI_CMN_RG_23AC_II_TRXS
1693: WHERE organization_id = cp_organization_id
1694: AND location_id = cp_location_id
1695: AND register_type = cp_register_type
1696: AND excise_invoice_no = cp_excise_invoice_no

Line 1704: from JAI_CMN_RG_23AC_II_TRXS a

1700: CURSOR c_2nd_claim_register_id(cp_organization_id IN NUMBER, cp_location_id IN NUMBER,
1701: cp_excise_invoice_no IN VARCHAR2, cp_excise_invoice_date IN DATE,
1702: cp_vendor_id NUMBER,cp_vendor_site_id NUMBER) IS /*bgowrava for forward porting bug#5674376*/
1703: select min(register_id)
1704: from JAI_CMN_RG_23AC_II_TRXS a
1705: where organization_id = cp_organization_id
1706: and location_id = cp_location_id
1707: and excise_invoice_no = cp_excise_invoice_no
1708: and excise_invoice_date = cp_excise_invoice_date

Line 1713: from JAI_CMN_RG_23AC_II_TRXS

1709: AND nvl(vendor_id,-999) = nvl(cp_vendor_id,-999)/*bgowrava for forward porting bug#5674376*/
1710: AND nvl(vendor_site_id,-999) = nvl(cp_vendor_site_id,-999)/*bgowrava for forward porting bug#5674376*/
1711: and inventory_item_id <> 0
1712: and exists (select '1'
1713: from JAI_CMN_RG_23AC_II_TRXS
1714: where organization_id = a.organization_id
1715: and location_id = a.location_id
1716: and excise_invoice_no = a.excise_invoice_no
1717: and excise_invoice_date = a.excise_invoice_date

Line 1729: from JAI_CMN_RG_23AC_II_TRXS

1725: cursor c_get_all_rounding_ids
1726: (cp_excise_invoice_no IN VARCHAR2, cp_excise_invoice_date IN DATE,
1727: cp_vendor_id NUMBER, cp_vendor_site_id NUMBER) is
1728: select min(register_id) minimum_rounding_id, max(register_id) maximum_rounding_id
1729: from JAI_CMN_RG_23AC_II_TRXS
1730: where inventory_item_id = 0
1731: and excise_invoice_no = cp_excise_invoice_no
1732: and excise_invoice_date = cp_excise_invoice_date
1733: and nvl(vendor_id,-999) = nvl(cp_vendor_id,-999)/*bgowrava for forward porting bug#5674376*/

Line 2009: v_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;

2005: v_created_by NUMBER ;--File.Sql.35 Cbabu := nvl(FND_GLOBAL.USER_ID, -1);
2006: v_last_update_login NUMBER ;--File.Sql.35 Cbabu := nvl(FND_GLOBAL.LOGIN_ID,- 1);
2007: v_today DATE ;--File.Sql.35 Cbabu := trunc(SYSDATE);
2008:
2009: v_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
2010: v_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;
2011: v_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;
2012: v_line_type_c_cnt NUMBER ;--File.Sql.35 Cbabu := 0;
2013: v_tot_lines_cnt NUMBER ;--File.Sql.35 Cbabu := 0;

Line 2010: v_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;

2006: v_last_update_login NUMBER ;--File.Sql.35 Cbabu := nvl(FND_GLOBAL.LOGIN_ID,- 1);
2007: v_today DATE ;--File.Sql.35 Cbabu := trunc(SYSDATE);
2008:
2009: v_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
2010: v_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;
2011: v_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;
2012: v_line_type_c_cnt NUMBER ;--File.Sql.35 Cbabu := 0;
2013: v_tot_lines_cnt NUMBER ;--File.Sql.35 Cbabu := 0;
2014:

Line 2011: v_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;

2007: v_today DATE ;--File.Sql.35 Cbabu := trunc(SYSDATE);
2008:
2009: v_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
2010: v_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;
2011: v_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;
2012: v_line_type_c_cnt NUMBER ;--File.Sql.35 Cbabu := 0;
2013: v_tot_lines_cnt NUMBER ;--File.Sql.35 Cbabu := 0;
2014:
2015: CURSOR c_vendor(p_shipment_header_id IN NUMBER) IS

Line 2026: FROM JAI_CMN_RG_23AC_II_TRXS

2022:
2023: CURSOR c_slno_balance_rg23p2(p_organization_id IN NUMBER, p_location_id IN NUMBER,
2024: p_fin_year IN NUMBER, p_register_type IN VARCHAR2) IS
2025: SELECT slno, closing_balance
2026: FROM JAI_CMN_RG_23AC_II_TRXS
2027: WHERE organization_id = p_organization_id
2028: AND location_id = p_location_id
2029: AND fin_year = p_fin_year
2030: AND register_type = p_register_type

Line 2032: FROM JAI_CMN_RG_23AC_II_TRXS

2028: AND location_id = p_location_id
2029: AND fin_year = p_fin_year
2030: AND register_type = p_register_type
2031: AND slno = (SELECT max(slno) slno
2032: FROM JAI_CMN_RG_23AC_II_TRXS
2033: WHERE organization_id = p_organization_id
2034: AND location_id = p_location_id
2035: AND fin_year = p_fin_year
2036: AND register_type = p_register_type);

Line 2212: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. from JAI_CMN_RG_23AC_II_TRXS a, rcv_transactions b, JAI_CMN_RG_OTHERS c

2208: nvl(sum( decode(c.tax_type, 'CVD_EDUCATION_CESS', c.debit, 0)), 0) dr_cvd_edu_cess,
2209: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_exc_edu_cess, c.debit, 0)), 0) dr_sh_exc_edu_cess, -- Date 16/04/2007 by sacsethi for Bug#5989740
2210: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.debit, 0)), 0) dr_sh_cvd_edu_cess,
2211: null transaction_date
2212: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. from JAI_CMN_RG_23AC_II_TRXS a, rcv_transactions b, JAI_CMN_RG_OTHERS c
2213: from JAI_CMN_RG_23AC_II_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c
2214: where a.RECEIPT_REF = b.transaction_id
2215: AND a.organization_id = p_organization_id
2216: AND c.source_type(+) = 1 -- this means register is JAI_CMN_RG_23AC_II_TRXS

Line 2213: from JAI_CMN_RG_23AC_II_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c

2209: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_exc_edu_cess, c.debit, 0)), 0) dr_sh_exc_edu_cess, -- Date 16/04/2007 by sacsethi for Bug#5989740
2210: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.debit, 0)), 0) dr_sh_cvd_edu_cess,
2211: null transaction_date
2212: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. from JAI_CMN_RG_23AC_II_TRXS a, rcv_transactions b, JAI_CMN_RG_OTHERS c
2213: from JAI_CMN_RG_23AC_II_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c
2214: where a.RECEIPT_REF = b.transaction_id
2215: AND a.organization_id = p_organization_id
2216: AND c.source_type(+) = 1 -- this means register is JAI_CMN_RG_23AC_II_TRXS
2217: AND a.register_id = c.source_register_id(+)

Line 2216: AND c.source_type(+) = 1 -- this means register is JAI_CMN_RG_23AC_II_TRXS

2212: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. from JAI_CMN_RG_23AC_II_TRXS a, rcv_transactions b, JAI_CMN_RG_OTHERS c
2213: from JAI_CMN_RG_23AC_II_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c
2214: where a.RECEIPT_REF = b.transaction_id
2215: AND a.organization_id = p_organization_id
2216: AND c.source_type(+) = 1 -- this means register is JAI_CMN_RG_23AC_II_TRXS
2217: AND a.register_id = c.source_register_id(+)
2218: AND (
2219: (p_ex_invoice_from_date IS NULL AND p_ex_invoice_to_date IS NULL)
2220: OR (p_ex_invoice_from_date IS NOT NULL AND p_ex_invoice_to_date IS NULL

Line 2357: UPDATE JAI_CMN_RG_23AC_II_TRXS jcrg23ac

2353: end if;
2354:
2355: if r.register = LV_RG23_REGISTER then
2356: v_statement_no := '1.2';
2357: UPDATE JAI_CMN_RG_23AC_II_TRXS jcrg23ac
2358: SET jcrg23ac.rounding_id = v_already_rounded_chk
2359: WHERE jcrg23ac.excise_invoice_no = v_excise_invoice_no
2360: AND jcrg23ac.excise_invoice_date = v_excise_invoice_date
2361: AND nvl(vendor_id,-999) = nvl(r.vendor_id,-999)/*bgowrava for forward porting bug#5674376*/

Line 2673: UPDATE JAI_CMN_RG_23AC_II_TRXS aa

2669: fnd_file.put_line(fnd_file.log, '3-Before Update of Register with 0 Rounding');
2670: end if;
2671:
2672: if r.register = LV_RG23_REGISTER then
2673: UPDATE JAI_CMN_RG_23AC_II_TRXS aa
2674: SET rounding_id = 0
2675: WHERE organization_id = p_organization_id
2676: AND excise_invoice_no = v_excise_invoice_no
2677: AND excise_invoice_date = v_excise_invoice_date

Line 2924: INSERT INTO JAI_CMN_RG_23AC_II_TRXS(

2920: raise_application_error( -20010, lv_process_message, true);
2921: end if;
2922:
2923: elsif r.register = LV_RG23_REGISTER then
2924: INSERT INTO JAI_CMN_RG_23AC_II_TRXS(
2925: REGISTER_ID, ORGANIZATION_ID, LOCATION_ID, FIN_YEAR, INVENTORY_ITEM_ID, SLNO,
2926: CR_BASIC_ED, DR_BASIC_ED,
2927: CR_ADDITIONAL_ED, DR_ADDITIONAL_ED,
2928: CR_ADDITIONAL_CVD, DR_ADDITIONAL_CVD,/*5228046 ADDITIONAL CVD ENHANCEMENT*/

Line 2937: JAI_CMN_RG_23AC_II_TRXS_S.nextval, p_organization_id, r.location_id , v_fin_year, 0, v_slno,

2933: OPENING_BALANCE, CLOSING_BALANCE, CHARGE_ACCOUNT_ID,
2934: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN
2935: , TRANSACTION_DATE, OTHER_TAX_CREDIT, OTHER_TAX_DEBIT
2936: ) VALUES (
2937: JAI_CMN_RG_23AC_II_TRXS_S.nextval, p_organization_id, r.location_id , v_fin_year, 0, v_slno,
2938: v_rounded_cr_rg23_amount.basic, v_rounded_dr_rg23_amount.basic,
2939: v_rounded_cr_rg23_amount.additional, v_rounded_dr_rg23_amount.additional,
2940: v_rounded_cr_rg23_amount.additional_cvd, v_rounded_dr_rg23_amount.additional_cvd,/*5228046 Additional cvd Enhancement*/
2941: v_rounded_cr_rg23_amount.other, v_rounded_dr_rg23_amount.other,

Line 3187: UPDATE JAI_CMN_RG_23AC_II_TRXS aa

3183: end if;
3184:
3185: if r.register = LV_RG23_REGISTER then
3186: lv_ttype_correct := 'CORRECT'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
3187: UPDATE JAI_CMN_RG_23AC_II_TRXS aa
3188: SET rounding_id = v_rounding_id
3189: WHERE organization_id = p_organization_id
3190: AND excise_invoice_no = v_excise_invoice_no
3191: AND excise_invoice_date = v_excise_invoice_date