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_AP_ST_REVERSE_PROCESS dependencies on RCV_TRANSACTIONS

Line 3420: , RCV_TRANSACTIONS RT

3416: ,nvl(jcta.adhoc_flag,'N') adhoc_flag --12351311
3417: FROM
3418: JAI_RCV_LINE_TAXES jrl
3419: , RCV_SHIPMENT_LINES RSL
3420: , RCV_TRANSACTIONS RT
3421: , jai_cmn_taxes_all jcta
3422: WHERE jrl.shipment_line_id = rsl.shipment_line_id
3423: AND rt.shipment_line_id = rsl.shipment_line_id
3424: AND rt.transaction_id = tran_id

Line 3466: , rcv_transactions rt

3462: ,nvl(jcta.adhoc_flag,'N') ADHOC_FLAG --12351311
3463: FROM
3464: jai_rcv_line_taxes jrl
3465: , rcv_shipment_lines rsl
3466: , rcv_transactions rt
3467: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
3468: WHERE jrl.shipment_line_id = rsl.shipment_line_id
3469: AND rt.shipment_line_id = rsl.shipment_line_id
3470: AND rt.transaction_id = tran_id

Line 3502: , rcv_transactions rt

3498: ,nvl(jcta.adhoc_flag,'N') ADHOC_FLAG --12351311
3499: FROM
3500: jai_retro_tax_changes jrl
3501: , rcv_shipment_lines rsl
3502: , rcv_transactions rt
3503: , jai_retro_line_changes jrlc
3504: , jai_cmn_taxes_all jcta
3505: WHERE jrlc.doc_line_id = rsl.shipment_line_id
3506: AND jrlc.line_change_id = jrl.line_change_id

Line 3640: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,

3636: ln_inclurec_tax_amt NUMBER;
3637: ap_invoice_lines_all_rec ap_invoice_lines_all%ROWTYPE;
3638: ap_invoice_dist_all_rec ap_invoice_distributions_all%ROWTYPE;
3639:
3640: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
3641: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
3642: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
3643: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
3644: cp_attribute1 VARCHAR2) --Added by Bgowrava for Bug#7503308

Line 3641: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308

3637: ap_invoice_lines_all_rec ap_invoice_lines_all%ROWTYPE;
3638: ap_invoice_dist_all_rec ap_invoice_distributions_all%ROWTYPE;
3639:
3640: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
3641: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
3642: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
3643: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
3644: cp_attribute1 VARCHAR2) --Added by Bgowrava for Bug#7503308
3645: is

Line 3642: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308

3638: ap_invoice_dist_all_rec ap_invoice_distributions_all%ROWTYPE;
3639:
3640: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
3641: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
3642: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
3643: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
3644: cp_attribute1 VARCHAR2) --Added by Bgowrava for Bug#7503308
3645: is
3646: select attribute2 excise_costing_flag

Line 3643: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308

3639:
3640: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
3641: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
3642: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
3643: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
3644: cp_attribute1 VARCHAR2) --Added by Bgowrava for Bug#7503308
3645: is
3646: select attribute2 excise_costing_flag
3647: from jai_rcv_transactions jrcvt

Line 3647: from jai_rcv_transactions jrcvt

3643: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
3644: cp_attribute1 VARCHAR2) --Added by Bgowrava for Bug#7503308
3645: is
3646: select attribute2 excise_costing_flag
3647: from jai_rcv_transactions jrcvt
3648: where jrcvt.parent_transaction_id = cp_rcv_transaction_id
3649: and jrcvt.organization_id = cp_organization_id --Added by Bgowrava for Bug#7503308
3650: and jrcvt.shipment_header_id = cp_shipment_header_id --Added by Bgowrava for Bug#7503308
3651: and jrcvt.transaction_type = cp_txn_type ;--'DELIVER' --Modified by Bgowrava for Bug#7503308

Line 3656: cursor c_rcv_transactions(p_transaction_id number) is

3652:
3653: lv_account_type gl_code_combinations.account_type%TYPE;
3654:
3655: /* Service Tax */
3656: cursor c_rcv_transactions(p_transaction_id number) is
3657: select po_line_id, organization_id
3658: from rcv_transactions
3659: where transaction_id = p_transaction_id;
3660:

Line 3658: from rcv_transactions

3654:
3655: /* Service Tax */
3656: cursor c_rcv_transactions(p_transaction_id number) is
3657: select po_line_id, organization_id
3658: from rcv_transactions
3659: where transaction_id = p_transaction_id;
3660:
3661:
3662: cursor c_po_lines_all(p_po_line_id number) is

Line 3687: r_rcv_transactions c_rcv_transactions%rowtype;

3683: and registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */
3684: and attribute_code = cp_tax_type;
3685:
3686:
3687: r_rcv_transactions c_rcv_transactions%rowtype;
3688: r_po_lines_all c_po_lines_all%rowtype;
3689: r_jai_regimes c_jai_regimes%rowtype;
3690: r_service_regime_tax_type c_regime_tax_type%rowtype;
3691: lv_is_item_an_expense varchar2(20); /* Service */

Line 4043: open c_rcv_transactions(rcv_tran_id);

4039: jai_ap_utils_pkg.get_apportion_factor(inv_id, pn_invoice_line_number);
4040:
4041: /* service Start */
4042:
4043: open c_rcv_transactions(rcv_tran_id);
4044: fetch c_rcv_transactions into r_rcv_transactions;
4045: close c_rcv_transactions;
4046:
4047: OPEN from_po_distributions(po_dist_id);

Line 4044: fetch c_rcv_transactions into r_rcv_transactions;

4040:
4041: /* service Start */
4042:
4043: open c_rcv_transactions(rcv_tran_id);
4044: fetch c_rcv_transactions into r_rcv_transactions;
4045: close c_rcv_transactions;
4046:
4047: OPEN from_po_distributions(po_dist_id);
4048: FETCH from_po_distributions INTO from_po_distributions_rec;

Line 4045: close c_rcv_transactions;

4041: /* service Start */
4042:
4043: open c_rcv_transactions(rcv_tran_id);
4044: fetch c_rcv_transactions into r_rcv_transactions;
4045: close c_rcv_transactions;
4046:
4047: OPEN from_po_distributions(po_dist_id);
4048: FETCH from_po_distributions INTO from_po_distributions_rec;
4049: CLOSE from_po_distributions;

Line 4059: p_organization_id => r_rcv_transactions.organization_id,

4055:
4056: lv_is_item_an_expense := null;
4057: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense
4058: (
4059: p_organization_id => r_rcv_transactions.organization_id,
4060: p_item_id => r_po_lines_all.item_id
4061: );
4062:
4063: /*lv_accounting_method_option := jai_general_pkg.get_accounting_method

Line 4067: p_organization_id => r_rcv_transactions.organization_id

4063: /*lv_accounting_method_option := jai_general_pkg.get_accounting_method
4064: (
4065: p_org_id => v_org_id,
4066: p_sob_id => for_dist_insertion_rec.set_of_books_id,
4067: p_organization_id => r_rcv_transactions.organization_id
4068: );*/
4069:
4070: OPEN c_po_details;
4071: FETCH c_po_details INTO ln_po_line_id, ln_po_line_location_id;

Line 5538: , rcv_transactions rt

5534: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag
5535: FROM
5536: JAI_RCV_LINE_TAXES jrl
5537: , rcv_shipment_lines rsl
5538: , rcv_transactions rt
5539: , jai_cmn_taxes_all jcta
5540: WHERE jrl.shipment_line_id = rsl.shipment_line_id
5541: AND rt.shipment_line_id = rsl.shipment_line_id
5542: AND rt.transaction_id = tran_id

Line 5719: cursor c_rcv_transactions(p_transaction_id number) is

5715: ln_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
5716: ln_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
5717:
5718: /* Service Tax */
5719: cursor c_rcv_transactions(p_transaction_id number) is
5720: select po_line_id, organization_id
5721: from rcv_transactions
5722: where transaction_id = p_transaction_id;
5723:

Line 5721: from rcv_transactions

5717:
5718: /* Service Tax */
5719: cursor c_rcv_transactions(p_transaction_id number) is
5720: select po_line_id, organization_id
5721: from rcv_transactions
5722: where transaction_id = p_transaction_id;
5723:
5724: cursor c_po_lines_all(p_po_line_id number) is
5725: select item_id

Line 5756: r_rcv_transactions c_rcv_transactions%rowtype;

5752: from jai_cmn_taxes_all
5753: where tax_id = cp_tax_id ;
5754: /*End, Added by kunkumar for bug#5593895*/
5755:
5756: r_rcv_transactions c_rcv_transactions%rowtype;
5757: r_po_lines_all c_po_lines_all%rowtype;
5758: r_jai_regimes c_jai_regimes%rowtype;
5759: r_service_regime_tax_type c_regime_tax_type%rowtype;
5760: lv_is_item_an_expense varchar2(20); /* Service */

Line 5960: open c_rcv_transactions(rcv_tran_id);

5956: v_apportn_factor_for_item_line :=
5957: jai_ap_utils_pkg.get_apportion_factor(inv_id, pn_invoice_line_number);
5958:
5959: /* service Start */
5960: open c_rcv_transactions(rcv_tran_id);
5961: fetch c_rcv_transactions into r_rcv_transactions;
5962: close c_rcv_transactions;
5963:
5964: open c_po_lines_all(po_dist_id);

Line 5961: fetch c_rcv_transactions into r_rcv_transactions;

5957: jai_ap_utils_pkg.get_apportion_factor(inv_id, pn_invoice_line_number);
5958:
5959: /* service Start */
5960: open c_rcv_transactions(rcv_tran_id);
5961: fetch c_rcv_transactions into r_rcv_transactions;
5962: close c_rcv_transactions;
5963:
5964: open c_po_lines_all(po_dist_id);
5965: fetch c_po_lines_all into r_po_lines_all;

Line 5962: close c_rcv_transactions;

5958:
5959: /* service Start */
5960: open c_rcv_transactions(rcv_tran_id);
5961: fetch c_rcv_transactions into r_rcv_transactions;
5962: close c_rcv_transactions;
5963:
5964: open c_po_lines_all(po_dist_id);
5965: fetch c_po_lines_all into r_po_lines_all;
5966: close c_po_lines_all;

Line 5971: p_organization_id => r_rcv_transactions.organization_id,

5967:
5968: lv_is_item_an_expense :=
5969: jai_general_pkg.is_item_an_expense
5970: (
5971: p_organization_id => r_rcv_transactions.organization_id,
5972: p_item_id => r_po_lines_all.item_id
5973: );
5974:
5975: lv_accrue_on_receipt_flag :=