DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on PO_HEADERS_ALL

Line 300: FROM po_headers_all

296: --//~~~~~~~~ Declaration Section for Preprocessing of the variables ~~~~~~~~~~//
297:
298: CURSOR c_po_header( p_document_type IN VARCHAR2, p_document_no IN VARCHAR2, p_org_id IN NUMBER) IS
299: SELECT po_header_id
300: FROM po_headers_all
301: WHERE segment1 = p_document_no
302: AND type_lookup_code = p_document_type
303: AND (p_org_id IS NULL OR org_id = p_org_id);
304:

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 541: FROM po_headers_all pha, po_lines_all pla, JAI_PO_LINE_LOCATIONS jipll

537: -1 ship_to_organization_id, -1 ship_to_location_id,
538: null unit_meas_lookup_code, 0 price_override, null shipment_type,
539: pla.item_id, pla.unit_meas_lookup_code line_uom,
540: pha.segment1 document_no, pla.line_num, -1 shipment_num
541: FROM po_headers_all pha, po_lines_all pla, JAI_PO_LINE_LOCATIONS jipll
542: WHERE pha.po_header_id = pla.po_header_id
543: AND pla.po_line_id = jipll.po_line_id
544: AND ((p_document_no IS NULL) or (p_document_no is NOT NULL and pha.segment1 = p_document_no ))
545: AND pha.type_lookup_code = p_document_type

Line 587: FROM po_headers_all pha, po_lines_all pla,

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