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 1184: v_po_unit_meas_lookup_code po_lines_all.unit_meas_lookup_code%type;

1180: ln_source VARCHAR2(50);
1181:
1182: ln_precision fnd_currencies.precision%type; -- added by sssumaith - bug# 3127834
1183: ln_tax_precision jai_cmn_taxes_all.rounding_factor%type;
1184: v_po_unit_meas_lookup_code po_lines_all.unit_meas_lookup_code%type;
1185: r_tax_lines_rec r_tax_lines_cur%ROWTYPE;
1186: /* r_cur_items_rec r_cur_items%ROWTYPE; Bug#4095234*/
1187: vPoUomCode mtl_units_of_measure.unit_of_measure%TYPE;
1188: vReceiptUomCode mtl_units_of_measure.unit_of_measure%TYPE;

Line 1310: cursor c_po_lines_all(p_po_line_id number) is

1306: from rcv_transactions
1307: where transaction_id = p_transaction_id;
1308:
1309:
1310: cursor c_po_lines_all(p_po_line_id number) is
1311: select item_id
1312: from po_lines_all
1313: where po_line_id = p_po_line_id;
1314:

Line 1312: from po_lines_all

1308:
1309:
1310: cursor c_po_lines_all(p_po_line_id number) is
1311: select item_id
1312: from po_lines_all
1313: where po_line_id = p_po_line_id;
1314:
1315: /* Bug 5358788. Added by Lakshmi Gopalsami
1316: * Added parameter cp_regime_code instead of

Line 1336: r_po_lines_all c_po_lines_all%rowtype;

1332: and attribute_code = cp_tax_type;
1333:
1334:
1335: r_rcv_transactions c_rcv_transactions%rowtype;
1336: r_po_lines_all c_po_lines_all%rowtype;
1337: r_jai_regimes c_jai_regimes%rowtype;
1338: r_service_regime_tax_type c_regime_tax_type%rowtype;
1339: lv_is_item_an_expense varchar2(20); /* Service */
1340: lv_accounting_method_option varchar2(20); /* Service */

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

1916: change in price too. In such cases, UOM is also taken into account for changes
1917: in quantity and price.
1918:
1919: UOM at PO was being checked always from po_line_locations. But there are cases
1920: like BPA, where the UOM is in po_lines_all in stead of po_line_locations_all.
1921: Changed the code to check from po_lines_all whenever UOM does not exist in
1922: Po_line_locations_all.
1923:
1924: 37 11/06/2004 Aparajita for bug#3671967. Version#115.2

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

1917: in quantity and price.
1918:
1919: UOM at PO was being checked always from po_line_locations. But there are cases
1920: like BPA, where the UOM is in po_lines_all in stead of po_line_locations_all.
1921: Changed the code to check from po_lines_all whenever UOM does not exist in
1922: Po_line_locations_all.
1923:
1924: 37 11/06/2004 Aparajita for bug#3671967. Version#115.2
1925:

Line 2553: open c_po_lines_all(from_po_distributions_rec.po_line_id);

2549: FETCH from_po_distributions INTO from_po_distributions_rec;
2550: CLOSE from_po_distributions;
2551:
2552:
2553: open c_po_lines_all(from_po_distributions_rec.po_line_id);
2554: fetch c_po_lines_all into r_po_lines_all;
2555: close c_po_lines_all;
2556:
2557: lv_is_item_an_expense := null;

Line 2554: fetch c_po_lines_all into r_po_lines_all;

2550: CLOSE from_po_distributions;
2551:
2552:
2553: open c_po_lines_all(from_po_distributions_rec.po_line_id);
2554: fetch c_po_lines_all into r_po_lines_all;
2555: close c_po_lines_all;
2556:
2557: lv_is_item_an_expense := null;
2558: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense

Line 2555: close c_po_lines_all;

2551:
2552:
2553: open c_po_lines_all(from_po_distributions_rec.po_line_id);
2554: fetch c_po_lines_all into r_po_lines_all;
2555: close c_po_lines_all;
2556:
2557: lv_is_item_an_expense := null;
2558: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense
2559: (

Line 2561: p_item_id => r_po_lines_all.item_id

2557: lv_is_item_an_expense := null;
2558: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense
2559: (
2560: p_organization_id => r_rcv_transactions.organization_id,
2561: p_item_id => r_po_lines_all.item_id
2562: );
2563:
2564: /*lv_accounting_method_option := jai_general_pkg.get_accounting_method
2565: (

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

2749: close c_get_ship_to_org_loc;
2750:
2751:
2752: Fnd_File.put_line(Fnd_File.LOG, 'ln_ship_to_organization_id='||ln_ship_to_organization_id
2753: ||', r_po_lines_all.item_id='||r_po_lines_all.item_id
2754: );
2755: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense
2756: (
2757: p_organization_id => ln_ship_to_organization_id,

Line 2758: p_item_id => r_po_lines_all.item_id

2754: );
2755: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense
2756: (
2757: p_organization_id => ln_ship_to_organization_id,
2758: p_item_id => r_po_lines_all.item_id
2759: );
2760: /*6595773 end*/
2761: if r_service_regime_tax_type.tax_type is not null then
2762: /* Service type of tax */

Line 7588: cursor c_po_lines_all(p_po_line_id number) is

7584: select po_line_id, organization_id
7585: from rcv_transactions
7586: where transaction_id = p_transaction_id;
7587:
7588: cursor c_po_lines_all(p_po_line_id number) is
7589: select item_id
7590: from po_lines_all
7591: where po_line_id = p_po_line_id;
7592:

Line 7590: from po_lines_all

7586: where transaction_id = p_transaction_id;
7587:
7588: cursor c_po_lines_all(p_po_line_id number) is
7589: select item_id
7590: from po_lines_all
7591: where po_line_id = p_po_line_id;
7592:
7593: /* Bug 5358788. Added by Lakshmi Gopalsami
7594: * Added parameter cp_regime_code instead of

Line 7621: r_po_lines_all c_po_lines_all%rowtype;

7617: where tax_id = cp_tax_id ;
7618: /*End, Added by kunkumar for bug#5593895*/
7619:
7620: r_rcv_transactions c_rcv_transactions%rowtype;
7621: r_po_lines_all c_po_lines_all%rowtype;
7622: r_jai_regimes c_jai_regimes%rowtype;
7623: r_service_regime_tax_type c_regime_tax_type%rowtype;
7624: lv_is_item_an_expense varchar2(20); /* Service */
7625: lv_accounting_method_option varchar2(20); /* Service */

Line 8317: open c_po_lines_all(po_dist_id);

8313: open c_rcv_transactions(rcv_tran_id);
8314: fetch c_rcv_transactions into r_rcv_transactions;
8315: close c_rcv_transactions;
8316:
8317: open c_po_lines_all(po_dist_id);
8318: fetch c_po_lines_all into r_po_lines_all;
8319: close c_po_lines_all;
8320:
8321: lv_is_item_an_expense :=

Line 8318: fetch c_po_lines_all into r_po_lines_all;

8314: fetch c_rcv_transactions into r_rcv_transactions;
8315: close c_rcv_transactions;
8316:
8317: open c_po_lines_all(po_dist_id);
8318: fetch c_po_lines_all into r_po_lines_all;
8319: close c_po_lines_all;
8320:
8321: lv_is_item_an_expense :=
8322: jai_general_pkg.is_item_an_expense

Line 8319: close c_po_lines_all;

8315: close c_rcv_transactions;
8316:
8317: open c_po_lines_all(po_dist_id);
8318: fetch c_po_lines_all into r_po_lines_all;
8319: close c_po_lines_all;
8320:
8321: lv_is_item_an_expense :=
8322: jai_general_pkg.is_item_an_expense
8323: (

Line 8325: p_item_id => r_po_lines_all.item_id

8321: lv_is_item_an_expense :=
8322: jai_general_pkg.is_item_an_expense
8323: (
8324: p_organization_id => r_rcv_transactions.organization_id,
8325: p_item_id => r_po_lines_all.item_id
8326: );
8327:
8328: /*lv_accounting_method_option :=
8329: jai_general_pkg.get_accounting_method