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_000005_PKG dependencies on ALL_OBJECTS

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

66796: , AR_BILL_TO_CUSTOMERS_S_V h2
66797: , AR_BILL_TO_SITE_USES_S_V h3
66798: , AR_RECEIVABLES_TRX_ACT_S_V h6
66799: , AR_TRANSACTIONS_S_V h7
66800: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
66801: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66802: AND xet.event_class_code = C_EVENT_CLASS_CODE
66803: AND h1.event_id = xet.event_id
66804: AND h2.event_id = h1.event_id

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

66944: , null source_meaning
66945: FROM xla_events_gt xet
66946: , AR_DISTRIBUTIONS_BASE_V l4
66947: , AR_DISTRIBUTIONS_L_V l5
66948: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
66949: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66950: AND xet.event_class_code = C_EVENT_CLASS_CODE
66951: AND l4.event_id = xet.event_id
66952: AND l5.event_id = l4.event_id

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

68245: FROM xla_events_gt xet
68246: , AR_BILL_TO_CUSTOMERS_S_V h1
68247: , AR_BILL_TO_SITE_USES_S_V h2
68248: , AR_TRANSACTIONS_S_V h5
68249: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
68250: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68251: AND xet.event_class_code = C_EVENT_CLASS_CODE
68252: AND h1.event_id = xet.event_id
68253: AND h2.event_id = h1.event_id

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

68386: , null source_meaning
68387: FROM xla_events_gt xet
68388: , AR_CUST_TRX_LINES_BASE_V l3
68389: , AR_CUST_TRX_LINES_L_V l4
68390: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
68391: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68392: AND xet.event_class_code = C_EVENT_CLASS_CODE
68393: AND l3.event_id = xet.event_id
68394: AND l4.event_id = l3.event_id

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

69487: , AR_CM_BILL_SITE_USES_H_V h1
69488: , AR_CM_BILL_TO_CUST_H_V h2
69489: , AR_CREDIT_MEMO_H_V h5
69490: , AR_SYSTEM_PARAM_H_V h8
69491: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
69492: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69493: AND xet.event_class_code = C_EVENT_CLASS_CODE
69494: AND h1.event_id = xet.event_id
69495: AND h2.event_id = h1.event_id

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

69677: , AR_CM_LINES_L_V l4
69678: , AR_DISTRIBUTIONS_L_V l6
69679: , AR_RECEIVABLES_TRX_ACT_S_V l7
69680: , AR_TRANSACTIONS_S_V l9
69681: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
69682: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69683: AND xet.event_class_code = C_EVENT_CLASS_CODE
69684: AND l3.event_id = xet.event_id
69685: AND l4.event_id (+) = l3.event_id

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

71223: FROM xla_events_gt xet
71224: , AR_BILL_TO_CUSTOMERS_S_V h1
71225: , AR_BILL_TO_SITE_USES_S_V h2
71226: , AR_TRANSACTIONS_S_V h5
71227: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
71228: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71229: AND xet.event_class_code = C_EVENT_CLASS_CODE
71230: AND h1.event_id = xet.event_id
71231: AND h2.event_id = h1.event_id

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

71369: , null source_meaning
71370: FROM xla_events_gt xet
71371: , AR_CUST_TRX_LINES_BASE_V l3
71372: , AR_CUST_TRX_LINES_L_V l4
71373: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
71374: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71375: AND xet.event_class_code = C_EVENT_CLASS_CODE
71376: AND l3.event_id = xet.event_id
71377: AND l4.event_id = l3.event_id

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

72704: FROM xla_events_gt xet
72705: , AR_BILL_TO_CUSTOMERS_S_V h1
72706: , AR_BILL_TO_SITE_USES_S_V h2
72707: , AR_TRANSACTIONS_S_V h5
72708: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
72709: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72710: AND xet.event_class_code = C_EVENT_CLASS_CODE
72711: AND h1.event_id = xet.event_id
72712: AND h2.event_id = h1.event_id

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

72845: , null source_meaning
72846: FROM xla_events_gt xet
72847: , AR_CUST_TRX_LINES_BASE_V l3
72848: , AR_CUST_TRX_LINES_L_V l4
72849: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
72850: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72851: AND xet.event_class_code = C_EVENT_CLASS_CODE
72852: AND l3.event_id = xet.event_id
72853: AND l4.event_id = l3.event_id

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

73950: FROM xla_events_gt xet
73951: , AR_BILL_TO_CUSTOMERS_S_V h1
73952: , AR_BILL_TO_SITE_USES_S_V h2
73953: , AR_TRANSACTIONS_S_V h5
73954: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
73955: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73956: AND xet.event_class_code = C_EVENT_CLASS_CODE
73957: AND h1.event_id = xet.event_id
73958: AND h2.event_id = h1.event_id

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

74091: , null source_meaning
74092: FROM xla_events_gt xet
74093: , AR_CUST_TRX_LINES_BASE_V l3
74094: , AR_CUST_TRX_LINES_L_V l4
74095: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
74096: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74097: AND xet.event_class_code = C_EVENT_CLASS_CODE
74098: AND l3.event_id = xet.event_id
74099: AND l4.event_id = l3.event_id

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

75206: FROM xla_events_gt xet
75207: , AR_BILL_TO_CUSTOMERS_S_V h1
75208: , AR_BILL_TO_SITE_USES_S_V h2
75209: , AR_TRANSACTIONS_S_V h5
75210: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
75211: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75212: AND xet.event_class_code = C_EVENT_CLASS_CODE
75213: AND h1.event_id = xet.event_id
75214: AND h2.event_id = h1.event_id

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

75368: FROM xla_events_gt xet
75369: , AR_CUST_TRX_LINES_BASE_V l3
75370: , AR_CUST_TRX_LINES_L_V l4
75371: , FV_XLA_AR_REF_V l6
75372: , (select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
75373: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75374: AND xet.event_class_code = C_EVENT_CLASS_CODE
75375: AND l3.event_id = xet.event_id
75376: AND l4.event_id = l3.event_id

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

76881: END source_value
76882: , null source_meaning
76883: FROM xla_events_gt xet
76884: , AR_CASH_RECEIPTS_H_V h1
76885: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
76886: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76887: AND xet.event_class_code = C_EVENT_CLASS_CODE
76888:
76889: )

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

77060: FROM xla_events_gt xet
77061: , AR_DISTRIBUTIONS_BASE_V l2
77062: , AR_DISTRIBUTIONS_L_V l3
77063: , FV_XLA_AR_REF_V l4
77064: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
77065: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77066: AND xet.event_class_code = C_EVENT_CLASS_CODE
77067: AND l2.event_id = xet.event_id
77068: AND l3.event_id = l2.event_id

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

78641: , AR_CASH_RECEIPTS_H_V h2
78642: , AR_RCT_SITE_USES_H_V h6
78643: , AR_REMIT_BANK_ACCT_H_V h8
78644: , AR_SYSTEM_PARAM_H_V h9
78645: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
78646: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78647: AND xet.event_class_code = C_EVENT_CLASS_CODE
78648: AND h2.event_id = xet.event_id
78649: AND h6.event_id (+) = h2.event_id

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

78933: , AR_DISTRIBUTIONS_L_V l5
78934: , AR_RECEIVABLES_TRX_ACT_S_V l7
78935: , AR_TRANSACTIONS_S_V l10
78936: , FV_XLA_AR_REF_V l11
78937: , (select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)
78938: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78939: AND xet.event_class_code = C_EVENT_CLASS_CODE
78940: AND l4.event_id = xet.event_id
78941: AND l1.event_id (+) = l4.event_id