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

Line 639: FROM AS_SALES_LEADS SL, HZ_PARTIES PARTY, HZ_CONTACT_POINTS CNT

635: CNT.EMAIL_ADDRESS
636: -- ckapoor Phase 2 Filtering 11.5.10. Find the mode of caller
637: -- , SL.IMPORT_FLAG
638:
639: FROM AS_SALES_LEADS SL, HZ_PARTIES PARTY, HZ_CONTACT_POINTS CNT
640: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id
641: AND SL.CUSTOMER_ID = PARTY.PARTY_ID
642: AND SL.PRIMARY_CNT_PERSON_PARTY_ID = CNT.OWNER_TABLE_ID(+)
643: AND CNT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

Line 643: AND CNT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

639: FROM AS_SALES_LEADS SL, HZ_PARTIES PARTY, HZ_CONTACT_POINTS CNT
640: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id
641: AND SL.CUSTOMER_ID = PARTY.PARTY_ID
642: AND SL.PRIMARY_CNT_PERSON_PARTY_ID = CNT.OWNER_TABLE_ID(+)
643: AND CNT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
644: AND CNT.CONTACT_POINT_TYPE(+) = 'EMAIL'
645: AND CNT.STATUS(+) = 'A';
646:
647: -- CURSOR C_Get_Area_Code(C_Customer_Id NUMBER, C_Address_Id NUMBER) IS

Line 652: as_sales_leads lead , hz_parties party

648:
649: CURSOR C_Get_Area_Code(C_Sales_Lead_ID NUMBER) IS
650:
651: select phone_area_code from HZ_CONTACT_POINTS phone,
652: as_sales_leads lead , hz_parties party
653: where
654: lead.sales_lead_id = C_Sales_Lead_ID
655: and ((lead.customer_id = party.party_id and party.party_type = 'PERSON'
656: and PHONE.OWNER_TABLE_NAME='HZ_PARTIES' and PHONE.OWNER_TABLE_ID=lead.customer_id

Line 656: and PHONE.OWNER_TABLE_NAME='HZ_PARTIES' and PHONE.OWNER_TABLE_ID=lead.customer_id

652: as_sales_leads lead , hz_parties party
653: where
654: lead.sales_lead_id = C_Sales_Lead_ID
655: and ((lead.customer_id = party.party_id and party.party_type = 'PERSON'
656: and PHONE.OWNER_TABLE_NAME='HZ_PARTIES' and PHONE.OWNER_TABLE_ID=lead.customer_id
657: and PHONE.PRIMARY_FLAG ='Y' and PHONE.CONTACT_POINT_TYPE='PHONE' )
658: or (PHONE.OWNER_TABLE_NAME='HZ_PARTIES' and PHONE.OWNER_TABLE_ID=lead.primary_contact_party_id
659: and PHONE.PRIMARY_FLAG ='Y' and PHONE.CONTACT_POINT_TYPE='PHONE'
660: and lead.primary_contact_party_id = party.party_id

Line 658: or (PHONE.OWNER_TABLE_NAME='HZ_PARTIES' and PHONE.OWNER_TABLE_ID=lead.primary_contact_party_id

654: lead.sales_lead_id = C_Sales_Lead_ID
655: and ((lead.customer_id = party.party_id and party.party_type = 'PERSON'
656: and PHONE.OWNER_TABLE_NAME='HZ_PARTIES' and PHONE.OWNER_TABLE_ID=lead.customer_id
657: and PHONE.PRIMARY_FLAG ='Y' and PHONE.CONTACT_POINT_TYPE='PHONE' )
658: or (PHONE.OWNER_TABLE_NAME='HZ_PARTIES' and PHONE.OWNER_TABLE_ID=lead.primary_contact_party_id
659: and PHONE.PRIMARY_FLAG ='Y' and PHONE.CONTACT_POINT_TYPE='PHONE'
660: and lead.primary_contact_party_id = party.party_id
661: and party.party_type = 'PARTY_RELATIONSHIP'));
662:

Line 677: AND phon.owner_table_name = 'HZ_PARTIES'

673: SELECT phon.phone_area_code
674: FROM hz_contact_points phon
675: WHERE c_address_id IS NULL
676: AND phon.owner_table_id = c_customer_id
677: AND phon.owner_table_name = 'HZ_PARTIES'
678: AND phon.contact_point_type = 'PHONE'
679: AND phon.status in ('A','I'); */
680:
681: CURSOR C_Get_Location(C_Address_Id NUMBER) IS