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 PO_LINES_ALL

Line 888: v_po_unit_meas_lookup_code po_lines_all.unit_meas_lookup_code%type;

884: from jai_cmn_taxes_all
885: where tax_id = cp_tax_id ;
886:
887: ln_precision fnd_currencies.precision%type; -- added by sssumaith - bug# 3127834
888: v_po_unit_meas_lookup_code po_lines_all.unit_meas_lookup_code%type;
889: r_tax_lines_rec r_tax_lines_cur%ROWTYPE;
890: /* r_cur_items_rec r_cur_items%ROWTYPE; Bug#4095234*/
891: vPoUomCode mtl_units_of_measure.unit_of_measure%TYPE;
892: vReceiptUomCode mtl_units_of_measure.unit_of_measure%TYPE;

Line 993: cursor c_po_lines_all(p_po_line_id number) is

989: from rcv_transactions
990: where transaction_id = p_transaction_id;
991:
992:
993: cursor c_po_lines_all(p_po_line_id number) is
994: select item_id
995: from po_lines_all
996: where po_line_id = p_po_line_id;
997:

Line 995: from po_lines_all

991:
992:
993: cursor c_po_lines_all(p_po_line_id number) is
994: select item_id
995: from po_lines_all
996: where po_line_id = p_po_line_id;
997:
998: /* Bug 5358788. Added by Lakshmi Gopalsami
999: * Added parameter cp_regime_code instead of

Line 1019: r_po_lines_all c_po_lines_all%rowtype;

1015: and attribute_code = cp_tax_type;
1016:
1017:
1018: r_rcv_transactions c_rcv_transactions%rowtype;
1019: r_po_lines_all c_po_lines_all%rowtype;
1020: r_jai_regimes c_jai_regimes%rowtype;
1021: r_service_regime_tax_type c_regime_tax_type%rowtype;
1022: lv_is_item_an_expense varchar2(20); /* Service */
1023: lv_accounting_method_option varchar2(20); /* Service */

Line 1593: like BPA, where the UOM is in po_lines_all in stead of po_line_locations_all.

1589: change in price too. In such cases, UOM is also taken into account for changes
1590: in quantity and price.
1591:
1592: UOM at PO was being checked always from po_line_locations. But there are cases
1593: like BPA, where the UOM is in po_lines_all in stead of po_line_locations_all.
1594: Changed the code to check from po_lines_all whenever UOM does not exist in
1595: Po_line_locations_all.
1596:
1597: 37 11/06/2004 Aparajita for bug#3671967. Version#115.2

Line 1594: Changed the code to check from po_lines_all whenever UOM does not exist in

1590: in quantity and price.
1591:
1592: UOM at PO was being checked always from po_line_locations. But there are cases
1593: like BPA, where the UOM is in po_lines_all in stead of po_line_locations_all.
1594: Changed the code to check from po_lines_all whenever UOM does not exist in
1595: Po_line_locations_all.
1596:
1597: 37 11/06/2004 Aparajita for bug#3671967. Version#115.2
1598:

Line 1933: open c_po_lines_all(from_po_distributions_rec.po_line_id);

1929: FETCH from_po_distributions INTO from_po_distributions_rec;
1930: CLOSE from_po_distributions;
1931:
1932:
1933: open c_po_lines_all(from_po_distributions_rec.po_line_id);
1934: fetch c_po_lines_all into r_po_lines_all;
1935: close c_po_lines_all;
1936:
1937: lv_is_item_an_expense := null;

Line 1934: fetch c_po_lines_all into r_po_lines_all;

1930: CLOSE from_po_distributions;
1931:
1932:
1933: open c_po_lines_all(from_po_distributions_rec.po_line_id);
1934: fetch c_po_lines_all into r_po_lines_all;
1935: close c_po_lines_all;
1936:
1937: lv_is_item_an_expense := null;
1938: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense

Line 1935: close c_po_lines_all;

1931:
1932:
1933: open c_po_lines_all(from_po_distributions_rec.po_line_id);
1934: fetch c_po_lines_all into r_po_lines_all;
1935: close c_po_lines_all;
1936:
1937: lv_is_item_an_expense := null;
1938: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense
1939: (

Line 1941: p_item_id => r_po_lines_all.item_id

1937: lv_is_item_an_expense := null;
1938: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense
1939: (
1940: p_organization_id => r_rcv_transactions.organization_id,
1941: p_item_id => r_po_lines_all.item_id
1942: );
1943:
1944: /*lv_accounting_method_option := jai_general_pkg.get_accounting_method
1945: (

Line 2118: ||', r_po_lines_all.item_id='||r_po_lines_all.item_id

2114: close c_get_ship_to_org_loc;
2115:
2116:
2117: Fnd_File.put_line(Fnd_File.LOG, 'ln_ship_to_organization_id='||ln_ship_to_organization_id
2118: ||', r_po_lines_all.item_id='||r_po_lines_all.item_id
2119: );
2120: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense
2121: (
2122: p_organization_id => ln_ship_to_organization_id,

Line 2123: p_item_id => r_po_lines_all.item_id

2119: );
2120: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense
2121: (
2122: p_organization_id => ln_ship_to_organization_id,
2123: p_item_id => r_po_lines_all.item_id
2124: );
2125: /*6595773 end*/
2126: if r_service_regime_tax_type.tax_type is not null then
2127: /* Service type of tax */

Line 6037: cursor c_po_lines_all(p_po_line_id number) is

6033: select po_line_id, organization_id
6034: from rcv_transactions
6035: where transaction_id = p_transaction_id;
6036:
6037: cursor c_po_lines_all(p_po_line_id number) is
6038: select item_id
6039: from po_lines_all
6040: where po_line_id = p_po_line_id;
6041:

Line 6039: from po_lines_all

6035: where transaction_id = p_transaction_id;
6036:
6037: cursor c_po_lines_all(p_po_line_id number) is
6038: select item_id
6039: from po_lines_all
6040: where po_line_id = p_po_line_id;
6041:
6042: /* Bug 5358788. Added by Lakshmi Gopalsami
6043: * Added parameter cp_regime_code instead of

Line 6069: r_po_lines_all c_po_lines_all%rowtype;

6065: where tax_id = cp_tax_id ;
6066: /*End, Added by kunkumar for bug#5593895*/
6067:
6068: r_rcv_transactions c_rcv_transactions%rowtype;
6069: r_po_lines_all c_po_lines_all%rowtype;
6070: r_jai_regimes c_jai_regimes%rowtype;
6071: r_service_regime_tax_type c_regime_tax_type%rowtype;
6072: lv_is_item_an_expense varchar2(20); /* Service */
6073: lv_accounting_method_option varchar2(20); /* Service */

Line 6763: open c_po_lines_all(po_dist_id);

6759: open c_rcv_transactions(rcv_tran_id);
6760: fetch c_rcv_transactions into r_rcv_transactions;
6761: close c_rcv_transactions;
6762:
6763: open c_po_lines_all(po_dist_id);
6764: fetch c_po_lines_all into r_po_lines_all;
6765: close c_po_lines_all;
6766:
6767: lv_is_item_an_expense :=

Line 6764: fetch c_po_lines_all into r_po_lines_all;

6760: fetch c_rcv_transactions into r_rcv_transactions;
6761: close c_rcv_transactions;
6762:
6763: open c_po_lines_all(po_dist_id);
6764: fetch c_po_lines_all into r_po_lines_all;
6765: close c_po_lines_all;
6766:
6767: lv_is_item_an_expense :=
6768: jai_general_pkg.is_item_an_expense

Line 6765: close c_po_lines_all;

6761: close c_rcv_transactions;
6762:
6763: open c_po_lines_all(po_dist_id);
6764: fetch c_po_lines_all into r_po_lines_all;
6765: close c_po_lines_all;
6766:
6767: lv_is_item_an_expense :=
6768: jai_general_pkg.is_item_an_expense
6769: (

Line 6771: p_item_id => r_po_lines_all.item_id

6767: lv_is_item_an_expense :=
6768: jai_general_pkg.is_item_an_expense
6769: (
6770: p_organization_id => r_rcv_transactions.organization_id,
6771: p_item_id => r_po_lines_all.item_id
6772: );
6773:
6774: /*lv_accounting_method_option :=
6775: jai_general_pkg.get_accounting_method