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_000010_PKG dependencies on AP_INVOICE_EXTRACT_HEADER_V

Line 118566: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

118562: FROM (
118563: SELECT xet.event_id event_id
118564: , 0 line_number
118565: , CASE r
118566: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118567: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118568: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118569: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118570: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 118567: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

118563: SELECT xet.event_id event_id
118564: , 0 line_number
118565: , CASE r
118566: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118567: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118568: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118569: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118570: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118571:

Line 118568: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

118564: , 0 line_number
118565: , CASE r
118566: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118567: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118568: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118569: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118570: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118571:
118572: ELSE null

Line 118569: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

118565: , CASE r
118566: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118567: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118568: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118569: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118570: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118571:
118572: ELSE null
118573: END object_name

Line 118570: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

118566: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118567: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118568: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118569: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118570: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
118571:
118572: ELSE null
118573: END object_name
118574: , CASE r

Line 118613: , AP_INVOICE_EXTRACT_HEADER_V h2

118609: ELSE null
118610: END source_value
118611: , null source_meaning
118612: FROM xla_events_gt xet
118613: , AP_INVOICE_EXTRACT_HEADER_V h2
118614: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
118615: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
118616: AND xet.event_class_code = C_EVENT_CLASS_CODE
118617: AND h2.event_id = xet.event_id

Line 118926: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

118922: --
118923: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
118924: --
118925:
118926: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
118927: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
118928: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
118929: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
118930: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 118927: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

118923: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
118924: --
118925:
118926: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
118927: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
118928: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
118929: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
118930: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
118931:

Line 118928: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

118924: --
118925:
118926: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
118927: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
118928: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
118929: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
118930: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
118931:
118932: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 118929: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

118925:
118926: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
118927: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
118928: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
118929: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
118930: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
118931:
118932: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
118933: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 118930: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

118926: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
118927: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
118928: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
118929: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
118930: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
118931:
118932: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
118933: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
118934: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 119007: , AP_INVOICE_EXTRACT_HEADER_V h2

119003: , h2.INV_DOC_SEQUENCE_CATEGORY source_152
119004: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_153
119005: , h2.INV_DOC_SEQUENCE_VALUE source_154
119006: FROM xla_events_gt xet
119007: , AP_INVOICE_EXTRACT_HEADER_V h2
119008: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
119009: and xet.event_class_code = C_EVENT_CLASS_CODE
119010: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
119011:

Line 119823: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

119819: FROM (
119820: SELECT xet.event_id event_id
119821: , 0 line_number
119822: , CASE r
119823: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119824: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119825: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119826: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119827: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 119824: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

119820: SELECT xet.event_id event_id
119821: , 0 line_number
119822: , CASE r
119823: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119824: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119825: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119826: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119827: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119828:

Line 119825: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

119821: , 0 line_number
119822: , CASE r
119823: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119824: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119825: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119826: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119827: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119828:
119829: ELSE null

Line 119826: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

119822: , CASE r
119823: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119824: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119825: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119826: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119827: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119828:
119829: ELSE null
119830: END object_name

Line 119827: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

119823: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119824: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119825: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119826: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119827: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
119828:
119829: ELSE null
119830: END object_name
119831: , CASE r

Line 119870: , AP_INVOICE_EXTRACT_HEADER_V h2

119866: ELSE null
119867: END source_value
119868: , null source_meaning
119869: FROM xla_events_gt xet
119870: , AP_INVOICE_EXTRACT_HEADER_V h2
119871: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
119872: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
119873: AND xet.event_class_code = C_EVENT_CLASS_CODE
119874: AND h2.event_id = xet.event_id

Line 120183: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

120179: --
120180: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
120181: --
120182:
120183: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
120184: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
120185: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
120186: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
120187: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 120184: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

120180: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
120181: --
120182:
120183: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
120184: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
120185: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
120186: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
120187: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
120188:

Line 120185: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

120181: --
120182:
120183: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
120184: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
120185: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
120186: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
120187: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
120188:
120189: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 120186: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

120182:
120183: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
120184: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
120185: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
120186: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
120187: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
120188:
120189: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
120190: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 120187: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

120183: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
120184: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
120185: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
120186: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
120187: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
120188:
120189: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
120190: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
120191: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 120264: , AP_INVOICE_EXTRACT_HEADER_V h2

120260: , h2.INV_DOC_SEQUENCE_CATEGORY source_152
120261: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_153
120262: , h2.INV_DOC_SEQUENCE_VALUE source_154
120263: FROM xla_events_gt xet
120264: , AP_INVOICE_EXTRACT_HEADER_V h2
120265: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
120266: and xet.event_class_code = C_EVENT_CLASS_CODE
120267: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
120268:

Line 123069: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

123065: FROM (
123066: SELECT xet.event_id event_id
123067: , 0 line_number
123068: , CASE r
123069: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123070: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123071: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123072: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123073: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 123070: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

123066: SELECT xet.event_id event_id
123067: , 0 line_number
123068: , CASE r
123069: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123070: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123071: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123072: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123073: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123074:

Line 123071: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

123067: , 0 line_number
123068: , CASE r
123069: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123070: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123071: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123072: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123073: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123074:
123075: ELSE null

Line 123072: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

123068: , CASE r
123069: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123070: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123071: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123072: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123073: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123074:
123075: ELSE null
123076: END object_name

Line 123073: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

123069: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123070: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123071: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123072: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123073: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
123074:
123075: ELSE null
123076: END object_name
123077: , CASE r

Line 123116: , AP_INVOICE_EXTRACT_HEADER_V h2

123112: ELSE null
123113: END source_value
123114: , null source_meaning
123115: FROM xla_events_gt xet
123116: , AP_INVOICE_EXTRACT_HEADER_V h2
123117: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
123118: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
123119: AND xet.event_class_code = C_EVENT_CLASS_CODE
123120: AND h2.event_id = xet.event_id

Line 123429: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

123425: --
123426: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
123427: --
123428:
123429: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
123430: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
123431: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
123432: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
123433: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 123430: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

123426: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
123427: --
123428:
123429: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
123430: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
123431: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
123432: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
123433: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
123434:

Line 123431: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

123427: --
123428:
123429: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
123430: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
123431: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
123432: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
123433: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
123434:
123435: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 123432: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

123428:
123429: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
123430: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
123431: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
123432: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
123433: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
123434:
123435: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
123436: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 123433: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

123429: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
123430: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
123431: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
123432: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
123433: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
123434:
123435: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
123436: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
123437: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 123510: , AP_INVOICE_EXTRACT_HEADER_V h2

123506: , h2.INV_DOC_SEQUENCE_CATEGORY source_152
123507: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_153
123508: , h2.INV_DOC_SEQUENCE_VALUE source_154
123509: FROM xla_events_gt xet
123510: , AP_INVOICE_EXTRACT_HEADER_V h2
123511: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
123512: and xet.event_class_code = C_EVENT_CLASS_CODE
123513: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
123514:

Line 129540: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

129536: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129537: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129538: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129539: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129540: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129541: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129542: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129543: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129544: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 129541: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

129537: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129538: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129539: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129540: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129541: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129542: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129543: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129544: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129545: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 129542: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

129538: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129539: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129540: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129541: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129542: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129543: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129544: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129545: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129546: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 129543: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

129539: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129540: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129541: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129542: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129543: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129544: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129545: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129546: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129547: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 129544: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

129540: WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129541: WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129542: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129543: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129544: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129545: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129546: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129547: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129548: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 129546: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

129542: WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129543: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129544: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129545: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129546: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129547: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129548: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129549: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129550: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 129547: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

129543: WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129544: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129545: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129546: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129547: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129548: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129549: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129550: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129551: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 129548: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

129544: WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129545: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129546: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129547: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129548: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129549: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129550: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129551: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129552:

Line 129549: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

129545: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
129546: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129547: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129548: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129549: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129550: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129551: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129552:
129553: ELSE null

Line 129550: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

129546: WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129547: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129548: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129549: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129550: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129551: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129552:
129553: ELSE null
129554: END object_name

Line 129551: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

129547: WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129548: WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129549: WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129550: WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129551: WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
129552:
129553: ELSE null
129554: END object_name
129555: , CASE r

Line 129656: , AP_INVOICE_EXTRACT_HEADER_V h1

129652:
129653: ELSE null
129654: END source_meaning
129655: FROM xla_events_gt xet
129656: , AP_INVOICE_EXTRACT_HEADER_V h1
129657: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
129658: , fnd_lookup_values fvl4
129659: , fnd_lookup_values fvl30
129660: , fnd_lookup_values fvl102

Line 130267: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

130263: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
130264: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
130265: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
130266: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
130267: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
130268: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
130269: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
130270: TYPE t_array_source_93 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
130271: TYPE t_array_source_94 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 130268: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

130264: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
130265: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
130266: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
130267: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
130268: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
130269: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
130270: TYPE t_array_source_93 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
130271: TYPE t_array_source_94 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
130272: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 130269: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

130265: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
130266: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
130267: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
130268: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
130269: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
130270: TYPE t_array_source_93 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
130271: TYPE t_array_source_94 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
130272: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
130273: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 130270: TYPE t_array_source_93 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

130266: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
130267: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
130268: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
130269: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
130270: TYPE t_array_source_93 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
130271: TYPE t_array_source_94 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
130272: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
130273: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
130274: TYPE t_array_source_125 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 130271: TYPE t_array_source_94 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

130267: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
130268: TYPE t_array_source_72 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;
130269: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
130270: TYPE t_array_source_93 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
130271: TYPE t_array_source_94 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
130272: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
130273: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
130274: TYPE t_array_source_125 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
130275: TYPE t_array_source_126 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 130273: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

130269: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
130270: TYPE t_array_source_93 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
130271: TYPE t_array_source_94 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
130272: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
130273: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
130274: TYPE t_array_source_125 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
130275: TYPE t_array_source_126 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
130276: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
130277: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 130274: TYPE t_array_source_125 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

130270: TYPE t_array_source_93 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
130271: TYPE t_array_source_94 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
130272: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
130273: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
130274: TYPE t_array_source_125 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
130275: TYPE t_array_source_126 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
130276: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
130277: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
130278: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 130275: TYPE t_array_source_126 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

130271: TYPE t_array_source_94 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
130272: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
130273: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
130274: TYPE t_array_source_125 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
130275: TYPE t_array_source_126 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
130276: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
130277: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
130278: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
130279:

Line 130276: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

130272: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
130273: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
130274: TYPE t_array_source_125 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
130275: TYPE t_array_source_126 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
130276: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
130277: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
130278: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
130279:
130280: TYPE t_array_source_6 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 130277: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

130273: TYPE t_array_source_124 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
130274: TYPE t_array_source_125 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
130275: TYPE t_array_source_126 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
130276: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
130277: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
130278: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
130279:
130280: TYPE t_array_source_6 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
130281: TYPE t_array_source_7 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 130278: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

130274: TYPE t_array_source_125 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
130275: TYPE t_array_source_126 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
130276: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
130277: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
130278: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
130279:
130280: TYPE t_array_source_6 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.INV_DIST_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
130281: TYPE t_array_source_7 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
130282: TYPE t_array_source_17 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 130489: , AP_INVOICE_EXTRACT_HEADER_V h1

130485: , h1.INV_DOC_SEQUENCE_CATEGORY source_152
130486: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_153
130487: , h1.INV_DOC_SEQUENCE_VALUE source_154
130488: FROM xla_events_gt xet
130489: , AP_INVOICE_EXTRACT_HEADER_V h1
130490: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
130491: , fnd_lookup_values fvl4
130492: , fnd_lookup_values fvl30
130493: , fnd_lookup_values fvl102

Line 133724: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

133720: FROM (
133721: SELECT xet.event_id event_id
133722: , 0 line_number
133723: , CASE r
133724: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133725: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133726: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133727: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133728: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

Line 133725: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

133721: SELECT xet.event_id event_id
133722: , 0 line_number
133723: , CASE r
133724: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133725: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133726: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133727: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133728: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133729:

Line 133726: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

133722: , 0 line_number
133723: , CASE r
133724: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133725: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133726: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133727: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133728: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133729:
133730: ELSE null

Line 133727: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

133723: , CASE r
133724: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133725: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133726: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133727: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133728: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133729:
133730: ELSE null
133731: END object_name

Line 133728: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'

133724: WHEN 1 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133725: WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133726: WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133727: WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133728: WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
133729:
133730: ELSE null
133731: END object_name
133732: , CASE r

Line 133771: , AP_INVOICE_EXTRACT_HEADER_V h2

133767: ELSE null
133768: END source_value
133769: , null source_meaning
133770: FROM xla_events_gt xet
133771: , AP_INVOICE_EXTRACT_HEADER_V h2
133772: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
133773: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
133774: AND xet.event_class_code = C_EVENT_CLASS_CODE
133775: AND h2.event_id = xet.event_id

Line 134084: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

134080: --
134081: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
134082: --
134083:
134084: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
134085: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
134086: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
134087: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
134088: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 134085: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

134081: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
134082: --
134083:
134084: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
134085: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
134086: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
134087: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
134088: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
134089:

Line 134086: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

134082: --
134083:
134084: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
134085: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
134086: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
134087: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
134088: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
134089:
134090: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 134087: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

134083:
134084: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
134085: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
134086: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
134087: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
134088: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
134089:
134090: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
134091: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 134088: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

134084: TYPE t_array_source_56 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
134085: TYPE t_array_source_80 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
134086: TYPE t_array_source_152 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
134087: TYPE t_array_source_153 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
134088: TYPE t_array_source_154 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.INV_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
134089:
134090: TYPE t_array_source_40 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DIST_ACCOUNT_REVERSAL_OPTION%TYPE INDEX BY BINARY_INTEGER;
134091: TYPE t_array_source_48 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
134092: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 134165: , AP_INVOICE_EXTRACT_HEADER_V h2

134161: , h2.INV_DOC_SEQUENCE_CATEGORY source_152
134162: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_153
134163: , h2.INV_DOC_SEQUENCE_VALUE source_154
134164: FROM xla_events_gt xet
134165: , AP_INVOICE_EXTRACT_HEADER_V h2
134166: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
134167: and xet.event_class_code = C_EVENT_CLASS_CODE
134168: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
134169: