[Home] [Help]
522: ,substr(pa_expenditures_utils.getorgtlname(po.org_id),1,30) PoOuname
523: ,pod.project_id PoProjectId
524: From po_headers_all po
525: ,po_vendors v
526: ,po_distributions_all pod
527: Where po.vendor_id = v.vendor_id
528: and NVL(po.closed_code,'XX') NOT IN ('FINALLY CLOSED','CLOSED')
529: and pod.po_header_id = po.po_header_id
530: and (( po.org_id = c_org_id and c_org_id is NOT NULL ) or c_org_id is NULL )
543: ,substr(pa_expenditures_utils.getorgtlname(po.org_id),1,30) PoOuname
544: ,pod.project_id PoProjectId
545: From po_headers_all po
546: ,po_vendors v
547: ,po_distributions_all pod
548: Where po.vendor_id = v.vendor_id
549: and NVL(po.closed_code,'XX') NOT IN ('FINALLY CLOSED','CLOSED')
550: and pod.po_header_id = po.po_header_id
551: and (( po.org_id = c_org_id and c_org_id is NOT NULL ) or c_org_id is NULL )
565: ,substr(pa_expenditures_utils.getorgtlname(pod.org_id),1,30) Ouname
566: ,pod.po_distribution_id Podistid
567: From po_lines_all pol
568: ,po_headers_all poh
569: ,po_distributions_all pod
570: Where poh.po_header_id = pol.po_header_id
571: and pod.po_header_id = pol.po_header_id
572: and pod.po_line_id = pol.po_line_id
573: and NVL(poh.closed_code,'XX') NOT IN ('FINALLY CLOSED','CLOSED')
589: ,substr(pa_expenditures_utils.getorgtlname(pod.org_id),1,30) Ouname
590: ,pod.po_distribution_id Podistid
591: From po_lines_all pol
592: ,po_headers_all poh
593: ,po_distributions_all pod
594: Where poh.po_header_id = pol.po_header_id
595: and pod.po_header_id = pol.po_header_id
596: and pod.po_line_id = pol.po_line_id
597: AND NVL(POL.CLM_INFO_FLAG,'N') = 'N' --Bug 9462109: CLM enhancement
807: /*if vendor id is not null then check whether it is valid or not,
808: depending on the change_type, execute the cursor query*/
809: if p_vendor_id is not null and p_vendor_id <> G_PA_MISS_NUM then
810: if p_change_type = 'UPDATE' then
811: l_check_vendor_query := l_check_vendor_query || ' where EXISTS (select * from po_distributions_all pod ,po_headers_all poh where pod.po_header_id = poh.po_header_id and pod.project_id = '||
812: l_project_id ||' and poh.vendor_id = v.vendor_id and v.vendor_id = '''||p_vendor_id ||''') ';
813: else
814: l_check_vendor_query := l_check_vendor_query ||
815: ' where v.vendor_id = '''||p_vendor_id ||'''';