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 ZX_AP_DEF_TAX_EXTRACT_V

Line 118686: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

118682: , l1.line_number line_number
118683: , CASE r
118684: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118685: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118686: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
118687: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118688: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
118689: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118690: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 118787: , ZX_AP_DEF_TAX_EXTRACT_V l3

118783: END source_value
118784: , null source_meaning
118785: FROM xla_events_gt xet
118786: , AP_INVOICE_EXTRACT_DETAILS_V l1
118787: , ZX_AP_DEF_TAX_EXTRACT_V l3
118788: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
118789: , (select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
118790: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
118791: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 118934: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%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;
118935: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
118936: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
118937: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
118938: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 119064: , ZX_AP_DEF_TAX_EXTRACT_V l3

119060: , l1.AID_INVOICE_DIST_ID source_156
119061: , l1.AID_PARENT_REVERSAL_ID source_157
119062: FROM xla_events_gt xet
119063: , AP_INVOICE_EXTRACT_DETAILS_V l1
119064: , ZX_AP_DEF_TAX_EXTRACT_V l3
119065: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
119066: WHERE xet.event_id between x_first_event_id and x_last_event_id
119067: and xet.event_date between p_pad_start_date and p_pad_end_date
119068: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 119943: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

119939: , l1.line_number line_number
119940: , CASE r
119941: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119942: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119943: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
119944: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119945: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
119946: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119947: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 120044: , ZX_AP_DEF_TAX_EXTRACT_V l3

120040: END source_value
120041: , null source_meaning
120042: FROM xla_events_gt xet
120043: , AP_INVOICE_EXTRACT_DETAILS_V l1
120044: , ZX_AP_DEF_TAX_EXTRACT_V l3
120045: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
120046: , (select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
120047: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
120048: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 120191: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%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;
120192: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
120193: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
120194: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
120195: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 120321: , ZX_AP_DEF_TAX_EXTRACT_V l3

120317: , l1.AID_INVOICE_DIST_ID source_156
120318: , l1.AID_PARENT_REVERSAL_ID source_157
120319: FROM xla_events_gt xet
120320: , AP_INVOICE_EXTRACT_DETAILS_V l1
120321: , ZX_AP_DEF_TAX_EXTRACT_V l3
120322: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
120323: WHERE xet.event_id between x_first_event_id and x_last_event_id
120324: and xet.event_date between p_pad_start_date and p_pad_end_date
120325: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 123189: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

123185: , l1.line_number line_number
123186: , CASE r
123187: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123188: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123189: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
123190: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123191: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
123192: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123193: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 123290: , ZX_AP_DEF_TAX_EXTRACT_V l3

123286: END source_value
123287: , null source_meaning
123288: FROM xla_events_gt xet
123289: , AP_INVOICE_EXTRACT_DETAILS_V l1
123290: , ZX_AP_DEF_TAX_EXTRACT_V l3
123291: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
123292: , (select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
123293: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
123294: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 123437: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%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;
123438: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
123439: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
123440: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
123441: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 123567: , ZX_AP_DEF_TAX_EXTRACT_V l3

123563: , l1.AID_INVOICE_DIST_ID source_156
123564: , l1.AID_PARENT_REVERSAL_ID source_157
123565: FROM xla_events_gt xet
123566: , AP_INVOICE_EXTRACT_DETAILS_V l1
123567: , ZX_AP_DEF_TAX_EXTRACT_V l3
123568: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
123569: WHERE xet.event_id between x_first_event_id and x_last_event_id
123570: and xet.event_date between p_pad_start_date and p_pad_end_date
123571: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 125785: WHEN 22 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

125781: WHEN 18 THEN 'AP_PO_HEADERS_EXTRACT_V'
125782: WHEN 19 THEN 'AP_PO_HEADERS_EXTRACT_V'
125783: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125784: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125785: WHEN 22 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
125786: WHEN 23 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
125787: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125788: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125789: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 125786: WHEN 23 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

125782: WHEN 19 THEN 'AP_PO_HEADERS_EXTRACT_V'
125783: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125784: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125785: WHEN 22 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
125786: WHEN 23 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
125787: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125788: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125789: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125790: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 125988: , ZX_AP_DEF_TAX_EXTRACT_V l5

125984: END source_meaning
125985: FROM xla_events_gt xet
125986: , AP_PAYMENT_EXTRACT_DETAILS_V l1
125987: , AP_PO_HEADERS_EXTRACT_V l3
125988: , ZX_AP_DEF_TAX_EXTRACT_V l5
125989: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
125990: , fnd_lookup_values fvl7
125991: , fnd_lookup_values fvl20
125992: , fnd_lookup_values fvl39

Line 126219: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

126215: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
126216: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
126217: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
126218: TYPE t_array_source_57 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
126219: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
126220: TYPE t_array_source_59 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
126221: TYPE t_array_source_61 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_INVOICE_DIST_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
126222: TYPE t_array_source_62 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
126223: TYPE t_array_source_63 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 126220: TYPE t_array_source_59 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

126216: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
126217: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
126218: TYPE t_array_source_57 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
126219: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
126220: TYPE t_array_source_59 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
126221: TYPE t_array_source_61 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_INVOICE_DIST_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
126222: TYPE t_array_source_62 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
126223: TYPE t_array_source_63 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
126224: TYPE t_array_source_64 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 126535: , ZX_AP_DEF_TAX_EXTRACT_V l5

126531: , l1.BF_RETAINED_INV_ID_PMT source_150
126532: FROM xla_events_gt xet
126533: , AP_PAYMENT_EXTRACT_DETAILS_V l1
126534: , AP_PO_HEADERS_EXTRACT_V l3
126535: , ZX_AP_DEF_TAX_EXTRACT_V l5
126536: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
126537: , fnd_lookup_values fvl7
126538: , fnd_lookup_values fvl20
126539: , fnd_lookup_values fvl39

Line 129755: WHEN 13 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

129751: WHEN 9 THEN 'AP_PO_HEADERS_EXTRACT_V'
129752: WHEN 10 THEN 'AP_PO_HEADERS_EXTRACT_V'
129753: WHEN 11 THEN 'AP_PO_HEADERS_EXTRACT_V'
129754: WHEN 12 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129755: WHEN 13 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
129756: WHEN 14 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129757: WHEN 15 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129758: WHEN 16 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129759: WHEN 17 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'

Line 130091: , ZX_AP_DEF_TAX_EXTRACT_V l5

130087: END source_meaning
130088: FROM xla_events_gt xet
130089: , AP_PO_HEADERS_EXTRACT_V l2
130090: , AP_PREPAYAPP_EXTRACT_DETAILS_V l3
130091: , ZX_AP_DEF_TAX_EXTRACT_V l5
130092: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
130093: , fnd_lookup_values fvl7
130094: , fnd_lookup_values fvl53
130095: , fnd_lookup_values fvl68

Line 130292: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

130288: TYPE t_array_source_50 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
130289: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
130290: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
130291: TYPE t_array_source_53 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
130292: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
130293: TYPE t_array_source_59 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
130294: TYPE t_array_source_62 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
130295: TYPE t_array_source_63 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
130296: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 130616: , ZX_AP_DEF_TAX_EXTRACT_V l5

130612: , l3.BF_RET_INV_ASSOC_TO_PP_RECIP source_146
130613: FROM xla_events_gt xet
130614: , AP_PO_HEADERS_EXTRACT_V l2
130615: , AP_PREPAYAPP_EXTRACT_DETAILS_V l3
130616: , ZX_AP_DEF_TAX_EXTRACT_V l5
130617: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
130618: , fnd_lookup_values fvl7
130619: , fnd_lookup_values fvl53
130620: , fnd_lookup_values fvl68

Line 133844: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

133840: , l1.line_number line_number
133841: , CASE r
133842: WHEN 1 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133843: WHEN 2 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133844: WHEN 3 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
133845: WHEN 4 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133846: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
133847: WHEN 6 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133848: WHEN 7 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 133945: , ZX_AP_DEF_TAX_EXTRACT_V l3

133941: END source_value
133942: , null source_meaning
133943: FROM xla_events_gt xet
133944: , AP_INVOICE_EXTRACT_DETAILS_V l1
133945: , ZX_AP_DEF_TAX_EXTRACT_V l3
133946: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
133947: , (select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
133948: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
133949: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 134092: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%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;
134093: TYPE t_array_source_59 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
134094: TYPE t_array_source_66 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
134095: TYPE t_array_source_78 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
134096: TYPE t_array_source_79 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 134222: , ZX_AP_DEF_TAX_EXTRACT_V l3

134218: , l1.AID_INVOICE_DIST_ID source_156
134219: , l1.AID_PARENT_REVERSAL_ID source_157
134220: FROM xla_events_gt xet
134221: , AP_INVOICE_EXTRACT_DETAILS_V l1
134222: , ZX_AP_DEF_TAX_EXTRACT_V l3
134223: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
134224: WHERE xet.event_id between x_first_event_id and x_last_event_id
134225: and xet.event_date between p_pad_start_date and p_pad_end_date
134226: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 137547: WHEN 25 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

137543: WHEN 21 THEN 'AP_PO_HEADERS_EXTRACT_V'
137544: WHEN 22 THEN 'AP_PO_HEADERS_EXTRACT_V'
137545: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137546: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137547: WHEN 25 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
137548: WHEN 26 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
137549: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137550: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137551: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 137548: WHEN 26 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

137544: WHEN 22 THEN 'AP_PO_HEADERS_EXTRACT_V'
137545: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137546: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137547: WHEN 25 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
137548: WHEN 26 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
137549: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137550: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137551: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
137552: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 137788: , ZX_AP_DEF_TAX_EXTRACT_V l5

137784: END source_meaning
137785: FROM xla_events_gt xet
137786: , AP_PAYMENT_EXTRACT_DETAILS_V l1
137787: , AP_PO_HEADERS_EXTRACT_V l3
137788: , ZX_AP_DEF_TAX_EXTRACT_V l5
137789: , fnd_lookup_values fvl7
137790: , fnd_lookup_values fvl20
137791: , fnd_lookup_values fvl39
137792: , fnd_lookup_values fvl53

Line 138028: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

138024: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
138025: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
138026: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
138027: TYPE t_array_source_57 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
138028: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
138029: TYPE t_array_source_59 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
138030: TYPE t_array_source_62 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
138031: TYPE t_array_source_63 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
138032: TYPE t_array_source_64 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 138029: TYPE t_array_source_59 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

138025: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
138026: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
138027: TYPE t_array_source_57 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
138028: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
138029: TYPE t_array_source_59 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
138030: TYPE t_array_source_62 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
138031: TYPE t_array_source_63 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
138032: TYPE t_array_source_64 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
138033: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ID%TYPE INDEX BY BINARY_INTEGER;

Line 138350: , ZX_AP_DEF_TAX_EXTRACT_V l5

138346: , fvl151.meaning source_151_meaning
138347: FROM xla_events_gt xet
138348: , AP_PAYMENT_EXTRACT_DETAILS_V l1
138349: , AP_PO_HEADERS_EXTRACT_V l3
138350: , ZX_AP_DEF_TAX_EXTRACT_V l5
138351: , fnd_lookup_values fvl7
138352: , fnd_lookup_values fvl20
138353: , fnd_lookup_values fvl39
138354: , fnd_lookup_values fvl53

Line 141694: WHEN 19 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

141690: WHEN 15 THEN 'AP_PO_HEADERS_EXTRACT_V'
141691: WHEN 16 THEN 'AP_PO_HEADERS_EXTRACT_V'
141692: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141693: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141694: WHEN 19 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
141695: WHEN 20 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
141696: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141697: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141698: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 141695: WHEN 20 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

141691: WHEN 16 THEN 'AP_PO_HEADERS_EXTRACT_V'
141692: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141693: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141694: WHEN 19 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
141695: WHEN 20 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
141696: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141697: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141698: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141699: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 141850: , ZX_AP_DEF_TAX_EXTRACT_V l5

141846: END source_meaning
141847: FROM xla_events_gt xet
141848: , AP_PAYMENT_EXTRACT_DETAILS_V l1
141849: , AP_PO_HEADERS_EXTRACT_V l3
141850: , ZX_AP_DEF_TAX_EXTRACT_V l5
141851: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
141852: , fnd_lookup_values fvl7
141853: , fnd_lookup_values fvl20
141854: , fnd_lookup_values fvl39

Line 142068: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

142064: TYPE t_array_source_51 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE%TYPE INDEX BY BINARY_INTEGER;
142065: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
142066: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
142067: TYPE t_array_source_57 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
142068: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
142069: TYPE t_array_source_59 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
142070: TYPE t_array_source_62 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
142071: TYPE t_array_source_63 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
142072: TYPE t_array_source_64 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 142069: TYPE t_array_source_59 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

142065: TYPE t_array_source_52 IS TABLE OF AP_PO_HEADERS_EXTRACT_V.POH_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
142066: TYPE t_array_source_53 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
142067: TYPE t_array_source_57 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_REV_PAY_HIST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
142068: TYPE t_array_source_58 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
142069: TYPE t_array_source_59 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
142070: TYPE t_array_source_62 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
142071: TYPE t_array_source_63 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
142072: TYPE t_array_source_64 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
142073: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ID%TYPE INDEX BY BINARY_INTEGER;

Line 142323: , ZX_AP_DEF_TAX_EXTRACT_V l5

142319: , fvl104.meaning source_104_meaning
142320: FROM xla_events_gt xet
142321: , AP_PAYMENT_EXTRACT_DETAILS_V l1
142322: , AP_PO_HEADERS_EXTRACT_V l3
142323: , ZX_AP_DEF_TAX_EXTRACT_V l5
142324: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
142325: , fnd_lookup_values fvl7
142326: , fnd_lookup_values fvl20
142327: , fnd_lookup_values fvl39