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.PO_INQ_SV dependencies on PO_HEADERS_ALL

Line 52: from po_headers_all

48:
49: -- Bug 11782280 start
50: select org_id
51: into l_org_id
52: from po_headers_all
53: where po_header_id = x_object_id;
54:
55: elsif x_object_type_code in ('RELEASE') then
56:

Line 663: FROM po_headers_all POH, po_line_locations_all PLL --

659: */
660:
661: SELECT POH.CLM_DOCUMENT_NUMBER
662: INTO x_po_number
663: FROM po_headers_all POH, po_line_locations_all PLL --
664: WHERE POH.po_header_id = PLL.po_header_id and
665: PLL.line_location_id = x_line_location_id;
666:
667:

Line 1402: from po_headers_all --< Shared Proc FPJ >

1398: where line_location_id = x_po_line_location_id;
1399:
1400: cursor c2 is
1401: select terms_id
1402: from po_headers_all --< Shared Proc FPJ >
1403: where po_header_id = x_po_header_id;
1404:
1405: x_progress varchar2(3) := '000';
1406: x_ship_to_org_id number;

Line 1890: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,

1886:
1887: ===========================================================================*/
1888: PROCEDURE get_source_info
1889: (
1890: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
1891: x_segment1 OUT NOCOPY PO_HEADERS_ALL.segment1%TYPE,
1892: x_type_lookup_code OUT NOCOPY PO_HEADERS_ALL.type_lookup_code%TYPE,
1893: x_global_agreement_flag OUT NOCOPY PO_HEADERS_ALL.global_agreement_flag%TYPE,
1894: x_owning_org_id OUT NOCOPY PO_HEADERS_ALL.org_id%TYPE,

Line 1891: x_segment1 OUT NOCOPY PO_HEADERS_ALL.segment1%TYPE,

1887: ===========================================================================*/
1888: PROCEDURE get_source_info
1889: (
1890: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
1891: x_segment1 OUT NOCOPY PO_HEADERS_ALL.segment1%TYPE,
1892: x_type_lookup_code OUT NOCOPY PO_HEADERS_ALL.type_lookup_code%TYPE,
1893: x_global_agreement_flag OUT NOCOPY PO_HEADERS_ALL.global_agreement_flag%TYPE,
1894: x_owning_org_id OUT NOCOPY PO_HEADERS_ALL.org_id%TYPE,
1895: x_quote_vendor_quote_number OUT NOCOPY PO_HEADERS_ALL.quote_vendor_quote_number%TYPE

Line 1892: x_type_lookup_code OUT NOCOPY PO_HEADERS_ALL.type_lookup_code%TYPE,

1888: PROCEDURE get_source_info
1889: (
1890: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
1891: x_segment1 OUT NOCOPY PO_HEADERS_ALL.segment1%TYPE,
1892: x_type_lookup_code OUT NOCOPY PO_HEADERS_ALL.type_lookup_code%TYPE,
1893: x_global_agreement_flag OUT NOCOPY PO_HEADERS_ALL.global_agreement_flag%TYPE,
1894: x_owning_org_id OUT NOCOPY PO_HEADERS_ALL.org_id%TYPE,
1895: x_quote_vendor_quote_number OUT NOCOPY PO_HEADERS_ALL.quote_vendor_quote_number%TYPE
1896: )

Line 1893: x_global_agreement_flag OUT NOCOPY PO_HEADERS_ALL.global_agreement_flag%TYPE,

1889: (
1890: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
1891: x_segment1 OUT NOCOPY PO_HEADERS_ALL.segment1%TYPE,
1892: x_type_lookup_code OUT NOCOPY PO_HEADERS_ALL.type_lookup_code%TYPE,
1893: x_global_agreement_flag OUT NOCOPY PO_HEADERS_ALL.global_agreement_flag%TYPE,
1894: x_owning_org_id OUT NOCOPY PO_HEADERS_ALL.org_id%TYPE,
1895: x_quote_vendor_quote_number OUT NOCOPY PO_HEADERS_ALL.quote_vendor_quote_number%TYPE
1896: )
1897: IS

Line 1894: x_owning_org_id OUT NOCOPY PO_HEADERS_ALL.org_id%TYPE,

1890: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
1891: x_segment1 OUT NOCOPY PO_HEADERS_ALL.segment1%TYPE,
1892: x_type_lookup_code OUT NOCOPY PO_HEADERS_ALL.type_lookup_code%TYPE,
1893: x_global_agreement_flag OUT NOCOPY PO_HEADERS_ALL.global_agreement_flag%TYPE,
1894: x_owning_org_id OUT NOCOPY PO_HEADERS_ALL.org_id%TYPE,
1895: x_quote_vendor_quote_number OUT NOCOPY PO_HEADERS_ALL.quote_vendor_quote_number%TYPE
1896: )
1897: IS
1898: BEGIN

Line 1895: x_quote_vendor_quote_number OUT NOCOPY PO_HEADERS_ALL.quote_vendor_quote_number%TYPE

1891: x_segment1 OUT NOCOPY PO_HEADERS_ALL.segment1%TYPE,
1892: x_type_lookup_code OUT NOCOPY PO_HEADERS_ALL.type_lookup_code%TYPE,
1893: x_global_agreement_flag OUT NOCOPY PO_HEADERS_ALL.global_agreement_flag%TYPE,
1894: x_owning_org_id OUT NOCOPY PO_HEADERS_ALL.org_id%TYPE,
1895: x_quote_vendor_quote_number OUT NOCOPY PO_HEADERS_ALL.quote_vendor_quote_number%TYPE
1896: )
1897: IS
1898: BEGIN
1899:

Line 1910: FROM po_headers_all

1906: x_type_lookup_code,
1907: x_global_agreement_flag,
1908: x_owning_org_id,
1909: x_quote_vendor_quote_number
1910: FROM po_headers_all
1911: WHERE po_header_id = p_po_header_id;
1912:
1913: EXCEPTION
1914: WHEN OTHERS THEN

Line 1967: from po_headers_all POH

1963: x_rate_type OUT NOCOPY varchar2) is
1964: cursor c1 is
1965: select GLDC.USER_CONVERSION_TYPE from GL_DAILY_CONVERSION_TYPES GLDC
1966: where GLDC.CONVERSION_TYPE = (select POH.RATE_TYPE
1967: from po_headers_all POH
1968: where poh.po_header_id = x_header_id);
1969:
1970: BEGIN
1971: