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 HZ_PARTIES

Line 1939: x_vendor_name OUT NOCOPY hz_parties.party_name%TYPE

1935: * Returns: x_vendor_name
1936: */
1937: PROCEDURE get_vendor_name
1938: ( l_user_name IN fnd_user.user_name%TYPE,
1939: x_vendor_name OUT NOCOPY hz_parties.party_name%TYPE
1940: )
1941: IS
1942:
1943: BEGIN

Line 1946: --SQL Why: Get vendor_name from hz_parties via hz_relationships starting

1942:
1943: BEGIN
1944:
1945: --SQL What: Query vendor name based on log on name
1946: --SQL Why: Get vendor_name from hz_parties via hz_relationships starting
1947: -- from fnd_user.user_name
1948: SELECT hp.party_name
1949: INTO x_vendor_name
1950: FROM hz_parties hp,

Line 1950: FROM hz_parties hp,

1946: --SQL Why: Get vendor_name from hz_parties via hz_relationships starting
1947: -- from fnd_user.user_name
1948: SELECT hp.party_name
1949: INTO x_vendor_name
1950: FROM hz_parties hp,
1951: hz_relationships h2,
1952: fnd_user fu
1953: WHERE hp.party_id = h2.subject_id
1954: AND h2.subject_type = 'ORGANIZATION'

Line 1958: AND h2.subject_table_name = 'HZ_PARTIES'

1954: AND h2.subject_type = 'ORGANIZATION'
1955: AND h2.object_type = 'PERSON'
1956: AND h2.relationship_type = 'POS_EMPLOYMENT'
1957: AND h2.relationship_code = 'EMPLOYER_OF'
1958: AND h2.subject_table_name = 'HZ_PARTIES'
1959: AND h2.object_table_name = 'HZ_PARTIES'
1960: AND h2.status = 'A'
1961: AND h2.start_date <= sysdate
1962: AND h2.end_date >= sysdate

Line 1959: AND h2.object_table_name = 'HZ_PARTIES'

1955: AND h2.object_type = 'PERSON'
1956: AND h2.relationship_type = 'POS_EMPLOYMENT'
1957: AND h2.relationship_code = 'EMPLOYER_OF'
1958: AND h2.subject_table_name = 'HZ_PARTIES'
1959: AND h2.object_table_name = 'HZ_PARTIES'
1960: AND h2.status = 'A'
1961: AND h2.start_date <= sysdate
1962: AND h2.end_date >= sysdate
1963: AND h2.object_id = fu.customer_id

Line 1967: WHERE owner_table_name = 'HZ_PARTIES'

1963: AND h2.object_id = fu.customer_id
1964: AND h2.subject_id IN
1965: (SELECT owner_table_id
1966: FROM hz_code_assignments
1967: WHERE owner_table_name = 'HZ_PARTIES'
1968: AND status = 'A'
1969: AND class_category = 'POS_PARTICIPANT_TYPE'
1970: AND class_code = 'VENDOR')
1971: AND fu.user_name = l_user_name;

Line 2052: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;

2048: FUNCTION get_party_vendor_name (p_user_id IN NUMBER)
2049: RETURN VARCHAR2
2050: IS
2051: l_user_name FND_USER.USER_NAME%TYPE;
2052: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;
2053: l_vendor_name HZ_PARTIES.PARTY_NAME%TYPE;
2054: l_result VARCHAR2(800); --approx. length to hold "party name(vendor name)"
2055: l_progress VARCHAR2(3) := '000';
2056: l_log_head VARCHAR2(100) := g_log_head||'get_party_vendor_name';

Line 2053: l_vendor_name HZ_PARTIES.PARTY_NAME%TYPE;

2049: RETURN VARCHAR2
2050: IS
2051: l_user_name FND_USER.USER_NAME%TYPE;
2052: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;
2053: l_vendor_name HZ_PARTIES.PARTY_NAME%TYPE;
2054: l_result VARCHAR2(800); --approx. length to hold "party name(vendor name)"
2055: l_progress VARCHAR2(3) := '000';
2056: l_log_head VARCHAR2(100) := g_log_head||'get_party_vendor_name';
2057: BEGIN

Line 2064: FROM fnd_user fu,hz_parties hp

2060: -- SQL What: Retrieve user_name and party_name based on user_id
2061: -- SQL Why: Need to construct output and to further retrieve vendor_name
2062: SELECT fu.user_name, hp.party_name
2063: INTO l_user_name, l_party_name
2064: FROM fnd_user fu,hz_parties hp
2065: WHERE hp.party_id = fu.customer_id
2066: AND fu.user_id = p_user_id;
2067:
2068: l_progress := '020';

Line 2131: -- email address stored in HZ_PARTIES; if that is not available, return

2127: --Parameters:
2128: --IN:
2129: -- p_user_id: user_id of the supplier party
2130: --Returns:
2131: -- email address stored in HZ_PARTIES; if that is not available, return
2132: -- email address stored in FND_USER
2133: --Testing:
2134: --End of Comments
2135: ---------------------------------------------------------------------------

Line 2140: l_hp_email_address HZ_PARTIES.EMAIL_ADDRESS%TYPE; -- Varchar2(2000)

2136: FUNCTION get_vendor_email (p_user_id IN NUMBER)
2137: RETURN VARCHAR2
2138: IS
2139: l_fu_email_address FND_USER.EMAIL_ADDRESS%TYPE; -- Varchar2(240)
2140: l_hp_email_address HZ_PARTIES.EMAIL_ADDRESS%TYPE; -- Varchar2(2000)
2141: l_result HZ_PARTIES.EMAIL_ADDRESS%TYPE;
2142: l_progress VARCHAR2(3) := '000';
2143: l_log_head VARCHAR2(100) := g_log_head||'get_vendor_email';
2144: BEGIN

Line 2141: l_result HZ_PARTIES.EMAIL_ADDRESS%TYPE;

2137: RETURN VARCHAR2
2138: IS
2139: l_fu_email_address FND_USER.EMAIL_ADDRESS%TYPE; -- Varchar2(240)
2140: l_hp_email_address HZ_PARTIES.EMAIL_ADDRESS%TYPE; -- Varchar2(2000)
2141: l_result HZ_PARTIES.EMAIL_ADDRESS%TYPE;
2142: l_progress VARCHAR2(3) := '000';
2143: l_log_head VARCHAR2(100) := g_log_head||'get_vendor_email';
2144: BEGIN
2145: l_progress := '010';

Line 2151: FROM fnd_user fu,hz_parties hp

2147: -- SQL What: Retrieve email_address based on user_id
2148: -- SQL Why: Need to return email_address
2149: SELECT fu.email_address, hp.email_address
2150: INTO l_fu_email_address, l_hp_email_address
2151: FROM fnd_user fu,hz_parties hp
2152: WHERE hp.party_id = fu.customer_id
2153: AND fu.user_id = p_user_id;
2154:
2155: l_progress := '020';