DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on PO_RELEASES_ALL

Line 321: FROM po_releases_all

317: AND ( (p_release_id IS NULL) OR (p_release_id IS NOT NULL AND po_release_id = p_release_id));
318:
319: CURSOR c_po_release( p_po_header_id IN NUMBER, p_release_no IN NUMBER) IS
320: SELECT po_release_id
321: FROM po_releases_all
322: WHERE po_header_id = p_po_header_id AND release_num = p_release_no;
323:
324: CURSOR c_so_header( p_order_number IN NUMBER, p_org_id IN NUMBER) IS
325: SELECT header_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