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_RCV_TRANSACTIONS

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