DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on PO_LINES_ALL

Line 348: FROM po_lines_all

344: AND (p_org_id IS NULL OR org_id = p_org_id);
345:
346: CURSOR c_po_line( p_po_header_id IN NUMBER, p_document_line_no IN NUMBER) IS
347: SELECT po_line_id
348: FROM po_lines_all
349: WHERE po_header_id = p_po_header_id AND line_num = p_document_line_no;
350:
351: CURSOR c_shipment_line( p_po_line_id IN NUMBER, p_shipment_no IN NUMBER,
352: p_shipment_type IN VARCHAR2, p_release_id IN NUMBER) IS

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 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 724: FROM po_headers_all pha, po_lines_all pla,

720: plla.ship_to_organization_id, plla.ship_to_location_id,
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