APPS.POA_EDW_SUPPERF dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 60: ap_invoice_distributions_all aid

56:
57: select MIN(aid.accounting_date)
58: into invoice_date
59: from po_distributions_all pod,
60: ap_invoice_distributions_all aid
61: where p_line_location_id = pod.line_location_id
62: AND aid.po_distribution_id = pod.po_distribution_id
63: AND nvl(pod.distribution_type,'-99') <> 'AGREEMENT';
64:

Line 91: ap_invoice_distributions_all aid

87:
88: select MIN(aid.accounting_date - pod.creation_date)
89: into v_days
90: from po_distributions_all pod,
91: ap_invoice_distributions_all aid
92: where p_line_location_id = pod.line_location_id
93: AND aid.po_distribution_id = pod.po_distribution_id
94: AND nvl(pod.distribution_type,'-99') <> 'AGREEMENT';
95:

Line 123: ap_invoice_distributions_all aid,

119:
120: select SUM(aid.base_invoice_price_variance / nvl(pod.rate,nvl(poh.rate,1)))
121: into v_ipv
122: from po_distributions_all pod,
123: ap_invoice_distributions_all aid,
124: po_headers_all poh
125: where p_line_location_id = pod.line_location_id
126: AND aid.po_distribution_id = pod.po_distribution_id
127: AND poh.po_header_id = pod.po_header_id