APPS.JAI_CMN_MTAX_PKG dependencies on JAI_PO_LINE_LOCATIONS

Line 639: FROM po_headers_all pha, po_lines_all pla, po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jipll

635: plla.ship_to_organization_id, plla.ship_to_location_id,
636: plla.unit_meas_lookup_code, plla.price_override, plla.shipment_type,
637: pla.item_id, pla.unit_meas_lookup_code line_uom,
638: pha.segment1 document_no, pla.line_num, plla.shipment_num
639: FROM po_headers_all pha, po_lines_all pla, po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jipll
640: WHERE pha.po_header_id = pla.po_header_id
641: AND pla.po_line_id = plla.po_line_id
642: AND plla.line_location_id = jipll.line_location_id
643: AND plla.shipment_type = p_shipment_type

Line 666: UNION -- if there are no base records in po_line_locations_all but JAI_PO_LINE_LOCATIONS have

662: jai_constants.closed_code_preapproved ,
663: jai_constants.closed_code_req_appr ,
664: jai_constants.closed_code_incomplete ))
665: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
666: UNION -- if there are no base records in po_line_locations_all but JAI_PO_LINE_LOCATIONS have
667: SELECT 2 source, jipll.rowid,
668: jipll.line_focus_id, jipll.line_location_id, jipll.po_line_id, jipll.po_header_id, jipll.tax_category_id,
669: pha.type_lookup_code, pha.vendor_id, pha.vendor_site_id, pha.currency_code,
670: pha.rate, pha.rate_date, pha.rate_type, pha.ship_to_location_id hdr_ship_to_location_id,

Line 678: FROM po_headers_all pha, po_lines_all pla, JAI_PO_LINE_LOCATIONS jipll

674: -1 ship_to_organization_id, -1 ship_to_location_id,
675: null unit_meas_lookup_code, 0 price_override, null shipment_type,
676: pla.item_id, pla.unit_meas_lookup_code line_uom,
677: pha.segment1 document_no, pla.line_num, -1 shipment_num
678: FROM po_headers_all pha, po_lines_all pla, JAI_PO_LINE_LOCATIONS jipll
679: WHERE pha.po_header_id = pla.po_header_id
680: AND pla.po_line_id = jipll.po_line_id
681: AND ((p_document_no IS NULL) or (p_document_no is NOT NULL and pha.segment1 = p_document_no ))
682: AND pha.type_lookup_code = p_document_type

Line 725: po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jipll, po_releases_all pra

721: plla.unit_meas_lookup_code, plla.price_override, plla.shipment_type,
722: pla.item_id, pla.unit_meas_lookup_code line_uom,
723: pra.release_num, pha.segment1 document_no, pla.line_num, plla.shipment_num
724: FROM po_headers_all pha, po_lines_all pla,
725: po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jipll, po_releases_all pra
726: WHERE pha.po_header_id = pla.po_header_id
727: AND pla.po_line_id = plla.po_line_id
728: AND pla.po_line_id = jipll.po_line_id
729: AND plla.line_location_id = jipll.line_location_id

Line 2172: UPDATE JAI_PO_LINE_LOCATIONS

2168: );
2169:
2170: END IF;
2171:
2172: UPDATE JAI_PO_LINE_LOCATIONS
2173: SET tax_category_id = v_dflt_tax_category_id
2174: WHERE rowid = shipment_rec.rowid;
2175:
2176: ELSE -- Failed to remove old taxes and insert new taxes because of some reason(will be shown in the LOG)

Line 2761: UPDATE JAI_PO_LINE_LOCATIONS

2757: );
2758:
2759: END IF;
2760:
2761: UPDATE JAI_PO_LINE_LOCATIONS
2762: SET tax_category_id = v_dflt_tax_category_id
2763: WHERE rowid = releases_rec.rowid;
2764:
2765: ELSE -- Failed to remove old taxes and insert new taxes because of some reason(will be shown in the LOG)

Line 4760: p_line_focus_id IN NUMBER, -- IF 'PO' this should contain JAI_PO_LINE_LOCATIONS.line_focus_id and

4756:
4757: PROCEDURE del_taxes_after_validate
4758: (
4759: p_document_type IN VARCHAR2, -- eg. PO, SO, REQUISITION
4760: p_line_focus_id IN NUMBER, -- IF 'PO' this should contain JAI_PO_LINE_LOCATIONS.line_focus_id and
4761: p_line_location_id IN NUMBER,
4762: p_line_id IN NUMBER, -- if 'SO' then this should contain JAI_OM_OE_SO_LINES.line_id
4763: p_success OUT NOCOPY NUMBER,
4764: p_message OUT NOCOPY VARCHAR2