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

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

13966: , PO_HEADERS_REF_V h5
13967: , PSA_CST_XLA_UPG_V h6
13968: , fnd_lookup_values fvl9
13969: , fnd_lookup_values fvl42
13970: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
13971: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
13972: AND xet.event_class_code = C_EVENT_CLASS_CODE
13973: AND h1.event_id = xet.event_id
13974: 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 fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

14077: END source_value
14078: , null source_meaning
14079: FROM xla_events_gt xet
14080: , CST_XLA_RCV_LINES_V l2
14081: , (select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
14082: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
14083: AND xet.event_class_code = C_EVENT_CLASS_CODE
14084: AND l2.event_id = xet.event_id
14085:

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

15289: , PO_REQ_HEADERS_REF_V h8
15290: , PSA_CST_XLA_UPG_V h9
15291: , fnd_lookup_values fvl9
15292: , fnd_lookup_values fvl42
15293: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
15294: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
15295: AND xet.event_class_code = C_EVENT_CLASS_CODE
15296: AND h1.event_id = xet.event_id
15297: AND h3.inv_organization_id (+) = h1.organization_id AND h4.ref_transaction_id = h1.transaction_id AND h5.inventory_item_id = h1.inventory_item_id and h5.organization_id = h1.organization_id AND h6.inv_transaction_type_id = h1.transaction_type_id AND h4.bus_flow_req_dist_id=h7.req_distribution_id (+) AND h4.bus_flow_req_id = h8.req_id (+) AND h4.rcv_transaction_id = h9.transaction_id (+) AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

15400: END source_value
15401: , null source_meaning
15402: FROM xla_events_gt xet
15403: , CST_XLA_INV_LINES_V l2
15404: , (select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
15405: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
15406: AND xet.event_class_code = C_EVENT_CLASS_CODE
15407: AND l2.event_id = xet.event_id
15408:

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

16550: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
16551: , CST_XLA_INV_TXN_TYPES_REF_V h5
16552: , fnd_lookup_values fvl9
16553: , fnd_lookup_values fvl42
16554: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
16555: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
16556: AND xet.event_type_code = C_EVENT_TYPE_CODE
16557: AND h1.event_id = xet.event_id
16558: AND h3.ref_transaction_id = h1.transaction_id AND h4.inventory_item_id = h1.inventory_item_id and h4.organization_id = h1.organization_id AND h5.inv_transaction_type_id = h1.transaction_type_id AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

16695: END source_value
16696: , null source_meaning
16697: FROM xla_events_gt xet
16698: , CST_XLA_INV_LINES_V l2
16699: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
16700: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
16701: AND xet.event_type_code = C_EVENT_TYPE_CODE
16702: AND l2.event_id = xet.event_id
16703:

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

17797: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
17798: , CST_XLA_INV_TXN_TYPES_REF_V h5
17799: , fnd_lookup_values fvl9
17800: , fnd_lookup_values fvl42
17801: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
17802: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
17803: AND xet.event_type_code = C_EVENT_TYPE_CODE
17804: AND h1.event_id = xet.event_id
17805: AND h3.ref_transaction_id = h1.transaction_id AND h4.inventory_item_id = h1.inventory_item_id and h4.organization_id = h1.organization_id AND h5.inv_transaction_type_id = h1.transaction_type_id AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

17942: END source_value
17943: , null source_meaning
17944: FROM xla_events_gt xet
17945: , CST_XLA_INV_LINES_V l2
17946: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
17947: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
17948: AND xet.event_type_code = C_EVENT_TYPE_CODE
17949: AND l2.event_id = xet.event_id
17950:

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

19113: , PO_REQ_HEADERS_REF_V h8
19114: , PSA_CST_XLA_UPG_V h9
19115: , fnd_lookup_values fvl9
19116: , fnd_lookup_values fvl42
19117: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
19118: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
19119: AND xet.event_type_code = C_EVENT_TYPE_CODE
19120: AND h1.event_id = xet.event_id
19121: AND h3.inv_organization_id (+) = h1.organization_id AND h4.ref_transaction_id = h1.transaction_id AND h5.inventory_item_id = h1.inventory_item_id and h5.organization_id = h1.organization_id AND h6.inv_transaction_type_id = h1.transaction_type_id AND h4.bus_flow_req_dist_id=h7.req_distribution_id (+) AND h4.bus_flow_req_id = h8.req_id (+) AND h4.rcv_transaction_id = h9.transaction_id (+) AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

19228: END source_value
19229: , null source_meaning
19230: FROM xla_events_gt xet
19231: , CST_XLA_INV_LINES_V l2
19232: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
19233: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
19234: AND xet.event_type_code = C_EVENT_TYPE_CODE
19235: AND l2.event_id = xet.event_id
19236:

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

20453: , PO_REQ_HEADERS_REF_V h8
20454: , PSA_CST_XLA_UPG_V h9
20455: , fnd_lookup_values fvl9
20456: , fnd_lookup_values fvl42
20457: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
20458: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
20459: AND xet.event_type_code = C_EVENT_TYPE_CODE
20460: AND h1.event_id = xet.event_id
20461: AND h3.inv_organization_id (+) = h1.organization_id AND h4.ref_transaction_id = h1.transaction_id AND h5.inventory_item_id = h1.inventory_item_id and h5.organization_id = h1.organization_id AND h6.inv_transaction_type_id = h1.transaction_type_id AND h4.bus_flow_req_dist_id=h7.req_distribution_id (+) AND h4.bus_flow_req_id = h8.req_id (+) AND h4.rcv_transaction_id = h9.transaction_id (+) AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

20568: END source_value
20569: , null source_meaning
20570: FROM xla_events_gt xet
20571: , CST_XLA_INV_LINES_V l2
20572: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
20573: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
20574: AND xet.event_type_code = C_EVENT_TYPE_CODE
20575: AND l2.event_id = xet.event_id
20576:

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

21696: FROM xla_events_gt xet
21697: , CST_XLA_INV_HEADERS_V h1
21698: , fnd_lookup_values fvl9
21699: , fnd_lookup_values fvl42
21700: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
21701: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
21702: AND xet.event_type_code = C_EVENT_TYPE_CODE
21703: AND h1.event_id = xet.event_id
21704: AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

21841: END source_value
21842: , null source_meaning
21843: FROM xla_events_gt xet
21844: , CST_XLA_INV_LINES_V l2
21845: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
21846: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
21847: AND xet.event_type_code = C_EVENT_TYPE_CODE
21848: AND l2.event_id = xet.event_id
21849:

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

22874: FROM xla_events_gt xet
22875: , CST_XLA_INV_HEADERS_V h1
22876: , fnd_lookup_values fvl9
22877: , fnd_lookup_values fvl42
22878: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
22879: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
22880: AND xet.event_type_code = C_EVENT_TYPE_CODE
22881: AND h1.event_id = xet.event_id
22882: AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

23019: END source_value
23020: , null source_meaning
23021: FROM xla_events_gt xet
23022: , CST_XLA_INV_LINES_V l2
23023: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
23024: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
23025: AND xet.event_type_code = C_EVENT_TYPE_CODE
23026: AND l2.event_id = xet.event_id
23027:

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

24080: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
24081: , CST_XLA_INV_TXN_TYPES_REF_V h5
24082: , fnd_lookup_values fvl9
24083: , fnd_lookup_values fvl42
24084: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
24085: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
24086: AND xet.event_type_code = C_EVENT_TYPE_CODE
24087: AND h1.event_id = xet.event_id
24088: AND h3.ref_transaction_id = h1.transaction_id AND h4.inventory_item_id = h1.inventory_item_id and h4.organization_id = h1.organization_id AND h5.inv_transaction_type_id = h1.transaction_type_id AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

24225: END source_value
24226: , null source_meaning
24227: FROM xla_events_gt xet
24228: , CST_XLA_INV_LINES_V l2
24229: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
24230: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
24231: AND xet.event_type_code = C_EVENT_TYPE_CODE
24232: AND l2.event_id = xet.event_id
24233:

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

25327: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
25328: , CST_XLA_INV_TXN_TYPES_REF_V h5
25329: , fnd_lookup_values fvl9
25330: , fnd_lookup_values fvl42
25331: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
25332: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
25333: AND xet.event_type_code = C_EVENT_TYPE_CODE
25334: AND h1.event_id = xet.event_id
25335: AND h3.ref_transaction_id = h1.transaction_id AND h4.inventory_item_id = h1.inventory_item_id and h4.organization_id = h1.organization_id AND h5.inv_transaction_type_id = h1.transaction_type_id AND fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

25472: END source_value
25473: , null source_meaning
25474: FROM xla_events_gt xet
25475: , CST_XLA_INV_LINES_V l2
25476: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
25477: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
25478: AND xet.event_type_code = C_EVENT_TYPE_CODE
25479: AND l2.event_id = xet.event_id
25480:

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

26643: , PO_HEADERS_REF_V h8
26644: , PSA_CST_XLA_UPG_V h9
26645: , fnd_lookup_values fvl9
26646: , fnd_lookup_values fvl42
26647: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
26648: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
26649: AND xet.event_type_code = C_EVENT_TYPE_CODE
26650: AND h1.event_id = xet.event_id
26651: AND h3.inv_organization_id (+) = h1.organization_id AND h4.ref_transaction_id = h1.transaction_id AND h5.inventory_item_id (+) = h1.inventory_item_id and h5.organization_id (+) = h1.organization_id AND h6.inv_transaction_type_id = h1.transaction_type_id AND h4.txn_po_header_id = h7.po_header_id (+) and h4.txn_po_distribution_id = h7.po_distribution_id (+) AND h4.txn_po_header_id = h8.po_header_id (+) AND h4.rcv_transaction_id = h9.transaction_id (+) AND fvl9.lookup_type(+) =

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

26759: END source_value
26760: , null source_meaning
26761: FROM xla_events_gt xet
26762: , CST_XLA_INV_LINES_V l2
26763: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
26764: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
26765: AND xet.event_type_code = C_EVENT_TYPE_CODE
26766: AND l2.event_id = xet.event_id
26767:

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

28019: , PO_HEADERS_REF_V h8
28020: , PSA_CST_XLA_UPG_V h9
28021: , fnd_lookup_values fvl9
28022: , fnd_lookup_values fvl42
28023: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
28024: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
28025: AND xet.event_type_code = C_EVENT_TYPE_CODE
28026: AND h1.event_id = xet.event_id
28027: AND h3.inv_organization_id (+) = h1.organization_id AND h4.ref_transaction_id = h1.transaction_id AND h5.inventory_item_id (+) = h1.inventory_item_id and h5.organization_id (+) = h1.organization_id AND h6.inv_transaction_type_id = h1.transaction_type_id AND h4.txn_po_header_id = h7.po_header_id (+) and h4.txn_po_distribution_id = h7.po_distribution_id (+) AND h4.txn_po_header_id = h8.po_header_id (+) AND h4.rcv_transaction_id = h9.transaction_id (+) AND fvl9.lookup_type(+) =

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

28135: END source_value
28136: , null source_meaning
28137: FROM xla_events_gt xet
28138: , CST_XLA_INV_LINES_V l2
28139: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
28140: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
28141: AND xet.event_type_code = C_EVENT_TYPE_CODE
28142: AND l2.event_id = xet.event_id
28143:

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

29395: , PO_HEADERS_REF_V h8
29396: , PSA_CST_XLA_UPG_V h9
29397: , fnd_lookup_values fvl9
29398: , fnd_lookup_values fvl42
29399: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
29400: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
29401: AND xet.event_type_code = C_EVENT_TYPE_CODE
29402: AND h1.event_id = xet.event_id
29403: AND h3.inv_organization_id (+) = h1.organization_id AND h4.ref_transaction_id = h1.transaction_id AND h5.inventory_item_id (+) = h1.inventory_item_id and h5.organization_id (+) = h1.organization_id AND h6.inv_transaction_type_id = h1.transaction_type_id AND h4.txn_po_header_id = h7.po_header_id (+) and h4.txn_po_distribution_id = h7.po_distribution_id (+) AND h4.txn_po_header_id = h8.po_header_id (+) AND h4.rcv_transaction_id = h9.transaction_id (+) AND fvl9.lookup_type(+) =

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

29511: END source_value
29512: , null source_meaning
29513: FROM xla_events_gt xet
29514: , CST_XLA_INV_LINES_V l2
29515: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
29516: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
29517: AND xet.event_type_code = C_EVENT_TYPE_CODE
29518: AND l2.event_id = xet.event_id
29519:

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

30738: , PO_HEADERS_REF_V h5
30739: , PSA_CST_XLA_PEA_UPG_V h6
30740: , fnd_lookup_values fvl9
30741: , fnd_lookup_values fvl42
30742: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
30743: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
30744: AND xet.event_class_code = C_EVENT_CLASS_CODE
30745: AND h1.event_id = xet.event_id
30746: 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 fvl9.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

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

30849: END source_value
30850: , null source_meaning
30851: FROM xla_events_gt xet
30852: , CST_XLA_RCV_LINES_V l2
30853: , (select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
30854: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
30855: AND xet.event_class_code = C_EVENT_CLASS_CODE
30856: AND l2.event_id = xet.event_id
30857:

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

32067: , PO_HEADERS_REF_V h8
32068: , PSA_CST_XLA_UPG_V h9
32069: , fnd_lookup_values fvl9
32070: , fnd_lookup_values fvl42
32071: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
32072: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
32073: AND xet.event_type_code = C_EVENT_TYPE_CODE
32074: AND h1.event_id = xet.event_id
32075: AND h3.inv_organization_id (+) = h1.organization_id AND h4.ref_transaction_id = h1.transaction_id AND h5.inventory_item_id (+) = h1.inventory_item_id and h5.organization_id (+) = h1.organization_id AND h6.inv_transaction_type_id = h1.transaction_type_id AND h4.txn_po_header_id = h7.po_header_id (+) and h4.txn_po_distribution_id = h7.po_distribution_id (+) AND h4.txn_po_header_id = h8.po_header_id (+) AND h4.rcv_transaction_id = h9.transaction_id (+) AND fvl9.lookup_type(+) =

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

32183: END source_value
32184: , null source_meaning
32185: FROM xla_events_gt xet
32186: , CST_XLA_INV_LINES_V l2
32187: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
32188: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
32189: AND xet.event_type_code = C_EVENT_TYPE_CODE
32190: AND l2.event_id = xet.event_id
32191:

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

33443: , PO_HEADERS_REF_V h8
33444: , PSA_CST_XLA_UPG_V h9
33445: , fnd_lookup_values fvl9
33446: , fnd_lookup_values fvl42
33447: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
33448: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
33449: AND xet.event_type_code = C_EVENT_TYPE_CODE
33450: AND h1.event_id = xet.event_id
33451: AND h3.inv_organization_id (+) = h1.organization_id AND h4.ref_transaction_id = h1.transaction_id AND h5.inventory_item_id (+) = h1.inventory_item_id and h5.organization_id (+) = h1.organization_id AND h6.inv_transaction_type_id = h1.transaction_type_id AND h4.txn_po_header_id = h7.po_header_id (+) and h4.txn_po_distribution_id = h7.po_distribution_id (+) AND h4.txn_po_header_id = h8.po_header_id (+) AND h4.rcv_transaction_id = h9.transaction_id (+) AND fvl9.lookup_type(+) =

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

33559: END source_value
33560: , null source_meaning
33561: FROM xla_events_gt xet
33562: , CST_XLA_INV_LINES_V l2
33563: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
33564: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
33565: AND xet.event_type_code = C_EVENT_TYPE_CODE
33566: AND l2.event_id = xet.event_id
33567:

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

34819: , PO_HEADERS_REF_V h8
34820: , PSA_CST_XLA_UPG_V h9
34821: , fnd_lookup_values fvl9
34822: , fnd_lookup_values fvl42
34823: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
34824: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
34825: AND xet.event_type_code = C_EVENT_TYPE_CODE
34826: AND h1.event_id = xet.event_id
34827: AND h3.inv_organization_id (+) = h1.organization_id AND h4.ref_transaction_id = h1.transaction_id AND h5.inventory_item_id (+) = h1.inventory_item_id and h5.organization_id (+) = h1.organization_id AND h6.inv_transaction_type_id = h1.transaction_type_id AND h4.txn_po_header_id = h7.po_header_id (+) and h4.txn_po_distribution_id = h7.po_distribution_id (+) AND h4.txn_po_header_id = h8.po_header_id (+) AND h4.rcv_transaction_id = h9.transaction_id (+) AND fvl9.lookup_type(+) =

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

34935: END source_value
34936: , null source_meaning
34937: FROM xla_events_gt xet
34938: , CST_XLA_INV_LINES_V l2
34939: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
34940: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
34941: AND xet.event_type_code = C_EVENT_TYPE_CODE
34942: AND l2.event_id = xet.event_id
34943: