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

Line 46: Cursor c_hz_parties(p_party_id NUMBER) IS

42: SELECT Payment_type_code
43: FROM Aso_Payments
44: WHERE quote_header_id = p_quote_id;
45:
46: Cursor c_hz_parties(p_party_id NUMBER) IS
47: SELECT Party_Name,Person_First_Name,Person_Middle_Name,
48: Person_Last_name,party_type
49: FROM hz_parties
50: WHERE party_id = p_party_id;

Line 49: FROM hz_parties

45:
46: Cursor c_hz_parties(p_party_id NUMBER) IS
47: SELECT Party_Name,Person_First_Name,Person_Middle_Name,
48: Person_Last_name,party_type
49: FROM hz_parties
50: WHERE party_id = p_party_id;
51:
52: Cursor c_hz_contact_points(p_party_id NUMBER) IS
53: SELECT Contact_Point_type,Primary_flag, Phone_line_type,

Line 56: WHERE owner_table_name = 'HZ_PARTIES'

52: Cursor c_hz_contact_points(p_party_id NUMBER) IS
53: SELECT Contact_Point_type,Primary_flag, Phone_line_type,
54: Phone_Country_code, Phone_area_code, Phone_number, Email_address
55: FROM hz_contact_points
56: WHERE owner_table_name = 'HZ_PARTIES'
57: AND owner_table_id = p_party_id;
58:
59:
60: cursor c_curr_symbol(p_currCode VARCHAR2) IS

Line 74: FOR c_hz_parties_rec IN c_hz_parties(pPartyId) LOOP

70: l_PartyType Varchar2(30);
71: l_UserType Varchar2(30) := 'B2B';
72: BEGIN
73:
74: FOR c_hz_parties_rec IN c_hz_parties(pPartyId) LOOP
75: l_PartyType := rtrim(c_hz_parties_rec.party_type);
76: END LOOP;
77:
78: If l_PartyType = 'PERSON' Then

Line 75: l_PartyType := rtrim(c_hz_parties_rec.party_type);

71: l_UserType Varchar2(30) := 'B2B';
72: BEGIN
73:
74: FOR c_hz_parties_rec IN c_hz_parties(pPartyId) LOOP
75: l_PartyType := rtrim(c_hz_parties_rec.party_type);
76: END LOOP;
77:
78: If l_PartyType = 'PERSON' Then
79: l_userType := 'B2C';

Line 274: l_bill_to_party_name hz_parties.party_name%TYPE;

270: l_contract_Modifier VARCHAR2(120);
271: l_contact_name VARCHAR2(400);
272: l_contact_number VARCHAR2(70);
273: l_contact_email hz_contact_points.email_address%TYPE;
274: l_bill_to_party_name hz_parties.party_name%TYPE;
275: l_bill_to_name VARCHAR2(400);
276: l_bill_to_number VARCHAR2(70);
277: l_bill_to_fax VARCHAR2(70);
278: l_bill_to_address hz_locations.address1%TYPE;

Line 288: l_ship_to_party_name hz_parties.party_name%TYPE;

284: l_ship_to_party_id aso_shipments.ship_to_party_id%TYPE;
285: l_ship_to_cust_account_id aso_shipments.ship_to_cust_account_id%TYPE;
286: l_ship_method_code aso_shipments.ship_method_code%TYPE;
287: l_ship_method varchar2(80);
288: l_ship_to_party_name hz_parties.party_name%TYPE;
289: l_ship_to_name VARCHAR2(400);
290: l_ship_to_number VARCHAR2(70);
291: l_ship_to_fax VARCHAR2(70);
292: l_ship_to_address hz_locations.address1%TYPE;

Line 320: FROM hz_cust_accounts hc, hz_parties hp

316:
317:
318: Cursor c_hz_cust_accounts(p_cust_account_id NUMBER) IS
319: SELECT hc.party_id,hp.Party_Name,hp.Person_First_Name,hp.Person_Middle_Name,hp.Person_Last_name,hp.party_type
320: FROM hz_cust_accounts hc, hz_parties hp
321: WHERE cust_account_id = p_cust_account_id
322: AND hc.party_id = hp.party_id;
323:
324: l_sold_contact_party_id Number;

Line 367: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.party_id) LOOP

363:
364: l_contact_name := null;
365: l_sold_contact_party_id := null;
366:
367: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.party_id) LOOP
368: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
369: l_contact_name := upper(rtrim(c_hz_parties_rec.person_first_name))||' '||upper(rtrim(c_hz_parties_rec.person_last_name));
370:
371: l_sold_contact_party_id := g_quote_header_rec.party_id;

Line 368: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then

364: l_contact_name := null;
365: l_sold_contact_party_id := null;
366:
367: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.party_id) LOOP
368: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
369: l_contact_name := upper(rtrim(c_hz_parties_rec.person_first_name))||' '||upper(rtrim(c_hz_parties_rec.person_last_name));
370:
371: l_sold_contact_party_id := g_quote_header_rec.party_id;
372: End If;

Line 369: l_contact_name := upper(rtrim(c_hz_parties_rec.person_first_name))||' '||upper(rtrim(c_hz_parties_rec.person_last_name));

365: l_sold_contact_party_id := null;
366:
367: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.party_id) LOOP
368: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
369: l_contact_name := upper(rtrim(c_hz_parties_rec.person_first_name))||' '||upper(rtrim(c_hz_parties_rec.person_last_name));
370:
371: l_sold_contact_party_id := g_quote_header_rec.party_id;
372: End If;
373: END LOOP;

Line 436: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.invoice_to_party_id) LOOP

432:
433: /* Bill Contact Info. From Invoice_To_Party_ID (PARTY_RELATIONSHIP) OR Bill Customer Party Id. */
434:
435: If g_quote_header_rec.invoice_to_party_id is not null Then
436: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.invoice_to_party_id) LOOP
437: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
438: l_bill_contact_party_id := g_quote_header_rec.party_id;
439: End If;
440: END LOOP;

Line 437: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then

433: /* Bill Contact Info. From Invoice_To_Party_ID (PARTY_RELATIONSHIP) OR Bill Customer Party Id. */
434:
435: If g_quote_header_rec.invoice_to_party_id is not null Then
436: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.invoice_to_party_id) LOOP
437: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
438: l_bill_contact_party_id := g_quote_header_rec.party_id;
439: End If;
440: END LOOP;
441: End if;

Line 525: FOR c_hz_parties_rec IN c_hz_parties(l_ship_to_party_id) LOOP

521: END IF;
522:
523: /* Shipping Contact ship_to_party_id(PARTY_REALTIONSHIP) OR Ship Customer's Party Id */
524: If l_ship_to_party_id is not null Then
525: FOR c_hz_parties_rec IN c_hz_parties(l_ship_to_party_id) LOOP
526: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
527: l_ship_contact_party_id := g_quote_header_rec.party_id;
528: End If;
529: END LOOP;

Line 526: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then

522:
523: /* Shipping Contact ship_to_party_id(PARTY_REALTIONSHIP) OR Ship Customer's Party Id */
524: If l_ship_to_party_id is not null Then
525: FOR c_hz_parties_rec IN c_hz_parties(l_ship_to_party_id) LOOP
526: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
527: l_ship_contact_party_id := g_quote_header_rec.party_id;
528: End If;
529: END LOOP;
530: End If;