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_SITE_USES_S_V

Line 52784: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'

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'
52788: WHEN 8 THEN 'AR_ADJUSTMENTS_H_V'

Line 52845: , AR_BILL_TO_SITE_USES_S_V h3

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)
52849: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

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;
53142: TYPE t_array_source_73 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 53215: , AR_BILL_TO_SITE_USES_S_V h3

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
53219: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 54183: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'

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'
54187: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

Line 54240: , AR_BILL_TO_SITE_USES_S_V h2

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
54244: AND xet.event_class_code = C_EVENT_CLASS_CODE

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

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;
54527: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 54596: , AR_BILL_TO_SITE_USES_S_V h2

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

Line 57049: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'

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'
57053: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 57115: , AR_BILL_TO_SITE_USES_S_V h2

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
57119: AND xet.event_class_code = C_EVENT_CLASS_CODE

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

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;
57408: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 57484: , AR_BILL_TO_SITE_USES_S_V h2

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

Line 58519: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'

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'
58523: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

Line 58576: , AR_BILL_TO_SITE_USES_S_V h2

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
58580: AND xet.event_class_code = C_EVENT_CLASS_CODE

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

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;
58863: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 58932: , AR_BILL_TO_SITE_USES_S_V h2

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

Line 59765: WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'

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'
59769: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'

Line 59822: , AR_BILL_TO_SITE_USES_S_V h2

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
59826: AND xet.event_class_code = C_EVENT_CLASS_CODE

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

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;
60109: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 60178: , AR_BILL_TO_SITE_USES_S_V h2

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

Line 61012: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'

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'
61016: WHEN 7 THEN 'AR_TRANSACTIONS_S_V'

Line 61078: , AR_BILL_TO_SITE_USES_S_V h2

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
61082: AND xet.event_class_code = C_EVENT_CLASS_CODE

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

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;
61376: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 61454: , AR_BILL_TO_SITE_USES_S_V h2

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