DBA Data[Home] [Help]

APPS.PO_DRAFT_APPR_STATUS_PVT dependencies on PO_LINES_ALL

Line 529: FROM po_lines_all PL

525: AND NVL(PLD.delete_flag, 'N') = 'N'
526: AND NVL(PLD.change_accepted_flag, 'Y') = 'Y'
527: AND NOT EXISTS
528: ( SELECT NULL
529: FROM po_lines_all PL
530: WHERE PLD.po_line_id = PL.po_line_id));
531:
532: IF (l_has_new_records = FND_API.G_TRUE) THEN
533: IF (PO_LOG.d_stmt) THEN

Line 555: po_lines_all PL

551: FROM dual
552: WHERE EXISTS
553: ( SELECT NULL
554: FROM po_lines_draft_all PLD,
555: po_lines_all PL
556: WHERE PLD.draft_id = p_draft_info.draft_id
557: AND NVL(PLD.delete_flag, 'N') = 'N'
558: AND NVL(PLD.change_accepted_flag, 'Y') = 'Y'
559: AND PLD.po_line_id = PL.po_line_id