[Home] [Help]
74: party.primary_phone_area_code || '-' || party.primary_phone_number
75: phone,
76: party.email_address email
77: FROM jtf_rs_resource_extns rsc,
78: hz_parties party
79: WHERE rsc.CATEGORY IN ('PARTY', 'PARTNER')
80: AND party.party_id = rsc.source_id
81: AND rsc.resource_id = TO_NUMBER (p_object1_id1)
82: AND '#' = p_object1_id2;
119: AND RSC.RESOURCE_ID = to_number(p_object1_id1)
120: AND '#' = p_object1_id2
121: UNION ALL
122: SELECT party.party_name name, party.primary_phone_area_code ||'-'||party.primary_phone_number phone ,party.email_address email
123: FROM JTF_RS_RESOURCE_EXTNS RSC ,HZ_PARTIES PARTY
124: WHERE RSC.CATEGORY IN ( 'PARTY', 'PARTNER')
125: AND PARTY.PARTY_ID = RSC.SOURCE_ID
126: AND RSC.RESOURCE_ID = to_number(p_object1_id1)
127: AND '#' = p_object1_id2 ;
325: Function get_BillContact_name(P_Contract_Id Number) return Varchar2 Is
326:
327: Cursor l_bill_contact_csr Is
328: Select Decode(SUBSTR (hz.person_last_name || ','|| hz.person_first_name, 1,255),',',null,SUBSTR (hz.person_last_name || ', '|| hz.person_first_name, 1,255)) Billing_contact
329: From hz_parties hz
330: , okc_contacts oc2
331: ,hz_relationships hr
332: Where oc2.jtot_object1_code = 'OKX_PCONTACT'
333: And oc2.cro_code = 'BILLING'
971: , CA1.CUST_ACCOUNT_ID AccountId,
972: Party.party_name PartyName
973: , Party.party_id PartyId
974: From HZ_CUST_ACCOUNTS CA1
975: , HZ_PARTIES party
976: WHERE CA1.party_id = P_party_id
977: And CA1. cust_account_id = p_account_id
978: And CA1.party_id = party.party_id
979: And CA1.status = 'A'
984: , CA2.cust_account_id AccountId
985: , Party1.party_name PartyName
986: , Party1.party_id PartyId
987: FROM HZ_CUST_ACCOUNTS CA2
988: , HZ_PARTIES party1
989: , HZ_CUST_ACCT_RELATE_ALL A
990: , HZ_CUST_ACCOUNTS B
991: WHERE CA2.party_id = party1.party_id
992: And CA2.cust_account_id = A.RELATED_CUST_ACCOUNT_ID