DBA Data[Home] [Help]

VIEW: APPS.AP_DISTRIBUTION_SET_LINES_V

Source

View Text - Preformatted

SELECT L.DISTRIBUTION_SET_ID , S.DISTRIBUTION_SET_NAME , L.DISTRIBUTION_SET_LINE_NUMBER , L.PERCENT_DISTRIBUTION , L.DESCRIPTION , L.TYPE_1099 , L.AWARD_ID FROM AP_DISTRIBUTION_SETS S, AP_DISTRIBUTION_SET_LINES L WHERE L.DISTRIBUTION_SET_ID = S.DISTRIBUTION_SET_ID
View Text - HTML Formatted

SELECT L.DISTRIBUTION_SET_ID
, S.DISTRIBUTION_SET_NAME
, L.DISTRIBUTION_SET_LINE_NUMBER
, L.PERCENT_DISTRIBUTION
, L.DESCRIPTION
, L.TYPE_1099
, L.AWARD_ID
FROM AP_DISTRIBUTION_SETS S
, AP_DISTRIBUTION_SET_LINES L
WHERE L.DISTRIBUTION_SET_ID = S.DISTRIBUTION_SET_ID