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_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 2274: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. from JAI_CMN_RG_PLA_TRXS a, rcv_transactions b, JAI_CMN_RG_OTHERS c

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

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

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

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

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

Line 2377: UPDATE JAI_CMN_RG_PLA_TRXS jcpla

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

Line 2693: UPDATE JAI_CMN_RG_PLA_TRXS aa

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

Line 2881: jai_cmn_rg_pla_trxs_pkg.insert_row(

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

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

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

Line 3210: UPDATE JAI_CMN_RG_PLA_TRXS aa

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