DBA Data[Home] [Help]

APPS.PO_DRAFT_APPR_STATUS_PVT dependencies on PO_DISTRIBUTIONS_DRAFT_ALL

Line 794: FROM po_distributions_draft_all PDD

790: INTO l_has_new_records
791: FROM dual
792: WHERE EXISTS
793: ( SELECT NULL
794: FROM po_distributions_draft_all PDD
795: WHERE PDD.draft_id = p_draft_info.draft_id
796: AND NVL(PDD.delete_flag, 'N') = 'N'
797: AND NVL(PDD.change_accepted_flag, 'Y') = 'Y'
798: AND NOT EXISTS

Line 817: FROM po_distributions_draft_all PDD,

813: -- distribution changes, and we only need one line location id in this case
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'