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_000002_PKG dependencies on AP_SYSTEM_PARAMETERS_EXTRACT_V

Line 143982: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

143978: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143979: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143980: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143981: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143982: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143983: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143984: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143985: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143986: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 143983: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

143979: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143980: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143981: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143982: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143983: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143984: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143985: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143986: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143987: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 143984: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

143980: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143981: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143982: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143983: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143984: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143985: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143986: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143987: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143988: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143986: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

143982: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143983: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143984: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143985: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143986: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143987: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143988: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143989: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143990: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 143987: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

143983: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143984: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143985: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143986: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143987: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
143988: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143989: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143990: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
143991: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 144115: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

144111: ELSE null
144112: END source_meaning
144113: FROM xla_events_gt xet
144114: , AP_INVOICE_EXTRACT_HEADER_V h2
144115: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
144116: , fnd_lookup_values fvl15
144117: , fnd_lookup_values fvl47
144118: , fnd_lookup_values fvl165
144119: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)

Line 144638: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

144634: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
144635: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
144636: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
144637: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144638: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
144639: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
144640: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
144641: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
144642: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 144639: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

144635: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
144636: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
144637: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144638: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
144639: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
144640: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
144641: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
144642: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
144643: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 144640: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

144636: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
144637: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
144638: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
144639: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
144640: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
144641: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
144642: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
144643: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
144644: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 144642: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

144638: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
144639: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
144640: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
144641: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
144642: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
144643: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
144644: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
144645: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144646: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 144643: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

144639: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
144640: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
144641: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
144642: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
144643: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
144644: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
144645: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144646: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
144647: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 144838: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

144834: , fvl165.meaning source_165_meaning
144835: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
144836: FROM xla_events_gt xet
144837: , AP_INVOICE_EXTRACT_HEADER_V h2
144838: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
144839: , fnd_lookup_values fvl15
144840: , fnd_lookup_values fvl47
144841: , fnd_lookup_values fvl165
144842: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 147282: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

147278: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147279: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147280: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147281: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147282: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147283: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147284: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147285: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147286: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 147283: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

147279: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147280: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147281: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147282: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147283: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147284: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147285: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147286: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147287: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 147284: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

147280: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147281: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147282: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147283: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147284: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147285: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147286: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147287: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147288: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147286: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

147282: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147283: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147284: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147285: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147286: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147287: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147288: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147289: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147290: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147287: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

147283: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147284: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147285: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147286: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147287: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
147288: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147289: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147290: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
147291: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 147409: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

147405: ELSE null
147406: END source_meaning
147407: FROM xla_events_gt xet
147408: , AP_INVOICE_EXTRACT_HEADER_V h2
147409: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
147410: , fnd_lookup_values fvl15
147411: , fnd_lookup_values fvl47
147412: ,(select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)
147413: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 147922: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

147918: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
147919: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
147920: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
147921: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147922: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
147923: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
147924: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
147925: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
147926: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 147923: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

147919: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
147920: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
147921: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147922: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
147923: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
147924: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
147925: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
147926: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147927: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 147924: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

147920: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
147921: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
147922: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
147923: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
147924: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
147925: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
147926: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147927: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
147928: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 147926: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

147922: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
147923: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
147924: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
147925: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
147926: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147927: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
147928: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
147929: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
147930: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 147927: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

147923: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
147924: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
147925: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
147926: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147927: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
147928: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
147929: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
147930: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
147931: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 148115: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

148111: , h2.INV_EXCHANGE_RATE_TYPE source_145
148112: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
148113: FROM xla_events_gt xet
148114: , AP_INVOICE_EXTRACT_HEADER_V h2
148115: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
148116: , fnd_lookup_values fvl15
148117: , fnd_lookup_values fvl47
148118: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
148119: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 150523: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

150519: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150520: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150521: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150522: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150523: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150524: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150525: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150526: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150527: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 150527: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

150523: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150524: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150525: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150526: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150527: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150528: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150529: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150530: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150531: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 150529: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

150525: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150526: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150527: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150528: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150529: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150530: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150531: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150532: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150533: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 150530: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

150526: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150527: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150528: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150529: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150530: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150531: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150532: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150533: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150534: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 150531: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

150527: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150528: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150529: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150530: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150531: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150532: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150533: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150534: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150535: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 150533: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

150529: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150530: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150531: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150532: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150533: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150534: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150535: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150536: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150537: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 150676: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

150672: ELSE null
150673: END source_meaning
150674: FROM xla_events_gt xet
150675: , AP_PAYMENT_EXTRACT_HEADER_V h2
150676: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
150677: , fnd_lookup_values fvl15
150678: , fnd_lookup_values fvl47
150679: , fnd_lookup_values fvl113
150680: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)

Line 151081: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

151077: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
151078: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
151079: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
151080: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
151081: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
151082: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
151083: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
151084: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151085: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 151085: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

151081: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
151082: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
151083: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
151084: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151085: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151086: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151087: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151088: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
151089: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 151087: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

151083: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
151084: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151085: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151086: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151087: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151088: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
151089: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
151090: TYPE t_array_source_83 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
151091: TYPE t_array_source_97 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

Line 151088: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

151084: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151085: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151086: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151087: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151088: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
151089: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
151090: TYPE t_array_source_83 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
151091: TYPE t_array_source_97 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
151092: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 151089: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

151085: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151086: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151087: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151088: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
151089: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
151090: TYPE t_array_source_83 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
151091: TYPE t_array_source_97 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
151092: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
151093: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 151091: TYPE t_array_source_97 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

151087: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151088: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
151089: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
151090: TYPE t_array_source_83 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
151091: TYPE t_array_source_97 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
151092: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
151093: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
151094: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
151095: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 151248: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

151244: , h2.AC_DOC_CATEGORY_CODE source_170
151245: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
151246: FROM xla_events_gt xet
151247: , AP_PAYMENT_EXTRACT_HEADER_V h2
151248: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
151249: , fnd_lookup_values fvl15
151250: , fnd_lookup_values fvl47
151251: , fnd_lookup_values fvl113
151252: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 152897: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

152893: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152894: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152895: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152896: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152897: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152898: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152899: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152900: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152901: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 152898: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

152894: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152895: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152896: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152897: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152898: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152899: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152900: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152901: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152902: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 152899: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

152895: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152896: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152897: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152898: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152899: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152900: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152901: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152902: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152903: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152901: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

152897: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152898: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152899: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152900: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152901: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152902: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152903: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152904: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152905: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 152902: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

152898: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152899: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152900: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152901: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152902: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
152903: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152904: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152905: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
152906: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 153030: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

153026: ELSE null
153027: END source_meaning
153028: FROM xla_events_gt xet
153029: , AP_INVOICE_EXTRACT_HEADER_V h2
153030: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153031: , fnd_lookup_values fvl15
153032: , fnd_lookup_values fvl47
153033: , fnd_lookup_values fvl165
153034: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)

Line 153563: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

153559: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
153560: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
153561: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153562: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153563: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153564: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153565: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153566: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153567: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 153564: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

153560: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
153561: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153562: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153563: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153564: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153565: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153566: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153567: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153568: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 153565: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

153561: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
153562: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
153563: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153564: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153565: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153566: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153567: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153568: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153569: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 153567: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

153563: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
153564: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153565: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153566: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153567: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153568: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153569: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153570: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153571: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 153568: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

153564: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
153565: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
153566: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
153567: TYPE t_array_source_40 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
153568: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
153569: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
153570: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
153571: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
153572: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 153767: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

153763: , fvl165.meaning source_165_meaning
153764: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
153765: FROM xla_events_gt xet
153766: , AP_INVOICE_EXTRACT_HEADER_V h2
153767: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153768: , fnd_lookup_values fvl15
153769: , fnd_lookup_values fvl47
153770: , fnd_lookup_values fvl165
153771: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 156279: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

156275: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156276: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156277: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156278: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156279: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156280: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156281: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156282: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156283: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 156281: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

156277: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156278: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156279: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156280: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156281: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156282: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156283: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156284: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156285: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 156282: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

156278: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156279: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156280: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156281: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156282: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156283: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156284: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156285: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156286: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 156284: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

156280: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156281: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156282: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156283: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156284: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156285: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156286: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156287: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156288: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 156285: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

156281: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156282: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156283: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156284: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156285: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156286: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156287: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156288: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156289: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 156287: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

156283: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156284: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156285: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156286: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156287: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156288: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156289: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156290: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156291: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 156288: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

156284: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156285: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156286: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156287: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156288: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156289: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156290: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156291: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156292: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 156291: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

156287: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156288: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156289: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156290: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156291: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156292: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156293: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156294: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156295: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 156293: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

156289: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156290: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156291: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156292: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156293: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156294: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156295: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156296: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156297: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 156294: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

156290: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156291: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156292: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156293: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156294: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156295: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156296: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156297: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156298: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 156295: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

156291: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156292: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156293: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156294: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156295: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156296: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156297: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156298: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156299: WHEN 27 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 156297: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

156293: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156294: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156295: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156296: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156297: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156298: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156299: WHEN 27 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156300: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156301: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 156299: WHEN 27 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

156295: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156296: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156297: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156298: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156299: WHEN 27 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156300: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156301: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156302: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156303: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 156501: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

156497: ELSE null
156498: END source_meaning
156499: FROM xla_events_gt xet
156500: , AP_PAYMENT_EXTRACT_HEADER_V h2
156501: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
156502: , fnd_lookup_values fvl15
156503: , fnd_lookup_values fvl19
156504: , fnd_lookup_values fvl25
156505: , fnd_lookup_values fvl47

Line 156984: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

156980: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
156981: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
156982: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
156983: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156984: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
156985: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
156986: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156987: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
156988: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 156986: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

156982: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
156983: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156984: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
156985: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
156986: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156987: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
156988: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
156989: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
156990: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 156987: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;

156983: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156984: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
156985: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
156986: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156987: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
156988: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
156989: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
156990: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
156991: TYPE t_array_source_27 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 156989: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;

156985: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
156986: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156987: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
156988: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
156989: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
156990: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
156991: TYPE t_array_source_27 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
156992: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
156993: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;

Line 156990: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;

156986: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156987: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
156988: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
156989: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
156990: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
156991: TYPE t_array_source_27 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
156992: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
156993: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
156994: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 156992: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;

156988: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
156989: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
156990: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
156991: TYPE t_array_source_27 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
156992: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
156993: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
156994: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
156995: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156996: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 156993: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;

156989: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
156990: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
156991: TYPE t_array_source_27 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
156992: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
156993: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
156994: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
156995: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156996: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156997: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 156996: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

156992: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
156993: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
156994: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
156995: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156996: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156997: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156998: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156999: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
157000: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 156998: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

156994: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
156995: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156996: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156997: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156998: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156999: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
157000: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
157001: TYPE t_array_source_48 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
157002: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 156999: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

156995: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156996: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156997: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156998: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156999: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
157000: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
157001: TYPE t_array_source_48 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
157002: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
157003: TYPE t_array_source_83 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 157000: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

156996: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156997: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156998: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156999: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
157000: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
157001: TYPE t_array_source_48 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
157002: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
157003: TYPE t_array_source_83 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
157004: TYPE t_array_source_97 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

Line 157002: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

156998: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156999: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
157000: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
157001: TYPE t_array_source_48 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
157002: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
157003: TYPE t_array_source_83 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
157004: TYPE t_array_source_97 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
157005: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
157006: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 157004: TYPE t_array_source_97 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

157000: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
157001: TYPE t_array_source_48 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
157002: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
157003: TYPE t_array_source_83 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
157004: TYPE t_array_source_97 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
157005: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
157006: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
157007: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
157008: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 157218: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

157214: , h2.TRANSAC_REVERSAL_FLAG source_172
157215: , fvl172.meaning source_172_meaning
157216: FROM xla_events_gt xet
157217: , AP_PAYMENT_EXTRACT_HEADER_V h2
157218: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
157219: , fnd_lookup_values fvl15
157220: , fnd_lookup_values fvl19
157221: , fnd_lookup_values fvl25
157222: , fnd_lookup_values fvl47

Line 159437: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

159433: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159434: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159435: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159436: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159437: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159438: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159439: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159440: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159441: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 159438: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

159434: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159435: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159436: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159437: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159438: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159439: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159440: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159441: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159442: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 159439: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

159435: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159436: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159437: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159438: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159439: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159440: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159441: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159442: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159443: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 159440: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

159436: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159437: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159438: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159439: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159440: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159441: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159442: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159443: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159444: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 159441: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

159437: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159438: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159439: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159440: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159441: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
159442: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159443: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159444: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
159445: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 159558: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

159554: ELSE null
159555: END source_meaning
159556: FROM xla_events_gt xet
159557: , AP_INVOICE_EXTRACT_HEADER_V h1
159558: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
159559: , fnd_lookup_values fvl15
159560: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
159561: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159562: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 160064: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

160060: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
160061: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
160062: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
160063: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
160064: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
160065: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
160066: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
160067: TYPE t_array_source_41 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
160068: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 160065: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

160061: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
160062: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
160063: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
160064: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
160065: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
160066: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
160067: TYPE t_array_source_41 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
160068: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
160069: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 160066: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

160062: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
160063: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
160064: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
160065: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
160066: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
160067: TYPE t_array_source_41 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
160068: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
160069: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
160070: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 160067: TYPE t_array_source_41 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;

160063: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
160064: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
160065: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
160066: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
160067: TYPE t_array_source_41 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
160068: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
160069: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
160070: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
160071: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 160068: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

160064: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
160065: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
160066: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
160067: TYPE t_array_source_41 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PREPAY_TAX_DIFF_CCID%TYPE INDEX BY BINARY_INTEGER;
160068: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
160069: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
160070: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
160071: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
160072: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 160254: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

160250: , h1.INV_EXCHANGE_RATE_TYPE source_145
160251: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_168
160252: FROM xla_events_gt xet
160253: , AP_INVOICE_EXTRACT_HEADER_V h1
160254: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
160255: , fnd_lookup_values fvl15
160256: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
160257: and xet.event_class_code = C_EVENT_CLASS_CODE
160258: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 161858: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

161854: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161855: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161856: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161857: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161858: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161859: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161860: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161861: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161862: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161859: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

161855: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161856: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161857: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161858: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161859: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161860: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161861: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161862: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161863: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 161860: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

161856: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161857: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161858: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161859: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161860: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161861: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161862: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161863: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161864: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161861: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

161857: WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161858: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161859: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161860: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161861: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161862: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161863: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161864: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161865: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161863: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

161859: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161860: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161861: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161862: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161863: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
161864: WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161865: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161866: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
161867: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 161986: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

161982: ELSE null
161983: END source_meaning
161984: FROM xla_events_gt xet
161985: , AP_INVOICE_EXTRACT_HEADER_V h2
161986: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161987: , fnd_lookup_values fvl15
161988: , fnd_lookup_values fvl31
161989: , fnd_lookup_values fvl47
161990: ,(select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)

Line 162500: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

162496: TYPE t_array_source_5 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
162497: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
162498: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162499: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162500: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162501: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162502: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162503: TYPE t_array_source_31 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
162504: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 162501: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

162497: TYPE t_array_source_6 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
162498: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162499: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162500: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162501: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162502: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162503: TYPE t_array_source_31 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
162504: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162505: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 162502: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

162498: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
162499: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162500: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162501: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162502: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162503: TYPE t_array_source_31 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
162504: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162505: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162506: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 162503: TYPE t_array_source_31 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;

162499: TYPE t_array_source_8 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
162500: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
162501: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162502: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162503: TYPE t_array_source_31 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
162504: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162505: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162506: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162507: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 162505: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

162501: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
162502: TYPE t_array_source_23 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
162503: TYPE t_array_source_31 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
162504: TYPE t_array_source_34 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_ACCTS_PAY_CCID%TYPE INDEX BY BINARY_INTEGER;
162505: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
162506: TYPE t_array_source_58 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
162507: TYPE t_array_source_67 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162508: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
162509: TYPE t_array_source_82 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 162692: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4

162688: , h2.INV_EXCHANGE_RATE_TYPE source_145
162689: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
162690: FROM xla_events_gt xet
162691: , AP_INVOICE_EXTRACT_HEADER_V h2
162692: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
162693: , fnd_lookup_values fvl15
162694: , fnd_lookup_values fvl31
162695: , fnd_lookup_values fvl47
162696: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 165140: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

165136: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165137: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165138: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165139: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165140: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165141: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165142: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165143: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165144: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 165143: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

165139: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165140: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165141: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165142: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165143: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165144: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165145: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165146: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165147: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 165144: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

165140: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165141: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165142: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165143: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165144: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165145: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165146: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165147: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165148: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 165145: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

165141: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165142: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165143: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165144: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165145: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165146: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165147: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165148: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165149: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 165146: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

165142: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165143: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165144: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165145: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165146: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165147: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165148: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165149: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165150: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 165148: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

165144: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165145: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165146: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165147: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165148: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165149: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165150: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165151: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165152: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 165150: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

165146: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165147: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165148: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165149: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165150: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165151: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165152: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165153: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165154: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 165151: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

165147: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165148: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165149: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165150: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165151: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165152: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165153: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165154: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165155: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 165152: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

165148: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165149: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165150: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165151: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165152: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165153: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165154: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165155: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165156: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 165153: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

165149: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165150: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165151: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165152: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165153: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165154: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165155: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165156: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165157: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 165155: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

165151: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165152: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165153: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165154: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165155: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
165156: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165157: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165158: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165159: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 165349: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

165345: ELSE null
165346: END source_meaning
165347: FROM xla_events_gt xet
165348: , AP_PAYMENT_EXTRACT_HEADER_V h2
165349: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165350: , fnd_lookup_values fvl15
165351: , fnd_lookup_values fvl19
165352: , fnd_lookup_values fvl47
165353: , fnd_lookup_values fvl113

Line 165862: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

165858: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
165859: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
165860: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165861: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
165862: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165863: TYPE t_array_source_16 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
165864: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165865: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165866: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;

Line 165865: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

165861: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
165862: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165863: TYPE t_array_source_16 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
165864: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165865: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165866: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165867: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165868: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165869: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 165866: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;

165862: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165863: TYPE t_array_source_16 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
165864: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165865: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165866: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165867: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165868: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165869: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165870: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 165867: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;

165863: TYPE t_array_source_16 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
165864: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165865: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165866: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165867: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165868: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165869: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165870: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165871: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 165868: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;

165864: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165865: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165866: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165867: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165868: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165869: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165870: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165871: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165872: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 165870: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

165866: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165867: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165868: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165869: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165870: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165871: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165872: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165873: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165874: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 165872: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

165868: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165869: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165870: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165871: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165872: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165873: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165874: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165875: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165876: TYPE t_array_source_83 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 165873: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

165869: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165870: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165871: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165872: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165873: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165874: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165875: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165876: TYPE t_array_source_83 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165877: TYPE t_array_source_97 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

Line 165874: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

165870: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165871: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165872: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165873: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165874: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165875: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165876: TYPE t_array_source_83 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165877: TYPE t_array_source_97 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165878: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 165875: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

165871: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165872: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165873: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165874: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165875: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165876: TYPE t_array_source_83 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165877: TYPE t_array_source_97 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165878: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165879: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 165877: TYPE t_array_source_97 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

165873: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165874: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165875: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165876: TYPE t_array_source_83 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165877: TYPE t_array_source_97 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165878: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165879: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
165880: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
165881: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 166101: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

166097: , h2.AC_DOC_CATEGORY_CODE source_170
166098: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
166099: FROM xla_events_gt xet
166100: , AP_PAYMENT_EXTRACT_HEADER_V h2
166101: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
166102: , fnd_lookup_values fvl15
166103: , fnd_lookup_values fvl19
166104: , fnd_lookup_values fvl47
166105: , fnd_lookup_values fvl113

Line 168283: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

168279: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168280: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168281: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168282: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168283: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168284: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168285: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168286: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168287: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 168285: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

168281: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168282: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168283: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168284: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168285: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168286: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168287: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168288: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168289: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 168286: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

168282: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168283: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168284: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168285: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168286: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168287: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168288: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168289: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168290: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 168289: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

168285: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168286: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168287: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168288: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168289: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168290: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168291: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168292: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168293: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 168291: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

168287: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168288: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168289: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168290: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168291: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168292: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168293: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168294: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168295: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 168292: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

168288: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168289: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168290: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168291: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168292: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168293: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168294: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168295: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168296: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 168293: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

168289: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168290: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168291: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168292: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168293: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168294: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168295: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168296: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168297: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 168294: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

168290: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168291: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168292: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168293: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168294: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168295: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168296: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168297: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168298: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 168296: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

168292: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168293: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168294: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168295: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168296: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168297: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168298: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168299: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168300: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 168464: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

168460: ELSE null
168461: END source_meaning
168462: FROM xla_events_gt xet
168463: , AP_PAYMENT_EXTRACT_HEADER_V h2
168464: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168465: , fnd_lookup_values fvl15
168466: , fnd_lookup_values fvl19
168467: , fnd_lookup_values fvl47
168468: , fnd_lookup_values fvl113

Line 168889: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

168885: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
168886: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
168887: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
168888: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168889: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
168890: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
168891: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168892: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
168893: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 168891: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

168887: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
168888: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168889: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
168890: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
168891: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168892: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
168893: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
168894: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168895: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 168892: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;

168888: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168889: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
168890: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
168891: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168892: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
168893: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
168894: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168895: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168896: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 168895: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

168891: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168892: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
168893: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
168894: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168895: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168896: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168897: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168898: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168899: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 168897: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

168893: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
168894: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168895: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168896: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168897: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168898: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168899: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
168900: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
168901: TYPE t_array_source_83 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 168898: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

168894: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168895: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168896: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168897: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168898: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168899: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
168900: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
168901: TYPE t_array_source_83 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
168902: TYPE t_array_source_97 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

Line 168899: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

168895: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168896: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168897: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168898: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168899: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
168900: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
168901: TYPE t_array_source_83 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
168902: TYPE t_array_source_97 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
168903: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 168900: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

168896: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168897: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168898: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168899: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
168900: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
168901: TYPE t_array_source_83 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
168902: TYPE t_array_source_97 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
168903: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
168904: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 168902: TYPE t_array_source_97 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;

168898: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168899: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
168900: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
168901: TYPE t_array_source_83 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
168902: TYPE t_array_source_97 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
168903: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
168904: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
168905: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
168906: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 169080: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3

169076: , h2.TRANSAC_REVERSAL_FLAG source_172
169077: , fvl172.meaning source_172_meaning
169078: FROM xla_events_gt xet
169079: , AP_PAYMENT_EXTRACT_HEADER_V h2
169080: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
169081: , fnd_lookup_values fvl15
169082: , fnd_lookup_values fvl19
169083: , fnd_lookup_values fvl47
169084: , fnd_lookup_values fvl113