[Home] [Help]
7636: , 0 line_number
7637: , CASE r
7638: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
7639: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
7640: WHEN 3 THEN 'FV_TREASURY_EXTRACT_HEADER_V'
7641:
7642: ELSE null
7643: END object_name
7644: , CASE r
7676: ELSE null
7677: END source_meaning
7678: FROM xla_events_gt xet
7679: , AP_SYSTEM_PARAMETERS_EXTRACT_V h1
7680: , FV_TREASURY_EXTRACT_HEADER_V h3
7681: , fnd_lookup_values fvl9
7682: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
7683: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7684: AND xet.event_class_code = C_EVENT_CLASS_CODE
8012: --
8013:
8014: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
8015: TYPE t_array_source_9 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
8016: TYPE t_array_source_13 IS TABLE OF FV_TREASURY_EXTRACT_HEADER_V.TREASURY_CONFIRMATION_ID%TYPE INDEX BY BINARY_INTEGER;
8017:
8018: TYPE t_array_source_1 IS TABLE OF FV_TREASURY_EXTRACT_DETAILS_V.FV_CHECK_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8019: TYPE t_array_source_2 IS TABLE OF FV_TREASURY_EXTRACT_DETAILS_V.FV_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
8020: TYPE t_array_source_3 IS TABLE OF FV_TREASURY_EXTRACT_DETAILS_V.FV_TREASURY_PAY_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8096: , fvl9.meaning source_9_meaning
8097: , h3.TREASURY_CONFIRMATION_ID source_13
8098: FROM xla_events_gt xet
8099: , AP_SYSTEM_PARAMETERS_EXTRACT_V h1
8100: , FV_TREASURY_EXTRACT_HEADER_V h3
8101: , fnd_lookup_values fvl9
8102: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
8103: and xet.event_class_code = C_EVENT_CLASS_CODE
8104: and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id