DBA Data[Home] [Help]

APPS.PA_CONTROL_API_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 526: ,po_distributions_all pod

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 )

Line 547: ,po_distributions_all pod

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 )

Line 569: ,po_distributions_all pod

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')

Line 591: ,po_distributions_all pod

587: ,substr(pa_expenditures_utils.getorgtlname(pod.org_id),1,30) Ouname
588: ,pod.po_distribution_id Podistid
589: From po_lines_all pol
590: ,po_headers_all poh
591: ,po_distributions_all pod
592: Where poh.po_header_id = pol.po_header_id
593: and pod.po_header_id = pol.po_header_id
594: and pod.po_line_id = pol.po_line_id
595: and NVL(poh.closed_code,'XX') NOT IN ('FINALLY CLOSED','CLOSED')

Line 807: 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 = '||

803: /*if vendor id is not null then check whether it is valid or not,
804: depending on the change_type, execute the cursor query*/
805: if p_vendor_id is not null and p_vendor_id <> G_PA_MISS_NUM then
806: if p_change_type = 'UPDATE' then
807: 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 = '||
808: l_project_id ||' and poh.vendor_id = v.vendor_id and v.vendor_id = '''||p_vendor_id ||''') ';
809: else
810: l_check_vendor_query := l_check_vendor_query ||
811: ' where v.vendor_id = '''||p_vendor_id ||'''';