VIEW: APPS.AST_LM_OPP_QUICK_INTTYPES_V

Source

View Text - Preformatted

SELECT opp.lead_id , oppl.lead_line_id , opp.lead_number , opp.customer_id , opp.org_id , party.party_name customer_name , party.party_type , opp.address_id , opp.sales_stage_id , astg.description sales_stage , opp.status status_code ,asts.meaning status , opp.channel_code , oe.meaning channel , opp.total_amount , opp.parent_project , opp.win_probability , DENORM.CATEGORY_ID PRODUCT_CATEGORY_ID , DENORM. CATEGORY_SET_ID PRODUCT_CAT_SET_ID , DENORM.CONCAT_CAT_PARENTAGE CONCATENATED_CAT_DESC , opp.decision_date close_date , opp.creation_date , opp.created_by , opp.last_update_date , opp.last_updated_by , opp.description opportunity_name , opp.source_promotion_id ,opp.total_revenue_opp_forecast_amt from as_leads_all opp , hz_parties party , as_statuses_tl asts , as_sales_stages_all_tl astg , oe_lookups oe , as_lead_lines_all oppl , ENI_PROD_DEN_HRCHY_PARENTS_V DENORM , ENI_PROD_DENORM_HRCHY_V CHILD_HRCHY WHERE opp.customer_id=party.party_id and opp.status=asts.status_code and asts.language=userenv('LANG') and opp.sales_stage_id=astg.sales_stage_id (+) and astg.language(+)=userenv('LANG') and opp.channel_code=oe.lookup_code(+) and oe.lookup_type(+)='SALES_CHANNEL' and opp.lead_id=oppl.lead_id AND DENORM.LANGUAGE = USERENV('LANG') AND OPPL.PRODUCT_CATEGORY_ID = CHILD_HRCHY.CHILD_ID AND OPPL.PRODUCT_CAT_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 OPP.LEAD_ID
, OPPL.LEAD_LINE_ID
, OPP.LEAD_NUMBER
, OPP.CUSTOMER_ID
, OPP.ORG_ID
, PARTY.PARTY_NAME CUSTOMER_NAME
, PARTY.PARTY_TYPE
, OPP.ADDRESS_ID
, OPP.SALES_STAGE_ID
, ASTG.DESCRIPTION SALES_STAGE
, OPP.STATUS STATUS_CODE
, ASTS.MEANING STATUS
, OPP.CHANNEL_CODE
, OE.MEANING CHANNEL
, OPP.TOTAL_AMOUNT
, OPP.PARENT_PROJECT
, OPP.WIN_PROBABILITY
, DENORM.CATEGORY_ID PRODUCT_CATEGORY_ID
, DENORM. CATEGORY_SET_ID PRODUCT_CAT_SET_ID
, DENORM.CONCAT_CAT_PARENTAGE CONCATENATED_CAT_DESC
, OPP.DECISION_DATE CLOSE_DATE
, OPP.CREATION_DATE
, OPP.CREATED_BY
, OPP.LAST_UPDATE_DATE
, OPP.LAST_UPDATED_BY
, OPP.DESCRIPTION OPPORTUNITY_NAME
, OPP.SOURCE_PROMOTION_ID
, OPP.TOTAL_REVENUE_OPP_FORECAST_AMT
FROM AS_LEADS_ALL OPP
, HZ_PARTIES PARTY
, AS_STATUSES_TL ASTS
, AS_SALES_STAGES_ALL_TL ASTG
, OE_LOOKUPS OE
, AS_LEAD_LINES_ALL OPPL
, ENI_PROD_DEN_HRCHY_PARENTS_V DENORM
, ENI_PROD_DENORM_HRCHY_V CHILD_HRCHY
WHERE OPP.CUSTOMER_ID=PARTY.PARTY_ID
AND OPP.STATUS=ASTS.STATUS_CODE
AND ASTS.LANGUAGE=USERENV('LANG')
AND OPP.SALES_STAGE_ID=ASTG.SALES_STAGE_ID (+)
AND ASTG.LANGUAGE(+)=USERENV('LANG')
AND OPP.CHANNEL_CODE=OE.LOOKUP_CODE(+)
AND OE.LOOKUP_TYPE(+)='SALES_CHANNEL'
AND OPP.LEAD_ID=OPPL.LEAD_ID
AND DENORM.LANGUAGE = USERENV('LANG')
AND OPPL.PRODUCT_CATEGORY_ID = CHILD_HRCHY.CHILD_ID
AND OPPL.PRODUCT_CAT_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'