APPS.JAI_CMN_MTAX_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 313: FROM po_line_locations_all

309:
310: CURSOR c_shipment_line( p_po_line_id IN NUMBER, p_shipment_no IN NUMBER,
311: p_shipment_type IN VARCHAR2, p_release_id IN NUMBER) IS
312: SELECT line_location_id
313: FROM po_line_locations_all
314: WHERE po_line_id = p_po_line_id
315: AND shipment_num = p_shipment_no
316: AND shipment_type = p_shipment_type
317: AND ( (p_release_id IS NULL) OR (p_release_id IS NOT NULL AND po_release_id = p_release_id));

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

498: plla.ship_to_organization_id, plla.ship_to_location_id,
499: plla.unit_meas_lookup_code, plla.price_override, plla.shipment_type,
500: pla.item_id, pla.unit_meas_lookup_code line_uom,
501: pha.segment1 document_no, pla.line_num, plla.shipment_num
502: FROM po_headers_all pha, po_lines_all pla, po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jipll
503: WHERE pha.po_header_id = pla.po_header_id
504: AND pla.po_line_id = plla.po_line_id
505: AND plla.line_location_id = jipll.line_location_id
506: AND plla.shipment_type = p_shipment_type

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

525: jai_constants.closed_code_preapproved ,
526: jai_constants.closed_code_req_appr ,
527: jai_constants.closed_code_incomplete ))
528: --'OPEN', 'IN PROCESS', 'APPROVED', 'PRE-APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') )
529: UNION -- if there are no base records in po_line_locations_all but JAI_PO_LINE_LOCATIONS have
530: SELECT 2 source, jipll.rowid,
531: jipll.line_focus_id, jipll.line_location_id, jipll.po_line_id, jipll.po_header_id, jipll.tax_category_id,
532: pha.type_lookup_code, pha.vendor_id, pha.vendor_site_id, pha.currency_code,
533: pha.rate, pha.rate_date, pha.rate_type, pha.ship_to_location_id hdr_ship_to_location_id,

Line 588: po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jipll, po_releases_all pra

584: plla.unit_meas_lookup_code, plla.price_override, plla.shipment_type,
585: pla.item_id, pla.unit_meas_lookup_code line_uom,
586: pra.release_num, pha.segment1 document_no, pla.line_num, plla.shipment_num
587: FROM po_headers_all pha, po_lines_all pla,
588: po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jipll, po_releases_all pra
589: WHERE pha.po_header_id = pla.po_header_id
590: AND pla.po_line_id = plla.po_line_id
591: AND pla.po_line_id = jipll.po_line_id
592: AND plla.line_location_id = jipll.line_location_id