VIEW: APPS.AST_LM_LEADS_QUICK_INT_PC_V

Source

View Text - Preformatted

SELECT LEAD.SALES_LEAD_ID , PARTY.PARTY_ID , PARTY.PARTY_NAME , PARTY.PARTY_TYPE , LEAD.PARENT_PROJECT , LEAD.DESCRIPTION LEAD_DESC , STAT.MEANING STAT_MEANING , RNK.MEANING RANK_MEANING , CHAN.MEANING CHAN_MEANING , AMS.SOURCE_CODE , OFFER.OFFER_CODE , TIME.MEANING TIME_MEANING , LEAD.LEAD_NUMBER , LEAD.BUDGET_STATUS_CODE , LEAD.BUDGET_AMOUNT , LEAD.QUALIFIED_FLAG , LEAD.URGENT_FLAG , LEAD.ACCEPT_FLAG , LEAD.VEHICLE_RESPONSE_CODE , LEAD.CREATION_DATE , ASSIGN.SOURCE_FIRST_NAME , ASSIGN.SOURCE_LAST_NAME , ASSIGN.SOURCE_NAME , LEAD.DESCRIPTION LEAD_DESCRIPTION , CLOSE.MEANING CLOSE_MEANING , LEAD.ASSIGN_TO_PERSON_ID , DENORM.CATEGORY_ID , LEAD.LAST_UPDATE_DATE FROM AS_SALES_LEADS LEAD , HZ_PARTIES PARTY , AS_STATUSES_TL STAT , AS_SALES_LEAD_RANKS_TL RNK , OE_LOOKUPS CHAN , AS_LOOKUPS TIME , AS_LOOKUPS CLOSE , JTF_RS_RESOURCE_EXTNS ASSIGN , AMS_SOURCE_CODES AMS , AMS_ACT_OFFERS OFFER , AS_SALES_LEAD_LINES LEAD_LINES, ENI_PROD_DEN_HRCHY_PARENTS_V DENORM, ENI_PROD_DENORM_HRCHY_V CHILD_HRCHY WHERE LEAD.CUSTOMER_ID = PARTY.PARTY_ID AND LEAD.STATUS_CODE = STAT.STATUS_CODE(+) AND STAT.LANGUAGE(+) = USERENV('LANG') AND LEAD.LEAD_RANK_ID = RNK.RANK_ID(+) AND RNK.LANGUAGE(+) = USERENV('LANG') AND LEAD.CHANNEL_CODE = CHAN.LOOKUP_CODE(+) AND CHAN.LOOKUP_TYPE(+) = 'SALES_CHANNEL' AND AMS.SOURCE_CODE_ID(+) = LEAD.SOURCE_PROMOTION_ID AND LEAD.OFFER_ID = OFFER.ACTIVITY_OFFER_ID(+) AND LEAD.DECISION_TIMEFRAME_CODE = TIME.LOOKUP_CODE(+) AND TIME.LOOKUP_TYPE(+) = 'DECISION_TIMEFRAME' AND LEAD.CLOSE_REASON = CLOSE.LOOKUP_CODE(+) AND CLOSE.LOOKUP_TYPE(+) = 'CLOSE_REASON' AND LEAD.ASSIGN_TO_PERSON_ID = ASSIGN.SOURCE_ID(+) AND ASSIGN.CATEGORY = 'EMPLOYEE' AND LEAD.SALES_LEAD_ID = LEAD_LINES.SALES_LEAD_ID AND DENORM.LANGUAGE = USERENV('LANG') AND LEAD_LINES.CATEGORY_ID = CHILD_HRCHY.CHILD_ID AND LEAD_LINES.CATEGORY_SET_ID = CHILD_HRCHY.CATEGORY_SET_ID AND CHILD_HRCHY.PARENT_ID = DENORM.CATEGORY_ID AND CHILD_HRCHY.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID AND CHILD_HRCHY.OLTP_FLAG = 'Y'

View Text - HTML Formatted

SELECT LEAD.SALES_LEAD_ID
, PARTY.PARTY_ID
, PARTY.PARTY_NAME
, PARTY.PARTY_TYPE
, LEAD.PARENT_PROJECT
, LEAD.DESCRIPTION LEAD_DESC
, STAT.MEANING STAT_MEANING
, RNK.MEANING RANK_MEANING
, CHAN.MEANING CHAN_MEANING
, AMS.SOURCE_CODE
, OFFER.OFFER_CODE
, TIME.MEANING TIME_MEANING
, LEAD.LEAD_NUMBER
, LEAD.BUDGET_STATUS_CODE
, LEAD.BUDGET_AMOUNT
, LEAD.QUALIFIED_FLAG
, LEAD.URGENT_FLAG
, LEAD.ACCEPT_FLAG
, LEAD.VEHICLE_RESPONSE_CODE
, LEAD.CREATION_DATE
, ASSIGN.SOURCE_FIRST_NAME
, ASSIGN.SOURCE_LAST_NAME
, ASSIGN.SOURCE_NAME
, LEAD.DESCRIPTION LEAD_DESCRIPTION
, CLOSE.MEANING CLOSE_MEANING
, LEAD.ASSIGN_TO_PERSON_ID
, DENORM.CATEGORY_ID
, LEAD.LAST_UPDATE_DATE
FROM AS_SALES_LEADS LEAD
, HZ_PARTIES PARTY
, AS_STATUSES_TL STAT
, AS_SALES_LEAD_RANKS_TL RNK
, OE_LOOKUPS CHAN
, AS_LOOKUPS TIME
, AS_LOOKUPS CLOSE
, JTF_RS_RESOURCE_EXTNS ASSIGN
, AMS_SOURCE_CODES AMS
, AMS_ACT_OFFERS OFFER
, AS_SALES_LEAD_LINES LEAD_LINES
, ENI_PROD_DEN_HRCHY_PARENTS_V DENORM
, ENI_PROD_DENORM_HRCHY_V CHILD_HRCHY
WHERE LEAD.CUSTOMER_ID = PARTY.PARTY_ID
AND LEAD.STATUS_CODE = STAT.STATUS_CODE(+)
AND STAT.LANGUAGE(+) = USERENV('LANG')
AND LEAD.LEAD_RANK_ID = RNK.RANK_ID(+)
AND RNK.LANGUAGE(+) = USERENV('LANG')
AND LEAD.CHANNEL_CODE = CHAN.LOOKUP_CODE(+)
AND CHAN.LOOKUP_TYPE(+) = 'SALES_CHANNEL'
AND AMS.SOURCE_CODE_ID(+) = LEAD.SOURCE_PROMOTION_ID
AND LEAD.OFFER_ID = OFFER.ACTIVITY_OFFER_ID(+)
AND LEAD.DECISION_TIMEFRAME_CODE = TIME.LOOKUP_CODE(+)
AND TIME.LOOKUP_TYPE(+) = 'DECISION_TIMEFRAME'
AND LEAD.CLOSE_REASON = CLOSE.LOOKUP_CODE(+)
AND CLOSE.LOOKUP_TYPE(+) = 'CLOSE_REASON'
AND LEAD.ASSIGN_TO_PERSON_ID = ASSIGN.SOURCE_ID(+)
AND ASSIGN.CATEGORY = 'EMPLOYEE'
AND LEAD.SALES_LEAD_ID = LEAD_LINES.SALES_LEAD_ID
AND DENORM.LANGUAGE = USERENV('LANG')
AND LEAD_LINES.CATEGORY_ID = CHILD_HRCHY.CHILD_ID
AND LEAD_LINES.CATEGORY_SET_ID = CHILD_HRCHY.CATEGORY_SET_ID
AND CHILD_HRCHY.PARENT_ID = DENORM.CATEGORY_ID
AND CHILD_HRCHY.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
AND CHILD_HRCHY.OLTP_FLAG = 'Y'