APPS.OKC_QUERY dependencies on OKX_CONTACT_POINTS_V

Line 777: from okx_contact_points_v

773: PHONE_COUNTRY_CODE,
774: PHONE_AREA_CODE,
775: PHONE_NUMBER,
776: PHONE_EXTENSION
777: from okx_contact_points_v
778: where PRIMARY_FLAG = 'Y'
779: and owner_table_name = 'HZ_PARTIES'
780: and owner_table_id = pid
781: and pcode = 'OKX_PCONTACT'

Line 789: from okx_contact_points_v

785: PHONE_COUNTRY_CODE FAX_COUNTRY_CODE,
786: PHONE_AREA_CODE FAX_AREA_CODE,
787: PHONE_NUMBER FAX_NUMBER,
788: PHONE_EXTENSION FAX_EXTENSION
789: from okx_contact_points_v
790: where PHONE_LINE_TYPE = 'FAX'
791: and owner_table_name = 'HZ_PARTIES'
792: and owner_table_id = pid
793: and status = 'A'

Line 956: from okx_contact_points_v

952: L_RETVAL varchar2(2000);
953: l_not_found BOOLEAN := TRUE;
954: cursor c(pid number) is
955: select EMAIL_ADDRESS
956: from okx_contact_points_v
957: where owner_table_name = 'HZ_PARTIES'
958: and owner_table_id = pid
959: and EMAIL_ADDRESS IS NOT NULL
960: order by decode(PRIMARY_FLAG,'Y',1,2)

Line 994: from okx_contact_points_v PNT

990: cursor c1(pid number) is
991: select decode(PNT.PHONE_COUNTRY_CODE,NULL,NULL,'+'||PNT.PHONE_COUNTRY_CODE||' ')
992: ||decode(PNT.PHONE_AREA_CODE,NULL,NULL,'('||PNT.PHONE_AREA_CODE||')')
993: ||PNT.PHONE_NUMBER||decode(PNT.PHONE_EXTENSION,NULL,NULL,'.'||PNT.PHONE_EXTENSION) PHONE
994: from okx_contact_points_v PNT
995: where owner_table_name = 'HZ_PARTIES'
996: and owner_table_id = pid
997: and PHONE_NUMBER IS NOT NULL
998: order by decode(PRIMARY_FLAG,'Y',1,2)