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.

[Home] [Help]

APPS.JAI_RCV_RND_PKG dependencies on JAI_CMN_RG_PLA_TRXS

Line 330: update of JAI_CMN_RG_PLA_TRXS and subquery checking

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
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

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

2269: nvl(sum( decode(c.tax_type, 'EXCISE_SH_EDU_CESS', c.debit, 0)), 0) dr_sh_exc_edu_cess,
2270: nvl(sum( decode(c.tax_type, 'CVD_SH_EDU_CESS', c.debit, 0)), 0) dr_sh_cvd_edu_cess,
2271: -- end
2272: max(a.transaction_date) transaction_date
2273: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. from JAI_CMN_RG_PLA_TRXS a, rcv_transactions b, JAI_CMN_RG_OTHERS c
2274: from JAI_CMN_RG_PLA_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c
2275: where a.ref_document_id = b.transaction_id
2276: AND a.organization_id = p_organization_id
2277: AND c.source_type(+) = 2 -- this means register is JAI_CMN_RG_PLA_TRXS

Line 2274: from JAI_CMN_RG_PLA_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c

2270: nvl(sum( decode(c.tax_type, 'CVD_SH_EDU_CESS', c.debit, 0)), 0) dr_sh_cvd_edu_cess,
2271: -- end
2272: max(a.transaction_date) transaction_date
2273: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. from JAI_CMN_RG_PLA_TRXS a, rcv_transactions b, JAI_CMN_RG_OTHERS c
2274: from JAI_CMN_RG_PLA_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c
2275: where a.ref_document_id = b.transaction_id
2276: AND a.organization_id = p_organization_id
2277: AND c.source_type(+) = 2 -- this means register is JAI_CMN_RG_PLA_TRXS
2278: AND a.register_id = c.source_register_id(+)

Line 2277: AND c.source_type(+) = 2 -- this means register is JAI_CMN_RG_PLA_TRXS

2273: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. from JAI_CMN_RG_PLA_TRXS a, rcv_transactions b, JAI_CMN_RG_OTHERS c
2274: from JAI_CMN_RG_PLA_TRXS a, JAI_RCV_TRANSACTIONS b, JAI_CMN_RG_OTHERS c
2275: where a.ref_document_id = b.transaction_id
2276: AND a.organization_id = p_organization_id
2277: AND c.source_type(+) = 2 -- this means register is JAI_CMN_RG_PLA_TRXS
2278: AND a.register_id = c.source_register_id(+)
2279: AND (
2280: (p_ex_invoice_from_date IS NULL AND p_ex_invoice_to_date IS NULL)
2281: OR (p_ex_invoice_from_date IS NOT NULL AND p_ex_invoice_to_date IS NULL

Line 2376: UPDATE JAI_CMN_RG_PLA_TRXS jcpla

2372:
2373: elsif r.register = LV_PLA_REGISTER then
2374:
2375: v_statement_no := '1.2';
2376: UPDATE JAI_CMN_RG_PLA_TRXS jcpla
2377: SET jcpla.rounding_id = v_already_rounded_chk
2378: WHERE jcpla.DR_INVOICE_NO = v_excise_invoice_no
2379: AND jcpla.dr_invoice_date = v_excise_invoice_date
2380: AND nvl(vendor_id,-999) = nvl(r.vendor_id,-999)/*bgowrava for forward porting bug#5674376*/

Line 2690: UPDATE JAI_CMN_RG_PLA_TRXS aa

2686: );
2687:
2688: elsif r.register = LV_PLA_REGISTER then
2689:
2690: UPDATE JAI_CMN_RG_PLA_TRXS aa
2691: SET rounding_id = 0
2692: WHERE organization_id = p_organization_id
2693: AND DR_INVOICE_NO = v_excise_invoice_no
2694: AND dr_invoice_date = v_excise_invoice_date

Line 2878: jai_cmn_rg_pla_trxs_pkg.insert_row(

2874: end if;
2875:
2876: if r.register = LV_PLA_REGISTER then
2877:
2878: jai_cmn_rg_pla_trxs_pkg.insert_row(
2879: p_register_id => v_register_id_part_ii,
2880: p_tr6_challan_no => NULL,
2881: p_tr6_challan_date => NULL,
2882: p_cr_basic_ed => v_rounded_cr_rg23_amount.basic,

Line 3169: /* this update is already taken in jai_cmn_rg_pla_trxs_pkg.insert_row call*/

3165: WHERE organization_id = p_organization_id
3166: AND location_id = r.location_id;
3167:
3168: elsif r.register = LV_PLA_REGISTER then
3169: /* this update is already taken in jai_cmn_rg_pla_trxs_pkg.insert_row call*/
3170: NULL;
3171:
3172: end if;
3173:

Line 3207: UPDATE JAI_CMN_RG_PLA_TRXS aa

3203: );
3204:
3205: elsif r.register = LV_PLA_REGISTER then
3206: lv_ttype_correct := 'CORRECT'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
3207: UPDATE JAI_CMN_RG_PLA_TRXS aa
3208: SET rounding_id = v_rounding_id
3209: WHERE organization_id = p_organization_id
3210: AND DR_INVOICE_NO = v_excise_invoice_no
3211: AND dr_invoice_date = v_excise_invoice_date