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_TAX_JRNL_LINE_DESC_V

Line 118688: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'

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'
118691: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
118692: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 118788: , ZX_AP_TAX_JRNL_LINE_DESC_V l4

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
118792: AND l1.event_id = xet.event_id

Line 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;

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;
118939: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
118940: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 119065: , ZX_AP_TAX_JRNL_LINE_DESC_V l4

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
119069: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 119945: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'

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'
119948: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
119949: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 120045: , ZX_AP_TAX_JRNL_LINE_DESC_V l4

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
120049: AND l1.event_id = xet.event_id

Line 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;

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;
120196: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
120197: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 120322: , ZX_AP_TAX_JRNL_LINE_DESC_V l4

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
120326: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 123191: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'

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'
123194: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
123195: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 123291: , ZX_AP_TAX_JRNL_LINE_DESC_V l4

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
123295: AND l1.event_id = xet.event_id

Line 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;

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;
123442: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
123443: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 123568: , ZX_AP_TAX_JRNL_LINE_DESC_V l4

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
123572: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 125792: WHEN 29 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_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'
125791: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125792: WHEN 29 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
125793: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125794: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125795: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
125796: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'

Line 125989: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
125993: , fnd_lookup_values fvl53

Line 126226: 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;

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;
126225: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.BUS_FLOW_INV_ID%TYPE INDEX BY BINARY_INTEGER;
126226: 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;
126227: TYPE t_array_source_100 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.POD_ACCRUE_ON_RECEIPT_FLAG%TYPE INDEX BY BINARY_INTEGER;
126228: TYPE t_array_source_101 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_TYPE_PAID%TYPE INDEX BY BINARY_INTEGER;
126229: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_INV_BASE_AMT_VARIANCE%TYPE INDEX BY BINARY_INTEGER;
126230: TYPE t_array_source_104 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_ENCUMBERED_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 126536: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
126540: , fnd_lookup_values fvl53

Line 129759: WHEN 17 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_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'
129760: WHEN 18 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129761: WHEN 19 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129762: WHEN 20 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
129763: WHEN 21 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'

Line 130092: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
130096: , fnd_lookup_values fvl100

Line 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;

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;
130297: TYPE t_array_source_67 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.APAD_DIST_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
130298: TYPE t_array_source_68 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.RECP_INV_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
130299: TYPE t_array_source_71 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.APAD_DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
130300: TYPE t_array_source_73 IS TABLE OF AP_PREPAYAPP_EXTRACT_DETAILS_V.BF_ACCRUAL_PREPAY_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 130617: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
130621: , fnd_lookup_values fvl100

Line 133846: WHEN 5 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'

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'
133849: WHEN 8 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'
133850: WHEN 9 THEN 'AP_INVOICE_EXTRACT_DETAILS_V'

Line 133946: , ZX_AP_TAX_JRNL_LINE_DESC_V l4

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
133950: AND l1.event_id = xet.event_id

Line 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;

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;
134097: TYPE t_array_source_81 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_CR_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
134098: TYPE t_array_source_83 IS TABLE OF AP_INVOICE_EXTRACT_DETAILS_V.UPG_ENC_DR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 134223: , ZX_AP_TAX_JRNL_LINE_DESC_V l4

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
134227: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 141700: WHEN 25 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_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'
141700: WHEN 25 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
141701: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141702: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141703: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
141704:

Line 141851: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
141855: , fnd_lookup_values fvl53

Line 142074: 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;

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;
142074: 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;
142075: TYPE t_array_source_100 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.POD_ACCRUE_ON_RECEIPT_FLAG%TYPE INDEX BY BINARY_INTEGER;
142076: TYPE t_array_source_101 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AI_INVOICE_TYPE_PAID%TYPE INDEX BY BINARY_INTEGER;
142077: TYPE t_array_source_104 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_ENCUMBERED_FLAG%TYPE INDEX BY BINARY_INTEGER;
142078:

Line 142324: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

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
142328: , fnd_lookup_values fvl53