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.PA_PAXPRCON_XMLP_PKG dependencies on HZ_PARTIES

Line 293: hz_parties party,

289: begin
290: IF bill_to_customer_id IS NOT NULL THEN
291: select substr(party.party_name,1,50) into tmp_flag
292: from
293: hz_parties party,
294: hz_cust_accounts cust_acct
295: where
296: party.party_id = cust_acct.party_id
297: and cust_acct.cust_account_id = bill_to_customer_id;

Line 312: hz_parties party,

308: begin
309: IF ship_to_customer_id IS NOT NULL THEN
310: SELECT substrb(party.party_name,1,50) INTO tmp_flag
311: FROM
312: hz_parties party,
313: hz_cust_accounts cust_acct
314: WHERE
315: party.party_id = cust_acct.party_id
316: and cust_acct.cust_account_id = ship_to_customer_id;

Line 330: hz_parties party,

326: l_cust_no varchar2(100);begin
327: IF bill_to_customer_id IS NOT NULL THEN
328: SELECT cust_acct.account_number INTO l_cust_no
329: FROM
330: hz_parties party,
331: hz_cust_accounts cust_acct
332: WHERE
333: party.party_id = cust_acct.party_id
334: and cust_acct.cust_account_id = bill_to_customer_id;

Line 348: hz_parties party,

344: l_cust_no varchar2(100);begin
345: IF ship_to_customer_id IS NOT NULL THEN
346: SELECT cust_acct.account_number INTO l_cust_no
347: FROM
348: hz_parties party,
349: hz_cust_accounts cust_acct
350: WHERE
351: party.party_id = cust_acct.party_id
352: and cust_acct.cust_account_id = ship_to_customer_id;