APPS.CSE_IPV_FA_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 617: FROM po_distributions_all pod

613: AND ct.transaction_status_code = 'COMPLETE'
614: AND ct.source_dist_ref_id1 = aida.po_distribution_id)
615: AND EXISTS (
616: SELECT '1'
617: FROM po_distributions_all pod
618: WHERE pod.po_distribution_id = aida.po_distribution_id
619: AND pod.po_header_id = nvl(p_po_header_id,pod.po_header_id)
620: AND pod.destination_organization_id = nvl(p_organization_id, pod.destination_organization_id))
621: UNION -- Added for bug 13770784

Line 667: FROM po_distributions_all pod

663: AND ct.transaction_status_code = 'COMPLETE'
664: AND ct.source_dist_ref_id1 = aida4.po_distribution_id)
665: AND EXISTS (
666: SELECT '1'
667: FROM po_distributions_all pod
668: WHERE pod.po_distribution_id = aida4.po_distribution_id
669: AND pod.po_header_id = nvl(p_po_header_id,pod.po_header_id)
670: AND pod.destination_organization_id = nvl(p_organization_id, pod.destination_organization_id)))
671: -- Cursor to get all the NONREC_TAX line types which has po_distribution_id as NULL -- Added for bug 13770784

Line 713: FROM po_distributions_all pod

709: AND ct.transaction_status_code = 'COMPLETE'
710: AND ct.source_dist_ref_id1 = aida.po_distribution_id)
711: AND EXISTS (
712: SELECT '1'
713: FROM po_distributions_all pod
714: WHERE pod.po_distribution_id = aida.po_distribution_id
715: AND pod.po_header_id = nvl(p_po_header_id,pod.po_header_id)
716: AND pod.destination_organization_id = nvl(p_organization_id, pod.destination_organization_id));*/
717: UNION

Line 912: FROM po_distributions_all pod,

908: l_invoice_rec.organization_id,
909: l_invoice_rec.payables_ccid,
910: l_invoice_rec.po_num,
911: l_invoice_rec.po_vendor_id
912: FROM po_distributions_all pod,
913: po_lines_all pol,
914: po_headers_all poh
915: WHERE pod.po_distribution_id = invoice_rec.po_distribution_id
916: AND pol.po_line_id = pod.po_line_id