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.

[Home] [Help]

APPS.XLA_00200_AAD_S_000012_BC_PKG dependencies on ZX_AP_DEF_TAX_EXTRACT_V

Line 36621: WHEN 36 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

36617: WHEN 32 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36618: WHEN 33 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36619: WHEN 34 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36620: WHEN 35 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36621: WHEN 36 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
36622: WHEN 37 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
36623: WHEN 38 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36624: WHEN 39 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36625: WHEN 40 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 36836: , ZX_AP_DEF_TAX_EXTRACT_V l4

36832: END source_meaning
36833: FROM xla_events_gt xet
36834: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
36835: , FV_XLA_AP_REF_V l3
36836: , ZX_AP_DEF_TAX_EXTRACT_V l4
36837: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
36838: , fnd_lookup_values fvl8
36839: , fnd_lookup_values fvl11
36840: , fnd_lookup_values fvl42

Line 37040: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

37036: TYPE t_array_source_41 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
37037: TYPE t_array_source_42 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
37038: TYPE t_array_source_46 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
37039: TYPE t_array_source_47 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_STAT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
37040: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
37041: TYPE t_array_source_49 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
37042: TYPE t_array_source_50 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
37043: TYPE t_array_source_51 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
37044: TYPE t_array_source_52 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 37251: , ZX_AP_DEF_TAX_EXTRACT_V l4

37247: , l1.INV_DIST_BASE_AMOUNT source_56
37248: FROM xla_events_gt xet
37249: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
37250: , FV_XLA_AP_REF_V l3
37251: , ZX_AP_DEF_TAX_EXTRACT_V l4
37252: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
37253: , fnd_lookup_values fvl8
37254: , fnd_lookup_values fvl11
37255: , fnd_lookup_values fvl42

Line 38965: WHEN 35 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

38961: WHEN 31 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38962: WHEN 32 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38963: WHEN 33 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38964: WHEN 34 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38965: WHEN 35 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
38966: WHEN 36 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
38967: WHEN 37 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38968: WHEN 38 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38969: WHEN 39 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 39181: , ZX_AP_DEF_TAX_EXTRACT_V l4

39177: END source_meaning
39178: FROM xla_events_gt xet
39179: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
39180: , FV_XLA_AP_REF_V l3
39181: , ZX_AP_DEF_TAX_EXTRACT_V l4
39182: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
39183: , fnd_lookup_values fvl8
39184: , fnd_lookup_values fvl11
39185: , fnd_lookup_values fvl42

Line 39384: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

39380: TYPE t_array_source_40 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DEFERRED_OPTION%TYPE INDEX BY BINARY_INTEGER;
39381: TYPE t_array_source_41 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
39382: TYPE t_array_source_42 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
39383: TYPE t_array_source_46 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
39384: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
39385: TYPE t_array_source_49 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
39386: TYPE t_array_source_50 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
39387: TYPE t_array_source_51 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
39388: TYPE t_array_source_52 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 39596: , ZX_AP_DEF_TAX_EXTRACT_V l4

39592: , l1.AID_BASE_AMT_NO_ROUND source_58
39593: FROM xla_events_gt xet
39594: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
39595: , FV_XLA_AP_REF_V l3
39596: , ZX_AP_DEF_TAX_EXTRACT_V l4
39597: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
39598: , fnd_lookup_values fvl8
39599: , fnd_lookup_values fvl11
39600: , fnd_lookup_values fvl42

Line 41311: WHEN 36 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

41307: WHEN 32 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41308: WHEN 33 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41309: WHEN 34 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41310: WHEN 35 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41311: WHEN 36 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
41312: WHEN 37 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
41313: WHEN 38 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41314: WHEN 39 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41315: WHEN 40 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 41581: , ZX_AP_DEF_TAX_EXTRACT_V l5

41577: END source_meaning
41578: FROM xla_events_gt xet
41579: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
41580: , FV_XLA_AP_REF_V l4
41581: , ZX_AP_DEF_TAX_EXTRACT_V l5
41582: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
41583: , fnd_lookup_values fvl8
41584: , fnd_lookup_values fvl11
41585: , fnd_lookup_values fvl42

Line 41786: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

41782: TYPE t_array_source_41 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
41783: TYPE t_array_source_42 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
41784: TYPE t_array_source_46 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
41785: TYPE t_array_source_47 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_STAT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
41786: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
41787: TYPE t_array_source_49 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
41788: TYPE t_array_source_50 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
41789: TYPE t_array_source_51 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
41790: TYPE t_array_source_52 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 42040: , ZX_AP_DEF_TAX_EXTRACT_V l5

42036: , l4.FEDERAL_PAID_UNEXP_OBG_AMT source_69
42037: FROM xla_events_gt xet
42038: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
42039: , FV_XLA_AP_REF_V l4
42040: , ZX_AP_DEF_TAX_EXTRACT_V l5
42041: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
42042: , fnd_lookup_values fvl8
42043: , fnd_lookup_values fvl11
42044: , fnd_lookup_values fvl42

Line 44321: WHEN 28 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'

44317: WHEN 24 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44318: WHEN 25 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44319: WHEN 26 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44320: WHEN 27 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44321: WHEN 28 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
44322: WHEN 29 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
44323: WHEN 30 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44324: WHEN 31 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44325: WHEN 32 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 44497: , ZX_AP_DEF_TAX_EXTRACT_V l4

44493: END source_meaning
44494: FROM xla_events_gt xet
44495: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
44496: , FV_XLA_AP_REF_V l3
44497: , ZX_AP_DEF_TAX_EXTRACT_V l4
44498: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
44499: , fnd_lookup_values fvl42
44500: , (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
44501: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 44681: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

44677: TYPE t_array_source_41 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
44678: TYPE t_array_source_42 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
44679: TYPE t_array_source_46 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
44680: TYPE t_array_source_47 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_STAT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
44681: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
44682: TYPE t_array_source_49 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
44683: TYPE t_array_source_50 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
44684: TYPE t_array_source_51 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
44685: TYPE t_array_source_52 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 44867: , ZX_AP_DEF_TAX_EXTRACT_V l4

44863: , l1.POD_PO_DISTRIBUTION_ID source_70
44864: FROM xla_events_gt xet
44865: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
44866: , FV_XLA_AP_REF_V l3
44867: , ZX_AP_DEF_TAX_EXTRACT_V l4
44868: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
44869: , fnd_lookup_values fvl42
44870: WHERE xet.event_id between x_first_event_id and x_last_event_id
44871: and xet.event_date between p_pad_start_date and p_pad_end_date