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_00222_AAD_S_000007_PKG dependencies on AR_BILL_TO_CUSTOMERS_S_V

Line 53085: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

53081: , 0 line_number
53082: , CASE r
53083: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
53084: WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
53085: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
53086: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
53087: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
53088: WHEN 6 THEN 'AR_ADJUSTMENTS_H_V'
53089: WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'

Line 53146: , AR_BILL_TO_CUSTOMERS_S_V h2

53142: END source_value
53143: , null source_meaning
53144: FROM xla_events_gt xet
53145: , AR_ADJUSTMENTS_H_V h1
53146: , AR_BILL_TO_CUSTOMERS_S_V h2
53147: , AR_BILL_TO_SITE_USES_S_V h3
53148: , AR_RECEIVABLES_TRX_ACT_S_V h6
53149: , AR_TRANSACTIONS_S_V h7
53150: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)

Line 53439: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

53435: --
53436:
53437: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
53438: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
53439: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
53440: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
53441: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
53442: TYPE t_array_source_73 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
53443: TYPE t_array_source_74 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 53516: , AR_BILL_TO_CUSTOMERS_S_V h2

53512: , h1.ADJ_DOC_SEQUENCE_ID source_74
53513: , h1.ADJ_DOC_SEQUENCE_VALUE source_75
53514: FROM xla_events_gt xet
53515: , AR_ADJUSTMENTS_H_V h1
53516: , AR_BILL_TO_CUSTOMERS_S_V h2
53517: , AR_BILL_TO_SITE_USES_S_V h3
53518: , AR_RECEIVABLES_TRX_ACT_S_V h6
53519: , AR_TRANSACTIONS_S_V h7
53520: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 54453: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

54449: FROM (
54450: SELECT xet.event_id event_id
54451: , 0 line_number
54452: , CASE r
54453: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
54454: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
54455: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
54456: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
54457: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 54510: , AR_BILL_TO_CUSTOMERS_S_V h1

54506: ELSE null
54507: END source_value
54508: , null source_meaning
54509: FROM xla_events_gt xet
54510: , AR_BILL_TO_CUSTOMERS_S_V h1
54511: , AR_BILL_TO_SITE_USES_S_V h2
54512: , AR_TRANSACTIONS_S_V h5
54513: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
54514: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 54793: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

54789: --
54790: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
54791: --
54792:
54793: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
54794: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
54795: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
54796: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
54797: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 54866: , AR_BILL_TO_CUSTOMERS_S_V h1

54862: , h5.TRX_DOC_SEQUENCE_CATEGORY source_77
54863: , h5.TRX_DOC_SEQUENCE_ID source_78
54864: , h5.TRX_DOC_SEQUENCE_VALUE source_79
54865: FROM xla_events_gt xet
54866: , AR_BILL_TO_CUSTOMERS_S_V h1
54867: , AR_BILL_TO_SITE_USES_S_V h2
54868: , AR_TRANSACTIONS_S_V h5
54869: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
54870: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 57319: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

57315: SELECT xet.event_id event_id
57316: , 0 line_number
57317: , CASE r
57318: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
57319: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
57320: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
57321: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
57322: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
57323: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

Line 57385: , AR_BILL_TO_CUSTOMERS_S_V h1

57381: ELSE null
57382: END source_value
57383: , null source_meaning
57384: FROM xla_events_gt xet
57385: , AR_BILL_TO_CUSTOMERS_S_V h1
57386: , AR_BILL_TO_SITE_USES_S_V h2
57387: , AR_TRANSACTIONS_S_V h5
57388: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
57389: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 57674: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

57670: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
57671: --
57672:
57673: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
57674: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
57675: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
57676: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
57677: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57678: TYPE t_array_source_53 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 57754: , AR_BILL_TO_CUSTOMERS_S_V h1

57750: , h5.TRX_DOC_SEQUENCE_CATEGORY source_77
57751: , h5.TRX_DOC_SEQUENCE_ID source_78
57752: , h5.TRX_DOC_SEQUENCE_VALUE source_79
57753: FROM xla_events_gt xet
57754: , AR_BILL_TO_CUSTOMERS_S_V h1
57755: , AR_BILL_TO_SITE_USES_S_V h2
57756: , AR_TRANSACTIONS_S_V h5
57757: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
57758: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 58789: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

58785: FROM (
58786: SELECT xet.event_id event_id
58787: , 0 line_number
58788: , CASE r
58789: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
58790: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
58791: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
58792: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
58793: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 58846: , AR_BILL_TO_CUSTOMERS_S_V h1

58842: ELSE null
58843: END source_value
58844: , null source_meaning
58845: FROM xla_events_gt xet
58846: , AR_BILL_TO_CUSTOMERS_S_V h1
58847: , AR_BILL_TO_SITE_USES_S_V h2
58848: , AR_TRANSACTIONS_S_V h5
58849: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
58850: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 59129: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

59125: --
59126: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
59127: --
59128:
59129: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
59130: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
59131: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
59132: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
59133: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 59202: , AR_BILL_TO_CUSTOMERS_S_V h1

59198: , h5.TRX_DOC_SEQUENCE_CATEGORY source_77
59199: , h5.TRX_DOC_SEQUENCE_ID source_78
59200: , h5.TRX_DOC_SEQUENCE_VALUE source_79
59201: FROM xla_events_gt xet
59202: , AR_BILL_TO_CUSTOMERS_S_V h1
59203: , AR_BILL_TO_SITE_USES_S_V h2
59204: , AR_TRANSACTIONS_S_V h5
59205: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
59206: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 60035: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

60031: FROM (
60032: SELECT xet.event_id event_id
60033: , 0 line_number
60034: , CASE r
60035: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
60036: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
60037: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
60038: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
60039: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 60092: , AR_BILL_TO_CUSTOMERS_S_V h1

60088: ELSE null
60089: END source_value
60090: , null source_meaning
60091: FROM xla_events_gt xet
60092: , AR_BILL_TO_CUSTOMERS_S_V h1
60093: , AR_BILL_TO_SITE_USES_S_V h2
60094: , AR_TRANSACTIONS_S_V h5
60095: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
60096: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 60375: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

60371: --
60372: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
60373: --
60374:
60375: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
60376: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
60377: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
60378: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
60379: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 60448: , AR_BILL_TO_CUSTOMERS_S_V h1

60444: , h5.TRX_DOC_SEQUENCE_CATEGORY source_77
60445: , h5.TRX_DOC_SEQUENCE_ID source_78
60446: , h5.TRX_DOC_SEQUENCE_VALUE source_79
60447: FROM xla_events_gt xet
60448: , AR_BILL_TO_CUSTOMERS_S_V h1
60449: , AR_BILL_TO_SITE_USES_S_V h2
60450: , AR_TRANSACTIONS_S_V h5
60451: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
60452: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 61282: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

61278: SELECT xet.event_id event_id
61279: , 0 line_number
61280: , CASE r
61281: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
61282: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
61283: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
61284: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
61285: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
61286: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

Line 61348: , AR_BILL_TO_CUSTOMERS_S_V h1

61344: ELSE null
61345: END source_value
61346: , null source_meaning
61347: FROM xla_events_gt xet
61348: , AR_BILL_TO_CUSTOMERS_S_V h1
61349: , AR_BILL_TO_SITE_USES_S_V h2
61350: , AR_TRANSACTIONS_S_V h5
61351: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
61352: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 61642: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

61638: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
61639: --
61640:
61641: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
61642: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
61643: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
61644: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
61645: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
61646: TYPE t_array_source_53 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 61724: , AR_BILL_TO_CUSTOMERS_S_V h1

61720: , h5.TRX_DOC_SEQUENCE_CATEGORY source_77
61721: , h5.TRX_DOC_SEQUENCE_ID source_78
61722: , h5.TRX_DOC_SEQUENCE_VALUE source_79
61723: FROM xla_events_gt xet
61724: , AR_BILL_TO_CUSTOMERS_S_V h1
61725: , AR_BILL_TO_SITE_USES_S_V h2
61726: , AR_TRANSACTIONS_S_V h5
61727: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
61728: and xet.event_class_code = C_EVENT_CLASS_CODE