DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_REFERRAL dependencies on AS_LOOKUPS

Line 354: from as_sales_leads asl, as_lookups lkp1, as_lookups lkp2, as_lookups lkp3

350: select asl.description, asl.referred_by, asl.referral_type,lkp1.meaning referral_type_meaning,
351: asl.referral_status,lkp2.meaning referral_status_meaning, asl.ref_order_number, asl.ref_order_amt,
352: asl.ref_comm_amt, asl.ref_decline_reason,lkp3.meaning decline_reason_meaning,
353: asl.ref_comm_ltr_status,asl.created_by
354: from as_sales_leads asl, as_lookups lkp1, as_lookups lkp2, as_lookups lkp3
355: where asl.sales_lead_id = pc_lead_id
356: and asl.referral_type = lkp1.lookup_code(+)
357: and lkp1.lookup_type(+) = 'REFERRAL_TYPE'
358: and asl.referral_status = lkp2.lookup_code(+)