VIEW: APPS.IBY_PERIODIC_SEQ_SRS_V

Source

View Text - Preformatted

SELECT seq, seq_name, reset_value, payment_profile_id from ( select '1' seq, periodic_sequence_name_1 seq_name, reset_value_1 reset_value, payment_profile_id from iby_payment_profiles where periodic_sequence_name_1 is not null union all select '2' seq, periodic_sequence_name_2 seq_name, reset_value_2 reset_value, payment_profile_id from iby_payment_profiles where periodic_sequence_name_2 is not null union all select '3' seq, periodic_sequence_name_3 seq_name, reset_value_3 reset_value, payment_profile_id from iby_payment_profiles where periodic_sequence_name_3 is not null )

View Text - HTML Formatted

SELECT SEQ
, SEQ_NAME
, RESET_VALUE
, PAYMENT_PROFILE_ID
FROM ( SELECT '1' SEQ
, PERIODIC_SEQUENCE_NAME_1 SEQ_NAME
, RESET_VALUE_1 RESET_VALUE
, PAYMENT_PROFILE_ID
FROM IBY_PAYMENT_PROFILES
WHERE PERIODIC_SEQUENCE_NAME_1 IS NOT NULL UNION ALL SELECT '2' SEQ
, PERIODIC_SEQUENCE_NAME_2 SEQ_NAME
, RESET_VALUE_2 RESET_VALUE
, PAYMENT_PROFILE_ID
FROM IBY_PAYMENT_PROFILES
WHERE PERIODIC_SEQUENCE_NAME_2 IS NOT NULL UNION ALL SELECT '3' SEQ
, PERIODIC_SEQUENCE_NAME_3 SEQ_NAME
, RESET_VALUE_3 RESET_VALUE
, PAYMENT_PROFILE_ID
FROM IBY_PAYMENT_PROFILES
WHERE PERIODIC_SEQUENCE_NAME_3 IS NOT NULL )