APPS.POA_DBI_PO_DIST_F_C dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 1901: po_line_locations_archive_all a,

1897: min(approved_date) approved_date,
1898: pod.amount_ordered,
1899: pod.amount_cancelled
1900: from
1901: po_line_locations_archive_all a,
1902: po_distributions_all pod
1903: where pod.line_location_id = a.line_location_id(+)
1904: and a.approved_date(+) >= pod.creation_date
1905: and nvl(pod.distribution_type,'-99') <> 'AGREEMENT'

Line 2540: from po_line_locations_archive_all pll

2536: FOR v_batch_no IN 1..l_no_batch LOOP
2537: bis_collection_utilities.log('EAD batch no='||v_batch_no || ' Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 1);
2538: update poa_dbi_pod_f f
2539: set (approved_date, po_approval_cycle_time) = (SELECT min(approved_date), MIN(approved_date - pod.creation_date)
2540: from po_line_locations_archive_all pll
2541: ,po_distributions_all pod
2542: where pod.po_distribution_id = f.po_distribution_id
2543: and pll.line_location_id = pod.line_location_id
2544: and pll.approved_date >= pod.creation_date)