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

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

53146: , AR_BILL_TO_CUSTOMERS_S_V h2
53147: , AR_BILL_TO_SITE_USES_S_V h3
53148: , AR_RECEIVABLES_TRX_ACT_S_V h6
53149: , AR_TRANSACTIONS_S_V h7
53150: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
53151: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
53152: AND xet.event_class_code = C_EVENT_CLASS_CODE
53153: AND h1.event_id = xet.event_id
53154: AND h2.event_id = h1.event_id

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

53294: , null source_meaning
53295: FROM xla_events_gt xet
53296: , AR_DISTRIBUTIONS_BASE_V l4
53297: , AR_DISTRIBUTIONS_L_V l5
53298: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
53299: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
53300: AND xet.event_class_code = C_EVENT_CLASS_CODE
53301: AND l4.event_id = xet.event_id
53302: AND l5.event_id = l4.event_id

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

54509: FROM xla_events_gt xet
54510: , AR_BILL_TO_CUSTOMERS_S_V h1
54511: , AR_BILL_TO_SITE_USES_S_V h2
54512: , AR_TRANSACTIONS_S_V h5
54513: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
54514: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
54515: AND xet.event_class_code = C_EVENT_CLASS_CODE
54516: AND h1.event_id = xet.event_id
54517: AND h2.event_id = h1.event_id

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

54650: , null source_meaning
54651: FROM xla_events_gt xet
54652: , AR_CUST_TRX_LINES_BASE_V l3
54653: , AR_CUST_TRX_LINES_L_V l4
54654: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
54655: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
54656: AND xet.event_class_code = C_EVENT_CLASS_CODE
54657: AND l3.event_id = xet.event_id
54658: AND l4.event_id = l3.event_id

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

55761: , AR_CM_BILL_SITE_USES_H_V h1
55762: , AR_CM_BILL_TO_CUST_H_V h2
55763: , AR_CREDIT_MEMO_H_V h5
55764: , AR_SYSTEM_PARAM_H_V h8
55765: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
55766: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55767: AND xet.event_class_code = C_EVENT_CLASS_CODE
55768: AND h1.event_id = xet.event_id
55769: AND h2.event_id = h1.event_id

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

55935: , AR_CM_LINES_BASE_V l3
55936: , AR_CM_LINES_L_V l4
55937: , AR_DISTRIBUTIONS_L_V l6
55938: , AR_RECEIVABLES_TRX_ACT_S_V l7
55939: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
55940: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55941: AND xet.event_class_code = C_EVENT_CLASS_CODE
55942: AND l3.event_id = xet.event_id
55943: AND l4.event_id (+) = l3.event_id

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

57384: FROM xla_events_gt xet
57385: , AR_BILL_TO_CUSTOMERS_S_V h1
57386: , AR_BILL_TO_SITE_USES_S_V h2
57387: , AR_TRANSACTIONS_S_V h5
57388: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
57389: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57390: AND xet.event_class_code = C_EVENT_CLASS_CODE
57391: AND h1.event_id = xet.event_id
57392: AND h2.event_id = h1.event_id

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

57530: , null source_meaning
57531: FROM xla_events_gt xet
57532: , AR_CUST_TRX_LINES_BASE_V l3
57533: , AR_CUST_TRX_LINES_L_V l4
57534: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
57535: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57536: AND xet.event_class_code = C_EVENT_CLASS_CODE
57537: AND l3.event_id = xet.event_id
57538: AND l4.event_id = l3.event_id

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

58845: FROM xla_events_gt xet
58846: , AR_BILL_TO_CUSTOMERS_S_V h1
58847: , AR_BILL_TO_SITE_USES_S_V h2
58848: , AR_TRANSACTIONS_S_V h5
58849: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
58850: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58851: AND xet.event_class_code = C_EVENT_CLASS_CODE
58852: AND h1.event_id = xet.event_id
58853: AND h2.event_id = h1.event_id

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

58986: , null source_meaning
58987: FROM xla_events_gt xet
58988: , AR_CUST_TRX_LINES_BASE_V l3
58989: , AR_CUST_TRX_LINES_L_V l4
58990: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
58991: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58992: AND xet.event_class_code = C_EVENT_CLASS_CODE
58993: AND l3.event_id = xet.event_id
58994: AND l4.event_id = l3.event_id

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

60091: FROM xla_events_gt xet
60092: , AR_BILL_TO_CUSTOMERS_S_V h1
60093: , AR_BILL_TO_SITE_USES_S_V h2
60094: , AR_TRANSACTIONS_S_V h5
60095: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
60096: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
60097: AND xet.event_class_code = C_EVENT_CLASS_CODE
60098: AND h1.event_id = xet.event_id
60099: AND h2.event_id = h1.event_id

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

60232: , null source_meaning
60233: FROM xla_events_gt xet
60234: , AR_CUST_TRX_LINES_BASE_V l3
60235: , AR_CUST_TRX_LINES_L_V l4
60236: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
60237: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
60238: AND xet.event_class_code = C_EVENT_CLASS_CODE
60239: AND l3.event_id = xet.event_id
60240: AND l4.event_id = l3.event_id

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

61347: FROM xla_events_gt xet
61348: , AR_BILL_TO_CUSTOMERS_S_V h1
61349: , AR_BILL_TO_SITE_USES_S_V h2
61350: , AR_TRANSACTIONS_S_V h5
61351: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
61352: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
61353: AND xet.event_class_code = C_EVENT_CLASS_CODE
61354: AND h1.event_id = xet.event_id
61355: AND h2.event_id = h1.event_id

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

61498: , null source_meaning
61499: FROM xla_events_gt xet
61500: , AR_CUST_TRX_LINES_BASE_V l3
61501: , AR_CUST_TRX_LINES_L_V l4
61502: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
61503: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
61504: AND xet.event_class_code = C_EVENT_CLASS_CODE
61505: AND l3.event_id = xet.event_id
61506: AND l4.event_id = l3.event_id

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

62835: FROM xla_events_gt xet
62836: , AR_CASH_RECEIPTS_H_V h1
62837: , AR_RCT_METHOD_H_V h4
62838: , AR_REMIT_BANK_ACCT_H_V h5
62839: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
62840: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62841: AND xet.event_class_code = C_EVENT_CLASS_CODE
62842:
62843: )

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

62983: , null source_meaning
62984: FROM xla_events_gt xet
62985: , AR_DISTRIBUTIONS_BASE_V l2
62986: , AR_DISTRIBUTIONS_L_V l3
62987: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
62988: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62989: AND xet.event_class_code = C_EVENT_CLASS_CODE
62990: AND l2.event_id = xet.event_id
62991: AND l3.event_id = l2.event_id

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

64411: , AR_RCT_METHOD_H_V h5
64412: , AR_RCT_SITE_USES_H_V h6
64413: , AR_REMIT_BANK_ACCT_H_V h8
64414: , AR_SYSTEM_PARAM_H_V h9
64415: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
64416: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64417: AND xet.event_class_code = C_EVENT_CLASS_CODE
64418: AND h1.event_id = xet.event_id
64419: AND h5.event_id (+) = h1.event_id

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

64652: , AR_DISTRIBUTIONS_BASE_V l3
64653: , AR_DISTRIBUTIONS_L_V l4
64654: , AR_RECEIVABLES_TRX_ACT_S_V l7
64655: , AR_TRANSACTIONS_S_V l10
64656: , (select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)
64657: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64658: AND xet.event_class_code = C_EVENT_CLASS_CODE
64659: AND l3.event_id = xet.event_id
64660: AND l2.event_id (+) = l3.event_id