DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on PO_REQUISITION_HEADERS_ALL

Line 378: FROM po_requisition_headers_all

374: WHERE header_id = p_header_id AND line_number = p_line_no;
375:
376: CURSOR c_requisition_header( p_document_type IN VARCHAR2, p_requisition_no IN VARCHAR2, p_org_id IN NUMBER) IS
377: SELECT requisition_header_id
378: FROM po_requisition_headers_all
379: WHERE segment1 = p_requisition_no
380: AND type_lookup_code = p_document_type
381: AND (p_org_id IS NULL OR org_id = p_org_id);
382:

Line 774: FROM po_requisition_headers_all prha, po_requisition_lines_all prla, JAI_PO_REQ_LINES jirl

770: prla.suggested_vendor_name, prla.suggested_vendor_location,
771: prla.destination_organization_id, prla.deliver_to_location_id, prla.source_organization_id,
772: prla.source_type_code, -- this tells whether source is VENDOR or INVENTORY. If vendor then suggested vendor will be there
773: prha.segment1 document_no, prla.line_num
774: FROM po_requisition_headers_all prha, po_requisition_lines_all prla, JAI_PO_REQ_LINES jirl
775: WHERE prha.requisition_header_id = prla.requisition_header_id
776: AND prla.requisition_line_id = jirl.requisition_line_id
777: AND ((p_document_no is null) OR (p_document_no is not null and prha.segment1 = p_document_no ))
778: AND prha.type_lookup_code = p_document_type