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

Line 27: 7. 15-Apr-2010 Bo Li 9305067 Replace the old attribute_category columns for JAI_RCV_TRANSACTIONS

23: 6. 09-Jul-2009 mbremkum 8660365 Appropriation factor was calculated using quantity from Base
24: Project Line. In R12 Projects populates amounts into Quantity.
25: Hence replaced it with the Delivered Quantity.
26:
27: 7. 15-Apr-2010 Bo Li 9305067 Replace the old attribute_category columns for JAI_RCV_TRANSACTIONS
28: with new meaningful one
29:
30: 8. 06-Jul-2010 Jia 7242428 Forward ported to R12.2 from R11i bug#7145704
31: Added the function get_comtmnt_amt

Line 90: pn_transaction_dist_id in number, /* One of PO_REQ_DISTRIBUTIONS_ALL.distribution_id, PO_DISTRIBUTIONS_ALL.po_distribution_id, RCV_TRANSACTIONS.transaction_id, AP_INVOICE_DISTRIBUTIONS_ALL.invoice_distribution_id */

86:
87: pv_transaction_source in varchar2,
88: pv_line_type in varchar2,
89: pn_transaction_header_id in number,
90: pn_transaction_dist_id in number, /* One of PO_REQ_DISTRIBUTIONS_ALL.distribution_id, PO_DISTRIBUTIONS_ALL.po_distribution_id, RCV_TRANSACTIONS.transaction_id, AP_INVOICE_DISTRIBUTIONS_ALL.invoice_distribution_id */
91: pv_currency_of_return_tax_amt in varchar2 default null, /* no value is passed, then tax amount in transaction currency is returned */
92: pv_transaction_uom in varchar2 default null, /* if not given, then conversion of UOM w.r.to main transaction will not be performed */
93: pn_transaction_qty in number default null,
94: pn_currency_conv_rate in number default null

Line 134: from JAI_RCV_TRANSACTIONS

130: r_get_po_line_loc_dtl c_get_po_line_loc_dtl%rowtype;
131:
132: cursor c_ja_in_rcv_trx(cp_transaction_id in number) is
133: select *
134: from JAI_RCV_TRANSACTIONS
135: where transaction_id = cp_transaction_id;
136: r_ja_in_receive_trx c_ja_in_rcv_trx%rowtype;
137: r_ja_in_deliver_trx c_ja_in_rcv_trx%rowtype;
138:

Line 883: from jai_rcv_transactions

879: and a.transaction_id = cp_tax_transaction_id;
880:
881: cursor c_ja_in_rcv_trx(cp_transaction_id in number) is
882: select *
883: from jai_rcv_transactions
884: where transaction_id = cp_transaction_id;
885: r_ja_in_receive_trx c_ja_in_rcv_trx%rowtype;
886: r_ja_in_deliver_trx c_ja_in_rcv_trx%rowtype;
887: ln_apportion_factor number;

Line 961: , pv_transaction_uom => r_po_rcpt.unit_of_measure -- this value is not being populated by costing. so we need to fetch from JAI_RCV_TRANSACTIONS

957: , pv_line_type => JAI_PA_COSTING_PKG.GV_LINE_TYPE_PO_RECEIPT
958: , pn_transaction_header_id => null -- ''
959: , pn_transaction_dist_id => r_po_rcpt.cdl_system_reference4 --> rcv_transaction_id
960: , pv_currency_of_return_tax_amt => JAI_PA_COSTING_PKG.gv_functional_currency
961: , pv_transaction_uom => r_po_rcpt.unit_of_measure -- this value is not being populated by costing. so we need to fetch from JAI_RCV_TRANSACTIONS
962: , pn_transaction_qty => r_po_rcpt.quantity
963: , pn_currency_conv_rate => r_po_rcpt.receipt_exchange_rate
964: );
965:

Line 1808: FROM jai_rcv_transactions a, rcv_transactions b

1804: SELECT a.transaction_id,
1805: a.shipment_header_id,
1806: a.quantity,
1807: b.currency_conversion_rate
1808: FROM jai_rcv_transactions a, rcv_transactions b
1809: WHERE b.po_distribution_id = cp_po_distribution_id
1810: AND ((b.destination_type_code = 'EXPENSE' ) OR
1811: (b.destination_type_code = 'RECEIVING' AND
1812: b.transaction_type in ('RETURN TO RECEIVING' , 'RETURN TO VENDOR')))

Line 1888: rec_get_deliver_trx jai_rcv_transactions%rowtype;

1884: ln_apportioned_func_tax_amt NUMBER;
1885: ln_apportioned_trx_tax_amt NUMBER;
1886: ln_trx_tax_amount NUMBER;
1887: ln_func_tax_amount NUMBER;
1888: rec_get_deliver_trx jai_rcv_transactions%rowtype;
1889: lv_cenvat_rg_flag VARCHAR2(1);
1890: lv_cenvat_rg_message jai_rcv_transactions.cenvat_rg_message%TYPE;
1891:
1892: CURSOR Rcv_Receipts_Cur (cp_transaction_id IN rcv_transactions.transaction_id%TYPE)

Line 1890: lv_cenvat_rg_message jai_rcv_transactions.cenvat_rg_message%TYPE;

1886: ln_trx_tax_amount NUMBER;
1887: ln_func_tax_amount NUMBER;
1888: rec_get_deliver_trx jai_rcv_transactions%rowtype;
1889: lv_cenvat_rg_flag VARCHAR2(1);
1890: lv_cenvat_rg_message jai_rcv_transactions.cenvat_rg_message%TYPE;
1891:
1892: CURSOR Rcv_Receipts_Cur (cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
1893: IS
1894: SELECT rcv_txn.transaction_id rcv_transaction_id,

Line 1892: CURSOR Rcv_Receipts_Cur (cp_transaction_id IN rcv_transactions.transaction_id%TYPE)

1888: rec_get_deliver_trx jai_rcv_transactions%rowtype;
1889: lv_cenvat_rg_flag VARCHAR2(1);
1890: lv_cenvat_rg_message jai_rcv_transactions.cenvat_rg_message%TYPE;
1891:
1892: CURSOR Rcv_Receipts_Cur (cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
1893: IS
1894: SELECT rcv_txn.transaction_id rcv_transaction_id,
1895: po_dist.po_distribution_id po_distribution_id,
1896: po_dist.po_header_id po_header_id,

Line 1938: from rcv_transactions rcv_txn,

1934: po_dist.ORG_ID
1935: ,rcv_sub.accounting_event_id acct_evt_id
1936: ,rcv_sub.accounted_rec_tax
1937: ,rcv_sub.entered_rec_tax
1938: from rcv_transactions rcv_txn,
1939: rcv_receiving_sub_ledger rcv_sub,
1940: po_headers_all po_head,
1941: po_lines_all po_line,
1942: po_distributions_all po_dist,

Line 1958: CURSOR cur_get_tax_amount(cp_transaction_id IN rcv_transactions.transaction_id%TYPE,

1954: AND rcv_txn.PO_DISTRIBUTION_ID=po_dist.po_distribution_id
1955: AND po_head.vendor_id=VEND.Vendor_Id
1956: order by rcv_txn.po_distribution_id;
1957:
1958: CURSOR cur_get_tax_amount(cp_transaction_id IN rcv_transactions.transaction_id%TYPE,
1959: cp_curr_conv_rate IN rcv_transactions.CURRENCY_CONVERSION_RATE%Type,
1960: cp_tax_type IN VARCHAR2)
1961: IS
1962: SELECT tax_id , -- Added by Jia for FP Bug#9863751, fetched Tax ID to uniquely identify a line in jai_pa_tax_trxs

Line 1959: cp_curr_conv_rate IN rcv_transactions.CURRENCY_CONVERSION_RATE%Type,

1955: AND po_head.vendor_id=VEND.Vendor_Id
1956: order by rcv_txn.po_distribution_id;
1957:
1958: CURSOR cur_get_tax_amount(cp_transaction_id IN rcv_transactions.transaction_id%TYPE,
1959: cp_curr_conv_rate IN rcv_transactions.CURRENCY_CONVERSION_RATE%Type,
1960: cp_tax_type IN VARCHAR2)
1961: IS
1962: SELECT tax_id , -- Added by Jia for FP Bug#9863751, fetched Tax ID to uniquely identify a line in jai_pa_tax_trxs
1963: nvl(

Line 1990: CURSOR cur_get_deliver_trx (cp_transaction_id IN rcv_transactions.transaction_id%TYPE)

1986: jai_constants.tax_type_sh_exc_edu_cess
1987: )))
1988: and transaction_id = cp_transaction_id;
1989:
1990: CURSOR cur_get_deliver_trx (cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
1991: IS
1992: SELECT *
1993: FROM jai_rcv_transactions
1994: WHERE transaction_type = 'DELIVER'

Line 1993: FROM jai_rcv_transactions

1989:
1990: CURSOR cur_get_deliver_trx (cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
1991: IS
1992: SELECT *
1993: FROM jai_rcv_transactions
1994: WHERE transaction_type = 'DELIVER'
1995: AND parent_transaction_id = cp_transaction_id;
1996:
1997: CURSOR cur_get_process_flag (cp_transaction_id IN rcv_transactions.transaction_id%TYPE)

Line 1997: CURSOR cur_get_process_flag (cp_transaction_id IN rcv_transactions.transaction_id%TYPE)

1993: FROM jai_rcv_transactions
1994: WHERE transaction_type = 'DELIVER'
1995: AND parent_transaction_id = cp_transaction_id;
1996:
1997: CURSOR cur_get_process_flag (cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
1998: IS
1999: SELECT process_status_flag
2000: FROM jai_rcv_rgm_lines
2001: WHERE transaction_id = cp_transaction_id;

Line 2003: CURSOR cur_get_cenvat_dtls (cp_transaction_id IN rcv_transactions.transaction_id%TYPE)

1999: SELECT process_status_flag
2000: FROM jai_rcv_rgm_lines
2001: WHERE transaction_id = cp_transaction_id;
2002:
2003: CURSOR cur_get_cenvat_dtls (cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
2004: IS
2005: SELECT cenvat_rg_status, cenvat_rg_message
2006: FROM jai_rcv_transactions
2007: WHERE transaction_id = cp_transaction_id;

Line 2006: FROM jai_rcv_transactions

2002:
2003: CURSOR cur_get_cenvat_dtls (cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
2004: IS
2005: SELECT cenvat_rg_status, cenvat_rg_message
2006: FROM jai_rcv_transactions
2007: WHERE transaction_id = cp_transaction_id;
2008:
2009: -- Added by Jia for FP Bug#9863751, Begin
2010: ---------------------------------------------------------------------------