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 2101: ln_rtv_excise_batch_group_id jai_rcv_rtv_batch_trxs.excise_batch_group_id%TYPE;

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

Line 2104: from jai_rcv_rtv_batch_trxs

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

Line 2414: jai_rcv_rtv_batch_trxs d

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.
2418: AND (a.transaction_type = p_transaction_type

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