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

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

143218: FROM xla_events_gt xet
143219: , CST_XLA_WIP_HEADERS_V h1
143220: , fnd_lookup_values fvl12
143221: , fnd_lookup_values fvl38
143222: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
143223: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
143224: AND xet.event_class_code = C_EVENT_CLASS_CODE
143225: AND h1.event_id = xet.event_id
143226: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

143344: END source_value
143345: , null source_meaning
143346: FROM xla_events_gt xet
143347: , CST_XLA_WIP_LINES_V l2
143348: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
143349: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
143350: AND xet.event_class_code = C_EVENT_CLASS_CODE
143351: AND l2.event_id = xet.event_id
143352:

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

144516: FROM xla_events_gt xet
144517: , CST_XLA_AWO_HEADERS_V h1
144518: , fnd_lookup_values fvl12
144519: , fnd_lookup_values fvl38
144520: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
144521: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
144522: AND xet.event_class_code = C_EVENT_CLASS_CODE
144523: AND h1.event_id = xet.event_id
144524: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

144652: END source_value
144653: , null source_meaning
144654: FROM xla_events_gt xet
144655: , CST_XLA_AWO_LINES_V l2
144656: , (select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
144657: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
144658: AND xet.event_class_code = C_EVENT_CLASS_CODE
144659: AND l2.event_id = xet.event_id
144660:

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

145783: FROM xla_events_gt xet
145784: , CST_XLA_INV_HEADERS_V h1
145785: , fnd_lookup_values fvl12
145786: , fnd_lookup_values fvl38
145787: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
145788: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
145789: AND xet.event_class_code = C_EVENT_CLASS_CODE
145790: AND h1.event_id = xet.event_id
145791: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

145929: END source_value
145930: , null source_meaning
145931: FROM xla_events_gt xet
145932: , CST_XLA_INV_LINES_V l2
145933: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
145934: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
145935: AND xet.event_class_code = C_EVENT_CLASS_CODE
145936: AND l2.event_id = xet.event_id
145937:

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

147151: , PO_HEADERS_REF_V h5
147152: , PSA_CST_XLA_UPG_V h6
147153: , fnd_lookup_values fvl12
147154: , fnd_lookup_values fvl38
147155: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
147156: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147157: AND xet.event_class_code = C_EVENT_CLASS_CODE
147158: AND h1.event_id = xet.event_id
147159: AND h3.ref_rcv_accounting_event_id = h1.rcv_accounting_event_id AND h3.po_header_id = h4.po_header_id (+) and h3.po_distribution_id = h4.po_distribution_id (+) AND h3.po_header_id = h5.po_header_id (+) AND h3.rcv_transaction_id = h6.transaction_id (+) AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

147277: END source_value
147278: , null source_meaning
147279: FROM xla_events_gt xet
147280: , CST_XLA_RCV_LINES_V l2
147281: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
147282: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147283: AND xet.event_class_code = C_EVENT_CLASS_CODE
147284: AND l2.event_id = xet.event_id
147285:

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

148472: , PO_REQ_HEADERS_REF_V h5
148473: , PSA_CST_XLA_UPG_V h6
148474: , fnd_lookup_values fvl12
148475: , fnd_lookup_values fvl38
148476: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
148477: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
148478: AND xet.event_class_code = C_EVENT_CLASS_CODE
148479: AND h1.event_id = xet.event_id
148480: AND h3.ref_transaction_id = h1.transaction_id AND h3.bus_flow_req_dist_id=h4.req_distribution_id (+) AND h3.bus_flow_req_id = h5.req_id (+) AND h3.rcv_transaction_id = h6.transaction_id (+) AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

148618: END source_value
148619: , null source_meaning
148620: FROM xla_events_gt xet
148621: , CST_XLA_INV_LINES_V l2
148622: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
148623: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
148624: AND xet.event_class_code = C_EVENT_CLASS_CODE
148625: AND l2.event_id = xet.event_id
148626:

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

150028: FROM xla_events_gt xet
150029: , CST_XLA_INV_HEADERS_V h1
150030: , fnd_lookup_values fvl12
150031: , fnd_lookup_values fvl38
150032: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
150033: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150034: AND xet.event_class_code = C_EVENT_CLASS_CODE
150035: AND h1.event_id = xet.event_id
150036: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

150174: END source_value
150175: , null source_meaning
150176: FROM xla_events_gt xet
150177: , CST_XLA_INV_LINES_V l2
150178: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
150179: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150180: AND xet.event_class_code = C_EVENT_CLASS_CODE
150181: AND l2.event_id = xet.event_id
150182:

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

151492: , PO_REQ_HEADERS_REF_V h5
151493: , PSA_CST_XLA_UPG_V h6
151494: , fnd_lookup_values fvl12
151495: , fnd_lookup_values fvl38
151496: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
151497: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
151498: AND xet.event_class_code = C_EVENT_CLASS_CODE
151499: AND h1.event_id = xet.event_id
151500: AND h3.ref_transaction_id = h1.transaction_id AND h3.bus_flow_req_dist_id=h4.req_distribution_id (+) AND h3.bus_flow_req_id = h5.req_id (+) AND h3.rcv_transaction_id = h6.transaction_id (+) AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

151638: END source_value
151639: , null source_meaning
151640: FROM xla_events_gt xet
151641: , CST_XLA_INV_LINES_V l2
151642: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
151643: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
151644: AND xet.event_class_code = C_EVENT_CLASS_CODE
151645: AND l2.event_id = xet.event_id
151646:

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

153009: FROM xla_events_gt xet
153010: , CST_XLA_INV_HEADERS_V h1
153011: , fnd_lookup_values fvl12
153012: , fnd_lookup_values fvl38
153013: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
153014: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153015: AND xet.event_class_code = C_EVENT_CLASS_CODE
153016: AND h1.event_id = xet.event_id
153017: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

153155: END source_value
153156: , null source_meaning
153157: FROM xla_events_gt xet
153158: , CST_XLA_INV_LINES_V l2
153159: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
153160: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153161: AND xet.event_class_code = C_EVENT_CLASS_CODE
153162: AND l2.event_id = xet.event_id
153163:

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

154361: FROM xla_events_gt xet
154362: , CST_XLA_INV_HEADERS_V h1
154363: , fnd_lookup_values fvl12
154364: , fnd_lookup_values fvl38
154365: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
154366: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
154367: AND xet.event_class_code = C_EVENT_CLASS_CODE
154368: AND h1.event_id = xet.event_id
154369: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

154507: END source_value
154508: , null source_meaning
154509: FROM xla_events_gt xet
154510: , CST_XLA_INV_LINES_V l2
154511: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
154512: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
154513: AND xet.event_class_code = C_EVENT_CLASS_CODE
154514: AND l2.event_id = xet.event_id
154515:

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

155651: , PO_REQ_HEADERS_REF_V h5
155652: , PSA_CST_XLA_UPG_V h6
155653: , fnd_lookup_values fvl12
155654: , fnd_lookup_values fvl38
155655: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
155656: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
155657: AND xet.event_class_code = C_EVENT_CLASS_CODE
155658: AND h1.event_id = xet.event_id
155659: AND h3.ref_transaction_id = h1.transaction_id AND h3.bus_flow_req_dist_id=h4.req_distribution_id (+) AND h3.bus_flow_req_id = h5.req_id (+) AND h3.rcv_transaction_id = h6.transaction_id (+) AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

155797: END source_value
155798: , null source_meaning
155799: FROM xla_events_gt xet
155800: , CST_XLA_INV_LINES_V l2
155801: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
155802: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
155803: AND xet.event_class_code = C_EVENT_CLASS_CODE
155804: AND l2.event_id = xet.event_id
155805:

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

156973: FROM xla_events_gt xet
156974: , CST_XLA_INV_HEADERS_V h1
156975: , fnd_lookup_values fvl12
156976: , fnd_lookup_values fvl38
156977: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
156978: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156979: AND xet.event_class_code = C_EVENT_CLASS_CODE
156980: AND h1.event_id = xet.event_id
156981: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

157119: END source_value
157120: , null source_meaning
157121: FROM xla_events_gt xet
157122: , CST_XLA_INV_LINES_V l2
157123: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
157124: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
157125: AND xet.event_class_code = C_EVENT_CLASS_CODE
157126: AND l2.event_id = xet.event_id
157127:

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

158383: FROM xla_events_gt xet
158384: , CST_XLA_INV_HEADERS_V h1
158385: , fnd_lookup_values fvl12
158386: , fnd_lookup_values fvl38
158387: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
158388: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
158389: AND xet.event_class_code = C_EVENT_CLASS_CODE
158390: AND h1.event_id = xet.event_id
158391: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

158529: END source_value
158530: , null source_meaning
158531: FROM xla_events_gt xet
158532: , CST_XLA_INV_LINES_V l2
158533: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
158534: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
158535: AND xet.event_class_code = C_EVENT_CLASS_CODE
158536: AND l2.event_id = xet.event_id
158537:

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

159706: FROM xla_events_gt xet
159707: , CST_XLA_INV_HEADERS_V h1
159708: , fnd_lookup_values fvl12
159709: , fnd_lookup_values fvl38
159710: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
159711: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159712: AND xet.event_class_code = C_EVENT_CLASS_CODE
159713: AND h1.event_id = xet.event_id
159714: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

159852: END source_value
159853: , null source_meaning
159854: FROM xla_events_gt xet
159855: , CST_XLA_INV_LINES_V l2
159856: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
159857: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159858: AND xet.event_class_code = C_EVENT_CLASS_CODE
159859: AND l2.event_id = xet.event_id
159860:

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

160942: FROM xla_events_gt xet
160943: , CST_XLA_INV_HEADERS_V h1
160944: , fnd_lookup_values fvl12
160945: , fnd_lookup_values fvl38
160946: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
160947: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
160948: AND xet.event_class_code = C_EVENT_CLASS_CODE
160949: AND h1.event_id = xet.event_id
160950: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

161088: END source_value
161089: , null source_meaning
161090: FROM xla_events_gt xet
161091: , CST_XLA_INV_LINES_V l2
161092: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
161093: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161094: AND xet.event_class_code = C_EVENT_CLASS_CODE
161095: AND l2.event_id = xet.event_id
161096:

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

162253: , CST_XLA_RCV_REF_V h3
162254: , PO_DISTS_REF_V h4
162255: , fnd_lookup_values fvl12
162256: , fnd_lookup_values fvl38
162257: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
162258: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162259: AND xet.event_class_code = C_EVENT_CLASS_CODE
162260: AND h1.event_id = xet.event_id
162261: AND h3.ref_rcv_accounting_event_id = h1.rcv_accounting_event_id AND h3.po_header_id = h4.po_header_id and h3.po_distribution_id = h4.po_distribution_id AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

162379: END source_value
162380: , null source_meaning
162381: FROM xla_events_gt xet
162382: , CST_XLA_RCV_LINES_V l2
162383: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
162384: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162385: AND xet.event_class_code = C_EVENT_CLASS_CODE
162386: AND l2.event_id = xet.event_id
162387:

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

163517: , CST_XLA_RCV_REF_V h3
163518: , PO_DISTS_REF_V h4
163519: , fnd_lookup_values fvl12
163520: , fnd_lookup_values fvl38
163521: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
163522: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
163523: AND xet.event_class_code = C_EVENT_CLASS_CODE
163524: AND h1.event_id = xet.event_id
163525: AND h3.ref_rcv_accounting_event_id = h1.rcv_accounting_event_id AND h3.po_header_id = h4.po_header_id and h3.po_distribution_id = h4.po_distribution_id AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

163643: END source_value
163644: , null source_meaning
163645: FROM xla_events_gt xet
163646: , CST_XLA_RCV_LINES_V l2
163647: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
163648: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
163649: AND xet.event_class_code = C_EVENT_CLASS_CODE
163650: AND l2.event_id = xet.event_id
163651:

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

164717: , CST_XLA_INV_HEADERS_V h1
164718: , fnd_lookup_values fvl12
164719: , fnd_lookup_values fvl35
164720: , fnd_lookup_values fvl38
164721: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
164722: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
164723: AND xet.event_class_code = C_EVENT_CLASS_CODE
164724: AND h1.event_id = xet.event_id
164725: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

164867: END source_value
164868: , null source_meaning
164869: FROM xla_events_gt xet
164870: , CST_XLA_INV_LINES_V l2
164871: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
164872: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
164873: AND xet.event_class_code = C_EVENT_CLASS_CODE
164874: AND l2.event_id = xet.event_id
164875:

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

166033: FROM xla_events_gt xet
166034: , CST_XLA_INV_HEADERS_V h1
166035: , fnd_lookup_values fvl12
166036: , fnd_lookup_values fvl38
166037: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
166038: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
166039: AND xet.event_class_code = C_EVENT_CLASS_CODE
166040: AND h1.event_id = xet.event_id
166041: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

166179: END source_value
166180: , null source_meaning
166181: FROM xla_events_gt xet
166182: , CST_XLA_INV_LINES_V l2
166183: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
166184: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
166185: AND xet.event_class_code = C_EVENT_CLASS_CODE
166186: AND l2.event_id = xet.event_id
166187:

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

167240: FROM xla_events_gt xet
167241: , CST_XLA_INV_HEADERS_V h1
167242: , fnd_lookup_values fvl12
167243: , fnd_lookup_values fvl38
167244: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
167245: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
167246: AND xet.event_class_code = C_EVENT_CLASS_CODE
167247: AND h1.event_id = xet.event_id
167248: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

167386: END source_value
167387: , null source_meaning
167388: FROM xla_events_gt xet
167389: , CST_XLA_INV_LINES_V l2
167390: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
167391: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
167392: AND xet.event_class_code = C_EVENT_CLASS_CODE
167393: AND l2.event_id = xet.event_id
167394:

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

168476: FROM xla_events_gt xet
168477: , CST_XLA_INV_HEADERS_V h1
168478: , fnd_lookup_values fvl12
168479: , fnd_lookup_values fvl38
168480: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
168481: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168482: AND xet.event_class_code = C_EVENT_CLASS_CODE
168483: AND h1.event_id = xet.event_id
168484: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

168622: END source_value
168623: , null source_meaning
168624: FROM xla_events_gt xet
168625: , CST_XLA_INV_LINES_V l2
168626: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
168627: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168628: AND xet.event_class_code = C_EVENT_CLASS_CODE
168629: AND l2.event_id = xet.event_id
168630:

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

169785: FROM xla_events_gt xet
169786: , CST_XLA_WIP_HEADERS_V h1
169787: , fnd_lookup_values fvl12
169788: , fnd_lookup_values fvl38
169789: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
169790: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
169791: AND xet.event_class_code = C_EVENT_CLASS_CODE
169792: AND h1.event_id = xet.event_id
169793: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

169911: END source_value
169912: , null source_meaning
169913: FROM xla_events_gt xet
169914: , CST_XLA_WIP_LINES_V l2
169915: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
169916: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
169917: AND xet.event_class_code = C_EVENT_CLASS_CODE
169918: AND l2.event_id = xet.event_id
169919:

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

171155: , PO_HEADERS_REF_V h5
171156: , PSA_CST_XLA_PEA_UPG_V h6
171157: , fnd_lookup_values fvl12
171158: , fnd_lookup_values fvl38
171159: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
171160: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
171161: AND xet.event_class_code = C_EVENT_CLASS_CODE
171162: AND h1.event_id = xet.event_id
171163: AND h3.ref_rcv_accounting_event_id = h1.rcv_accounting_event_id AND h3.po_header_id = h4.po_header_id (+) and h3.po_distribution_id = h4.po_distribution_id (+) AND h3.po_header_id = h5.po_header_id (+) AND h3.ref_rcv_accounting_event_id = h6.accounting_event_id (+) AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

171281: END source_value
171282: , null source_meaning
171283: FROM xla_events_gt xet
171284: , CST_XLA_RCV_LINES_V l2
171285: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
171286: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
171287: AND xet.event_class_code = C_EVENT_CLASS_CODE
171288: AND l2.event_id = xet.event_id
171289:

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

172522: , PO_HEADERS_REF_V h5
172523: , PSA_CST_XLA_UPG_V h6
172524: , fnd_lookup_values fvl12
172525: , fnd_lookup_values fvl38
172526: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
172527: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
172528: AND xet.event_class_code = C_EVENT_CLASS_CODE
172529: AND h1.event_id = xet.event_id
172530: AND h3.ref_transaction_id = h1.transaction_id AND h3.txn_po_header_id = h4.po_header_id (+) and h3.txn_po_distribution_id = h4.po_distribution_id (+) AND h3.txn_po_header_id = h5.po_header_id (+) AND h3.rcv_transaction_id = h6.transaction_id (+) AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

172668: END source_value
172669: , null source_meaning
172670: FROM xla_events_gt xet
172671: , CST_XLA_INV_LINES_V l2
172672: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
172673: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
172674: AND xet.event_class_code = C_EVENT_CLASS_CODE
172675: AND l2.event_id = xet.event_id
172676:

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

174059: FROM xla_events_gt xet
174060: , CST_XLA_RCV_HEADERS_V h1
174061: , fnd_lookup_values fvl12
174062: , fnd_lookup_values fvl38
174063: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
174064: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174065: AND xet.event_class_code = C_EVENT_CLASS_CODE
174066: AND h1.event_id = xet.event_id
174067: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

174185: END source_value
174186: , null source_meaning
174187: FROM xla_events_gt xet
174188: , CST_XLA_RCV_LINES_V l2
174189: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
174190: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174191: AND xet.event_class_code = C_EVENT_CLASS_CODE
174192: AND l2.event_id = xet.event_id
174193:

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

175366: FROM xla_events_gt xet
175367: , CST_XLA_INV_HEADERS_V h1
175368: , fnd_lookup_values fvl12
175369: , fnd_lookup_values fvl38
175370: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
175371: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
175372: AND xet.event_class_code = C_EVENT_CLASS_CODE
175373: AND h1.event_id = xet.event_id
175374: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

175512: END source_value
175513: , null source_meaning
175514: FROM xla_events_gt xet
175515: , CST_XLA_INV_LINES_V l2
175516: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
175517: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
175518: AND xet.event_class_code = C_EVENT_CLASS_CODE
175519: AND l2.event_id = xet.event_id
175520:

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

176588: FROM xla_events_gt xet
176589: , CST_XLA_RCV_HEADERS_V h1
176590: , fnd_lookup_values fvl12
176591: , fnd_lookup_values fvl38
176592: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
176593: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
176594: AND xet.event_class_code = C_EVENT_CLASS_CODE
176595: AND h1.event_id = xet.event_id
176596: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

176714: END source_value
176715: , null source_meaning
176716: FROM xla_events_gt xet
176717: , CST_XLA_RCV_LINES_V l2
176718: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
176719: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
176720: AND xet.event_class_code = C_EVENT_CLASS_CODE
176721: AND l2.event_id = xet.event_id
176722:

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

177820: FROM xla_events_gt xet
177821: , CST_XLA_RCV_HEADERS_V h1
177822: , fnd_lookup_values fvl12
177823: , fnd_lookup_values fvl38
177824: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
177825: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177826: AND xet.event_class_code = C_EVENT_CLASS_CODE
177827: AND h1.event_id = xet.event_id
177828: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

177946: END source_value
177947: , null source_meaning
177948: FROM xla_events_gt xet
177949: , CST_XLA_RCV_LINES_V l2
177950: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
177951: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177952: AND xet.event_class_code = C_EVENT_CLASS_CODE
177953: AND l2.event_id = xet.event_id
177954:

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

179069: FROM xla_events_gt xet
179070: , CST_XLA_INV_HEADERS_V h1
179071: , fnd_lookup_values fvl12
179072: , fnd_lookup_values fvl38
179073: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
179074: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
179075: AND xet.event_class_code = C_EVENT_CLASS_CODE
179076: AND h1.event_id = xet.event_id
179077: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

179215: END source_value
179216: , null source_meaning
179217: FROM xla_events_gt xet
179218: , CST_XLA_INV_LINES_V l2
179219: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
179220: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
179221: AND xet.event_class_code = C_EVENT_CLASS_CODE
179222: AND l2.event_id = xet.event_id
179223:

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

180363: FROM xla_events_gt xet
180364: , CST_XLA_INV_HEADERS_V h1
180365: , fnd_lookup_values fvl12
180366: , fnd_lookup_values fvl38
180367: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
180368: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
180369: AND xet.event_type_code = C_EVENT_TYPE_CODE
180370: AND h1.event_id = xet.event_id
180371: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

180508: END source_value
180509: , null source_meaning
180510: FROM xla_events_gt xet
180511: , CST_XLA_INV_LINES_V l2
180512: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
180513: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
180514: AND xet.event_type_code = C_EVENT_TYPE_CODE
180515: AND l2.event_id = xet.event_id
180516:

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

181657: FROM xla_events_gt xet
181658: , CST_XLA_INV_HEADERS_V h1
181659: , fnd_lookup_values fvl12
181660: , fnd_lookup_values fvl38
181661: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
181662: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
181663: AND xet.event_type_code = C_EVENT_TYPE_CODE
181664: AND h1.event_id = xet.event_id
181665: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

181802: END source_value
181803: , null source_meaning
181804: FROM xla_events_gt xet
181805: , CST_XLA_INV_LINES_V l2
181806: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
181807: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
181808: AND xet.event_type_code = C_EVENT_TYPE_CODE
181809: AND l2.event_id = xet.event_id
181810:

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

182893: FROM xla_events_gt xet
182894: , CST_XLA_INV_HEADERS_V h1
182895: , fnd_lookup_values fvl12
182896: , fnd_lookup_values fvl38
182897: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
182898: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
182899: AND xet.event_type_code = C_EVENT_TYPE_CODE
182900: AND h1.event_id = xet.event_id
182901: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

183038: END source_value
183039: , null source_meaning
183040: FROM xla_events_gt xet
183041: , CST_XLA_INV_LINES_V l2
183042: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
183043: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
183044: AND xet.event_type_code = C_EVENT_TYPE_CODE
183045: AND l2.event_id = xet.event_id
183046:

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

184303: FROM xla_events_gt xet
184304: , CST_XLA_INV_HEADERS_V h1
184305: , fnd_lookup_values fvl12
184306: , fnd_lookup_values fvl38
184307: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
184308: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
184309: AND xet.event_type_code = C_EVENT_TYPE_CODE
184310: AND h1.event_id = xet.event_id
184311: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

184448: END source_value
184449: , null source_meaning
184450: FROM xla_events_gt xet
184451: , CST_XLA_INV_LINES_V l2
184452: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
184453: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
184454: AND xet.event_type_code = C_EVENT_TYPE_CODE
184455: AND l2.event_id = xet.event_id
184456:

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

185713: FROM xla_events_gt xet
185714: , CST_XLA_INV_HEADERS_V h1
185715: , fnd_lookup_values fvl12
185716: , fnd_lookup_values fvl38
185717: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
185718: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
185719: AND xet.event_type_code = C_EVENT_TYPE_CODE
185720: AND h1.event_id = xet.event_id
185721: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

185858: END source_value
185859: , null source_meaning
185860: FROM xla_events_gt xet
185861: , CST_XLA_INV_LINES_V l2
185862: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
185863: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
185864: AND xet.event_type_code = C_EVENT_TYPE_CODE
185865: AND l2.event_id = xet.event_id
185866:

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

187123: FROM xla_events_gt xet
187124: , CST_XLA_INV_HEADERS_V h1
187125: , fnd_lookup_values fvl12
187126: , fnd_lookup_values fvl38
187127: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
187128: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
187129: AND xet.event_type_code = C_EVENT_TYPE_CODE
187130: AND h1.event_id = xet.event_id
187131: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

187268: END source_value
187269: , null source_meaning
187270: FROM xla_events_gt xet
187271: , CST_XLA_INV_LINES_V l2
187272: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
187273: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
187274: AND xet.event_type_code = C_EVENT_TYPE_CODE
187275: AND l2.event_id = xet.event_id
187276:

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

188533: FROM xla_events_gt xet
188534: , CST_XLA_INV_HEADERS_V h1
188535: , fnd_lookup_values fvl12
188536: , fnd_lookup_values fvl38
188537: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
188538: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
188539: AND xet.event_type_code = C_EVENT_TYPE_CODE
188540: AND h1.event_id = xet.event_id
188541: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

188678: END source_value
188679: , null source_meaning
188680: FROM xla_events_gt xet
188681: , CST_XLA_INV_LINES_V l2
188682: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
188683: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
188684: AND xet.event_type_code = C_EVENT_TYPE_CODE
188685: AND l2.event_id = xet.event_id
188686:

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

189943: FROM xla_events_gt xet
189944: , CST_XLA_INV_HEADERS_V h1
189945: , fnd_lookup_values fvl12
189946: , fnd_lookup_values fvl38
189947: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
189948: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
189949: AND xet.event_type_code = C_EVENT_TYPE_CODE
189950: AND h1.event_id = xet.event_id
189951: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

190088: END source_value
190089: , null source_meaning
190090: FROM xla_events_gt xet
190091: , CST_XLA_INV_LINES_V l2
190092: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
190093: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
190094: AND xet.event_type_code = C_EVENT_TYPE_CODE
190095: AND l2.event_id = xet.event_id
190096:

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

191353: FROM xla_events_gt xet
191354: , CST_XLA_INV_HEADERS_V h1
191355: , fnd_lookup_values fvl12
191356: , fnd_lookup_values fvl38
191357: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
191358: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
191359: AND xet.event_type_code = C_EVENT_TYPE_CODE
191360: AND h1.event_id = xet.event_id
191361: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

191498: END source_value
191499: , null source_meaning
191500: FROM xla_events_gt xet
191501: , CST_XLA_INV_LINES_V l2
191502: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
191503: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
191504: AND xet.event_type_code = C_EVENT_TYPE_CODE
191505: AND l2.event_id = xet.event_id
191506:

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

192589: FROM xla_events_gt xet
192590: , CST_XLA_INV_HEADERS_V h1
192591: , fnd_lookup_values fvl12
192592: , fnd_lookup_values fvl38
192593: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
192594: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
192595: AND xet.event_type_code = C_EVENT_TYPE_CODE
192596: AND h1.event_id = xet.event_id
192597: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

192734: END source_value
192735: , null source_meaning
192736: FROM xla_events_gt xet
192737: , CST_XLA_INV_LINES_V l2
192738: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
192739: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
192740: AND xet.event_type_code = C_EVENT_TYPE_CODE
192741: AND l2.event_id = xet.event_id
192742:

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

193999: FROM xla_events_gt xet
194000: , CST_XLA_INV_HEADERS_V h1
194001: , fnd_lookup_values fvl12
194002: , fnd_lookup_values fvl38
194003: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
194004: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
194005: AND xet.event_type_code = C_EVENT_TYPE_CODE
194006: AND h1.event_id = xet.event_id
194007: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

194144: END source_value
194145: , null source_meaning
194146: FROM xla_events_gt xet
194147: , CST_XLA_INV_LINES_V l2
194148: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
194149: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
194150: AND xet.event_type_code = C_EVENT_TYPE_CODE
194151: AND l2.event_id = xet.event_id
194152:

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

195409: FROM xla_events_gt xet
195410: , CST_XLA_INV_HEADERS_V h1
195411: , fnd_lookup_values fvl12
195412: , fnd_lookup_values fvl38
195413: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
195414: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
195415: AND xet.event_type_code = C_EVENT_TYPE_CODE
195416: AND h1.event_id = xet.event_id
195417: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

195554: END source_value
195555: , null source_meaning
195556: FROM xla_events_gt xet
195557: , CST_XLA_INV_LINES_V l2
195558: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
195559: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
195560: AND xet.event_type_code = C_EVENT_TYPE_CODE
195561: AND l2.event_id = xet.event_id
195562:

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

196732: FROM xla_events_gt xet
196733: , CST_XLA_INV_HEADERS_V h1
196734: , fnd_lookup_values fvl12
196735: , fnd_lookup_values fvl38
196736: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
196737: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
196738: AND xet.event_type_code = C_EVENT_TYPE_CODE
196739: AND h1.event_id = xet.event_id
196740: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

196877: END source_value
196878: , null source_meaning
196879: FROM xla_events_gt xet
196880: , CST_XLA_INV_LINES_V l2
196881: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
196882: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
196883: AND xet.event_type_code = C_EVENT_TYPE_CODE
196884: AND l2.event_id = xet.event_id
196885:

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

198055: FROM xla_events_gt xet
198056: , CST_XLA_INV_HEADERS_V h1
198057: , fnd_lookup_values fvl12
198058: , fnd_lookup_values fvl38
198059: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
198060: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
198061: AND xet.event_type_code = C_EVENT_TYPE_CODE
198062: AND h1.event_id = xet.event_id
198063: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

198200: END source_value
198201: , null source_meaning
198202: FROM xla_events_gt xet
198203: , CST_XLA_INV_LINES_V l2
198204: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
198205: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
198206: AND xet.event_type_code = C_EVENT_TYPE_CODE
198207: AND l2.event_id = xet.event_id
198208:

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

199320: FROM xla_events_gt xet
199321: , CST_XLA_INV_HEADERS_V h1
199322: , fnd_lookup_values fvl12
199323: , fnd_lookup_values fvl38
199324: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
199325: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
199326: AND xet.event_type_code = C_EVENT_TYPE_CODE
199327: AND h1.event_id = xet.event_id
199328: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

199465: END source_value
199466: , null source_meaning
199467: FROM xla_events_gt xet
199468: , CST_XLA_INV_LINES_V l2
199469: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
199470: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
199471: AND xet.event_type_code = C_EVENT_TYPE_CODE
199472: AND l2.event_id = xet.event_id
199473:

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

200556: FROM xla_events_gt xet
200557: , CST_XLA_INV_HEADERS_V h1
200558: , fnd_lookup_values fvl12
200559: , fnd_lookup_values fvl38
200560: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
200561: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
200562: AND xet.event_type_code = C_EVENT_TYPE_CODE
200563: AND h1.event_id = xet.event_id
200564: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

200701: END source_value
200702: , null source_meaning
200703: FROM xla_events_gt xet
200704: , CST_XLA_INV_LINES_V l2
200705: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
200706: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
200707: AND xet.event_type_code = C_EVENT_TYPE_CODE
200708: AND l2.event_id = xet.event_id
200709:

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

201792: FROM xla_events_gt xet
201793: , CST_XLA_INV_HEADERS_V h1
201794: , fnd_lookup_values fvl12
201795: , fnd_lookup_values fvl38
201796: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
201797: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
201798: AND xet.event_type_code = C_EVENT_TYPE_CODE
201799: AND h1.event_id = xet.event_id
201800: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

201937: END source_value
201938: , null source_meaning
201939: FROM xla_events_gt xet
201940: , CST_XLA_INV_LINES_V l2
201941: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
201942: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
201943: AND xet.event_type_code = C_EVENT_TYPE_CODE
201944: AND l2.event_id = xet.event_id
201945:

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

203048: FROM xla_events_gt xet
203049: , CST_XLA_WIP_HEADERS_V h1
203050: , fnd_lookup_values fvl12
203051: , fnd_lookup_values fvl38
203052: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
203053: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
203054: AND xet.event_class_code = C_EVENT_CLASS_CODE
203055: AND h1.event_id = xet.event_id
203056: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

203174: END source_value
203175: , null source_meaning
203176: FROM xla_events_gt xet
203177: , CST_XLA_WIP_LINES_V l2
203178: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
203179: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
203180: AND xet.event_class_code = C_EVENT_CLASS_CODE
203181: AND l2.event_id = xet.event_id
203182:

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

204259: FROM xla_events_gt xet
204260: , CST_XLA_WIP_HEADERS_V h1
204261: , fnd_lookup_values fvl12
204262: , fnd_lookup_values fvl38
204263: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
204264: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
204265: AND xet.event_class_code = C_EVENT_CLASS_CODE
204266: AND h1.event_id = xet.event_id
204267: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

204385: END source_value
204386: , null source_meaning
204387: FROM xla_events_gt xet
204388: , CST_XLA_WIP_LINES_V l2
204389: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
204390: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
204391: AND xet.event_class_code = C_EVENT_CLASS_CODE
204392: AND l2.event_id = xet.event_id
204393:

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

205470: FROM xla_events_gt xet
205471: , CST_XLA_WIP_HEADERS_V h1
205472: , fnd_lookup_values fvl12
205473: , fnd_lookup_values fvl38
205474: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
205475: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
205476: AND xet.event_class_code = C_EVENT_CLASS_CODE
205477: AND h1.event_id = xet.event_id
205478: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

205596: END source_value
205597: , null source_meaning
205598: FROM xla_events_gt xet
205599: , CST_XLA_WIP_LINES_V l2
205600: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
205601: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
205602: AND xet.event_class_code = C_EVENT_CLASS_CODE
205603: AND l2.event_id = xet.event_id
205604:

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

206661: FROM xla_events_gt xet
206662: , CST_XLA_INV_HEADERS_V h1
206663: , fnd_lookup_values fvl12
206664: , fnd_lookup_values fvl38
206665: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
206666: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
206667: AND xet.event_class_code = C_EVENT_CLASS_CODE
206668: AND h1.event_id = xet.event_id
206669: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

206807: END source_value
206808: , null source_meaning
206809: FROM xla_events_gt xet
206810: , CST_XLA_INV_LINES_V l2
206811: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
206812: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
206813: AND xet.event_class_code = C_EVENT_CLASS_CODE
206814: AND l2.event_id = xet.event_id
206815: