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 ALL_OBJECTS

Line 52848: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)

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
52850: AND xet.event_class_code = C_EVENT_CLASS_CODE
52851: AND h1.event_id = xet.event_id
52852: AND h2.event_id = h1.event_id

Line 52996: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

52992: , null source_meaning
52993: FROM xla_events_gt xet
52994: , AR_DISTRIBUTIONS_BASE_V l4
52995: , AR_DISTRIBUTIONS_L_V l5
52996: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
52997: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
52998: AND xet.event_class_code = C_EVENT_CLASS_CODE
52999: AND l4.event_id = xet.event_id
53000: AND l5.event_id = l4.event_id

Line 54242: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)

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
54245: AND h1.event_id = xet.event_id
54246: AND h2.event_id = h1.event_id

Line 54383: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

54379: , null source_meaning
54380: FROM xla_events_gt xet
54381: , AR_CUST_TRX_LINES_BASE_V l3
54382: , AR_CUST_TRX_LINES_L_V l4
54383: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
54384: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
54385: AND xet.event_class_code = C_EVENT_CLASS_CODE
54386: AND l3.event_id = xet.event_id
54387: AND l4.event_id = l3.event_id

Line 55494: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)

55490: , AR_CM_BILL_SITE_USES_H_V h1
55491: , AR_CM_BILL_TO_CUST_H_V h2
55492: , AR_CREDIT_MEMO_H_V h5
55493: , AR_SYSTEM_PARAM_H_V h8
55494: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
55495: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55496: AND xet.event_class_code = C_EVENT_CLASS_CODE
55497: AND h1.event_id = xet.event_id
55498: AND h2.event_id = h1.event_id

Line 55668: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)

55664: , AR_CM_LINES_BASE_V l3
55665: , AR_CM_LINES_L_V l4
55666: , AR_DISTRIBUTIONS_L_V l6
55667: , AR_RECEIVABLES_TRX_ACT_S_V l7
55668: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
55669: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55670: AND xet.event_class_code = C_EVENT_CLASS_CODE
55671: AND l3.event_id = xet.event_id
55672: AND l4.event_id (+) = l3.event_id

Line 57117: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

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
57120: AND h1.event_id = xet.event_id
57121: AND h2.event_id = h1.event_id

Line 57263: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

57259: , null source_meaning
57260: FROM xla_events_gt xet
57261: , AR_CUST_TRX_LINES_BASE_V l3
57262: , AR_CUST_TRX_LINES_L_V l4
57263: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
57264: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57265: AND xet.event_class_code = C_EVENT_CLASS_CODE
57266: AND l3.event_id = xet.event_id
57267: AND l4.event_id = l3.event_id

Line 58578: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)

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
58581: AND h1.event_id = xet.event_id
58582: AND h2.event_id = h1.event_id

Line 58719: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

58715: , null source_meaning
58716: FROM xla_events_gt xet
58717: , AR_CUST_TRX_LINES_BASE_V l3
58718: , AR_CUST_TRX_LINES_L_V l4
58719: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
58720: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58721: AND xet.event_class_code = C_EVENT_CLASS_CODE
58722: AND l3.event_id = xet.event_id
58723: AND l4.event_id = l3.event_id

Line 59824: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)

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
59827: AND h1.event_id = xet.event_id
59828: AND h2.event_id = h1.event_id

Line 59965: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

59961: , null source_meaning
59962: FROM xla_events_gt xet
59963: , AR_CUST_TRX_LINES_BASE_V l3
59964: , AR_CUST_TRX_LINES_L_V l4
59965: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
59966: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
59967: AND xet.event_class_code = C_EVENT_CLASS_CODE
59968: AND l3.event_id = xet.event_id
59969: AND l4.event_id = l3.event_id

Line 61080: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

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
61083: AND h1.event_id = xet.event_id
61084: AND h2.event_id = h1.event_id

Line 61231: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

61227: , null source_meaning
61228: FROM xla_events_gt xet
61229: , AR_CUST_TRX_LINES_BASE_V l3
61230: , AR_CUST_TRX_LINES_L_V l4
61231: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
61232: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
61233: AND xet.event_class_code = C_EVENT_CLASS_CODE
61234: AND l3.event_id = xet.event_id
61235: AND l4.event_id = l3.event_id

Line 62568: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

62564: FROM xla_events_gt xet
62565: , AR_CASH_RECEIPTS_H_V h1
62566: , AR_RCT_METHOD_H_V h4
62567: , AR_REMIT_BANK_ACCT_H_V h5
62568: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
62569: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62570: AND xet.event_class_code = C_EVENT_CLASS_CODE
62571:
62572: )

Line 62716: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

62712: , null source_meaning
62713: FROM xla_events_gt xet
62714: , AR_DISTRIBUTIONS_BASE_V l2
62715: , AR_DISTRIBUTIONS_L_V l3
62716: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
62717: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62718: AND xet.event_class_code = C_EVENT_CLASS_CODE
62719: AND l2.event_id = xet.event_id
62720: AND l3.event_id = l2.event_id

Line 64134: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)

64130: , AR_RCT_METHOD_H_V h5
64131: , AR_RCT_SITE_USES_H_V h6
64132: , AR_REMIT_BANK_ACCT_H_V h8
64133: , AR_SYSTEM_PARAM_H_V h9
64134: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
64135: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64136: AND xet.event_class_code = C_EVENT_CLASS_CODE
64137: AND h1.event_id = xet.event_id
64138: AND h5.event_id (+) = h1.event_id

Line 64375: , (select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)

64371: , AR_DISTRIBUTIONS_BASE_V l3
64372: , AR_DISTRIBUTIONS_L_V l4
64373: , AR_RECEIVABLES_TRX_ACT_S_V l7
64374: , AR_TRANSACTIONS_S_V l10
64375: , (select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)
64376: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64377: AND xet.event_class_code = C_EVENT_CLASS_CODE
64378: AND l3.event_id = xet.event_id
64379: AND l2.event_id (+) = l3.event_id