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 RCV_TRANSACTIONS

Line 268: v_transaction_type rcv_transactions.transaction_type%type;

264:
265: v_exc_inv_rnd_counter NUMBER; --File.Sql.35 Cbabu := 0;
266: v_rnd_entries_to_be_passed NUMBER;--File.Sql.35 Cbabu := 0;
267: v_receipt_num rcv_shipment_headers.receipt_num%type;
268: v_transaction_type rcv_transactions.transaction_type%type;
269:
270: lv_ttype_correct rcv_transactions.transaction_type%type ;
271: BEGIN
272:

Line 270: lv_ttype_correct rcv_transactions.transaction_type%type ;

266: v_rnd_entries_to_be_passed NUMBER;--File.Sql.35 Cbabu := 0;
267: v_receipt_num rcv_shipment_headers.receipt_num%type;
268: v_transaction_type rcv_transactions.transaction_type%type;
269:
270: lv_ttype_correct rcv_transactions.transaction_type%type ;
271: BEGIN
272:
273: /*--------------------------------------------------------------------------------------------------------------------------------
274: Change History for Filename - ja_in_rg_rounding_p.sql

Line 328: for the existence in jai_rcv_transactions

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
332: (3) Changed transaction_source_num to transaction_id in

Line 331: for the existence in jai_rcv_transactions

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
335: (4) Added proper alias names and changed

Line 334: for the existence in rcv_transactions

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
338: JAI_CMN_RG_23AC_II_TRXS. This is done in 2 places.

Line 337: checking data in rcv_transactions in update to

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
338: JAI_CMN_RG_23AC_II_TRXS. This is done in 2 places.
339:
340:
341: DEPENDENCY

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 656: AND exists (select 1 from rcv_transactions rt

652: AND nvl(vendor_site_id,-999) = nvl(r.vendor_site_id,-999)/*bgowrava for forward porting bug#5674376*/
653: AND jcrg23ac.organization_id = p_organization_id
654: AND jcrg23ac.rounding_id IS NULL
655: AND jcrg23ac.transaction_source_num = 18
656: AND exists (select 1 from rcv_transactions rt
657: /* Bug 4930048. Added by Lakshmi Gopalsami
658: Changed transaction_source_num to transaction_id
659: */
660: where rt.transaction_id = jcrg23ac.receipt_ref

Line 698: FROM JAI_RCV_LINES a,JAI_RCV_CENVAT_CLAIMS b,RCV_TRANSACTIONS c, JAI_INV_ITM_SETUPS d

694:
695: v_statement_no := '1.4';
696: -- this is to get RECEIVE type of transactions
697: FOR line IN ( SELECT a.shipment_line_id, a.transaction_id, d.item_class
698: FROM JAI_RCV_LINES a,JAI_RCV_CENVAT_CLAIMS b,RCV_TRANSACTIONS c, JAI_INV_ITM_SETUPS d
699: WHERE a.organization_id = d.organization_id
700: AND b.transaction_id = a.transaction_id /*bgowrava for forward porting bug#5674376*/
701: AND a.inventory_item_id = d.inventory_item_id
702: AND a.shipment_header_id = v_shipment_header_id

Line 744: from rcv_transactions

740:
741: -- this is to loop through all the RECEIVE and related CORRECT transactions
742: lv_ttype_correct := 'CORRECT' ; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
743: FOR trx IN (select transaction_id, quantity
744: from rcv_transactions
745: where shipment_line_id = line.shipment_line_id
746: and (
747: (transaction_type = lv_ttype_correct and parent_transaction_id = line.transaction_id)
748: OR transaction_id = line.transaction_id

Line 1054: to transaction_id while checking data in rcv_transactions.

1050: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1051: lv_ttype_correct := 'CORRECT' ;
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

Line 1066: SELECT 1 FROM rcv_transactions rt

1062: AND nvl(vendor_site_id,-999) = nvl(r.vendor_site_id,-999)/*bgowrava for forward porting bug#5674376*/
1063: AND jcrg23ac.rounding_id IS NULL
1064: AND jcrg23ac.TRANSACTION_SOURCE_NUM = 18
1065: AND EXISTS (
1066: SELECT 1 FROM rcv_transactions rt
1067: WHERE rt.shipment_header_id = v_shipment_header_id
1068: AND rt.transaction_id = jcrg23ac.receipt_ref
1069: AND ( rt.transaction_type = r.transaction_type
1070: OR ( rt.transaction_type = lv_ttype_correct AND exists

Line 1071: (select 1 from rcv_transactions rt1

1067: WHERE rt.shipment_header_id = v_shipment_header_id
1068: AND rt.transaction_id = jcrg23ac.receipt_ref
1069: AND ( rt.transaction_type = r.transaction_type
1070: OR ( rt.transaction_type = lv_ttype_correct AND exists
1071: (select 1 from rcv_transactions rt1
1072: where rt1.transaction_id = rt.parent_transaction_id
1073: and rt1.transaction_type = r.transaction_type)
1074: )
1075: )

Line 1517: FROM rcv_transactions rt

1513: AND jcrg23ac.rounding_id IS NULL
1514: AND jcrg23ac.TRANSACTION_SOURCE_NUM = 18
1515: AND jcrg23ac.receipt_ref IN (
1516: SELECT rt.transaction_id
1517: FROM rcv_transactions rt
1518: WHERE rt.shipment_header_id = v_shipment_header_id
1519: AND ( rt.transaction_type = r.transaction_type
1520: OR ( rt.transaction_type = lv_ttype_correct
1521: AND exists (select 1

Line 1522: from rcv_transactions rt1

1518: WHERE rt.shipment_header_id = v_shipment_header_id
1519: AND ( rt.transaction_type = r.transaction_type
1520: OR ( rt.transaction_type = lv_ttype_correct
1521: AND exists (select 1
1522: from rcv_transactions rt1
1523: where rt1.transaction_id = rt.parent_transaction_id
1524: and rt1.transaction_type = r.transaction_type)
1525: )
1526: )

Line 1561: FROM rcv_transactions rt

1557: AND jcrg23ac.rounding_id IS NULL
1558: AND jcrg23ac.TRANSACTION_SOURCE_NUM = 18
1559: AND EXISTS (
1560: SELECT rt.transaction_id
1561: FROM rcv_transactions rt
1562: WHERE rt.shipment_header_id = v_shipment_header_id
1563: AND rt.transaction_id = jcrg23ac.receipt_ref
1564: AND ( rt.transaction_type = r.transaction_type
1565: OR ( rt.transaction_type = lv_ttype_correct

Line 1568: from rcv_transactions rt1

1564: AND ( rt.transaction_type = r.transaction_type
1565: OR ( rt.transaction_type = lv_ttype_correct
1566: AND exists --'CORRECT'
1567: (select 1
1568: from rcv_transactions rt1
1569: where rt1.transaction_id= rt.parent_transaction_id
1570: and rt1.transaction_type = r.transaction_type)
1571: )
1572: )

Line 2117: lv_ttype_correct JAI_RCV_TRANSACTIONS.transaction_type%type ;

2113: lv_process_message VARCHAR2(1996);
2114: v_receipt_num rcv_shipment_headers.receipt_num%TYPE;
2115: v_pla_register_id NUMBER;
2116:
2117: lv_ttype_correct JAI_RCV_TRANSACTIONS.transaction_type%type ;
2118:
2119: BEGIN
2120:
2121: v_statement_no := '0.1';

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 2230: /* Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. exists (select 1 from JAI_RCV_TRANSACTIONS

2226: AND a.rounding_id IS NULL
2227: AND a.TRANSACTION_SOURCE_NUM = 18
2228: AND ( (b.transaction_type = p_transaction_type)
2229: or (b.transaction_type = lv_ttype_correct and b.parent_transaction_type = p_transaction_type --'CORRECT'
2230: /* Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. exists (select 1 from JAI_RCV_TRANSACTIONS
2231: where transaction_id = b.parent_transaction_id
2232: and transaction_type = p_transaction_type)*/
2233: )
2234: )

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 2292: /*Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. exists (select 1 from JAI_RCV_TRANSACTIONS

2288: AND a.rounding_id IS NULL
2289: AND a.TRANSACTION_SOURCE_NUM = 19
2290: AND ( (b.transaction_type = p_transaction_type)
2291: or (b.transaction_type = 'CORRECT' and b.parent_transaction_type = p_transaction_type
2292: /*Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. exists (select 1 from JAI_RCV_TRANSACTIONS
2293: where transaction_id = b.parent_transaction_id
2294: and transaction_type = p_transaction_type)*/
2295: )
2296: )

Line 2365: AND exists (select 1 from JAI_RCV_TRANSACTIONS jrt

2361: AND nvl(vendor_site_id,-999) = nvl(r.vendor_site_id,-999)/*bgowrava for forward porting bug#5674376*/
2362: AND jcrg23ac.organization_id = p_organization_id
2363: AND jcrg23ac.rounding_id IS NULL
2364: AND jcrg23ac.transaction_source_num = 18
2365: AND exists (select 1 from JAI_RCV_TRANSACTIONS jrt
2366: /* Bug 4930048. Added by Lakshmi Gopalsami
2367: Changed transaction_source_num to transaction_id
2368: */
2369: where jrt.transaction_id = jcrg23ac.receipt_ref

Line 2385: AND exists (select 1 from JAI_RCV_TRANSACTIONS jrt

2381: AND nvl(vendor_site_id,-999) = nvl(r.vendor_site_id,-999)/*bgowrava for forward porting bug#5674376*/
2382: AND jcpla.organization_id = p_organization_id
2383: AND jcpla.rounding_id IS NULL
2384: AND jcpla.TRANSACTION_SOURCE_NUM = 19
2385: AND exists (select 1 from JAI_RCV_TRANSACTIONS jrt
2386: /* Bug 4930048. Added by Lakshmi Gopalsami
2387: Changed transaction_source_num to transaction_id
2388: */
2389: where jrt.transaction_id = jcpla.ref_document_id

Line 2411: FROM JAI_RCV_TRANSACTIONS a,

2407:
2408: v_statement_no := '1.4';
2409: FOR line IN ( SELECT a.shipment_line_id, a.transaction_id, a.item_class,
2410: a.transaction_type, a.parent_transaction_type, a.quantity
2411: FROM JAI_RCV_TRANSACTIONS a,
2412: JAI_RCV_CENVAT_CLAIMS b,/*bgowrava for forward porting bug#5674376*/
2413: RCV_TRANSACTIONS c,/*bgowrava for forward porting bug#5674376*/
2414: jai_rcv_rtv_batch_trxs d
2415: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. WHERE a.shipment_header_id = v_shipment_header_id

Line 2413: RCV_TRANSACTIONS c,/bgowrava for forward porting bug#5674376/

2409: FOR line IN ( SELECT a.shipment_line_id, a.transaction_id, a.item_class,
2410: a.transaction_type, a.parent_transaction_type, a.quantity
2411: FROM JAI_RCV_TRANSACTIONS a,
2412: JAI_RCV_CENVAT_CLAIMS b,/*bgowrava for forward porting bug#5674376*/
2413: RCV_TRANSACTIONS c,/*bgowrava for forward porting bug#5674376*/
2414: jai_rcv_rtv_batch_trxs d
2415: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. WHERE a.shipment_header_id = v_shipment_header_id
2416: WHERE a.transaction_id = d.transaction_id -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
2417: and d.excise_batch_group_id = ln_rtv_excise_batch_group_id -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.

Line 2680: SELECT 1 FROM JAI_RCV_TRANSACTIONS bb, jai_rcv_rtv_batch_trxs b1

2676: AND nvl(vendor_site_id,-999) = nvl(r.vendor_site_id,-999)/*bgowrava for forward porting bug#5674376*/
2677: AND rounding_id IS NULL
2678: AND TRANSACTION_SOURCE_NUM = 18
2679: AND EXISTS (
2680: SELECT 1 FROM JAI_RCV_TRANSACTIONS bb, jai_rcv_rtv_batch_trxs b1
2681: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. WHERE BB.shipment_header_id = v_shipment_header_id
2682: WHERE bb.transaction_id = b1.transaction_id -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
2683: and b1.excise_batch_group_id = ln_rtv_excise_batch_group_id -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
2684: AND bb.transaction_id = aa.receipt_ref

Line 2700: SELECT 1 FROM JAI_RCV_TRANSACTIONS bb, jai_rcv_rtv_batch_trxs b1

2696: AND nvl(vendor_site_id,-999) = nvl(r.vendor_site_id,-999)/*bgowrava for forward porting bug#5674376*/
2697: AND rounding_id IS NULL
2698: AND TRANSACTION_SOURCE_NUM = 19
2699: AND EXISTS (
2700: SELECT 1 FROM JAI_RCV_TRANSACTIONS bb, jai_rcv_rtv_batch_trxs b1
2701: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. WHERE BB.shipment_header_id = v_shipment_header_id
2702: WHERE bb.transaction_id = b1.transaction_id -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
2703: and b1.excise_batch_group_id = ln_rtv_excise_batch_group_id -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
2704: AND bb.transaction_id = aa.ref_document_id

Line 3195: FROM JAI_RCV_TRANSACTIONS bb, jai_rcv_rtv_batch_trxs b1

3191: AND rounding_id IS NULL
3192: AND TRANSACTION_SOURCE_NUM = 18
3193: AND EXISTS (
3194: SELECT BB.transaction_id
3195: FROM JAI_RCV_TRANSACTIONS bb, jai_rcv_rtv_batch_trxs b1
3196: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. WHERE bb.shipment_header_id = v_shipment_header_id
3197: WHERE bb.transaction_id = b1.transaction_id -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
3198: and b1.excise_batch_group_id = ln_rtv_excise_batch_group_id -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
3199: AND bb.transaction_id = aa.receipt_ref

Line 3218: FROM JAI_RCV_TRANSACTIONS bb, jai_rcv_rtv_batch_trxs b1

3214: AND rounding_id IS NULL
3215: AND TRANSACTION_SOURCE_NUM = 19
3216: AND exists (
3217: SELECT BB.transaction_id
3218: FROM JAI_RCV_TRANSACTIONS bb, jai_rcv_rtv_batch_trxs b1
3219: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. WHERE bb.shipment_header_id = v_shipment_header_id
3220: WHERE bb.transaction_id = b1.transaction_id -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
3221: and b1.excise_batch_group_id = ln_rtv_excise_batch_group_id -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
3222: AND bb.transaction_id = aa.ref_document_id