APPS.PO_DRAFT_APPR_STATUS_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 800: FROM po_distributions_all PD

796: AND NVL(PDD.delete_flag, 'N') = 'N'
797: AND NVL(PDD.change_accepted_flag, 'Y') = 'Y'
798: AND NOT EXISTS
799: ( SELECT NULL
800: FROM po_distributions_all PD
801: WHERE PDD.po_distribution_id = PD.po_distribution_id));
802:
803: IF (l_has_new_records = FND_API.G_TRUE) THEN
804: IF (PO_LOG.d_stmt) THEN

Line 818: po_distributions_all PD

814: SELECT DISTINCT PDD.line_location_id
815: BULK COLLECT
816: INTO x_changed_line_loc_list
817: FROM po_distributions_draft_all PDD,
818: po_distributions_all PD
819: WHERE PDD.draft_id = p_draft_info.draft_id
820: AND NVL(PDD.delete_flag, 'N') = 'N'
821: AND NVL(PDD.change_accepted_flag, 'Y') = 'Y'
822: AND PDD.po_distribution_id = PD.po_distribution_id