APPS.JAI_RCV_TAX_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 59: v_loc_quantity po_line_locations_all.quantity % TYPE;

55: lv_object_name CONSTANT VARCHAR2(61) := 'jai_rcv_tax_pkg.default_taxes_onto_line';
56:
57: -- LAST MODIFIED BY SRIHARI on 25-JUN-2000
58: v_receipt_num rcv_shipment_headers.receipt_num % TYPE;
59: v_loc_quantity po_line_locations_all.quantity % TYPE;
60: v_cor_amount JAI_PO_LINE_LOCATIONS.tax_amount % TYPE;
61: -- v_form_id VARCHAR2(30); --File.Sql.35 Cbabu := 'JAINPORE';
62: v_chk_form VARCHAR2(30);
63: -- v_rowid JAI_CMN_LOCATORS_T.row_id % TYPE;

Line 1080: of PO_LINES_ALL instead of PO_LINE_LOCATIONS_ALL. Code is modified to calculate

1076: When a Receipt is made against a SCHEDULED Release (partial quantity) of
1077: PLANNED PO, then taxes are calculated for whole of the PLANNED PO line quantity
1078: instead of SCHEDULED Release quantity.
1079: The issue is occuring because, precedence_0 is calculated as unit_price * quantity
1080: of PO_LINES_ALL instead of PO_LINE_LOCATIONS_ALL. Code is modified to calculate
1081: precedence_0 as PRICE_OVERRIDE * QUANTITY of PO_LINE_LOCATIONS_ALL instead of using
1082: PO_LINES_ALL
1083:
1084: 16. 06/06/2003 Nagaraj.s for Bug #2991872. Version : 616.1

Line 1081: precedence_0 as PRICE_OVERRIDE * QUANTITY of PO_LINE_LOCATIONS_ALL instead of using

1077: PLANNED PO, then taxes are calculated for whole of the PLANNED PO line quantity
1078: instead of SCHEDULED Release quantity.
1079: The issue is occuring because, precedence_0 is calculated as unit_price * quantity
1080: of PO_LINES_ALL instead of PO_LINE_LOCATIONS_ALL. Code is modified to calculate
1081: precedence_0 as PRICE_OVERRIDE * QUANTITY of PO_LINE_LOCATIONS_ALL instead of using
1082: PO_LINES_ALL
1083:
1084: 16. 06/06/2003 Nagaraj.s for Bug #2991872. Version : 616.1
1085: Code is added to ensure that if Assessable price is defined for Excise Taxes, then

Line 1086: the Assessable Price is picked up instead of the unit price from po_line_locations_all

1082: PO_LINES_ALL
1083:
1084: 16. 06/06/2003 Nagaraj.s for Bug #2991872. Version : 616.1
1085: Code is added to ensure that if Assessable price is defined for Excise Taxes, then
1086: the Assessable Price is picked up instead of the unit price from po_line_locations_all
1087: table.
1088:
1089: 17. 21/07/2003 Vijay Shankar for Bug# 3028040, Version : 616.2
1090: Code is added to check for EXPRESS transaction and then stop 'For Passing' to fire for every RECEIVE transaction

Line 1828: FROM po_line_locations_all plla,

1824: IF p_source_document_code = 'PO' THEN
1825: --Changed by Nagaraj.s for Bug2531667
1826: FOR ll_rec IN (SELECT plla.unit_meas_lookup_code ll_uom,
1827: pla.unit_meas_lookup_code l_uom
1828: FROM po_line_locations_all plla,
1829: po_lines_all pla
1830: WHERE plla.line_location_id = p_line_location_id
1831: AND pla.po_header_id = plla.po_header_id
1832: AND pla.po_line_id = p_po_line_id)

Line 2042: FROM po_line_locations_all

2038:
2039: -------------------------- To retrieve po quantity -------------------------------------
2040:
2041: FOR qty_rec IN (SELECT quantity
2042: FROM po_line_locations_all
2043: WHERE line_location_id = p_line_location_id)
2044: LOOP
2045: v_loc_quantity := qty_rec.quantity;
2046: END LOOP;

Line 2487: FROM po_line_locations_all

2483: IF p_source_document_code = 'PO' AND lv_asbn_type <> 'TRUE'
2484: THEN
2485: SELECT price_override , quantity
2486: INTO v_price_override,v_po_quantity
2487: FROM po_line_locations_all
2488: WHERE line_location_id = p_line_location_id;
2489: ELSIF p_source_document_code = 'PO' AND lv_asbn_type = 'TRUE'
2490: THEN
2491: v_po_quantity := r_jai_cmn_lines.quantity;