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

Line 52783: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

52779: , 0 line_number
52780: , CASE r
52781: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
52782: WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
52783: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
52784: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
52785: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
52786: WHEN 6 THEN 'AR_ADJUSTMENTS_H_V'
52787: WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'

Line 52844: , AR_BILL_TO_CUSTOMERS_S_V h2

52840: END source_value
52841: , null source_meaning
52842: FROM xla_events_gt xet
52843: , AR_ADJUSTMENTS_H_V h1
52844: , AR_BILL_TO_CUSTOMERS_S_V h2
52845: , AR_BILL_TO_SITE_USES_S_V h3
52846: , AR_RECEIVABLES_TRX_ACT_S_V h6
52847: , AR_TRANSACTIONS_S_V h7
52848: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)

Line 53137: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

53133: --
53134:
53135: TYPE t_array_source_9 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
53136: TYPE t_array_source_14 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
53137: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
53138: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
53139: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
53140: TYPE t_array_source_71 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
53141: TYPE t_array_source_72 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 53214: , AR_BILL_TO_CUSTOMERS_S_V h2

53210: , h1.ADJ_DOC_SEQUENCE_ID source_72
53211: , h1.ADJ_DOC_SEQUENCE_VALUE source_73
53212: FROM xla_events_gt xet
53213: , AR_ADJUSTMENTS_H_V h1
53214: , AR_BILL_TO_CUSTOMERS_S_V h2
53215: , AR_BILL_TO_SITE_USES_S_V h3
53216: , AR_RECEIVABLES_TRX_ACT_S_V h6
53217: , AR_TRANSACTIONS_S_V h7
53218: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 54182: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

54178: FROM (
54179: SELECT xet.event_id event_id
54180: , 0 line_number
54181: , CASE r
54182: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
54183: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
54184: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
54185: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
54186: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 54239: , AR_BILL_TO_CUSTOMERS_S_V h1

54235: ELSE null
54236: END source_value
54237: , null source_meaning
54238: FROM xla_events_gt xet
54239: , AR_BILL_TO_CUSTOMERS_S_V h1
54240: , AR_BILL_TO_SITE_USES_S_V h2
54241: , AR_TRANSACTIONS_S_V h5
54242: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
54243: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 54522: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

54518: --
54519: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
54520: --
54521:
54522: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
54523: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
54524: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
54525: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
54526: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 54595: , AR_BILL_TO_CUSTOMERS_S_V h1

54591: , h5.TRX_DOC_SEQUENCE_CATEGORY source_75
54592: , h5.TRX_DOC_SEQUENCE_ID source_76
54593: , h5.TRX_DOC_SEQUENCE_VALUE source_77
54594: FROM xla_events_gt xet
54595: , AR_BILL_TO_CUSTOMERS_S_V h1
54596: , AR_BILL_TO_SITE_USES_S_V h2
54597: , AR_TRANSACTIONS_S_V h5
54598: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
54599: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 57048: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

57044: SELECT xet.event_id event_id
57045: , 0 line_number
57046: , CASE r
57047: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
57048: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
57049: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
57050: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
57051: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
57052: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

Line 57114: , AR_BILL_TO_CUSTOMERS_S_V h1

57110: ELSE null
57111: END source_value
57112: , null source_meaning
57113: FROM xla_events_gt xet
57114: , AR_BILL_TO_CUSTOMERS_S_V h1
57115: , AR_BILL_TO_SITE_USES_S_V h2
57116: , AR_TRANSACTIONS_S_V h5
57117: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
57118: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 57403: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

57399: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
57400: --
57401:
57402: TYPE t_array_source_9 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
57403: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
57404: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
57405: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
57406: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57407: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 57483: , AR_BILL_TO_CUSTOMERS_S_V h1

57479: , h5.TRX_DOC_SEQUENCE_CATEGORY source_75
57480: , h5.TRX_DOC_SEQUENCE_ID source_76
57481: , h5.TRX_DOC_SEQUENCE_VALUE source_77
57482: FROM xla_events_gt xet
57483: , AR_BILL_TO_CUSTOMERS_S_V h1
57484: , AR_BILL_TO_SITE_USES_S_V h2
57485: , AR_TRANSACTIONS_S_V h5
57486: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
57487: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 58518: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

58514: FROM (
58515: SELECT xet.event_id event_id
58516: , 0 line_number
58517: , CASE r
58518: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
58519: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
58520: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
58521: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
58522: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 58575: , AR_BILL_TO_CUSTOMERS_S_V h1

58571: ELSE null
58572: END source_value
58573: , null source_meaning
58574: FROM xla_events_gt xet
58575: , AR_BILL_TO_CUSTOMERS_S_V h1
58576: , AR_BILL_TO_SITE_USES_S_V h2
58577: , AR_TRANSACTIONS_S_V h5
58578: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
58579: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 58858: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

58854: --
58855: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
58856: --
58857:
58858: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
58859: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
58860: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
58861: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58862: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 58931: , AR_BILL_TO_CUSTOMERS_S_V h1

58927: , h5.TRX_DOC_SEQUENCE_CATEGORY source_75
58928: , h5.TRX_DOC_SEQUENCE_ID source_76
58929: , h5.TRX_DOC_SEQUENCE_VALUE source_77
58930: FROM xla_events_gt xet
58931: , AR_BILL_TO_CUSTOMERS_S_V h1
58932: , AR_BILL_TO_SITE_USES_S_V h2
58933: , AR_TRANSACTIONS_S_V h5
58934: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
58935: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 59764: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

59760: FROM (
59761: SELECT xet.event_id event_id
59762: , 0 line_number
59763: , CASE r
59764: WHEN 1 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
59765: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
59766: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
59767: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
59768: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'

Line 59821: , AR_BILL_TO_CUSTOMERS_S_V h1

59817: ELSE null
59818: END source_value
59819: , null source_meaning
59820: FROM xla_events_gt xet
59821: , AR_BILL_TO_CUSTOMERS_S_V h1
59822: , AR_BILL_TO_SITE_USES_S_V h2
59823: , AR_TRANSACTIONS_S_V h5
59824: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
59825: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 60104: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

60100: --
60101: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
60102: --
60103:
60104: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
60105: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
60106: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
60107: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
60108: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 60177: , AR_BILL_TO_CUSTOMERS_S_V h1

60173: , h5.TRX_DOC_SEQUENCE_CATEGORY source_75
60174: , h5.TRX_DOC_SEQUENCE_ID source_76
60175: , h5.TRX_DOC_SEQUENCE_VALUE source_77
60176: FROM xla_events_gt xet
60177: , AR_BILL_TO_CUSTOMERS_S_V h1
60178: , AR_BILL_TO_SITE_USES_S_V h2
60179: , AR_TRANSACTIONS_S_V h5
60180: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
60181: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 61011: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'

61007: SELECT xet.event_id event_id
61008: , 0 line_number
61009: , CASE r
61010: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
61011: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
61012: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
61013: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
61014: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
61015: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

Line 61077: , AR_BILL_TO_CUSTOMERS_S_V h1

61073: ELSE null
61074: END source_value
61075: , null source_meaning
61076: FROM xla_events_gt xet
61077: , AR_BILL_TO_CUSTOMERS_S_V h1
61078: , AR_BILL_TO_SITE_USES_S_V h2
61079: , AR_TRANSACTIONS_S_V h5
61080: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
61081: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 61371: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

61367: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
61368: --
61369:
61370: TYPE t_array_source_9 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
61371: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
61372: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
61373: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
61374: TYPE t_array_source_30 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
61375: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 61453: , AR_BILL_TO_CUSTOMERS_S_V h1

61449: , h5.TRX_DOC_SEQUENCE_CATEGORY source_75
61450: , h5.TRX_DOC_SEQUENCE_ID source_76
61451: , h5.TRX_DOC_SEQUENCE_VALUE source_77
61452: FROM xla_events_gt xet
61453: , AR_BILL_TO_CUSTOMERS_S_V h1
61454: , AR_BILL_TO_SITE_USES_S_V h2
61455: , AR_TRANSACTIONS_S_V h5
61456: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
61457: and xet.event_class_code = C_EVENT_CLASS_CODE