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_RTV_BATCH_TRXS

Line 2102: ln_rtv_excise_batch_group_id jai_rcv_rtv_batch_trxs.excise_batch_group_id%TYPE;

2098: AND src_transaction_type = p_transaction_type
2099: GROUP BY rounding_id, excise_invoice_no, excise_invoice_date;
2100:
2101: /*Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. */
2102: ln_rtv_excise_batch_group_id jai_rcv_rtv_batch_trxs.excise_batch_group_id%TYPE;
2103: CURSOR c_excise_batch_group_id(cpn_transaction_id number) IS
2104: select excise_batch_group_id
2105: from jai_rcv_rtv_batch_trxs
2106: where transaction_id = cpn_transaction_id;

Line 2105: from jai_rcv_rtv_batch_trxs

2101: /*Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. */
2102: ln_rtv_excise_batch_group_id jai_rcv_rtv_batch_trxs.excise_batch_group_id%TYPE;
2103: CURSOR c_excise_batch_group_id(cpn_transaction_id number) IS
2104: select excise_batch_group_id
2105: from jai_rcv_rtv_batch_trxs
2106: where transaction_id = cpn_transaction_id;
2107:
2108: v_no_of_periods_updated NUMBER(15);
2109: v_period_balance_id NUMBER(15);

Line 2415: jai_rcv_rtv_batch_trxs d

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
2419: and b.shipment_line_id = a.shipment_line_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