VIEW: APPS.PA_PROBABILITIES_V

Source

View Text - Preformatted

SELECT mb.probability_member_id probability_member_id , mb.probability_percentage probability_percentage , mb.description probability_desc , list.probability_list_id probability_list_id , list.name probability_list_name , list.description probability_list_desc FROM pa_probability_members mb, pa_probability_lists list WHERE mb.probability_list_id = list.probability_list_id

View Text - HTML Formatted

SELECT MB.PROBABILITY_MEMBER_ID PROBABILITY_MEMBER_ID
, MB.PROBABILITY_PERCENTAGE PROBABILITY_PERCENTAGE
, MB.DESCRIPTION PROBABILITY_DESC
, LIST.PROBABILITY_LIST_ID PROBABILITY_LIST_ID
, LIST.NAME PROBABILITY_LIST_NAME
, LIST.DESCRIPTION PROBABILITY_LIST_DESC
FROM PA_PROBABILITY_MEMBERS MB
, PA_PROBABILITY_LISTS LIST
WHERE MB.PROBABILITY_LIST_ID = LIST.PROBABILITY_LIST_ID