APPS.PO_REVISION_DIFFERENCES dependencies on PO_DISTRIBUTIONS_ARCHIVE

Line 877: FROM po_distributions_archive pda1

873: current_release_id NUMBER,
874: current_revision_num NUMBER
875: ) IS
876: SELECT *
877: FROM po_distributions_archive pda1
878: WHERE
879: po_header_id = current_header_id
880: AND NVL( po_release_id, -99 ) = current_release_id
881: AND revision_num = (

Line 883: FROM po_distributions_archive pda2

879: po_header_id = current_header_id
880: AND NVL( po_release_id, -99 ) = current_release_id
881: AND revision_num = (
882: SELECT MAX( revision_num )
883: FROM po_distributions_archive pda2
884: WHERE
885: revision_num <= current_revision_num
886: AND pda2.po_distribution_id = pda1.po_distribution_id
887: );

Line 889: v_dist_from po_distributions_archive%ROWTYPE;

885: revision_num <= current_revision_num
886: AND pda2.po_distribution_id = pda1.po_distribution_id
887: );
888:
889: v_dist_from po_distributions_archive%ROWTYPE;
890: v_dist_to po_distributions_archive%ROWTYPE;
891:
892: v_previous_revision_num NUMBER;
893: v_progress VARCHAR2(3);

Line 890: v_dist_to po_distributions_archive%ROWTYPE;

886: AND pda2.po_distribution_id = pda1.po_distribution_id
887: );
888:
889: v_dist_from po_distributions_archive%ROWTYPE;
890: v_dist_to po_distributions_archive%ROWTYPE;
891:
892: v_previous_revision_num NUMBER;
893: v_progress VARCHAR2(3);
894:

Line 927: FROM po_distributions_archive

923:
924: v_progress := '240';
925: SELECT *
926: INTO v_dist_from
927: FROM po_distributions_archive
928: WHERE
929: revision_num = (
930: SELECT MAX( revision_num )
931: FROM po_distributions_archive

Line 931: FROM po_distributions_archive

927: FROM po_distributions_archive
928: WHERE
929: revision_num = (
930: SELECT MAX( revision_num )
931: FROM po_distributions_archive
932: WHERE revision_num <=
933: v_previous_revision_num
934: AND po_distribution_id =
935: v_dist_to.po_distribution_id

Line 1663: FROM po_distributions_archive pda1

1659: current_line_id number,
1660: current_release_id number
1661: ) IS
1662: SELECT *
1663: FROM po_distributions_archive pda1
1664: WHERE
1665: po_line_id = current_line_id
1666: AND NVL( po_release_id, -99 ) = current_release_id
1667: AND revision_num = (

Line 1669: FROM po_distributions_archive pda2

1665: po_line_id = current_line_id
1666: AND NVL( po_release_id, -99 ) = current_release_id
1667: AND revision_num = (
1668: SELECT MAX( revision_num )
1669: FROM po_distributions_archive pda2
1670: WHERE
1671: revision_num <= p_revision_num
1672: AND pda2.po_distribution_id = pda1.po_distribution_id
1673: );

Line 1675: v_dist_from po_distributions_archive%ROWTYPE;

1671: revision_num <= p_revision_num
1672: AND pda2.po_distribution_id = pda1.po_distribution_id
1673: );
1674:
1675: v_dist_from po_distributions_archive%ROWTYPE;
1676: v_dist_to po_distributions_archive%ROWTYPE;
1677:
1678: v_previous_revision_num NUMBER;
1679: v_progress VARCHAR2(3);

Line 1676: v_dist_to po_distributions_archive%ROWTYPE;

1672: AND pda2.po_distribution_id = pda1.po_distribution_id
1673: );
1674:
1675: v_dist_from po_distributions_archive%ROWTYPE;
1676: v_dist_to po_distributions_archive%ROWTYPE;
1677:
1678: v_previous_revision_num NUMBER;
1679: v_progress VARCHAR2(3);
1680:

Line 1714: FROM po_distributions_archive

1710:
1711: v_progress := '440';
1712: SELECT *
1713: INTO v_dist_from
1714: FROM po_distributions_archive
1715: WHERE
1716: po_distribution_id =
1717: v_dist_to.po_distribution_id
1718: AND revision_num = (

Line 1720: FROM po_distributions_archive

1716: po_distribution_id =
1717: v_dist_to.po_distribution_id
1718: AND revision_num = (
1719: SELECT MAX( revision_num )
1720: FROM po_distributions_archive
1721: WHERE revision_num <=
1722: v_previous_revision_num
1723: AND po_distribution_id =
1724: v_dist_to.po_distribution_id