APPS.PA_ADJUSTMENTS dependencies on PO_DISTRIBUTIONS

Line 10245: , po_distributions po_dist

10241: , po_dist.distribution_num
10242: , po_dist.distribution_type
10243: FROM po_headers po
10244: , po_lines po_line
10245: , po_distributions po_dist
10246: WHERE po.po_header_id = po_line.po_header_id
10247: AND po_line.po_line_id = po_dist.po_line_id
10248: AND po_dist.po_distribution_id = p_po_distribution_id;
10249: BEGIN

Line 10446: FROM PO_DISTRIBUTIONS

10442: l_ccid_changed BOOLEAN := FALSE; /* Bug 5440305 */
10443:
10444: CURSOR c_po_shipment_id_cur(p_po_distribution_id NUMBER) IS
10445: SELECT LINE_LOCATION_ID
10446: FROM PO_DISTRIBUTIONS
10447: WHERE PO_DISTRIBUTION_ID = p_po_distribution_id;
10448:
10449: /* Bug 5386471 - Start */
10450: CURSOR c_parent_distribution_id_cur(p_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS

Line 10838: , po_distributions_all pod

10834:
10835: CURSOR c_get_accrue_on_receipt_flag IS
10836: SELECT poll.accrue_on_receipt_flag
10837: FROM po_line_locations_all poll
10838: , po_distributions_all pod
10839: , ap_invoice_distributions_all aid
10840: WHERE poll.line_location_id = pod.line_location_id
10841: AND pod.po_distribution_id = aid.po_distribution_id
10842: AND aid.invoice_distribution_id = p_invoice_distribution_id;