APPS.JAI_CMN_MTAX_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 385: FROM po_requisition_lines_all

381: AND (p_org_id IS NULL OR org_id = p_org_id);
382:
383: CURSOR c_requisition_line( p_requisition_header_id IN NUMBER, p_requisition_line_no IN NUMBER) IS
384: SELECT requisition_line_id
385: FROM po_requisition_lines_all
386: WHERE requisition_header_id = p_requisition_header_id AND line_num = p_requisition_line_no;
387:
388:
389: --Added by zhiwei for BOE ER bug 11684111 begin

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