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 1056: UPDATE JAI_CMN_RG_23AC_II_TRXS jcrg23ac

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

Line 1240: INSERT INTO JAI_CMN_RG_23AC_II_TRXS(

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

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

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

Line 1506: UPDATE JAI_CMN_RG_23AC_II_TRXS jcrg23ac

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

Line 1529: select min(register_id) from JAI_CMN_RG_23AC_II_TRXS

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

Line 1550: UPDATE JAI_CMN_RG_23AC_II_TRXS jcrg23ac

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

Line 1682: FROM JAI_CMN_RG_23AC_II_TRXS

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

Line 1691: FROM JAI_CMN_RG_23AC_II_TRXS

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

Line 1703: from JAI_CMN_RG_23AC_II_TRXS a

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

Line 1712: from JAI_CMN_RG_23AC_II_TRXS

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

Line 1728: from JAI_CMN_RG_23AC_II_TRXS

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

Line 2008: v_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;

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

Line 2009: v_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;

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

Line 2010: v_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;

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

Line 2025: FROM JAI_CMN_RG_23AC_II_TRXS

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

Line 2031: FROM JAI_CMN_RG_23AC_II_TRXS

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

Line 2211: -- 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

2207: nvl(sum( decode(c.tax_type, 'CVD_EDUCATION_CESS', c.debit, 0)), 0) dr_cvd_edu_cess,
2208: 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
2209: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.debit, 0)), 0) dr_sh_cvd_edu_cess,
2210: null transaction_date
2211: -- 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
2212: from JAI_CMN_RG_23AC_II_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c
2213: where a.RECEIPT_REF = b.transaction_id
2214: AND a.organization_id = p_organization_id
2215: AND c.source_type(+) = 1 -- this means register is JAI_CMN_RG_23AC_II_TRXS

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

2208: 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
2209: nvl(sum( decode(c.tax_type, jai_constants.tax_type_sh_cvd_edu_cess, c.debit, 0)), 0) dr_sh_cvd_edu_cess,
2210: null transaction_date
2211: -- 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
2212: from JAI_CMN_RG_23AC_II_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c
2213: where a.RECEIPT_REF = b.transaction_id
2214: AND a.organization_id = p_organization_id
2215: AND c.source_type(+) = 1 -- this means register is JAI_CMN_RG_23AC_II_TRXS
2216: AND a.register_id = c.source_register_id(+)

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

2211: -- 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
2212: from JAI_CMN_RG_23AC_II_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c
2213: where a.RECEIPT_REF = b.transaction_id
2214: AND a.organization_id = p_organization_id
2215: AND c.source_type(+) = 1 -- this means register is JAI_CMN_RG_23AC_II_TRXS
2216: AND a.register_id = c.source_register_id(+)
2217: AND (
2218: (p_ex_invoice_from_date IS NULL AND p_ex_invoice_to_date IS NULL)
2219: OR (p_ex_invoice_from_date IS NOT NULL AND p_ex_invoice_to_date IS NULL

Line 2356: UPDATE JAI_CMN_RG_23AC_II_TRXS jcrg23ac

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

Line 2670: UPDATE JAI_CMN_RG_23AC_II_TRXS aa

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

Line 2921: INSERT INTO JAI_CMN_RG_23AC_II_TRXS(

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

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

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

Line 3184: UPDATE JAI_CMN_RG_23AC_II_TRXS aa

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