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.transaction_id = c.transaction_id --Added by nprashar for bug # 13367420
702: AND a.inventory_item_id = d.inventory_item_id

Line 745: from rcv_transactions

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

Line 1055: to transaction_id while checking data in rcv_transactions.

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

Line 1067: SELECT 1 FROM rcv_transactions rt

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

Line 1072: (select 1 from rcv_transactions rt1

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

Line 1518: FROM rcv_transactions rt

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

Line 1523: from rcv_transactions rt1

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

Line 1562: FROM rcv_transactions rt

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

Line 1569: from rcv_transactions rt1

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

Line 2118: lv_ttype_correct JAI_RCV_TRANSACTIONS.transaction_type%type ;

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

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

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

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

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

Line 2366: AND exists (select 1 from JAI_RCV_TRANSACTIONS jrt

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

Line 2386: AND exists (select 1 from JAI_RCV_TRANSACTIONS jrt

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

Line 2412: FROM JAI_RCV_TRANSACTIONS a,

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

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

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

Line 2683: SELECT 1 FROM JAI_RCV_TRANSACTIONS bb, jai_rcv_rtv_batch_trxs b1

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

Line 2703: SELECT 1 FROM JAI_RCV_TRANSACTIONS bb, jai_rcv_rtv_batch_trxs b1

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

Line 3198: FROM JAI_RCV_TRANSACTIONS bb, jai_rcv_rtv_batch_trxs b1

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

Line 3221: FROM JAI_RCV_TRANSACTIONS bb, jai_rcv_rtv_batch_trxs b1

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