VIEW: APPS.BIL_TX_SALES_STAGE_V

Source

View Text - Preformatted

SELECT assb.sales_stage_id , asst.name , assm.sales_methodology_id, assm.stage_sequence FROM as_sales_stages_all_b assb, as_sales_stages_all_tl asst, as_sales_meth_stage_map assm WHERE assb.sales_stage_id = asst.sales_stage_id AND asst.language = USERENV('LANG') AND assb.enabled_flag = 'Y' AND trunc(nvl(assb.start_date_active, SYSDATE)) <= trunc(SYSDATE) AND trunc(nvl(assb.end_date_active, SYSDATE)) >= trunc(SYSDATE) AND assb.applicability in ('OPPORTUNITY','BOTH') AND assm.sales_stage_id = assb.sales_stage_id

View Text - HTML Formatted

SELECT ASSB.SALES_STAGE_ID
, ASST.NAME
, ASSM.SALES_METHODOLOGY_ID
, ASSM.STAGE_SEQUENCE
FROM AS_SALES_STAGES_ALL_B ASSB
, AS_SALES_STAGES_ALL_TL ASST
, AS_SALES_METH_STAGE_MAP ASSM
WHERE ASSB.SALES_STAGE_ID = ASST.SALES_STAGE_ID
AND ASST.LANGUAGE = USERENV('LANG')
AND ASSB.ENABLED_FLAG = 'Y'
AND TRUNC(NVL(ASSB.START_DATE_ACTIVE
, SYSDATE)) <= TRUNC(SYSDATE)
AND TRUNC(NVL(ASSB.END_DATE_ACTIVE
, SYSDATE)) >= TRUNC(SYSDATE)
AND ASSB.APPLICABILITY IN ('OPPORTUNITY'
, 'BOTH')
AND ASSM.SALES_STAGE_ID = ASSB.SALES_STAGE_ID