DBA Data[Home] [Help]

APPS.CSE_IPV_FA_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 551: FROM po_distributions_all pod

547: AND ct.transaction_status_code = 'COMPLETE'
548: AND ct.source_dist_ref_id1 = aida.po_distribution_id)
549: AND EXISTS (
550: SELECT '1'
551: FROM po_distributions_all pod
552: WHERE pod.po_distribution_id = aida.po_distribution_id
553: AND pod.po_header_id = nvl(p_po_header_id,pod.po_header_id)
554: AND pod.destination_organization_id = nvl(p_organization_id, pod.destination_organization_id));
555:

Line 686: FROM po_distributions_all pod,

682: l_invoice_rec.organization_id,
683: l_invoice_rec.payables_ccid,
684: l_invoice_rec.po_num,
685: l_invoice_rec.po_vendor_id
686: FROM po_distributions_all pod,
687: po_lines_all pol,
688: po_headers_all poh
689: WHERE pod.po_distribution_id = invoice_rec.po_distribution_id
690: AND pol.po_line_id = pod.po_line_id