DBA Data[Home] [Help]

APPS.PO_XML_DELIVERY dependencies on PO_LINES_ARCHIVE_ALL

Line 987: from po_lines_archive_all

983:
984: if doc_type = 'BLANKET' then
985:
986: select max(revision_num) into l_one
987: from po_lines_archive_all
988: where po_header_id = p_header_id
989: and po_line_id = p_line_id ;
990:
991: else

Line 994: from po_lines_archive_all

990:
991: else
992:
993: select max(revision_num) into l_one
994: from po_lines_archive_all
995: where po_header_id = p_header_id
996: and po_line_id = p_line_id
997: and revision_num <= p_revision_num;
998: end if;

Line 1003: from po_lines_archive_all

999:
1000: if(l_one = p_line_revision_num) then
1001:
1002: select max(revision_num) into l_line_revision
1003: from po_lines_archive_all
1004: where po_header_id = p_header_id
1005: and po_line_id = p_line_id
1006: and revision_num <= p_revision_num;
1007: