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

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

144115: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
144116: , fnd_lookup_values fvl15
144117: , fnd_lookup_values fvl47
144118: , fnd_lookup_values fvl165
144119: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
144120: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
144121: AND xet.event_class_code = C_EVENT_CLASS_CODE
144122: AND h2.event_id = xet.event_id
144123: AND h4.asp_org_id = h2.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

144471: , fnd_lookup_values fvl33
144472: , fnd_lookup_values fvl80
144473: , fnd_lookup_values fvl96
144474: , fnd_lookup_values fvl142
144475: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
144476: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
144477: AND xet.event_class_code = C_EVENT_CLASS_CODE
144478: AND l1.event_id = xet.event_id
144479: AND l1.pod_po_header_id = l3.po_header_id (+) AND l1.zrnd_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND l1.zrnd_tax_dist_id = l6.rec_nrec_tax_dist_id (+) AND fvl22.lookup_type(+) = 'DESTINATION TYPE'

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

147408: , AP_INVOICE_EXTRACT_HEADER_V h2
147409: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
147410: , fnd_lookup_values fvl15
147411: , fnd_lookup_values fvl47
147412: ,(select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)
147413: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147414: AND xet.event_class_code = C_EVENT_CLASS_CODE
147415: AND h2.event_id = xet.event_id
147416: AND h4.asp_org_id= h2.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

147755: , fnd_lookup_values fvl33
147756: , fnd_lookup_values fvl80
147757: , fnd_lookup_values fvl96
147758: , fnd_lookup_values fvl142
147759: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
147760: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147761: AND xet.event_class_code = C_EVENT_CLASS_CODE
147762: AND l1.event_id = xet.event_id
147763: AND l1.pod_po_header_id = l3.po_header_id (+) AND l1.zrnd_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND l1.zrnd_tax_dist_id = l6.rec_nrec_tax_dist_id (+) AND fvl22.lookup_type(+) = 'DESTINATION TYPE'

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

150676: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
150677: , fnd_lookup_values fvl15
150678: , fnd_lookup_values fvl47
150679: , fnd_lookup_values fvl113
150680: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
150681: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150682: AND xet.event_class_code = C_EVENT_CLASS_CODE
150683: AND h2.event_id = xet.event_id
150684: AND h3.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

150918: , fnd_lookup_values fvl33
150919: , fnd_lookup_values fvl80
150920: , fnd_lookup_values fvl98
150921: , fnd_lookup_values fvl137
150922: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
150923: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150924: AND xet.event_class_code = C_EVENT_CLASS_CODE
150925: AND l1.event_id = xet.event_id
150926: AND l1.aid_detail_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND fvl33.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'

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

153030: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153031: , fnd_lookup_values fvl15
153032: , fnd_lookup_values fvl47
153033: , fnd_lookup_values fvl165
153034: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
153035: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153036: AND xet.event_class_code = C_EVENT_CLASS_CODE
153037: AND h2.event_id = xet.event_id
153038: AND h4.asp_org_id = h2.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

153396: , fnd_lookup_values fvl33
153397: , fnd_lookup_values fvl80
153398: , fnd_lookup_values fvl96
153399: , fnd_lookup_values fvl142
153400: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
153401: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153402: AND xet.event_class_code = C_EVENT_CLASS_CODE
153403: AND l1.event_id = xet.event_id
153404: AND l1.pod_po_header_id = l3.po_header_id (+) AND l1.zrnd_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND l1.zrnd_tax_dist_id = l6.rec_nrec_tax_dist_id (+) AND fvl22.lookup_type(+) = 'DESTINATION TYPE'

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

156505: , fnd_lookup_values fvl47
156506: , fnd_lookup_values fvl113
156507: , fnd_lookup_values fvl122
156508: , fnd_lookup_values fvl172
156509: ,(select rownum r from all_objects where rownum <= 39 and owner = p_apps_owner)
156510: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156511: AND xet.event_class_code = C_EVENT_CLASS_CODE
156512: AND h2.event_id = xet.event_id
156513: AND h3.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

156813: , fnd_lookup_values fvl98
156814: , fnd_lookup_values fvl137
156815: , fnd_lookup_values fvl163
156816: , fnd_lookup_values fvl164
156817: , (select rownum r from all_objects where rownum <= 34 and owner = p_apps_owner)
156818: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156819: AND xet.event_class_code = C_EVENT_CLASS_CODE
156820: AND l1.event_id = xet.event_id
156821: AND l1.aid_detail_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND l1.aid_detail_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND fvl33.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'

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

159556: FROM xla_events_gt xet
159557: , AP_INVOICE_EXTRACT_HEADER_V h1
159558: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
159559: , fnd_lookup_values fvl15
159560: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
159561: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159562: AND xet.event_class_code = C_EVENT_CLASS_CODE
159563: AND h1.event_id = xet.event_id
159564: AND h4.asp_org_id = h1.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

159905: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
159906: , fnd_lookup_values fvl80
159907: , fnd_lookup_values fvl126
159908: , fnd_lookup_values fvl137
159909: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
159910: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159911: AND xet.event_class_code = C_EVENT_CLASS_CODE
159912: AND l2.event_id = xet.event_id
159913: AND l2.pp_detail_tax_dist_id = l3.rec_nrec_pp_tax_dist_id (+) AND l2.recp_detail_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND l2.recp_detail_tax_dist_id = l6.rec_nrec_tax_dist_id (+) AND fvl80.lookup_type(+) = 'YES_NO'

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

161986: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161987: , fnd_lookup_values fvl15
161988: , fnd_lookup_values fvl31
161989: , fnd_lookup_values fvl47
161990: ,(select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)
161991: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161992: AND xet.event_class_code = C_EVENT_CLASS_CODE
161993: AND h2.event_id = xet.event_id
161994: AND h4.asp_org_id = h2.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

162329: , fnd_lookup_values fvl80
162330: , fnd_lookup_values fvl96
162331: , fnd_lookup_values fvl137
162332: , fnd_lookup_values fvl142
162333: , (select rownum r from all_objects where rownum <= 44 and owner = p_apps_owner)
162334: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162335: AND xet.event_class_code = C_EVENT_CLASS_CODE
162336: AND l1.event_id = xet.event_id
162337: AND l1.pod_po_header_id = l3.po_header_id (+) AND l1.zrnd_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND l1.zrnd_tax_dist_id = l6.rec_nrec_tax_dist_id (+) AND fvl22.lookup_type(+) = 'DESTINATION TYPE'

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

165351: , fnd_lookup_values fvl19
165352: , fnd_lookup_values fvl47
165353: , fnd_lookup_values fvl113
165354: , fnd_lookup_values fvl122
165355: ,(select rownum r from all_objects where rownum <= 37 and owner = p_apps_owner)
165356: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165357: AND xet.event_class_code = C_EVENT_CLASS_CODE
165358: AND h2.event_id = xet.event_id
165359: AND h3.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

165690: , fnd_lookup_values fvl98
165691: , fnd_lookup_values fvl137
165692: , fnd_lookup_values fvl163
165693: , fnd_lookup_values fvl164
165694: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
165695: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165696: AND xet.event_class_code = C_EVENT_CLASS_CODE
165697: AND l1.event_id = xet.event_id
165698: AND l1.aid_detail_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND fvl33.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'

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

168467: , fnd_lookup_values fvl47
168468: , fnd_lookup_values fvl113
168469: , fnd_lookup_values fvl122
168470: , fnd_lookup_values fvl172
168471: ,(select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
168472: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168473: AND xet.event_class_code = C_EVENT_CLASS_CODE
168474: AND h2.event_id = xet.event_id
168475: AND h3.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

168730: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
168731: , fnd_lookup_values fvl33
168732: , fnd_lookup_values fvl80
168733: , fnd_lookup_values fvl98
168734: , (select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
168735: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168736: AND xet.event_class_code = C_EVENT_CLASS_CODE
168737: AND l1.event_id = xet.event_id
168738: AND l1.aid_detail_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND l1.aid_detail_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND fvl33.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'