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

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

118610: END source_value
118611: , null source_meaning
118612: FROM xla_events_gt xet
118613: , AP_INVOICE_EXTRACT_HEADER_V h2
118614: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
118615: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
118616: AND xet.event_class_code = C_EVENT_CLASS_CODE
118617: AND h2.event_id = xet.event_id
118618:

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

118785: FROM xla_events_gt xet
118786: , AP_INVOICE_EXTRACT_DETAILS_V l1
118787: , ZX_AP_DEF_TAX_EXTRACT_V l3
118788: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
118789: , (select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
118790: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
118791: AND xet.event_class_code = C_EVENT_CLASS_CODE
118792: AND l1.event_id = xet.event_id
118793: AND l1.zrnd_tax_dist_id = l3.rec_nrec_tax_dist_id (+) AND l1.zrnd_tax_dist_id = l4.rec_nrec_tax_dist_id (+)

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

119867: END source_value
119868: , null source_meaning
119869: FROM xla_events_gt xet
119870: , AP_INVOICE_EXTRACT_HEADER_V h2
119871: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
119872: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
119873: AND xet.event_class_code = C_EVENT_CLASS_CODE
119874: AND h2.event_id = xet.event_id
119875:

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

120042: FROM xla_events_gt xet
120043: , AP_INVOICE_EXTRACT_DETAILS_V l1
120044: , ZX_AP_DEF_TAX_EXTRACT_V l3
120045: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
120046: , (select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
120047: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
120048: AND xet.event_class_code = C_EVENT_CLASS_CODE
120049: AND l1.event_id = xet.event_id
120050: AND l1.zrnd_tax_dist_id = l3.rec_nrec_tax_dist_id (+) AND l1.zrnd_tax_dist_id = l4.rec_nrec_tax_dist_id (+)

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

121219: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
121220: , fnd_lookup_values fvl4
121221: , fnd_lookup_values fvl30
121222: , fnd_lookup_values fvl110
121223: ,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
121224: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
121225: AND xet.event_class_code = C_EVENT_CLASS_CODE
121226: AND h2.event_id = xet.event_id
121227: AND h3.asp_org_id = h2.ac_org_id AND fvl4.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

121416: FROM xla_events_gt xet
121417: , AP_PAYMENT_EXTRACT_DETAILS_V l1
121418: , fnd_lookup_values fvl39
121419: , fnd_lookup_values fvl53
121420: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
121421: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
121422: AND xet.event_class_code = C_EVENT_CLASS_CODE
121423: AND l1.event_id = xet.event_id
121424: AND fvl39.lookup_type(+) = 'PAY_DIST_TYPES'

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

123113: END source_value
123114: , null source_meaning
123115: FROM xla_events_gt xet
123116: , AP_INVOICE_EXTRACT_HEADER_V h2
123117: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
123118: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
123119: AND xet.event_class_code = C_EVENT_CLASS_CODE
123120: AND h2.event_id = xet.event_id
123121:

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

123288: FROM xla_events_gt xet
123289: , AP_INVOICE_EXTRACT_DETAILS_V l1
123290: , ZX_AP_DEF_TAX_EXTRACT_V l3
123291: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
123292: , (select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
123293: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
123294: AND xet.event_class_code = C_EVENT_CLASS_CODE
123295: AND l1.event_id = xet.event_id
123296: AND l1.zrnd_tax_dist_id = l3.rec_nrec_tax_dist_id (+) AND l1.zrnd_tax_dist_id = l4.rec_nrec_tax_dist_id (+)

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

124431: END source_value
124432: , null source_meaning
124433: FROM xla_events_gt xet
124434: , PA_XLA_BC_PKT_AP_DETAIL_V l1
124435: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
124436: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
124437: AND xet.event_class_code = C_EVENT_CLASS_CODE
124438: AND l1.event_id = xet.event_id
124439:

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

125654: , fnd_lookup_values fvl60
125655: , fnd_lookup_values fvl102
125656: , fnd_lookup_values fvl110
125657: , fnd_lookup_values fvl175
125658: ,(select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
125659: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
125660: AND xet.event_class_code = C_EVENT_CLASS_CODE
125661: AND h2.event_id = xet.event_id
125662: AND h4.asp_org_id = h2.ac_org_id AND fvl3.lookup_type(+) = 'DISCOUNT_DIST_OPTIONS'

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

125993: , fnd_lookup_values fvl53
125994: , fnd_lookup_values fvl100
125995: , fnd_lookup_values fvl101
125996: , fnd_lookup_values fvl104
125997: , (select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)
125998: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
125999: AND xet.event_class_code = C_EVENT_CLASS_CODE
126000: AND l1.event_id = xet.event_id
126001: 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 fvl7.lookup_type(+) = 'DESTINATION TYPE'

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

129657: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
129658: , fnd_lookup_values fvl4
129659: , fnd_lookup_values fvl30
129660: , fnd_lookup_values fvl102
129661: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
129662: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
129663: AND xet.event_class_code = C_EVENT_CLASS_CODE
129664: AND h1.event_id = xet.event_id
129665: AND h4.asp_org_id = h1.ai_org_id AND fvl4.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

130095: , fnd_lookup_values fvl68
130096: , fnd_lookup_values fvl100
130097: , fnd_lookup_values fvl104
130098: , fnd_lookup_values fvl144
130099: , (select rownum r from all_objects where rownum <= 63 and owner = p_apps_owner)
130100: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
130101: AND xet.event_class_code = C_EVENT_CLASS_CODE
130102: AND l3.event_id = xet.event_id
130103: 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 fvl7.lookup_type(+) = 'DESTINATION TYPE'

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

133768: END source_value
133769: , null source_meaning
133770: FROM xla_events_gt xet
133771: , AP_INVOICE_EXTRACT_HEADER_V h2
133772: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
133773: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
133774: AND xet.event_class_code = C_EVENT_CLASS_CODE
133775: AND h2.event_id = xet.event_id
133776:

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

133943: FROM xla_events_gt xet
133944: , AP_INVOICE_EXTRACT_DETAILS_V l1
133945: , ZX_AP_DEF_TAX_EXTRACT_V l3
133946: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
133947: , (select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
133948: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
133949: AND xet.event_class_code = C_EVENT_CLASS_CODE
133950: AND l1.event_id = xet.event_id
133951: AND l1.zrnd_tax_dist_id = l3.rec_nrec_tax_dist_id (+) AND l1.zrnd_tax_dist_id = l4.rec_nrec_tax_dist_id (+)

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

135086: END source_value
135087: , null source_meaning
135088: FROM xla_events_gt xet
135089: , PA_XLA_BC_PKT_AP_DETAIL_V l1
135090: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
135091: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
135092: AND xet.event_class_code = C_EVENT_CLASS_CODE
135093: AND l1.event_id = xet.event_id
135094:

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

136198: END source_value
136199: , null source_meaning
136200: FROM xla_events_gt xet
136201: , PA_XLA_BC_PKT_AP_DETAIL_V l1
136202: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
136203: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
136204: AND xet.event_class_code = C_EVENT_CLASS_CODE
136205: AND l1.event_id = xet.event_id
136206:

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

137425: , fnd_lookup_values fvl30
137426: , fnd_lookup_values fvl60
137427: , fnd_lookup_values fvl102
137428: , fnd_lookup_values fvl110
137429: ,(select rownum r from all_objects where rownum <= 37 and owner = p_apps_owner)
137430: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
137431: AND xet.event_class_code = C_EVENT_CLASS_CODE
137432: AND h2.event_id = xet.event_id
137433: AND h4.asp_org_id = h2.ac_org_id AND fvl3.lookup_type(+) = 'DISCOUNT_DIST_OPTIONS'

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

137793: , fnd_lookup_values fvl100
137794: , fnd_lookup_values fvl101
137795: , fnd_lookup_values fvl104
137796: , fnd_lookup_values fvl151
137797: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
137798: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
137799: AND xet.event_class_code = C_EVENT_CLASS_CODE
137800: AND l1.event_id = xet.event_id
137801: AND l1.pod_po_header_id = l3.po_header_id (+) AND l1.aid_detail_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND fvl7.lookup_type(+) = 'DESTINATION TYPE'

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

141574: , fnd_lookup_values fvl60
141575: , fnd_lookup_values fvl102
141576: , fnd_lookup_values fvl110
141577: , fnd_lookup_values fvl175
141578: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
141579: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
141580: AND xet.event_class_code = C_EVENT_CLASS_CODE
141581: AND h2.event_id = xet.event_id
141582: AND h4.asp_org_id = h2.ac_org_id AND fvl3.lookup_type(+) = 'DISCOUNT_DIST_OPTIONS'

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

141855: , fnd_lookup_values fvl53
141856: , fnd_lookup_values fvl100
141857: , fnd_lookup_values fvl101
141858: , fnd_lookup_values fvl104
141859: , (select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)
141860: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
141861: AND xet.event_class_code = C_EVENT_CLASS_CODE
141862: AND l1.event_id = xet.event_id
141863: 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 fvl7.lookup_type(+) = 'DESTINATION TYPE'