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

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

68972: , AR_BILL_TO_CUSTOMERS_S_V h2
68973: , AR_BILL_TO_SITE_USES_S_V h3
68974: , AR_RECEIVABLES_TRX_ACT_S_V h6
68975: , AR_TRANSACTIONS_S_V h7
68976: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
68977: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68978: AND xet.event_class_code = C_EVENT_CLASS_CODE
68979: AND h1.event_id = xet.event_id
68980: AND h2.event_id = h1.event_id

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

69120: , null source_meaning
69121: FROM xla_events_gt xet
69122: , AR_DISTRIBUTIONS_BASE_V l4
69123: , AR_DISTRIBUTIONS_L_V l5
69124: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
69125: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69126: AND xet.event_class_code = C_EVENT_CLASS_CODE
69127: AND l4.event_id = xet.event_id
69128: AND l5.event_id = l4.event_id

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

70366: FROM xla_events_gt xet
70367: , AR_BILL_TO_CUSTOMERS_S_V h1
70368: , AR_BILL_TO_SITE_USES_S_V h2
70369: , AR_TRANSACTIONS_S_V h5
70370: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
70371: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70372: AND xet.event_class_code = C_EVENT_CLASS_CODE
70373: AND h1.event_id = xet.event_id
70374: AND h2.event_id = h1.event_id

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

70507: , null source_meaning
70508: FROM xla_events_gt xet
70509: , AR_CUST_TRX_LINES_BASE_V l3
70510: , AR_CUST_TRX_LINES_L_V l4
70511: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
70512: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70513: AND xet.event_class_code = C_EVENT_CLASS_CODE
70514: AND l3.event_id = xet.event_id
70515: AND l4.event_id = l3.event_id

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

71618: , AR_CM_BILL_SITE_USES_H_V h1
71619: , AR_CM_BILL_TO_CUST_H_V h2
71620: , AR_CREDIT_MEMO_H_V h5
71621: , AR_SYSTEM_PARAM_H_V h8
71622: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
71623: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71624: AND xet.event_class_code = C_EVENT_CLASS_CODE
71625: AND h1.event_id = xet.event_id
71626: AND h2.event_id = h1.event_id

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

71792: , AR_CM_LINES_BASE_V l3
71793: , AR_CM_LINES_L_V l4
71794: , AR_DISTRIBUTIONS_L_V l6
71795: , AR_RECEIVABLES_TRX_ACT_S_V l7
71796: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
71797: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71798: AND xet.event_class_code = C_EVENT_CLASS_CODE
71799: AND l3.event_id = xet.event_id
71800: AND l4.event_id (+) = l3.event_id

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

73241: FROM xla_events_gt xet
73242: , AR_BILL_TO_CUSTOMERS_S_V h1
73243: , AR_BILL_TO_SITE_USES_S_V h2
73244: , AR_TRANSACTIONS_S_V h5
73245: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
73246: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73247: AND xet.event_class_code = C_EVENT_CLASS_CODE
73248: AND h1.event_id = xet.event_id
73249: AND h2.event_id = h1.event_id

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

73387: , null source_meaning
73388: FROM xla_events_gt xet
73389: , AR_CUST_TRX_LINES_BASE_V l3
73390: , AR_CUST_TRX_LINES_L_V l4
73391: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
73392: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73393: AND xet.event_class_code = C_EVENT_CLASS_CODE
73394: AND l3.event_id = xet.event_id
73395: AND l4.event_id = l3.event_id

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

74702: FROM xla_events_gt xet
74703: , AR_BILL_TO_CUSTOMERS_S_V h1
74704: , AR_BILL_TO_SITE_USES_S_V h2
74705: , AR_TRANSACTIONS_S_V h5
74706: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
74707: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74708: AND xet.event_class_code = C_EVENT_CLASS_CODE
74709: AND h1.event_id = xet.event_id
74710: AND h2.event_id = h1.event_id

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

74843: , null source_meaning
74844: FROM xla_events_gt xet
74845: , AR_CUST_TRX_LINES_BASE_V l3
74846: , AR_CUST_TRX_LINES_L_V l4
74847: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
74848: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74849: AND xet.event_class_code = C_EVENT_CLASS_CODE
74850: AND l3.event_id = xet.event_id
74851: AND l4.event_id = l3.event_id

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

75948: FROM xla_events_gt xet
75949: , AR_BILL_TO_CUSTOMERS_S_V h1
75950: , AR_BILL_TO_SITE_USES_S_V h2
75951: , AR_TRANSACTIONS_S_V h5
75952: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
75953: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75954: AND xet.event_class_code = C_EVENT_CLASS_CODE
75955: AND h1.event_id = xet.event_id
75956: AND h2.event_id = h1.event_id

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

76089: , null source_meaning
76090: FROM xla_events_gt xet
76091: , AR_CUST_TRX_LINES_BASE_V l3
76092: , AR_CUST_TRX_LINES_L_V l4
76093: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
76094: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76095: AND xet.event_class_code = C_EVENT_CLASS_CODE
76096: AND l3.event_id = xet.event_id
76097: AND l4.event_id = l3.event_id

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

77209: FROM xla_events_gt xet
77210: , AR_BILL_TO_CUSTOMERS_S_V h1
77211: , AR_BILL_TO_SITE_USES_S_V h2
77212: , AR_TRANSACTIONS_S_V h5
77213: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
77214: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77215: AND xet.event_class_code = C_EVENT_CLASS_CODE
77216: AND h1.event_id = xet.event_id
77217: AND h2.event_id = h1.event_id

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

77371: FROM xla_events_gt xet
77372: , AR_CUST_TRX_LINES_BASE_V l3
77373: , AR_CUST_TRX_LINES_L_V l4
77374: , FV_XLA_AR_REF_V l6
77375: , (select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
77376: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77377: AND xet.event_class_code = C_EVENT_CLASS_CODE
77378: AND l3.event_id = xet.event_id
77379: AND l4.event_id = l3.event_id

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

78794: FROM xla_events_gt xet
78795: , AR_CASH_RECEIPTS_H_V h1
78796: , AR_RCT_METHOD_H_V h4
78797: , AR_REMIT_BANK_ACCT_H_V h5
78798: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
78799: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78800: AND xet.event_class_code = C_EVENT_CLASS_CODE
78801:
78802: )

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

78973: FROM xla_events_gt xet
78974: , AR_DISTRIBUTIONS_BASE_V l2
78975: , AR_DISTRIBUTIONS_L_V l3
78976: , FV_XLA_AR_REF_V l6
78977: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
78978: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78979: AND xet.event_class_code = C_EVENT_CLASS_CODE
78980: AND l2.event_id = xet.event_id
78981: AND l3.event_id = l2.event_id

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

80678: , AR_RCT_METHOD_H_V h6
80679: , AR_RCT_SITE_USES_H_V h7
80680: , AR_REMIT_BANK_ACCT_H_V h9
80681: , AR_SYSTEM_PARAM_H_V h10
80682: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
80683: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
80684: AND xet.event_class_code = C_EVENT_CLASS_CODE
80685: AND h2.event_id = xet.event_id
80686: AND h6.event_id (+) = h2.event_id

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

80956: , AR_DISTRIBUTIONS_L_V l5
80957: , AR_RECEIVABLES_TRX_ACT_S_V l8
80958: , AR_TRANSACTIONS_S_V l11
80959: , FV_XLA_AR_REF_V l12
80960: , (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
80961: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
80962: AND xet.event_class_code = C_EVENT_CLASS_CODE
80963: AND l4.event_id = xet.event_id
80964: AND l1.event_id (+) = l4.event_id