eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_REVISION_DIFFERENCES dependencies on PO_LINES_ARCHIVE_ALL

Line 894: FROM po_lines_archive_all pla1

890: CURSOR current_lines_cursor(
891: current_header_id NUMBER,
892: current_revision_num NUMBER ) IS
893: SELECT *
894: FROM po_lines_archive_all pla1
895: WHERE
896: po_header_id = current_header_id
897: AND revision_num = (
898: SELECT MAX( revision_num )

Line 899: FROM po_lines_archive_all pla2

895: WHERE
896: po_header_id = current_header_id
897: AND revision_num = (
898: SELECT MAX( revision_num )
899: FROM po_lines_archive_all pla2
900: WHERE
901: revision_num <= current_revision_num
902: AND pla2.po_line_id = pla1.po_line_id
903: );

Line 905: v_line_to po_lines_archive_all%ROWTYPE;

901: revision_num <= current_revision_num
902: AND pla2.po_line_id = pla1.po_line_id
903: );
904:
905: v_line_to po_lines_archive_all%ROWTYPE;
906: v_line_from po_lines_archive_all%ROWTYPE;
907:
908: v_previous_revision_num NUMBER;
909: v_progress VARCHAR2(3);

Line 906: v_line_from po_lines_archive_all%ROWTYPE;

902: AND pla2.po_line_id = pla1.po_line_id
903: );
904:
905: v_line_to po_lines_archive_all%ROWTYPE;
906: v_line_from po_lines_archive_all%ROWTYPE;
907:
908: v_previous_revision_num NUMBER;
909: v_progress VARCHAR2(3);
910:

Line 943: FROM po_lines_archive_all

939:
940: v_progress := '180';
941: SELECT *
942: INTO v_line_from
943: FROM po_lines_archive_all
944: WHERE
945: revision_num = (
946: SELECT MAX( revision_num )
947: FROM po_lines_archive_all

Line 947: FROM po_lines_archive_all

943: FROM po_lines_archive_all
944: WHERE
945: revision_num = (
946: SELECT MAX( revision_num )
947: FROM po_lines_archive_all
948: WHERE
949: revision_num <=
950: v_previous_revision_num
951: AND po_line_id = v_line_to.po_line_id

Line 1498: * PO_LINES_ARCHIVE_ALL table

1494: * Call the procedure COMPARE_PO_LINE with ALL as comparison flag.
1495: *
1496: * ARGUMENTS
1497: * p_line_id Unique identified for the current PO line in
1498: * PO_LINES_ARCHIVE_ALL table
1499: * p_release_id Unique identifier for the PO release in
1500: * PO_RELEASES_ARCHIVE_ALL table
1501: * p_revision_num Current PO line revision number
1502: * p_dummy_in4 Not required

Line 1596: * PO_LINES_ARCHIVE_ALL table

1592: * flag.
1593: *
1594: * ARGUMENTS
1595: * p_line_id Unique identified for the current PO line in
1596: * PO_LINES_ARCHIVE_ALL table
1597: * p_release_id Unique identifier for the PO release in
1598: * PO_RELEASES_ARCHIVE_ALL table
1599: * p_revision_num Current PO line revision number
1600: * p_dummy_in4 Not required

Line 1694: * PO_LINES_ARCHIVE_ALL table

1690: * flag.
1691: *
1692: * ARGUMENTS
1693: * p_line_id Unique identified for the current PO line in
1694: * PO_LINES_ARCHIVE_ALL table
1695: * p_release_id Unique identifier for the PO release in
1696: * PO_RELEASES_ARCHIVE_ALL table
1697: * p_revision_num Current PO line revision number
1698: * p_dummy_in4 Not required

Line 1794: * PO_LINES_ARCHIVE_ALL table

1790: * revision---including all shipments, and distributions.
1791: *
1792: * ARGUMENTS
1793: * p_line_id Unique identified for the current PO line in
1794: * PO_LINES_ARCHIVE_ALL table
1795: * p_release_id Unique identifier for the PO release in
1796: * PO_RELEASES_ARCHIVE_ALL table
1797: * p_revision_num Current PO line revision number
1798: * p_comparison_flag Indicator to compare the PO with the previous

Line 1900: * PO_LINES_ARCHIVE_ALL table

1896: * revision---including all shipments, and distributions.
1897: *
1898: * ARGUMENTS
1899: * p_line_id Unique identified for the current PO line in
1900: * PO_LINES_ARCHIVE_ALL table
1901: * p_revision_num Current PO line revision number
1902: * p_comparison_flag Indicator to compare the PO with the previous
1903: * or original revision
1904: * p_sequence_num Sequence number to identify the comparison

Line 1927: v_line_to po_lines_archive_all%ROWTYPE;

1923: p_comparison_flag IN VARCHAR2,
1924: p_sequence_num IN NUMBER
1925: ) AS
1926:
1927: v_line_to po_lines_archive_all%ROWTYPE;
1928: v_line_from po_lines_archive_all%ROWTYPE;
1929:
1930: v_previous_revision_num NUMBER;
1931: v_progress VARCHAR2(3);

Line 1928: v_line_from po_lines_archive_all%ROWTYPE;

1924: p_sequence_num IN NUMBER
1925: ) AS
1926:
1927: v_line_to po_lines_archive_all%ROWTYPE;
1928: v_line_from po_lines_archive_all%ROWTYPE;
1929:
1930: v_previous_revision_num NUMBER;
1931: v_progress VARCHAR2(3);
1932:

Line 1944: FROM po_lines_archive_all

1940:
1941: IF p_comparison_flag = 'ORIGINAL' THEN
1942: SELECT MIN( revision_num )
1943: INTO v_previous_revision_num
1944: FROM po_lines_archive_all
1945: WHERE po_line_id = p_line_id;
1946: ELSE
1947: v_previous_revision_num := p_revision_num - 1;
1948: END IF;

Line 1955: FROM po_lines_archive_all pla1

1951:
1952: v_progress := '360';
1953: SELECT *
1954: INTO v_line_to
1955: FROM po_lines_archive_all pla1
1956: WHERE
1957: po_line_id = p_line_id
1958: AND revision_num = p_revision_num;
1959:

Line 1971: FROM po_lines_archive_all

1967:
1968: v_progress := '370';
1969: SELECT *
1970: INTO v_line_from
1971: FROM po_lines_archive_all
1972: WHERE
1973: po_line_id = p_line_id
1974: AND revision_num = (
1975: SELECT MAX( revision_num )

Line 1976: FROM po_lines_archive_all

1972: WHERE
1973: po_line_id = p_line_id
1974: AND revision_num = (
1975: SELECT MAX( revision_num )
1976: FROM po_lines_archive_all
1977: WHERE
1978: revision_num <= v_previous_revision_num
1979: AND po_line_id = p_line_id
1980: );

Line 2016: * PO_LINES_ARCHIVE_ALL table

2012: * revision---including all shipments, and distributions.
2013: *
2014: * ARGUMENTS
2015: * p_line_id Unique identified for the current PO line in
2016: * PO_LINES_ARCHIVE_ALL table
2017: * p_release_id Unique identified for the current PO release
2018: * in PO_RELEASES_ARCHIVE_ALL table
2019: * p_revision_num Current PO line revision number
2020: * p_comparison_flag Indicator to compare the PO with the previous

Line 2077: FROM po_lines_archive_all

2073:
2074: IF p_comparison_flag = 'ORIGINAL' THEN
2075: SELECT MIN( revision_num )
2076: INTO v_previous_revision_num
2077: FROM po_lines_archive_all
2078: WHERE po_line_id = p_line_id;
2079: ELSE
2080: v_previous_revision_num := p_revision_num - 1;
2081: END IF;

Line 2151: * PO_LINES_ARCHIVE_ALL table

2147: * revision.
2148: *
2149: * ARGUMENTS
2150: * p_line_id Unique identified for the current PO line in
2151: * PO_LINES_ARCHIVE_ALL table
2152: * p_release_id Unique identified for the current PO release
2153: * in PO_RELEASES_ARCHIVE_ALL table
2154: * p_revision_num Current PO line revision number
2155: * p_comparison_flag Indicator to compare the PO with the previous

Line 2213: FROM po_lines_archive_all

2209:
2210: IF p_comparison_flag = 'ORIGINAL' THEN
2211: SELECT MIN( revision_num )
2212: INTO v_previous_revision_num
2213: FROM po_lines_archive_all
2214: WHERE po_line_id = p_line_id;
2215: ELSE
2216: v_previous_revision_num := p_revision_num - 1;
2217: END IF;