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

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

138226: FROM xla_events_gt xet
138227: , CST_XLA_WIP_HEADERS_V h1
138228: , fnd_lookup_values fvl12
138229: , fnd_lookup_values fvl38
138230: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
138231: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
138232: AND xet.event_class_code = C_EVENT_CLASS_CODE
138233: AND h1.event_id = xet.event_id
138234: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

138352: END source_value
138353: , null source_meaning
138354: FROM xla_events_gt xet
138355: , CST_XLA_WIP_LINES_V l2
138356: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
138357: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
138358: AND xet.event_class_code = C_EVENT_CLASS_CODE
138359: AND l2.event_id = xet.event_id
138360:

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

139524: FROM xla_events_gt xet
139525: , CST_XLA_AWO_HEADERS_V h1
139526: , fnd_lookup_values fvl12
139527: , fnd_lookup_values fvl38
139528: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
139529: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
139530: AND xet.event_class_code = C_EVENT_CLASS_CODE
139531: AND h1.event_id = xet.event_id
139532: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

139660: END source_value
139661: , null source_meaning
139662: FROM xla_events_gt xet
139663: , CST_XLA_AWO_LINES_V l2
139664: , (select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
139665: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
139666: AND xet.event_class_code = C_EVENT_CLASS_CODE
139667: AND l2.event_id = xet.event_id
139668:

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

140791: FROM xla_events_gt xet
140792: , CST_XLA_INV_HEADERS_V h1
140793: , fnd_lookup_values fvl12
140794: , fnd_lookup_values fvl38
140795: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
140796: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
140797: AND xet.event_class_code = C_EVENT_CLASS_CODE
140798: AND h1.event_id = xet.event_id
140799: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

140937: END source_value
140938: , null source_meaning
140939: FROM xla_events_gt xet
140940: , CST_XLA_INV_LINES_V l2
140941: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
140942: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
140943: AND xet.event_class_code = C_EVENT_CLASS_CODE
140944: AND l2.event_id = xet.event_id
140945:

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

142159: , PO_HEADERS_REF_V h5
142160: , PSA_CST_XLA_UPG_V h6
142161: , fnd_lookup_values fvl12
142162: , fnd_lookup_values fvl38
142163: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
142164: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
142165: AND xet.event_class_code = C_EVENT_CLASS_CODE
142166: AND h1.event_id = xet.event_id
142167: 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 142289: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

142285: END source_value
142286: , null source_meaning
142287: FROM xla_events_gt xet
142288: , CST_XLA_RCV_LINES_V l2
142289: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
142290: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
142291: AND xet.event_class_code = C_EVENT_CLASS_CODE
142292: AND l2.event_id = xet.event_id
142293:

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

143480: , PO_REQ_HEADERS_REF_V h5
143481: , PSA_CST_XLA_UPG_V h6
143482: , fnd_lookup_values fvl12
143483: , fnd_lookup_values fvl38
143484: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
143485: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
143486: AND xet.event_class_code = C_EVENT_CLASS_CODE
143487: AND h1.event_id = xet.event_id
143488: 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 143630: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

143626: END source_value
143627: , null source_meaning
143628: FROM xla_events_gt xet
143629: , CST_XLA_INV_LINES_V l2
143630: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
143631: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
143632: AND xet.event_class_code = C_EVENT_CLASS_CODE
143633: AND l2.event_id = xet.event_id
143634:

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

145036: FROM xla_events_gt xet
145037: , CST_XLA_INV_HEADERS_V h1
145038: , fnd_lookup_values fvl12
145039: , fnd_lookup_values fvl38
145040: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
145041: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
145042: AND xet.event_class_code = C_EVENT_CLASS_CODE
145043: AND h1.event_id = xet.event_id
145044: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

145182: END source_value
145183: , null source_meaning
145184: FROM xla_events_gt xet
145185: , CST_XLA_INV_LINES_V l2
145186: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
145187: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
145188: AND xet.event_class_code = C_EVENT_CLASS_CODE
145189: AND l2.event_id = xet.event_id
145190:

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

146500: , PO_REQ_HEADERS_REF_V h5
146501: , PSA_CST_XLA_UPG_V h6
146502: , fnd_lookup_values fvl12
146503: , fnd_lookup_values fvl38
146504: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
146505: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
146506: AND xet.event_class_code = C_EVENT_CLASS_CODE
146507: AND h1.event_id = xet.event_id
146508: 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 146650: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

146646: END source_value
146647: , null source_meaning
146648: FROM xla_events_gt xet
146649: , CST_XLA_INV_LINES_V l2
146650: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
146651: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
146652: AND xet.event_class_code = C_EVENT_CLASS_CODE
146653: AND l2.event_id = xet.event_id
146654:

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

148017: FROM xla_events_gt xet
148018: , CST_XLA_INV_HEADERS_V h1
148019: , fnd_lookup_values fvl12
148020: , fnd_lookup_values fvl38
148021: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
148022: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
148023: AND xet.event_class_code = C_EVENT_CLASS_CODE
148024: AND h1.event_id = xet.event_id
148025: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

148163: END source_value
148164: , null source_meaning
148165: FROM xla_events_gt xet
148166: , CST_XLA_INV_LINES_V l2
148167: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
148168: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
148169: AND xet.event_class_code = C_EVENT_CLASS_CODE
148170: AND l2.event_id = xet.event_id
148171:

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

149369: FROM xla_events_gt xet
149370: , CST_XLA_INV_HEADERS_V h1
149371: , fnd_lookup_values fvl12
149372: , fnd_lookup_values fvl38
149373: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
149374: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
149375: AND xet.event_class_code = C_EVENT_CLASS_CODE
149376: AND h1.event_id = xet.event_id
149377: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

149515: END source_value
149516: , null source_meaning
149517: FROM xla_events_gt xet
149518: , CST_XLA_INV_LINES_V l2
149519: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
149520: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
149521: AND xet.event_class_code = C_EVENT_CLASS_CODE
149522: AND l2.event_id = xet.event_id
149523:

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

150659: , PO_REQ_HEADERS_REF_V h5
150660: , PSA_CST_XLA_UPG_V h6
150661: , fnd_lookup_values fvl12
150662: , fnd_lookup_values fvl38
150663: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
150664: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150665: AND xet.event_class_code = C_EVENT_CLASS_CODE
150666: AND h1.event_id = xet.event_id
150667: 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 150809: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

150805: END source_value
150806: , null source_meaning
150807: FROM xla_events_gt xet
150808: , CST_XLA_INV_LINES_V l2
150809: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
150810: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150811: AND xet.event_class_code = C_EVENT_CLASS_CODE
150812: AND l2.event_id = xet.event_id
150813:

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

151981: FROM xla_events_gt xet
151982: , CST_XLA_INV_HEADERS_V h1
151983: , fnd_lookup_values fvl12
151984: , fnd_lookup_values fvl38
151985: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
151986: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
151987: AND xet.event_class_code = C_EVENT_CLASS_CODE
151988: AND h1.event_id = xet.event_id
151989: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

152127: END source_value
152128: , null source_meaning
152129: FROM xla_events_gt xet
152130: , CST_XLA_INV_LINES_V l2
152131: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
152132: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
152133: AND xet.event_class_code = C_EVENT_CLASS_CODE
152134: AND l2.event_id = xet.event_id
152135:

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

153391: FROM xla_events_gt xet
153392: , CST_XLA_INV_HEADERS_V h1
153393: , fnd_lookup_values fvl12
153394: , fnd_lookup_values fvl38
153395: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
153396: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153397: AND xet.event_class_code = C_EVENT_CLASS_CODE
153398: AND h1.event_id = xet.event_id
153399: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

153537: END source_value
153538: , null source_meaning
153539: FROM xla_events_gt xet
153540: , CST_XLA_INV_LINES_V l2
153541: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
153542: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153543: AND xet.event_class_code = C_EVENT_CLASS_CODE
153544: AND l2.event_id = xet.event_id
153545:

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

154714: FROM xla_events_gt xet
154715: , CST_XLA_INV_HEADERS_V h1
154716: , fnd_lookup_values fvl12
154717: , fnd_lookup_values fvl38
154718: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
154719: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
154720: AND xet.event_class_code = C_EVENT_CLASS_CODE
154721: AND h1.event_id = xet.event_id
154722: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

154860: END source_value
154861: , null source_meaning
154862: FROM xla_events_gt xet
154863: , CST_XLA_INV_LINES_V l2
154864: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
154865: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
154866: AND xet.event_class_code = C_EVENT_CLASS_CODE
154867: AND l2.event_id = xet.event_id
154868:

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

155950: FROM xla_events_gt xet
155951: , CST_XLA_INV_HEADERS_V h1
155952: , fnd_lookup_values fvl12
155953: , fnd_lookup_values fvl38
155954: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
155955: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
155956: AND xet.event_class_code = C_EVENT_CLASS_CODE
155957: AND h1.event_id = xet.event_id
155958: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

156096: END source_value
156097: , null source_meaning
156098: FROM xla_events_gt xet
156099: , CST_XLA_INV_LINES_V l2
156100: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
156101: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156102: AND xet.event_class_code = C_EVENT_CLASS_CODE
156103: AND l2.event_id = xet.event_id
156104:

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

157261: , CST_XLA_RCV_REF_V h3
157262: , PO_DISTS_REF_V h4
157263: , fnd_lookup_values fvl12
157264: , fnd_lookup_values fvl38
157265: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
157266: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
157267: AND xet.event_class_code = C_EVENT_CLASS_CODE
157268: AND h1.event_id = xet.event_id
157269: 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 157391: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

157387: END source_value
157388: , null source_meaning
157389: FROM xla_events_gt xet
157390: , CST_XLA_RCV_LINES_V l2
157391: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
157392: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
157393: AND xet.event_class_code = C_EVENT_CLASS_CODE
157394: AND l2.event_id = xet.event_id
157395:

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

158525: , CST_XLA_RCV_REF_V h3
158526: , PO_DISTS_REF_V h4
158527: , fnd_lookup_values fvl12
158528: , fnd_lookup_values fvl38
158529: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
158530: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
158531: AND xet.event_class_code = C_EVENT_CLASS_CODE
158532: AND h1.event_id = xet.event_id
158533: 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 158655: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

158651: END source_value
158652: , null source_meaning
158653: FROM xla_events_gt xet
158654: , CST_XLA_RCV_LINES_V l2
158655: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
158656: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
158657: AND xet.event_class_code = C_EVENT_CLASS_CODE
158658: AND l2.event_id = xet.event_id
158659:

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

159725: , CST_XLA_INV_HEADERS_V h1
159726: , fnd_lookup_values fvl12
159727: , fnd_lookup_values fvl35
159728: , fnd_lookup_values fvl38
159729: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
159730: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159731: AND xet.event_class_code = C_EVENT_CLASS_CODE
159732: AND h1.event_id = xet.event_id
159733: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

159875: END source_value
159876: , null source_meaning
159877: FROM xla_events_gt xet
159878: , CST_XLA_INV_LINES_V l2
159879: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
159880: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159881: AND xet.event_class_code = C_EVENT_CLASS_CODE
159882: AND l2.event_id = xet.event_id
159883:

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

161041: FROM xla_events_gt xet
161042: , CST_XLA_INV_HEADERS_V h1
161043: , fnd_lookup_values fvl12
161044: , fnd_lookup_values fvl38
161045: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
161046: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161047: AND xet.event_class_code = C_EVENT_CLASS_CODE
161048: AND h1.event_id = xet.event_id
161049: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

161187: END source_value
161188: , null source_meaning
161189: FROM xla_events_gt xet
161190: , CST_XLA_INV_LINES_V l2
161191: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
161192: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161193: AND xet.event_class_code = C_EVENT_CLASS_CODE
161194: AND l2.event_id = xet.event_id
161195:

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

162292: FROM xla_events_gt xet
162293: , CST_XLA_WIP_HEADERS_V h1
162294: , fnd_lookup_values fvl12
162295: , fnd_lookup_values fvl38
162296: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
162297: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162298: AND xet.event_class_code = C_EVENT_CLASS_CODE
162299: AND h1.event_id = xet.event_id
162300: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

162418: END source_value
162419: , null source_meaning
162420: FROM xla_events_gt xet
162421: , CST_XLA_WIP_LINES_V l2
162422: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
162423: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162424: AND xet.event_class_code = C_EVENT_CLASS_CODE
162425: AND l2.event_id = xet.event_id
162426:

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

163662: , PO_HEADERS_REF_V h5
163663: , PSA_CST_XLA_PEA_UPG_V h6
163664: , fnd_lookup_values fvl12
163665: , fnd_lookup_values fvl38
163666: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
163667: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
163668: AND xet.event_class_code = C_EVENT_CLASS_CODE
163669: AND h1.event_id = xet.event_id
163670: 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 163792: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

163788: END source_value
163789: , null source_meaning
163790: FROM xla_events_gt xet
163791: , CST_XLA_RCV_LINES_V l2
163792: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
163793: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
163794: AND xet.event_class_code = C_EVENT_CLASS_CODE
163795: AND l2.event_id = xet.event_id
163796:

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

165029: , PO_HEADERS_REF_V h5
165030: , PSA_CST_XLA_UPG_V h6
165031: , fnd_lookup_values fvl12
165032: , fnd_lookup_values fvl38
165033: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
165034: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165035: AND xet.event_class_code = C_EVENT_CLASS_CODE
165036: AND h1.event_id = xet.event_id
165037: 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 165179: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

165175: END source_value
165176: , null source_meaning
165177: FROM xla_events_gt xet
165178: , CST_XLA_INV_LINES_V l2
165179: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
165180: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165181: AND xet.event_class_code = C_EVENT_CLASS_CODE
165182: AND l2.event_id = xet.event_id
165183:

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

166566: FROM xla_events_gt xet
166567: , CST_XLA_RCV_HEADERS_V h1
166568: , fnd_lookup_values fvl12
166569: , fnd_lookup_values fvl38
166570: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
166571: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
166572: AND xet.event_class_code = C_EVENT_CLASS_CODE
166573: AND h1.event_id = xet.event_id
166574: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

166692: END source_value
166693: , null source_meaning
166694: FROM xla_events_gt xet
166695: , CST_XLA_RCV_LINES_V l2
166696: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
166697: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
166698: AND xet.event_class_code = C_EVENT_CLASS_CODE
166699: AND l2.event_id = xet.event_id
166700:

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

167888: FROM xla_events_gt xet
167889: , CST_XLA_RCV_HEADERS_V h1
167890: , fnd_lookup_values fvl12
167891: , fnd_lookup_values fvl38
167892: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
167893: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
167894: AND xet.event_class_code = C_EVENT_CLASS_CODE
167895: AND h1.event_id = xet.event_id
167896: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

168014: END source_value
168015: , null source_meaning
168016: FROM xla_events_gt xet
168017: , CST_XLA_RCV_LINES_V l2
168018: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
168019: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168020: AND xet.event_class_code = C_EVENT_CLASS_CODE
168021: AND l2.event_id = xet.event_id
168022:

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

169120: FROM xla_events_gt xet
169121: , CST_XLA_RCV_HEADERS_V h1
169122: , fnd_lookup_values fvl12
169123: , fnd_lookup_values fvl38
169124: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
169125: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
169126: AND xet.event_class_code = C_EVENT_CLASS_CODE
169127: AND h1.event_id = xet.event_id
169128: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

169246: END source_value
169247: , null source_meaning
169248: FROM xla_events_gt xet
169249: , CST_XLA_RCV_LINES_V l2
169250: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
169251: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
169252: AND xet.event_class_code = C_EVENT_CLASS_CODE
169253: AND l2.event_id = xet.event_id
169254:

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

170369: FROM xla_events_gt xet
170370: , CST_XLA_INV_HEADERS_V h1
170371: , fnd_lookup_values fvl12
170372: , fnd_lookup_values fvl38
170373: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
170374: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
170375: AND xet.event_class_code = C_EVENT_CLASS_CODE
170376: AND h1.event_id = xet.event_id
170377: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

170515: END source_value
170516: , null source_meaning
170517: FROM xla_events_gt xet
170518: , CST_XLA_INV_LINES_V l2
170519: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
170520: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
170521: AND xet.event_class_code = C_EVENT_CLASS_CODE
170522: AND l2.event_id = xet.event_id
170523:

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

171663: FROM xla_events_gt xet
171664: , CST_XLA_INV_HEADERS_V h1
171665: , fnd_lookup_values fvl12
171666: , fnd_lookup_values fvl38
171667: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
171668: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
171669: AND xet.event_type_code = C_EVENT_TYPE_CODE
171670: AND h1.event_id = xet.event_id
171671: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

171808: END source_value
171809: , null source_meaning
171810: FROM xla_events_gt xet
171811: , CST_XLA_INV_LINES_V l2
171812: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
171813: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
171814: AND xet.event_type_code = C_EVENT_TYPE_CODE
171815: AND l2.event_id = xet.event_id
171816:

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

172957: FROM xla_events_gt xet
172958: , CST_XLA_INV_HEADERS_V h1
172959: , fnd_lookup_values fvl12
172960: , fnd_lookup_values fvl38
172961: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
172962: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
172963: AND xet.event_type_code = C_EVENT_TYPE_CODE
172964: AND h1.event_id = xet.event_id
172965: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

173102: END source_value
173103: , null source_meaning
173104: FROM xla_events_gt xet
173105: , CST_XLA_INV_LINES_V l2
173106: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
173107: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
173108: AND xet.event_type_code = C_EVENT_TYPE_CODE
173109: AND l2.event_id = xet.event_id
173110:

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

174193: FROM xla_events_gt xet
174194: , CST_XLA_INV_HEADERS_V h1
174195: , fnd_lookup_values fvl12
174196: , fnd_lookup_values fvl38
174197: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
174198: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174199: AND xet.event_type_code = C_EVENT_TYPE_CODE
174200: AND h1.event_id = xet.event_id
174201: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

174338: END source_value
174339: , null source_meaning
174340: FROM xla_events_gt xet
174341: , CST_XLA_INV_LINES_V l2
174342: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
174343: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174344: AND xet.event_type_code = C_EVENT_TYPE_CODE
174345: AND l2.event_id = xet.event_id
174346:

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

175603: FROM xla_events_gt xet
175604: , CST_XLA_INV_HEADERS_V h1
175605: , fnd_lookup_values fvl12
175606: , fnd_lookup_values fvl38
175607: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
175608: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
175609: AND xet.event_type_code = C_EVENT_TYPE_CODE
175610: AND h1.event_id = xet.event_id
175611: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

175748: END source_value
175749: , null source_meaning
175750: FROM xla_events_gt xet
175751: , CST_XLA_INV_LINES_V l2
175752: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
175753: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
175754: AND xet.event_type_code = C_EVENT_TYPE_CODE
175755: AND l2.event_id = xet.event_id
175756:

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

177013: FROM xla_events_gt xet
177014: , CST_XLA_INV_HEADERS_V h1
177015: , fnd_lookup_values fvl12
177016: , fnd_lookup_values fvl38
177017: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
177018: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177019: AND xet.event_type_code = C_EVENT_TYPE_CODE
177020: AND h1.event_id = xet.event_id
177021: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

177158: END source_value
177159: , null source_meaning
177160: FROM xla_events_gt xet
177161: , CST_XLA_INV_LINES_V l2
177162: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
177163: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177164: AND xet.event_type_code = C_EVENT_TYPE_CODE
177165: AND l2.event_id = xet.event_id
177166:

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

178423: FROM xla_events_gt xet
178424: , CST_XLA_INV_HEADERS_V h1
178425: , fnd_lookup_values fvl12
178426: , fnd_lookup_values fvl38
178427: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
178428: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
178429: AND xet.event_type_code = C_EVENT_TYPE_CODE
178430: AND h1.event_id = xet.event_id
178431: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

178568: END source_value
178569: , null source_meaning
178570: FROM xla_events_gt xet
178571: , CST_XLA_INV_LINES_V l2
178572: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
178573: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
178574: AND xet.event_type_code = C_EVENT_TYPE_CODE
178575: AND l2.event_id = xet.event_id
178576:

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

179833: FROM xla_events_gt xet
179834: , CST_XLA_INV_HEADERS_V h1
179835: , fnd_lookup_values fvl12
179836: , fnd_lookup_values fvl38
179837: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
179838: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
179839: AND xet.event_type_code = C_EVENT_TYPE_CODE
179840: AND h1.event_id = xet.event_id
179841: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

179978: END source_value
179979: , null source_meaning
179980: FROM xla_events_gt xet
179981: , CST_XLA_INV_LINES_V l2
179982: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
179983: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
179984: AND xet.event_type_code = C_EVENT_TYPE_CODE
179985: AND l2.event_id = xet.event_id
179986:

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

181243: FROM xla_events_gt xet
181244: , CST_XLA_INV_HEADERS_V h1
181245: , fnd_lookup_values fvl12
181246: , fnd_lookup_values fvl38
181247: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
181248: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
181249: AND xet.event_type_code = C_EVENT_TYPE_CODE
181250: AND h1.event_id = xet.event_id
181251: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

181388: END source_value
181389: , null source_meaning
181390: FROM xla_events_gt xet
181391: , CST_XLA_INV_LINES_V l2
181392: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
181393: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
181394: AND xet.event_type_code = C_EVENT_TYPE_CODE
181395: AND l2.event_id = xet.event_id
181396:

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

182653: FROM xla_events_gt xet
182654: , CST_XLA_INV_HEADERS_V h1
182655: , fnd_lookup_values fvl12
182656: , fnd_lookup_values fvl38
182657: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
182658: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
182659: AND xet.event_type_code = C_EVENT_TYPE_CODE
182660: AND h1.event_id = xet.event_id
182661: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

182798: END source_value
182799: , null source_meaning
182800: FROM xla_events_gt xet
182801: , CST_XLA_INV_LINES_V l2
182802: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
182803: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
182804: AND xet.event_type_code = C_EVENT_TYPE_CODE
182805: AND l2.event_id = xet.event_id
182806:

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

183889: FROM xla_events_gt xet
183890: , CST_XLA_INV_HEADERS_V h1
183891: , fnd_lookup_values fvl12
183892: , fnd_lookup_values fvl38
183893: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
183894: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
183895: AND xet.event_type_code = C_EVENT_TYPE_CODE
183896: AND h1.event_id = xet.event_id
183897: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

184034: END source_value
184035: , null source_meaning
184036: FROM xla_events_gt xet
184037: , CST_XLA_INV_LINES_V l2
184038: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
184039: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
184040: AND xet.event_type_code = C_EVENT_TYPE_CODE
184041: AND l2.event_id = xet.event_id
184042:

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

185299: FROM xla_events_gt xet
185300: , CST_XLA_INV_HEADERS_V h1
185301: , fnd_lookup_values fvl12
185302: , fnd_lookup_values fvl38
185303: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
185304: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
185305: AND xet.event_type_code = C_EVENT_TYPE_CODE
185306: AND h1.event_id = xet.event_id
185307: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

185444: END source_value
185445: , null source_meaning
185446: FROM xla_events_gt xet
185447: , CST_XLA_INV_LINES_V l2
185448: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
185449: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
185450: AND xet.event_type_code = C_EVENT_TYPE_CODE
185451: AND l2.event_id = xet.event_id
185452:

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

186709: FROM xla_events_gt xet
186710: , CST_XLA_INV_HEADERS_V h1
186711: , fnd_lookup_values fvl12
186712: , fnd_lookup_values fvl38
186713: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
186714: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
186715: AND xet.event_type_code = C_EVENT_TYPE_CODE
186716: AND h1.event_id = xet.event_id
186717: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

186854: END source_value
186855: , null source_meaning
186856: FROM xla_events_gt xet
186857: , CST_XLA_INV_LINES_V l2
186858: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
186859: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
186860: AND xet.event_type_code = C_EVENT_TYPE_CODE
186861: AND l2.event_id = xet.event_id
186862:

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

188032: FROM xla_events_gt xet
188033: , CST_XLA_INV_HEADERS_V h1
188034: , fnd_lookup_values fvl12
188035: , fnd_lookup_values fvl38
188036: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
188037: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
188038: AND xet.event_type_code = C_EVENT_TYPE_CODE
188039: AND h1.event_id = xet.event_id
188040: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

188177: END source_value
188178: , null source_meaning
188179: FROM xla_events_gt xet
188180: , CST_XLA_INV_LINES_V l2
188181: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
188182: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
188183: AND xet.event_type_code = C_EVENT_TYPE_CODE
188184: AND l2.event_id = xet.event_id
188185:

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

189355: FROM xla_events_gt xet
189356: , CST_XLA_INV_HEADERS_V h1
189357: , fnd_lookup_values fvl12
189358: , fnd_lookup_values fvl38
189359: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
189360: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
189361: AND xet.event_type_code = C_EVENT_TYPE_CODE
189362: AND h1.event_id = xet.event_id
189363: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

189500: END source_value
189501: , null source_meaning
189502: FROM xla_events_gt xet
189503: , CST_XLA_INV_LINES_V l2
189504: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
189505: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
189506: AND xet.event_type_code = C_EVENT_TYPE_CODE
189507: AND l2.event_id = xet.event_id
189508:

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

190620: FROM xla_events_gt xet
190621: , CST_XLA_INV_HEADERS_V h1
190622: , fnd_lookup_values fvl12
190623: , fnd_lookup_values fvl38
190624: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
190625: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
190626: AND xet.event_type_code = C_EVENT_TYPE_CODE
190627: AND h1.event_id = xet.event_id
190628: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

190765: END source_value
190766: , null source_meaning
190767: FROM xla_events_gt xet
190768: , CST_XLA_INV_LINES_V l2
190769: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
190770: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
190771: AND xet.event_type_code = C_EVENT_TYPE_CODE
190772: AND l2.event_id = xet.event_id
190773:

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

191856: FROM xla_events_gt xet
191857: , CST_XLA_INV_HEADERS_V h1
191858: , fnd_lookup_values fvl12
191859: , fnd_lookup_values fvl38
191860: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
191861: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
191862: AND xet.event_type_code = C_EVENT_TYPE_CODE
191863: AND h1.event_id = xet.event_id
191864: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

192001: END source_value
192002: , null source_meaning
192003: FROM xla_events_gt xet
192004: , CST_XLA_INV_LINES_V l2
192005: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
192006: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
192007: AND xet.event_type_code = C_EVENT_TYPE_CODE
192008: AND l2.event_id = xet.event_id
192009:

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

193092: FROM xla_events_gt xet
193093: , CST_XLA_INV_HEADERS_V h1
193094: , fnd_lookup_values fvl12
193095: , fnd_lookup_values fvl38
193096: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
193097: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
193098: AND xet.event_type_code = C_EVENT_TYPE_CODE
193099: AND h1.event_id = xet.event_id
193100: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

193237: END source_value
193238: , null source_meaning
193239: FROM xla_events_gt xet
193240: , CST_XLA_INV_LINES_V l2
193241: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
193242: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
193243: AND xet.event_type_code = C_EVENT_TYPE_CODE
193244: AND l2.event_id = xet.event_id
193245:

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

194348: FROM xla_events_gt xet
194349: , CST_XLA_WIP_HEADERS_V h1
194350: , fnd_lookup_values fvl12
194351: , fnd_lookup_values fvl38
194352: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
194353: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
194354: AND xet.event_class_code = C_EVENT_CLASS_CODE
194355: AND h1.event_id = xet.event_id
194356: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

194474: END source_value
194475: , null source_meaning
194476: FROM xla_events_gt xet
194477: , CST_XLA_WIP_LINES_V l2
194478: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
194479: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
194480: AND xet.event_class_code = C_EVENT_CLASS_CODE
194481: AND l2.event_id = xet.event_id
194482:

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

195559: FROM xla_events_gt xet
195560: , CST_XLA_WIP_HEADERS_V h1
195561: , fnd_lookup_values fvl12
195562: , fnd_lookup_values fvl38
195563: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
195564: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
195565: AND xet.event_class_code = C_EVENT_CLASS_CODE
195566: AND h1.event_id = xet.event_id
195567: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

195685: END source_value
195686: , null source_meaning
195687: FROM xla_events_gt xet
195688: , CST_XLA_WIP_LINES_V l2
195689: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
195690: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
195691: AND xet.event_class_code = C_EVENT_CLASS_CODE
195692: AND l2.event_id = xet.event_id
195693:

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

196770: FROM xla_events_gt xet
196771: , CST_XLA_WIP_HEADERS_V h1
196772: , fnd_lookup_values fvl12
196773: , fnd_lookup_values fvl38
196774: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
196775: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
196776: AND xet.event_class_code = C_EVENT_CLASS_CODE
196777: AND h1.event_id = xet.event_id
196778: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

196896: END source_value
196897: , null source_meaning
196898: FROM xla_events_gt xet
196899: , CST_XLA_WIP_LINES_V l2
196900: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
196901: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
196902: AND xet.event_class_code = C_EVENT_CLASS_CODE
196903: AND l2.event_id = xet.event_id
196904:

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

197961: FROM xla_events_gt xet
197962: , CST_XLA_INV_HEADERS_V h1
197963: , fnd_lookup_values fvl12
197964: , fnd_lookup_values fvl38
197965: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
197966: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
197967: AND xet.event_class_code = C_EVENT_CLASS_CODE
197968: AND h1.event_id = xet.event_id
197969: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

198107: END source_value
198108: , null source_meaning
198109: FROM xla_events_gt xet
198110: , CST_XLA_INV_LINES_V l2
198111: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
198112: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
198113: AND xet.event_class_code = C_EVENT_CLASS_CODE
198114: AND l2.event_id = xet.event_id
198115: