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_QUOTE_PVT dependencies on HZ_PARTIES

Line 49: CURSOR c_hz_parties(p_party_id NUMBER) IS

45:
46: l_PartyType Varchar2(30);
47: l_UserType Varchar2(30) := 'B2B';
48:
49: CURSOR c_hz_parties(p_party_id NUMBER) IS
50: SELECT Party_Name,Person_First_Name,Person_Middle_Name,Person_Last_name,party_type,Person_title
51: FROM hz_parties
52: WHERE party_id = p_party_id;
53:

Line 51: FROM hz_parties

47: l_UserType Varchar2(30) := 'B2B';
48:
49: CURSOR c_hz_parties(p_party_id NUMBER) IS
50: SELECT Party_Name,Person_First_Name,Person_Middle_Name,Person_Last_name,party_type,Person_title
51: FROM hz_parties
52: WHERE party_id = p_party_id;
53:
54: BEGIN
55:

Line 56: FOR c_hz_parties_rec IN c_hz_parties(pPartyId)

52: WHERE party_id = p_party_id;
53:
54: BEGIN
55:
56: FOR c_hz_parties_rec IN c_hz_parties(pPartyId)
57: LOOP
58: l_PartyType := rtrim(c_hz_parties_rec.party_type);
59: END LOOP;
60:

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

54: BEGIN
55:
56: FOR c_hz_parties_rec IN c_hz_parties(pPartyId)
57: LOOP
58: l_PartyType := rtrim(c_hz_parties_rec.party_type);
59: END LOOP;
60:
61: IF l_PartyType = 'PERSON'
62: THEN

Line 391: l_bill_to_party_name hz_parties.party_name%TYPE;

387: l_comments VARCHAR2(2000);
388: l_contact_name VARCHAR2(400);
389: l_contact_number VARCHAR2(70);
390: l_contact_email hz_contact_points.email_address%TYPE;
391: l_bill_to_party_name hz_parties.party_name%TYPE;
392: l_bill_to_name VARCHAR2(400);
393: l_bill_to_number VARCHAR2(70);
394: l_bill_to_fax VARCHAR2(70);
395: l_bill_to_address hz_locations.address1%TYPE;

Line 407: l_ship_to_party_name hz_parties.party_name%TYPE;

403: l_ship_method_code aso_shipments.ship_method_code%TYPE;
404:
405: l_ship_method varchar2(80);
406:
407: l_ship_to_party_name hz_parties.party_name%TYPE;
408: l_ship_to_name VARCHAR2(400);
409: l_ship_to_number VARCHAR2(70);
410: l_ship_to_fax VARCHAR2(70);
411: l_ship_to_address hz_locations.address1%TYPE;

Line 439: FROM hz_cust_accounts hc, hz_parties hp

435:
436:
437: Cursor c_hz_cust_accounts(p_cust_account_id NUMBER) IS
438: SELECT hc.party_id,hp.Party_Name,hp.Person_First_Name,hp.Person_Middle_Name,hp.Person_Last_name,hp.party_type
439: FROM hz_cust_accounts hc, hz_parties hp
440: WHERE cust_account_id = p_cust_account_id
441: AND hc.party_id = hp.party_id;
442:
443: Cursor c_ship_methods(pCode Varchar2) IS

Line 453: CURSOR c_hz_parties(p_party_id NUMBER) IS

449: Select Contract_number,Contract_number_modifier
450: From okc_k_headers_b
451: Where ID = p_id;
452:
453: CURSOR c_hz_parties(p_party_id NUMBER) IS
454: SELECT Party_Name,Person_First_Name,Person_Middle_Name,Person_Last_name,party_type,Person_title
455: FROM hz_parties
456: WHERE party_id = p_party_id;
457:

Line 455: FROM hz_parties

451: Where ID = p_id;
452:
453: CURSOR c_hz_parties(p_party_id NUMBER) IS
454: SELECT Party_Name,Person_First_Name,Person_Middle_Name,Person_Last_name,party_type,Person_title
455: FROM hz_parties
456: WHERE party_id = p_party_id;
457:
458: CURSOR c_hz_contact_points(p_party_id NUMBER) IS
459: SELECT Contact_Point_type,Primary_flag, Phone_line_type, Phone_Country_code, Phone_area_code, Phone_number, Email_address

Line 461: WHERE owner_table_name = 'HZ_PARTIES'

457:
458: CURSOR c_hz_contact_points(p_party_id NUMBER) IS
459: SELECT Contact_Point_type,Primary_flag, Phone_line_type, Phone_Country_code, Phone_area_code, Phone_number, Email_address
460: FROM hz_contact_points
461: WHERE owner_table_name = 'HZ_PARTIES'
462: AND owner_table_id = p_party_id;
463:
464:
465: l_sold_contact_party_id Number;

Line 520: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.party_id)

516:
517: l_contact_name := null;
518: l_sold_contact_party_id := null;
519:
520: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.party_id)
521: LOOP
522: IF c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP'
523: THEN
524: l_contact_name := upper(rtrim(c_hz_parties_rec.person_first_name))||' '||upper(rtrim(c_hz_parties_rec.person_last_name));

Line 522: IF c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP'

518: l_sold_contact_party_id := null;
519:
520: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.party_id)
521: LOOP
522: IF c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP'
523: THEN
524: l_contact_name := upper(rtrim(c_hz_parties_rec.person_first_name))||' '||upper(rtrim(c_hz_parties_rec.person_last_name));
525:
526: l_sold_contact_party_id := g_quote_header_rec.party_id;

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

520: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.party_id)
521: LOOP
522: IF c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP'
523: THEN
524: l_contact_name := upper(rtrim(c_hz_parties_rec.person_first_name))||' '||upper(rtrim(c_hz_parties_rec.person_last_name));
525:
526: l_sold_contact_party_id := g_quote_header_rec.party_id;
527: END IF;
528: END LOOP;

Line 593: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.invoice_to_party_id)

589: /* Bill Contact Info. From Invoice_To_Party_ID (PARTY_RELATIONSHIP) OR Bill Customer Party Id. */
590:
591: IF g_quote_header_rec.invoice_to_party_id is NOT NULL
592: THEN
593: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.invoice_to_party_id)
594: LOOP
595: IF c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' THEN
596: l_bill_contact_party_id := g_quote_header_rec.party_id;
597: END IF;

Line 595: IF c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' THEN

591: IF g_quote_header_rec.invoice_to_party_id is NOT NULL
592: THEN
593: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.invoice_to_party_id)
594: LOOP
595: IF c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' THEN
596: l_bill_contact_party_id := g_quote_header_rec.party_id;
597: END IF;
598: END LOOP;
599: END IF;

Line 686: FOR c_hz_parties_rec IN c_hz_parties(l_ship_to_party_id)

682:
683: /* Shipping Contact ship_to_party_id(PARTY_REALTIONSHIP) OR Ship Customer's Party Id */
684: IF l_ship_to_party_id IS NOT NULL
685: THEN
686: FOR c_hz_parties_rec IN c_hz_parties(l_ship_to_party_id)
687: LOOP
688: IF c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP'
689: THEN
690: l_ship_contact_party_id := g_quote_header_rec.party_id;

Line 688: IF c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP'

684: IF l_ship_to_party_id IS NOT NULL
685: THEN
686: FOR c_hz_parties_rec IN c_hz_parties(l_ship_to_party_id)
687: LOOP
688: IF c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP'
689: THEN
690: l_ship_contact_party_id := g_quote_header_rec.party_id;
691: END IF;
692: END LOOP;