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

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

96794: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
96795: , fnd_lookup_values fvl16
96796: , fnd_lookup_values fvl42
96797: , fnd_lookup_values fvl117
96798: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
96799: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
96800: AND xet.event_class_code = C_EVENT_CLASS_CODE
96801: AND h2.event_id = xet.event_id
96802: AND h3.asp_org_id = h2.ac_org_id AND fvl16.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

96991: FROM xla_events_gt xet
96992: , AP_PAYMENT_EXTRACT_DETAILS_V l1
96993: , fnd_lookup_values fvl51
96994: , fnd_lookup_values fvl64
96995: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
96996: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
96997: AND xet.event_class_code = C_EVENT_CLASS_CODE
96998: AND l1.event_id = xet.event_id
96999: AND fvl51.lookup_type(+) = 'PAY_DIST_TYPES'

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

98907: , fnd_lookup_values fvl42
98908: , fnd_lookup_values fvl71
98909: , fnd_lookup_values fvl117
98910: , fnd_lookup_values fvl159
98911: ,(select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)
98912: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
98913: AND xet.event_class_code = C_EVENT_CLASS_CODE
98914: AND h2.event_id = xet.event_id
98915: AND h4.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'DISCOUNT_DIST_OPTIONS'

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

99215: , fnd_lookup_values fvl51
99216: , fnd_lookup_values fvl64
99217: , fnd_lookup_values fvl111
99218: , fnd_lookup_values fvl112
99219: , (select rownum r from all_objects where rownum <= 33 and owner = p_apps_owner)
99220: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
99221: AND xet.event_class_code = C_EVENT_CLASS_CODE
99222: AND l1.event_id = xet.event_id
99223: AND l1.pod_po_header_id = l3.po_header_id (+) AND l1.aid_detail_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND l1.aid_detail_tax_dist_id = l6.rec_nrec_tax_dist_id (+) AND fvl19.lookup_type(+) = 'DESTINATION TYPE'

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

102250: , AP_INVOICE_EXTRACT_HEADER_V h1
102251: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
102252: , fnd_lookup_values fvl16
102253: , fnd_lookup_values fvl42
102254: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
102255: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
102256: AND xet.event_class_code = C_EVENT_CLASS_CODE
102257: AND h1.event_id = xet.event_id
102258: AND h4.asp_org_id = h1.ai_org_id AND fvl16.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

102672: , fnd_lookup_values fvl64
102673: , fnd_lookup_values fvl79
102674: , fnd_lookup_values fvl111
102675: , fnd_lookup_values fvl148
102676: , (select rownum r from all_objects where rownum <= 61 and owner = p_apps_owner)
102677: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
102678: AND xet.event_class_code = C_EVENT_CLASS_CODE
102679: AND l3.event_id = xet.event_id
102680: AND l3.pod_po_header_id = l2.po_header_id (+) AND l3.recp_detail_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND l3.recp_detail_tax_dist_id = l6.rec_nrec_tax_dist_id (+) AND fvl19.lookup_type(+) = 'DESTINATION TYPE'

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

106472: , fnd_lookup_values fvl16
106473: , fnd_lookup_values fvl42
106474: , fnd_lookup_values fvl71
106475: , fnd_lookup_values fvl117
106476: ,(select rownum r from all_objects where rownum <= 40 and owner = p_apps_owner)
106477: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
106478: AND xet.event_class_code = C_EVENT_CLASS_CODE
106479: AND h2.event_id = xet.event_id
106480: AND h4.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'DISCOUNT_DIST_OPTIONS'

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

106789: , fnd_lookup_values fvl64
106790: , fnd_lookup_values fvl111
106791: , fnd_lookup_values fvl112
106792: , fnd_lookup_values fvl155
106793: , (select rownum r from all_objects where rownum <= 37 and owner = p_apps_owner)
106794: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
106795: AND xet.event_class_code = C_EVENT_CLASS_CODE
106796: AND l1.event_id = xet.event_id
106797: AND l1.pod_po_header_id = l3.po_header_id (+) AND l1.aid_detail_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND fvl19.lookup_type(+) = 'DESTINATION TYPE'

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

109977: , fnd_lookup_values fvl42
109978: , fnd_lookup_values fvl71
109979: , fnd_lookup_values fvl117
109980: , fnd_lookup_values fvl159
109981: ,(select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)
109982: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
109983: AND xet.event_class_code = C_EVENT_CLASS_CODE
109984: AND h2.event_id = xet.event_id
109985: AND h4.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'DISCOUNT_DIST_OPTIONS'

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

110240: , fnd_lookup_values fvl32
110241: , fnd_lookup_values fvl51
110242: , fnd_lookup_values fvl64
110243: , fnd_lookup_values fvl111
110244: , (select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
110245: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
110246: AND xet.event_class_code = C_EVENT_CLASS_CODE
110247: AND l1.event_id = xet.event_id
110248: AND l1.pod_po_header_id = l3.po_header_id (+) AND l1.aid_detail_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND l1.aid_detail_tax_dist_id = l6.rec_nrec_tax_dist_id (+) AND fvl19.lookup_type(+) = 'DESTINATION TYPE'