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

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

143985: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
143986: , fnd_lookup_values fvl15
143987: , fnd_lookup_values fvl47
143988: , fnd_lookup_values fvl164
143989: ,(select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
143990: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
143991: AND xet.event_class_code = C_EVENT_CLASS_CODE
143992: AND h2.event_id = xet.event_id
143993: AND h4.asp_org_id = h2.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

144346: , fnd_lookup_values fvl33
144347: , fnd_lookup_values fvl79
144348: , fnd_lookup_values fvl95
144349: , fnd_lookup_values fvl135
144350: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
144351: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
144352: AND xet.event_class_code = C_EVENT_CLASS_CODE
144353: AND l1.event_id = xet.event_id
144354: 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 147307: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)

147303: , AP_INVOICE_EXTRACT_HEADER_V h2
147304: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
147305: , fnd_lookup_values fvl15
147306: , fnd_lookup_values fvl47
147307: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
147308: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147309: AND xet.event_class_code = C_EVENT_CLASS_CODE
147310: AND h2.event_id = xet.event_id
147311: AND h4.asp_org_id= h2.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

147655: , fnd_lookup_values fvl33
147656: , fnd_lookup_values fvl79
147657: , fnd_lookup_values fvl95
147658: , fnd_lookup_values fvl135
147659: , (select rownum r from all_objects where rownum <= 47 and owner = p_apps_owner)
147660: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147661: AND xet.event_class_code = C_EVENT_CLASS_CODE
147662: AND l1.event_id = xet.event_id
147663: 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 150600: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)

150596: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
150597: , fnd_lookup_values fvl15
150598: , fnd_lookup_values fvl47
150599: , fnd_lookup_values fvl113
150600: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
150601: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150602: AND xet.event_class_code = C_EVENT_CLASS_CODE
150603: AND h2.event_id = xet.event_id
150604: AND h3.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

150838: , fnd_lookup_values fvl33
150839: , fnd_lookup_values fvl79
150840: , fnd_lookup_values fvl97
150841: , fnd_lookup_values fvl125
150842: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
150843: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150844: AND xet.event_class_code = C_EVENT_CLASS_CODE
150845: AND l1.event_id = xet.event_id
150846: AND l1.aid_detail_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND fvl33.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'

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

152974: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
152975: , fnd_lookup_values fvl15
152976: , fnd_lookup_values fvl47
152977: , fnd_lookup_values fvl164
152978: ,(select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
152979: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
152980: AND xet.event_class_code = C_EVENT_CLASS_CODE
152981: AND h2.event_id = xet.event_id
152982: AND h4.asp_org_id = h2.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

153345: , fnd_lookup_values fvl33
153346: , fnd_lookup_values fvl79
153347: , fnd_lookup_values fvl95
153348: , fnd_lookup_values fvl135
153349: , (select rownum r from all_objects where rownum <= 50 and owner = p_apps_owner)
153350: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153351: AND xet.event_class_code = C_EVENT_CLASS_CODE
153352: AND l1.event_id = xet.event_id
153353: 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 156473: ,(select rownum r from all_objects where rownum <= 39 and owner = p_apps_owner)

156469: , fnd_lookup_values fvl47
156470: , fnd_lookup_values fvl113
156471: , fnd_lookup_values fvl122
156472: , fnd_lookup_values fvl172
156473: ,(select rownum r from all_objects where rownum <= 39 and owner = p_apps_owner)
156474: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156475: AND xet.event_class_code = C_EVENT_CLASS_CODE
156476: AND h2.event_id = xet.event_id
156477: AND h3.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

156777: , fnd_lookup_values fvl97
156778: , fnd_lookup_values fvl125
156779: , fnd_lookup_values fvl160
156780: , fnd_lookup_values fvl161
156781: , (select rownum r from all_objects where rownum <= 34 and owner = p_apps_owner)
156782: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156783: AND xet.event_class_code = C_EVENT_CLASS_CODE
156784: AND l1.event_id = xet.event_id
156785: 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 159479: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)

159475: FROM xla_events_gt xet
159476: , AP_INVOICE_EXTRACT_HEADER_V h1
159477: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
159478: , fnd_lookup_values fvl15
159479: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
159480: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159481: AND xet.event_class_code = C_EVENT_CLASS_CODE
159482: AND h1.event_id = xet.event_id
159483: AND h4.asp_org_id = h1.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

159809: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
159810: , fnd_lookup_values fvl79
159811: , fnd_lookup_values fvl125
159812: , fnd_lookup_values fvl165
159813: , (select rownum r from all_objects where rownum <= 45 and owner = p_apps_owner)
159814: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159815: AND xet.event_class_code = C_EVENT_CLASS_CODE
159816: AND l2.event_id = xet.event_id
159817: 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 fvl79.lookup_type(+) = 'YES_NO'

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

161796: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161797: , fnd_lookup_values fvl15
161798: , fnd_lookup_values fvl31
161799: , fnd_lookup_values fvl47
161800: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
161801: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161802: AND xet.event_class_code = C_EVENT_CLASS_CODE
161803: AND h2.event_id = xet.event_id
161804: AND h4.asp_org_id = h2.ai_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

162144: , fnd_lookup_values fvl79
162145: , fnd_lookup_values fvl95
162146: , fnd_lookup_values fvl125
162147: , fnd_lookup_values fvl135
162148: , (select rownum r from all_objects where rownum <= 45 and owner = p_apps_owner)
162149: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162150: AND xet.event_class_code = C_EVENT_CLASS_CODE
162151: AND l1.event_id = xet.event_id
162152: 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 165190: ,(select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)

165186: , fnd_lookup_values fvl19
165187: , fnd_lookup_values fvl47
165188: , fnd_lookup_values fvl113
165189: , fnd_lookup_values fvl122
165190: ,(select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)
165191: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165192: AND xet.event_class_code = C_EVENT_CLASS_CODE
165193: AND h2.event_id = xet.event_id
165194: AND h3.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

165525: , fnd_lookup_values fvl97
165526: , fnd_lookup_values fvl125
165527: , fnd_lookup_values fvl160
165528: , fnd_lookup_values fvl161
165529: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
165530: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165531: AND xet.event_class_code = C_EVENT_CLASS_CODE
165532: AND l1.event_id = xet.event_id
165533: AND l1.aid_detail_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND fvl33.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'

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

168282: , fnd_lookup_values fvl47
168283: , fnd_lookup_values fvl113
168284: , fnd_lookup_values fvl122
168285: , fnd_lookup_values fvl172
168286: ,(select rownum r from all_objects where rownum <= 32 and owner = p_apps_owner)
168287: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168288: AND xet.event_class_code = C_EVENT_CLASS_CODE
168289: AND h2.event_id = xet.event_id
168290: AND h3.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

168545: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
168546: , fnd_lookup_values fvl33
168547: , fnd_lookup_values fvl79
168548: , fnd_lookup_values fvl97
168549: , (select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
168550: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168551: AND xet.event_class_code = C_EVENT_CLASS_CODE
168552: AND l1.event_id = xet.event_id
168553: 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'