eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00200_AAD_S_000006_PKG dependencies on AP_SYSTEM_PARAMETERS_EXTRACT_V

Line 182553: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

182549: FROM (
182550: SELECT xet.event_id event_id
182551: , 0 line_number
182552: , CASE r
182553: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182554: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182555: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182556: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182557: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 182554: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

182550: SELECT xet.event_id event_id
182551: , 0 line_number
182552: , CASE r
182553: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182554: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182555: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182556: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182557: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182558: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 182555: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

182551: , 0 line_number
182552: , CASE r
182553: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182554: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182555: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182556: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182557: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182558: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182559: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 182557: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

182553: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182554: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182555: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182556: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182557: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182558: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182559: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182560: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182561: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 182558: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

182554: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182555: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182556: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182557: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182558: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182559: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182560: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182561: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182562: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 182564: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

182560: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182561: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182562: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182563: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182564: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
182565: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182566: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182567: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
182568: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 182678: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

182674: ELSE null
182675: END source_meaning
182676: FROM xla_events_gt xet
182677: , AP_INVOICE_EXTRACT_HEADER_V h2
182678: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
182679: , fnd_lookup_values fvl3
182680: , fnd_lookup_values fvl35
182681: , fnd_lookup_values fvl86
182682: , fnd_lookup_values fvl159

Line 183241: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

183237: --
183238: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
183239: --
183240:
183241: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
183242: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
183243: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
183244: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
183245: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 183242: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

183238: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
183239: --
183240:
183241: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
183242: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
183243: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
183244: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
183245: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
183246: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 183243: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

183239: --
183240:
183241: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
183242: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
183243: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
183244: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
183245: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
183246: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
183247: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 183245: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

183241: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
183242: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
183243: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
183244: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
183245: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
183246: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
183247: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
183248: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
183249: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 183246: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

183242: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
183243: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
183244: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
183245: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
183246: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
183247: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
183248: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
183249: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
183250: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 183252: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

183248: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
183249: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
183250: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
183251: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
183252: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
183253: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
183254: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
183255: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
183256: TYPE t_array_source_159 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 183455: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

183451: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_166
183452: , h2.INV_DOC_SEQUENCE_VALUE source_167
183453: FROM xla_events_gt xet
183454: , AP_INVOICE_EXTRACT_HEADER_V h2
183455: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
183456: , fnd_lookup_values fvl3
183457: , fnd_lookup_values fvl35
183458: , fnd_lookup_values fvl86
183459: , fnd_lookup_values fvl159

Line 186783: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

186779: FROM (
186780: SELECT xet.event_id event_id
186781: , 0 line_number
186782: , CASE r
186783: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186784: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186785: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186786: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186787: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 186784: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

186780: SELECT xet.event_id event_id
186781: , 0 line_number
186782: , CASE r
186783: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186784: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186785: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186786: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186787: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186788: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 186785: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

186781: , 0 line_number
186782: , CASE r
186783: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186784: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186785: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186786: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186787: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186788: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186789: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 186787: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

186783: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186784: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186785: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186786: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186787: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186788: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186789: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186790: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186791: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 186788: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

186784: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186785: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186786: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186787: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186788: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186789: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186790: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186791: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186792: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 186794: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

186790: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186791: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186792: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186793: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186794: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
186795: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186796: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186797: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
186798: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 186902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

186898: ELSE null
186899: END source_meaning
186900: FROM xla_events_gt xet
186901: , AP_INVOICE_EXTRACT_HEADER_V h2
186902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
186903: , fnd_lookup_values fvl3
186904: , fnd_lookup_values fvl35
186905: , fnd_lookup_values fvl86
186906: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)

Line 187455: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

187451: --
187452: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
187453: --
187454:
187455: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
187456: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
187457: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
187458: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
187459: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 187456: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

187452: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
187453: --
187454:
187455: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
187456: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
187457: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
187458: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
187459: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
187460: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 187457: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

187453: --
187454:
187455: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
187456: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
187457: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
187458: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
187459: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
187460: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
187461: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 187459: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

187455: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
187456: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
187457: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
187458: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
187459: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
187460: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
187461: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
187462: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
187463: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 187460: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

187456: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
187457: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
187458: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
187459: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
187460: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
187461: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
187462: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
187463: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
187464: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 187466: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

187462: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
187463: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
187464: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
187465: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
187466: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
187467: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
187468: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
187469: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
187470: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 187662: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

187658: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_166
187659: , h2.INV_DOC_SEQUENCE_VALUE source_167
187660: FROM xla_events_gt xet
187661: , AP_INVOICE_EXTRACT_HEADER_V h2
187662: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
187663: , fnd_lookup_values fvl3
187664: , fnd_lookup_values fvl35
187665: , fnd_lookup_values fvl86
187666: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 190939: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

190935: FROM (
190936: SELECT xet.event_id event_id
190937: , 0 line_number
190938: , CASE r
190939: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190940: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190941: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190942: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190943: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 190943: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

190939: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190940: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190941: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190942: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190943: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190944: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190945: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190946: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190947: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 190945: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

190941: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190942: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190943: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190944: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190945: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190946: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190947: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190948: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190949: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 190946: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

190942: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190943: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190944: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190945: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190946: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190947: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190948: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190949: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190950: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 190947: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

190943: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190944: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190945: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190946: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190947: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190948: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190949: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190950: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190951: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 190949: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

190945: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190946: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190947: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190948: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190949: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190950: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190951: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190952: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190953: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 191078: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

191074: ELSE null
191075: END source_meaning
191076: FROM xla_events_gt xet
191077: , AP_PAYMENT_EXTRACT_HEADER_V h2
191078: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
191079: , fnd_lookup_values fvl3
191080: , fnd_lookup_values fvl35
191081: , fnd_lookup_values fvl105
191082: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)

Line 191477: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

191473: --
191474: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
191475: --
191476:
191477: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
191478: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
191479: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
191480: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
191481: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 191481: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

191477: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
191478: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
191479: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
191480: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
191481: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
191482: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
191483: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
191484: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
191485: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 191483: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

191479: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
191480: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
191481: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
191482: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
191483: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
191484: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
191485: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
191486: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
191487: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

Line 191484: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

191480: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
191481: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
191482: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
191483: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
191484: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
191485: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
191486: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
191487: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
191488: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 191485: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

191481: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
191482: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
191483: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
191484: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
191485: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
191486: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
191487: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
191488: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
191489: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 191487: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

191483: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
191484: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
191485: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
191486: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
191487: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
191488: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
191489: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
191490: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
191491: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 191638: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

191634: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_170
191635: , h2.AC_DOC_SEQUENCE_VALUE source_171
191636: FROM xla_events_gt xet
191637: , AP_PAYMENT_EXTRACT_HEADER_V h2
191638: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
191639: , fnd_lookup_values fvl3
191640: , fnd_lookup_values fvl35
191641: , fnd_lookup_values fvl105
191642: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 193259: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

193255: FROM (
193256: SELECT xet.event_id event_id
193257: , 0 line_number
193258: , CASE r
193259: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193260: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193261: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193262: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193263: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 193260: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

193256: SELECT xet.event_id event_id
193257: , 0 line_number
193258: , CASE r
193259: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193260: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193261: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193262: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193263: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193264: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 193261: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

193257: , 0 line_number
193258: , CASE r
193259: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193260: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193261: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193262: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193263: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193264: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193265: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 193263: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

193259: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193260: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193261: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193262: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193263: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193264: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193265: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193266: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193267: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 193264: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

193260: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193261: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193262: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193263: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193264: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193265: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193266: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193267: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193268: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 193270: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

193266: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193267: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193268: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193269: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193270: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
193271: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193272: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193273: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
193274: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 193384: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

193380: ELSE null
193381: END source_meaning
193382: FROM xla_events_gt xet
193383: , AP_INVOICE_EXTRACT_HEADER_V h2
193384: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
193385: , fnd_lookup_values fvl3
193386: , fnd_lookup_values fvl35
193387: , fnd_lookup_values fvl86
193388: , fnd_lookup_values fvl159

Line 193957: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

193953: --
193954: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
193955: --
193956:
193957: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
193958: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
193959: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
193960: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
193961: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 193958: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

193954: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
193955: --
193956:
193957: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
193958: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
193959: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
193960: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
193961: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
193962: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 193959: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

193955: --
193956:
193957: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
193958: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
193959: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
193960: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
193961: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
193962: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
193963: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 193961: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

193957: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
193958: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
193959: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
193960: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
193961: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
193962: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
193963: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
193964: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
193965: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 193962: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

193958: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
193959: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
193960: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
193961: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
193962: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
193963: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
193964: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
193965: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
193966: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 193968: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

193964: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
193965: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
193966: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
193967: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
193968: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
193969: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
193970: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
193971: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
193972: TYPE t_array_source_159 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 194175: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

194171: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_166
194172: , h2.INV_DOC_SEQUENCE_VALUE source_167
194173: FROM xla_events_gt xet
194174: , AP_INVOICE_EXTRACT_HEADER_V h2
194175: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
194176: , fnd_lookup_values fvl3
194177: , fnd_lookup_values fvl35
194178: , fnd_lookup_values fvl86
194179: , fnd_lookup_values fvl159

Line 198700: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

198696: FROM (
198697: SELECT xet.event_id event_id
198698: , 0 line_number
198699: , CASE r
198700: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198701: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198702: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198703: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198704: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198702: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

198698: , 0 line_number
198699: , CASE r
198700: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198701: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198702: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198703: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198704: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198705: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198706: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 198703: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

198699: , CASE r
198700: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198701: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198702: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198703: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198704: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198705: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198706: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198707: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198705: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

198701: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198702: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198703: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198704: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198705: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198706: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198707: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198708: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198709: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 198706: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

198702: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198703: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198704: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198705: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198706: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198707: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198708: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198709: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198710: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198708: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

198704: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198705: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198706: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198707: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198708: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198709: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198710: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198711: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198712: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 198709: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

198705: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198706: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198707: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198708: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198709: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198710: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198711: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198712: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198713: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198712: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

198708: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198709: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198710: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198711: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198712: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198713: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198714: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198715: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198716: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 198714: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

198710: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198711: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198712: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198713: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198714: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198715: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198716: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198717: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198718: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 198715: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

198711: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198712: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198713: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198714: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198715: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198716: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198717: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198718: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198719: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198716: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

198712: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198713: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198714: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198715: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198716: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198717: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198718: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198719: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198720: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 198718: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

198714: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198715: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198716: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198717: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198718: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198719: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198720: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198721: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198722: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198720: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

198716: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198717: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198718: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198719: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198720: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198721: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198722: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198723: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198724: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198908: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

198904: ELSE null
198905: END source_meaning
198906: FROM xla_events_gt xet
198907: , AP_PAYMENT_EXTRACT_HEADER_V h2
198908: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
198909: , fnd_lookup_values fvl3
198910: , fnd_lookup_values fvl7
198911: , fnd_lookup_values fvl13
198912: , fnd_lookup_values fvl35

Line 199385: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

199381: --
199382: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
199383: --
199384:
199385: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
199386: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
199387: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
199388: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
199389: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 199387: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

199383: --
199384:
199385: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
199386: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
199387: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
199388: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
199389: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
199390: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
199391: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 199388: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;

199384:
199385: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
199386: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
199387: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
199388: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
199389: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
199390: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
199391: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
199392: TYPE t_array_source_15 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 199390: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;

199386: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
199387: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
199388: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
199389: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
199390: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
199391: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
199392: TYPE t_array_source_15 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
199393: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
199394: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;

Line 199391: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;

199387: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
199388: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
199389: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
199390: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
199391: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
199392: TYPE t_array_source_15 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
199393: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
199394: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
199395: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 199393: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;

199389: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
199390: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
199391: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
199392: TYPE t_array_source_15 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
199393: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
199394: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
199395: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
199396: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
199397: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 199394: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;

199390: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
199391: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
199392: TYPE t_array_source_15 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
199393: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
199394: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
199395: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
199396: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
199397: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
199398: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 199397: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

199393: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
199394: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
199395: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
199396: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
199397: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
199398: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
199399: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
199400: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
199401: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 199399: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

199395: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
199396: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
199397: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
199398: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
199399: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
199400: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
199401: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
199402: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
199403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 199400: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

199396: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
199397: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
199398: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
199399: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
199400: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
199401: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
199402: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
199403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
199404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 199401: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

199397: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
199398: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
199399: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
199400: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
199401: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
199402: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
199403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
199404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
199405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

Line 199403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

199399: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
199400: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
199401: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
199402: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
199403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
199404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
199405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
199406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
199407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 199405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

199401: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
199402: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
199403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
199404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
199405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
199406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
199407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
199408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
199409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 199613: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

199609: , h2.TRANSAC_REVERSAL_FLAG source_185
199610: , fvl185.meaning source_185_meaning
199611: FROM xla_events_gt xet
199612: , AP_PAYMENT_EXTRACT_HEADER_V h2
199613: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
199614: , fnd_lookup_values fvl3
199615: , fnd_lookup_values fvl7
199616: , fnd_lookup_values fvl13
199617: , fnd_lookup_values fvl35

Line 201804: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

201800: FROM (
201801: SELECT xet.event_id event_id
201802: , 0 line_number
201803: , CASE r
201804: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201805: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201806: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201807: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201808: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 201805: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

201801: SELECT xet.event_id event_id
201802: , 0 line_number
201803: , CASE r
201804: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201805: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201806: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201807: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201808: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201809: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 201806: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

201802: , 0 line_number
201803: , CASE r
201804: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201805: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201806: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201807: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201808: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201809: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201810: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 201807: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

201803: , CASE r
201804: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201805: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201806: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201807: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201808: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201809: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201810: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201811: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 201808: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

201804: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201805: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201806: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201807: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201808: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201809: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201810: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201811: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201812: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 201814: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

201810: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201811: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201812: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201813: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201814: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
201815: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201816: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201817: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
201818: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 201917: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

201913: ELSE null
201914: END source_meaning
201915: FROM xla_events_gt xet
201916: , AP_INVOICE_EXTRACT_HEADER_V h1
201917: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
201918: , fnd_lookup_values fvl3
201919: , fnd_lookup_values fvl86
201920: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
201921: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 202433: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

202429: --
202430: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
202431: --
202432:
202433: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
202434: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
202435: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
202436: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
202437: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 202434: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

202430: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
202431: --
202432:
202433: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
202434: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
202435: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
202436: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
202437: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
202438: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 202435: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

202431: --
202432:
202433: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
202434: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
202435: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
202436: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
202437: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
202438: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
202439: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 202436: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;

202432:
202433: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
202434: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
202435: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
202436: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
202437: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
202438: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
202439: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
202440: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 202437: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

202433: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
202434: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
202435: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
202436: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
202437: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
202438: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
202439: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
202440: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
202441: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 202443: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

202439: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
202440: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
202441: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
202442: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
202443: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
202444: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
202445: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
202446: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
202447: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 202625: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

202621: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_166
202622: , h1.INV_DOC_SEQUENCE_VALUE source_167
202623: FROM xla_events_gt xet
202624: , AP_INVOICE_EXTRACT_HEADER_V h1
202625: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
202626: , fnd_lookup_values fvl3
202627: , fnd_lookup_values fvl86
202628: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
202629: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 204281: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

204277: FROM (
204278: SELECT xet.event_id event_id
204279: , 0 line_number
204280: , CASE r
204281: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204282: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204283: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204284: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204285: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 204282: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

204278: SELECT xet.event_id event_id
204279: , 0 line_number
204280: , CASE r
204281: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204282: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204283: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204284: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204285: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204286: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 204283: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

204279: , 0 line_number
204280: , CASE r
204281: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204282: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204283: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204284: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204285: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204286: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204287: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 204284: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

204280: , CASE r
204281: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204282: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204283: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204284: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204285: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204286: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204287: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204288: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 204286: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

204282: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204283: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204284: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204285: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204286: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204287: WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204288: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204289: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204290: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 204292: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

204288: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204289: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204290: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204291: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204292: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
204293: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204294: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204295: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
204296: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 204401: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

204397: ELSE null
204398: END source_meaning
204399: FROM xla_events_gt xet
204400: , AP_INVOICE_EXTRACT_HEADER_V h2
204401: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
204402: , fnd_lookup_values fvl3
204403: , fnd_lookup_values fvl19
204404: , fnd_lookup_values fvl35
204405: , fnd_lookup_values fvl86

Line 204955: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

204951: --
204952: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
204953: --
204954:
204955: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
204956: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
204957: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
204958: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
204959: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 204956: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

204952: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
204953: --
204954:
204955: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
204956: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
204957: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
204958: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
204959: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
204960: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 204957: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

204953: --
204954:
204955: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
204956: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
204957: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
204958: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
204959: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
204960: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
204961: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 204958: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;

204954:
204955: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
204956: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
204957: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
204958: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
204959: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
204960: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
204961: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
204962: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 204960: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

204956: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
204957: TYPE t_array_source_11 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
204958: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
204959: TYPE t_array_source_22 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
204960: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
204961: TYPE t_array_source_46 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
204962: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
204963: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
204964: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 204966: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

204962: TYPE t_array_source_55 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
204963: TYPE t_array_source_69 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
204964: TYPE t_array_source_70 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
204965: TYPE t_array_source_71 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
204966: TYPE t_array_source_86 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
204967: TYPE t_array_source_136 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
204968: TYPE t_array_source_137 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
204969: TYPE t_array_source_138 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
204970: TYPE t_array_source_165 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 205161: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

205157: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_166
205158: , h2.INV_DOC_SEQUENCE_VALUE source_167
205159: FROM xla_events_gt xet
205160: , AP_INVOICE_EXTRACT_HEADER_V h2
205161: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
205162: , fnd_lookup_values fvl3
205163: , fnd_lookup_values fvl19
205164: , fnd_lookup_values fvl35
205165: , fnd_lookup_values fvl86

Line 210717: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

210713: SELECT xet.event_id event_id
210714: , 0 line_number
210715: , CASE r
210716: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210717: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210718: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210719: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210720: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210721: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 210720: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

210716: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210717: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210718: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210719: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210720: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210721: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210722: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210723: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210724: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 210721: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

210717: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210718: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210719: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210720: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210721: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210722: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210723: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210724: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210725: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 210722: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

210718: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210719: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210720: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210721: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210722: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210723: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210724: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210725: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210726: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 210723: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

210719: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210720: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210721: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210722: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210723: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210724: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210725: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210726: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210727: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 210725: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

210721: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210722: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210723: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210724: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210725: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210726: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210727: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210728: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210729: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 210727: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

210723: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210724: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210725: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210726: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210727: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210728: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210729: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210730: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210731: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 210728: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

210724: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210725: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210726: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210727: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210728: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210729: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210730: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210731: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210732: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 210729: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

210725: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210726: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210727: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210728: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210729: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210730: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210731: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210732: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210733: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 210730: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

210726: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210727: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210728: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210729: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210730: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210731: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210732: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210733: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210734: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 210732: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

210728: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210729: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210730: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210731: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210732: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210733: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210734: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210735: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210736: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 210912: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

210908: ELSE null
210909: END source_meaning
210910: FROM xla_events_gt xet
210911: , AP_PAYMENT_EXTRACT_HEADER_V h2
210912: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
210913: , fnd_lookup_values fvl3
210914: , fnd_lookup_values fvl7
210915: , fnd_lookup_values fvl35
210916: , fnd_lookup_values fvl105

Line 211419: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

211415: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
211416: --
211417:
211418: TYPE t_array_source_2 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
211419: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
211420: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
211421: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
211422: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
211423: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;

Line 211422: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

211418: TYPE t_array_source_2 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
211419: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
211420: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
211421: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
211422: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
211423: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
211424: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
211425: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
211426: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 211423: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;

211419: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
211420: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
211421: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
211422: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
211423: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
211424: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
211425: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
211426: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
211427: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 211424: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;

211420: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
211421: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
211422: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
211423: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
211424: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
211425: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
211426: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
211427: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
211428: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 211425: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;

211421: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
211422: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
211423: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
211424: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
211425: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
211426: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
211427: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
211428: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
211429: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 211427: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

211423: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
211424: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
211425: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
211426: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
211427: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
211428: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
211429: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
211430: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
211431: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 211429: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

211425: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
211426: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
211427: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
211428: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
211429: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
211430: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
211431: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
211432: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
211433: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 211430: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

211426: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
211427: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
211428: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
211429: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
211430: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
211431: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
211432: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
211433: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
211434: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

Line 211431: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

211427: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
211428: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
211429: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
211430: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
211431: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
211432: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
211433: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
211434: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
211435: TYPE t_array_source_97 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 211432: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

211428: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
211429: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
211430: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
211431: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
211432: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
211433: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
211434: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
211435: TYPE t_array_source_97 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
211436: TYPE t_array_source_98 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 211434: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

211430: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
211431: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
211432: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
211433: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
211434: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
211435: TYPE t_array_source_97 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
211436: TYPE t_array_source_98 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
211437: TYPE t_array_source_99 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
211438: TYPE t_array_source_100 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 211652: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

211648: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_170
211649: , h2.AC_DOC_SEQUENCE_VALUE source_171
211650: FROM xla_events_gt xet
211651: , AP_PAYMENT_EXTRACT_HEADER_V h2
211652: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
211653: , fnd_lookup_values fvl3
211654: , fnd_lookup_values fvl7
211655: , fnd_lookup_values fvl35
211656: , fnd_lookup_values fvl105

Line 213806: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

213802: FROM (
213803: SELECT xet.event_id event_id
213804: , 0 line_number
213805: , CASE r
213806: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213807: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213808: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213809: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213810: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 213808: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

213804: , 0 line_number
213805: , CASE r
213806: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213807: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213808: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213809: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213810: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213811: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213812: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 213809: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

213805: , CASE r
213806: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213807: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213808: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213809: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213810: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213811: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213812: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213813: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 213812: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

213808: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213809: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213810: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213811: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213812: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213813: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213814: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213815: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213816: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 213814: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

213810: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213811: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213812: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213813: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213814: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213815: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213816: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213817: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213818: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 213815: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

213811: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213812: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213813: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213814: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213815: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213816: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213817: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213818: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213819: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 213816: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

213812: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213813: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213814: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213815: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213816: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213817: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213818: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213819: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213820: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 213817: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

213813: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213814: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213815: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213816: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213817: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213818: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213819: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213820: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213821: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 213819: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

213815: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213816: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213817: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213818: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213819: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213820: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213821: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213822: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213823: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 213973: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

213969: ELSE null
213970: END source_meaning
213971: FROM xla_events_gt xet
213972: , AP_PAYMENT_EXTRACT_HEADER_V h2
213973: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
213974: , fnd_lookup_values fvl3
213975: , fnd_lookup_values fvl7
213976: , fnd_lookup_values fvl35
213977: , fnd_lookup_values fvl105

Line 214392: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

214388: --
214389: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
214390: --
214391:
214392: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
214393: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
214394: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
214395: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
214396: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 214394: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

214390: --
214391:
214392: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
214393: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
214394: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
214395: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
214396: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
214397: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
214398: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 214395: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;

214391:
214392: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
214393: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
214394: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
214395: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
214396: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
214397: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
214398: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
214399: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 214398: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

214394: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
214395: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
214396: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
214397: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
214398: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
214399: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
214400: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
214401: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
214402: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 214400: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

214396: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
214397: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
214398: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
214399: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
214400: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
214401: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
214402: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
214403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
214404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 214401: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

214397: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
214398: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
214399: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
214400: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
214401: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
214402: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
214403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
214404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
214405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

Line 214402: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

214398: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
214399: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
214400: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
214401: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
214402: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
214403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
214404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
214405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
214406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 214403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

214399: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
214400: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
214401: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
214402: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
214403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
214404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
214405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
214406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
214407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 214405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

214401: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
214402: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
214403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
214404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
214405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
214406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
214407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
214408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
214409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 214577: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

214573: , h2.TRANSAC_REVERSAL_FLAG source_185
214574: , fvl185.meaning source_185_meaning
214575: FROM xla_events_gt xet
214576: , AP_PAYMENT_EXTRACT_HEADER_V h2
214577: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
214578: , fnd_lookup_values fvl3
214579: , fnd_lookup_values fvl7
214580: , fnd_lookup_values fvl35
214581: , fnd_lookup_values fvl105