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 967: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308

963: lv_ap_line_to_inst_flag VARCHAR2(1); --added by eric for inclusive tax
964: lv_tax_line_to_inst_flag VARCHAR2(1); --added by eric for inclusive tax
965:
966: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
967: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
968: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
969: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
970: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
971: is

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

964: lv_tax_line_to_inst_flag VARCHAR2(1); --added by eric for inclusive tax
965:
966: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
967: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
968: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
969: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
970: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
971: is
972: select attribute2 excise_costing_flag

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

965:
966: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
967: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
968: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
969: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
970: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
971: is
972: select attribute2 excise_costing_flag
973: from jai_rcv_transactions jrcvt

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

966: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
967: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
968: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
969: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
970: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
971: is
972: select attribute2 excise_costing_flag
973: from jai_rcv_transactions jrcvt
974: where jrcvt.parent_transaction_id = cp_rcv_transaction_id

Line 973: from jai_rcv_transactions jrcvt

969: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
970: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
971: is
972: select attribute2 excise_costing_flag
973: from jai_rcv_transactions jrcvt
974: where jrcvt.parent_transaction_id = cp_rcv_transaction_id
975: and jrcvt.organization_id = cp_organization_id --Added by Bgowrava for Bug#7503308
976: and jrcvt.shipment_header_id = cp_shipment_header_id --Added by Bgowrava for Bug#7503308
977: and jrcvt.transaction_type = cp_txn_type --'DELIVER' --Modified by Bgowrava for Bug#7503308

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

1736: based on v_assets_tracking_flag and removed the condition of account_type.
1737:
1738: 57. 12-Dec-2008 Added by Bgowrava for Bug#7503308, File Version 120.7.12000000.15, 120.34.12010000.4, 120.38
1739: Issue: INDIA - TO INSERT TAXES FOR PAY ON RECEIPT REQUESTPERFORMANCE ISSUE
1740: Reason: full table scan on JAI_RCV_TRANSACTIONS table in cursor c_get_excise_costing_flag
1741: Fix: Added organization_id and shipment_headder_id columns
1742:
1743: Future Dependencies For the release Of this Object:-
1744: ==================================================

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

6013:
6014:
6015:
6016: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
6017: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
6018: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
6019: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
6020: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
6021: is

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

6014:
6015:
6016: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
6017: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
6018: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
6019: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
6020: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
6021: is
6022: select attribute2 excise_costing_flag

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

6015:
6016: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
6017: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
6018: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
6019: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
6020: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
6021: is
6022: select attribute2 excise_costing_flag
6023: from jai_rcv_transactions jrcvt

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

6016: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
6017: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
6018: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
6019: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
6020: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
6021: is
6022: select attribute2 excise_costing_flag
6023: from jai_rcv_transactions jrcvt
6024: where jrcvt.parent_transaction_id = cp_rcv_transaction_id

Line 6023: from jai_rcv_transactions jrcvt

6019: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
6020: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
6021: is
6022: select attribute2 excise_costing_flag
6023: from jai_rcv_transactions jrcvt
6024: where jrcvt.parent_transaction_id = cp_rcv_transaction_id
6025: and jrcvt.organization_id = cp_organization_id --Added by Bgowrava for Bug#7503308
6026: and jrcvt.shipment_header_id = cp_shipment_header_id
6027: and jrcvt.transaction_type = cp_txn_type --'DELIVER' --Modified by Bgowrava for Bug#7503308