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_MATCH_TAX_PKG dependencies on JAI_RCV_TRANSACTIONS

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

1280:
1281:
1282:
1283: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
1284: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
1285: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
1286: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
1287: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
1288: is

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

1281:
1282:
1283: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
1284: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
1285: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
1286: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
1287: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
1288: is
1289: select attribute2 excise_costing_flag

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

1282:
1283: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
1284: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
1285: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
1286: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
1287: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
1288: is
1289: select attribute2 excise_costing_flag
1290: from jai_rcv_transactions jrcvt

Line 1287: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308

1283: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
1284: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
1285: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
1286: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
1287: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
1288: is
1289: select attribute2 excise_costing_flag
1290: from jai_rcv_transactions jrcvt
1291: where jrcvt.parent_transaction_id = cp_rcv_transaction_id

Line 1290: from jai_rcv_transactions jrcvt

1286: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
1287: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
1288: is
1289: select attribute2 excise_costing_flag
1290: from jai_rcv_transactions jrcvt
1291: where jrcvt.parent_transaction_id = cp_rcv_transaction_id
1292: and jrcvt.organization_id = cp_organization_id --Added by Bgowrava for Bug#7503308
1293: and jrcvt.shipment_header_id = cp_shipment_header_id --Added by Bgowrava for Bug#7503308
1294: and jrcvt.transaction_type = cp_txn_type --'DELIVER' --Modified by Bgowrava for Bug#7503308

Line 2067: Reason: full table scan on JAI_RCV_TRANSACTIONS table in cursor c_get_excise_costing_flag

2063: based on v_assets_tracking_flag and removed the condition of account_type.
2064:
2065: 57. 12-Dec-2008 Added by Bgowrava for Bug#7503308, File Version 120.7.12000000.15, 120.34.12010000.4, 120.38
2066: Issue: INDIA - TO INSERT TAXES FOR PAY ON RECEIPT REQUESTPERFORMANCE ISSUE
2067: Reason: full table scan on JAI_RCV_TRANSACTIONS table in cursor c_get_excise_costing_flag
2068: Fix: Added organization_id and shipment_headder_id columns
2069:
2070: 58. 06-Apr-2010 Bgowrava For Bug#9499146, File Version 120.34.12010000.14,
2071: Issue: WRONG AP ACCRUAL ACCOUNT TAKING FOR RECOVERABLE TAXES LIKE EXCISE IN AP INVOICE

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

7564:
7565:
7566:
7567: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
7568: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
7569: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
7570: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
7571: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
7572: is

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

7565:
7566:
7567: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
7568: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
7569: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
7570: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
7571: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
7572: is
7573: select attribute2 excise_costing_flag

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

7566:
7567: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
7568: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
7569: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
7570: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
7571: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
7572: is
7573: select attribute2 excise_costing_flag
7574: from jai_rcv_transactions jrcvt

Line 7571: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308

7567: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
7568: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
7569: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
7570: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
7571: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
7572: is
7573: select attribute2 excise_costing_flag
7574: from jai_rcv_transactions jrcvt
7575: where jrcvt.parent_transaction_id = cp_rcv_transaction_id

Line 7574: from jai_rcv_transactions jrcvt

7570: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
7571: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
7572: is
7573: select attribute2 excise_costing_flag
7574: from jai_rcv_transactions jrcvt
7575: where jrcvt.parent_transaction_id = cp_rcv_transaction_id
7576: and jrcvt.organization_id = cp_organization_id --Added by Bgowrava for Bug#7503308
7577: and jrcvt.shipment_header_id = cp_shipment_header_id
7578: and jrcvt.transaction_type = cp_txn_type --'DELIVER' --Modified by Bgowrava for Bug#7503308