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