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_000006_BC_PKG dependencies on ZX_AP_TAX_JRNL_LINE_DESC_V

Line 65465: WHEN 33 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'

65461: WHEN 29 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
65462: WHEN 30 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
65463: WHEN 31 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
65464: WHEN 32 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
65465: WHEN 33 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
65466: WHEN 34 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
65467: WHEN 35 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
65468: WHEN 36 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
65469: WHEN 37 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 65700: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

65696: END source_meaning
65697: FROM xla_events_gt xet
65698: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
65699: , ZX_AP_DEF_TAX_EXTRACT_V l4
65700: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
65701: , fnd_lookup_values fvl9
65702: , fnd_lookup_values fvl15
65703: , fnd_lookup_values fvl18
65704: , fnd_lookup_values fvl46

Line 65912: TYPE t_array_source_53 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

65908: TYPE t_array_source_46 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
65909: TYPE t_array_source_50 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
65910: TYPE t_array_source_51 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_STAT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
65911: TYPE t_array_source_52 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
65912: TYPE t_array_source_53 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
65913: TYPE t_array_source_54 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
65914: TYPE t_array_source_55 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
65915: TYPE t_array_source_56 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
65916: TYPE t_array_source_58 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 66160: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

66156: , l1.AID_BASE_QUANTITY_VARIANCE source_82
66157: FROM xla_events_gt xet
66158: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
66159: , ZX_AP_DEF_TAX_EXTRACT_V l4
66160: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
66161: , fnd_lookup_values fvl9
66162: , fnd_lookup_values fvl15
66163: , fnd_lookup_values fvl18
66164: , fnd_lookup_values fvl46

Line 68322: WHEN 32 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'

68318: WHEN 28 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
68319: WHEN 29 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
68320: WHEN 30 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
68321: WHEN 31 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
68322: WHEN 32 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
68323: WHEN 33 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
68324: WHEN 34 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
68325: WHEN 35 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
68326: WHEN 36 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 68553: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

68549: END source_meaning
68550: FROM xla_events_gt xet
68551: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
68552: , ZX_AP_DEF_TAX_EXTRACT_V l4
68553: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
68554: , fnd_lookup_values fvl9
68555: , fnd_lookup_values fvl15
68556: , fnd_lookup_values fvl18
68557: , fnd_lookup_values fvl46

Line 68764: TYPE t_array_source_53 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

68760: TYPE t_array_source_45 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
68761: TYPE t_array_source_46 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
68762: TYPE t_array_source_50 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
68763: TYPE t_array_source_52 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
68764: TYPE t_array_source_53 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
68765: TYPE t_array_source_54 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
68766: TYPE t_array_source_55 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
68767: TYPE t_array_source_56 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
68768: TYPE t_array_source_58 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 69010: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

69006: , l1.AID_BASE_QUANTITY_VARIANCE source_82
69007: FROM xla_events_gt xet
69008: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
69009: , ZX_AP_DEF_TAX_EXTRACT_V l4
69010: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
69011: , fnd_lookup_values fvl9
69012: , fnd_lookup_values fvl15
69013: , fnd_lookup_values fvl18
69014: , fnd_lookup_values fvl46

Line 71166: WHEN 33 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'

71162: WHEN 29 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
71163: WHEN 30 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
71164: WHEN 31 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
71165: WHEN 32 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
71166: WHEN 33 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
71167: WHEN 34 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
71168: WHEN 35 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
71169: WHEN 36 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
71170: WHEN 37 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 71406: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

71402: END source_meaning
71403: FROM xla_events_gt xet
71404: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
71405: , ZX_AP_DEF_TAX_EXTRACT_V l4
71406: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
71407: , fnd_lookup_values fvl9
71408: , fnd_lookup_values fvl15
71409: , fnd_lookup_values fvl18
71410: , fnd_lookup_values fvl46

Line 71619: TYPE t_array_source_53 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

71615: TYPE t_array_source_46 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
71616: TYPE t_array_source_50 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
71617: TYPE t_array_source_51 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_STAT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
71618: TYPE t_array_source_52 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
71619: TYPE t_array_source_53 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
71620: TYPE t_array_source_54 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
71621: TYPE t_array_source_55 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
71622: TYPE t_array_source_56 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
71623: TYPE t_array_source_57 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 71879: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

71875: , l1.AID_BASE_QUANTITY_VARIANCE source_82
71876: FROM xla_events_gt xet
71877: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
71878: , ZX_AP_DEF_TAX_EXTRACT_V l4
71879: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
71880: , fnd_lookup_values fvl9
71881: , fnd_lookup_values fvl15
71882: , fnd_lookup_values fvl18
71883: , fnd_lookup_values fvl46

Line 75926: WHEN 16 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'

75922: WHEN 12 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
75923: WHEN 13 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
75924: WHEN 14 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
75925: WHEN 15 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
75926: WHEN 16 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
75927: WHEN 17 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
75928: WHEN 18 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
75929: WHEN 19 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
75930: WHEN 20 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'

Line 76114: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

76110: END source_meaning
76111: FROM xla_events_gt xet
76112: , AP_PREPAYAPP_EXTRACT_DTLS_BC_V l2
76113: , ZX_AP_DEF_TAX_EXTRACT_V l4
76114: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
76115: , fnd_lookup_values fvl46
76116: , (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
76117: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76118: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 76280: TYPE t_array_source_53 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

76276: TYPE t_array_source_44 IS TABLE OF AP_PREPAYAPP_EXTRACT_DTLS_BC_V.DEFERRED_OPTION%TYPE INDEX BY BINARY_INTEGER;
76277: TYPE t_array_source_45 IS TABLE OF AP_PREPAYAPP_EXTRACT_DTLS_BC_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
76278: TYPE t_array_source_46 IS TABLE OF AP_PREPAYAPP_EXTRACT_DTLS_BC_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
76279: TYPE t_array_source_52 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
76280: TYPE t_array_source_53 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76281: TYPE t_array_source_54 IS TABLE OF AP_PREPAYAPP_EXTRACT_DTLS_BC_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
76282: TYPE t_array_source_55 IS TABLE OF AP_PREPAYAPP_EXTRACT_DTLS_BC_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
76283: TYPE t_array_source_56 IS TABLE OF AP_PREPAYAPP_EXTRACT_DTLS_BC_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
76284: TYPE t_array_source_58 IS TABLE OF AP_PREPAYAPP_EXTRACT_DTLS_BC_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 76469: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

76465: , l2.REVERSED_PREPAY_APP_DIST_ID source_80
76466: FROM xla_events_gt xet
76467: , AP_PREPAYAPP_EXTRACT_DTLS_BC_V l2
76468: , ZX_AP_DEF_TAX_EXTRACT_V l4
76469: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
76470: , fnd_lookup_values fvl46
76471: WHERE xet.event_id between x_first_event_id and x_last_event_id
76472: and xet.event_date between p_pad_start_date and p_pad_end_date
76473: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 77595: WHEN 33 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'

77591: WHEN 29 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
77592: WHEN 30 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
77593: WHEN 31 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
77594: WHEN 32 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
77595: WHEN 33 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
77596: WHEN 34 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
77597: WHEN 35 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
77598: WHEN 36 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
77599: WHEN 37 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 77830: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

77826: END source_meaning
77827: FROM xla_events_gt xet
77828: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
77829: , ZX_AP_DEF_TAX_EXTRACT_V l4
77830: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
77831: , fnd_lookup_values fvl9
77832: , fnd_lookup_values fvl15
77833: , fnd_lookup_values fvl18
77834: , fnd_lookup_values fvl46

Line 78042: TYPE t_array_source_53 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

78038: TYPE t_array_source_46 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
78039: TYPE t_array_source_50 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
78040: TYPE t_array_source_51 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_STAT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
78041: TYPE t_array_source_52 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
78042: TYPE t_array_source_53 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
78043: TYPE t_array_source_54 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
78044: TYPE t_array_source_55 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
78045: TYPE t_array_source_56 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
78046: TYPE t_array_source_58 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 78290: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

78286: , l1.AID_BASE_QUANTITY_VARIANCE source_82
78287: FROM xla_events_gt xet
78288: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
78289: , ZX_AP_DEF_TAX_EXTRACT_V l4
78290: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
78291: , fnd_lookup_values fvl9
78292: , fnd_lookup_values fvl15
78293: , fnd_lookup_values fvl18
78294: , fnd_lookup_values fvl46