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

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

67762: , AR_BILL_TO_CUSTOMERS_S_V h2
67763: , AR_BILL_TO_SITE_USES_S_V h3
67764: , AR_RECEIVABLES_TRX_ACT_S_V h6
67765: , AR_TRANSACTIONS_S_V h7
67766: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
67767: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
67768: AND xet.event_class_code = C_EVENT_CLASS_CODE
67769: AND h1.event_id = xet.event_id
67770: AND h2.event_id = h1.event_id

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

67910: , null source_meaning
67911: FROM xla_events_gt xet
67912: , AR_DISTRIBUTIONS_BASE_V l4
67913: , AR_DISTRIBUTIONS_L_V l5
67914: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
67915: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
67916: AND xet.event_class_code = C_EVENT_CLASS_CODE
67917: AND l4.event_id = xet.event_id
67918: AND l5.event_id = l4.event_id

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

69125: FROM xla_events_gt xet
69126: , AR_BILL_TO_CUSTOMERS_S_V h1
69127: , AR_BILL_TO_SITE_USES_S_V h2
69128: , AR_TRANSACTIONS_S_V h5
69129: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
69130: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69131: AND xet.event_class_code = C_EVENT_CLASS_CODE
69132: AND h1.event_id = xet.event_id
69133: AND h2.event_id = h1.event_id

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

69266: , null source_meaning
69267: FROM xla_events_gt xet
69268: , AR_CUST_TRX_LINES_BASE_V l3
69269: , AR_CUST_TRX_LINES_L_V l4
69270: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
69271: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69272: AND xet.event_class_code = C_EVENT_CLASS_CODE
69273: AND l3.event_id = xet.event_id
69274: AND l4.event_id = l3.event_id

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

70377: , AR_CM_BILL_SITE_USES_H_V h1
70378: , AR_CM_BILL_TO_CUST_H_V h2
70379: , AR_CREDIT_MEMO_H_V h5
70380: , AR_SYSTEM_PARAM_H_V h8
70381: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
70382: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70383: AND xet.event_class_code = C_EVENT_CLASS_CODE
70384: AND h1.event_id = xet.event_id
70385: AND h2.event_id = h1.event_id

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

70551: , AR_CM_LINES_BASE_V l3
70552: , AR_CM_LINES_L_V l4
70553: , AR_DISTRIBUTIONS_L_V l6
70554: , AR_RECEIVABLES_TRX_ACT_S_V l7
70555: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
70556: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70557: AND xet.event_class_code = C_EVENT_CLASS_CODE
70558: AND l3.event_id = xet.event_id
70559: AND l4.event_id (+) = l3.event_id

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

72000: FROM xla_events_gt xet
72001: , AR_BILL_TO_CUSTOMERS_S_V h1
72002: , AR_BILL_TO_SITE_USES_S_V h2
72003: , AR_TRANSACTIONS_S_V h5
72004: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
72005: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72006: AND xet.event_class_code = C_EVENT_CLASS_CODE
72007: AND h1.event_id = xet.event_id
72008: AND h2.event_id = h1.event_id

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

72146: , null source_meaning
72147: FROM xla_events_gt xet
72148: , AR_CUST_TRX_LINES_BASE_V l3
72149: , AR_CUST_TRX_LINES_L_V l4
72150: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
72151: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72152: AND xet.event_class_code = C_EVENT_CLASS_CODE
72153: AND l3.event_id = xet.event_id
72154: AND l4.event_id = l3.event_id

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

73461: FROM xla_events_gt xet
73462: , AR_BILL_TO_CUSTOMERS_S_V h1
73463: , AR_BILL_TO_SITE_USES_S_V h2
73464: , AR_TRANSACTIONS_S_V h5
73465: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
73466: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73467: AND xet.event_class_code = C_EVENT_CLASS_CODE
73468: AND h1.event_id = xet.event_id
73469: AND h2.event_id = h1.event_id

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

73602: , null source_meaning
73603: FROM xla_events_gt xet
73604: , AR_CUST_TRX_LINES_BASE_V l3
73605: , AR_CUST_TRX_LINES_L_V l4
73606: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
73607: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73608: AND xet.event_class_code = C_EVENT_CLASS_CODE
73609: AND l3.event_id = xet.event_id
73610: AND l4.event_id = l3.event_id

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

74707: FROM xla_events_gt xet
74708: , AR_BILL_TO_CUSTOMERS_S_V h1
74709: , AR_BILL_TO_SITE_USES_S_V h2
74710: , AR_TRANSACTIONS_S_V h5
74711: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
74712: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74713: AND xet.event_class_code = C_EVENT_CLASS_CODE
74714: AND h1.event_id = xet.event_id
74715: AND h2.event_id = h1.event_id

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

74848: , null source_meaning
74849: FROM xla_events_gt xet
74850: , AR_CUST_TRX_LINES_BASE_V l3
74851: , AR_CUST_TRX_LINES_L_V l4
74852: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
74853: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74854: AND xet.event_class_code = C_EVENT_CLASS_CODE
74855: AND l3.event_id = xet.event_id
74856: AND l4.event_id = l3.event_id

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

75968: FROM xla_events_gt xet
75969: , AR_BILL_TO_CUSTOMERS_S_V h1
75970: , AR_BILL_TO_SITE_USES_S_V h2
75971: , AR_TRANSACTIONS_S_V h5
75972: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
75973: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75974: AND xet.event_class_code = C_EVENT_CLASS_CODE
75975: AND h1.event_id = xet.event_id
75976: AND h2.event_id = h1.event_id

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

76130: FROM xla_events_gt xet
76131: , AR_CUST_TRX_LINES_BASE_V l3
76132: , AR_CUST_TRX_LINES_L_V l4
76133: , FV_XLA_AR_REF_V l6
76134: , (select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
76135: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76136: AND xet.event_class_code = C_EVENT_CLASS_CODE
76137: AND l3.event_id = xet.event_id
76138: AND l4.event_id = l3.event_id

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

77551: FROM xla_events_gt xet
77552: , AR_CASH_RECEIPTS_H_V h1
77553: , AR_RCT_METHOD_H_V h4
77554: , AR_REMIT_BANK_ACCT_H_V h5
77555: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
77556: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77557: AND xet.event_class_code = C_EVENT_CLASS_CODE
77558:
77559: )

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

77730: FROM xla_events_gt xet
77731: , AR_DISTRIBUTIONS_BASE_V l2
77732: , AR_DISTRIBUTIONS_L_V l3
77733: , FV_XLA_AR_REF_V l6
77734: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
77735: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77736: AND xet.event_class_code = C_EVENT_CLASS_CODE
77737: AND l2.event_id = xet.event_id
77738: AND l3.event_id = l2.event_id

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

79437: , AR_RCT_METHOD_H_V h6
79438: , AR_RCT_SITE_USES_H_V h7
79439: , AR_REMIT_BANK_ACCT_H_V h9
79440: , AR_SYSTEM_PARAM_H_V h10
79441: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
79442: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79443: AND xet.event_class_code = C_EVENT_CLASS_CODE
79444: AND h2.event_id = xet.event_id
79445: AND h6.event_id (+) = h2.event_id

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

79715: , AR_DISTRIBUTIONS_L_V l5
79716: , AR_RECEIVABLES_TRX_ACT_S_V l8
79717: , AR_TRANSACTIONS_S_V l11
79718: , FV_XLA_AR_REF_V l12
79719: , (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
79720: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79721: AND xet.event_class_code = C_EVENT_CLASS_CODE
79722: AND l4.event_id = xet.event_id
79723: AND l1.event_id (+) = l4.event_id