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

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

55311: END source_meaning
55312: FROM xla_events_gt xet
55313: , PA_XLA_EXP_HEADER_V h2
55314: , fnd_lookup_values fvl67
55315: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
55316: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55317: AND xet.event_class_code = C_EVENT_CLASS_CODE
55318: AND h2.event_id = xet.event_id
55319: AND fvl67.lookup_type(+) = 'TP_AMOUNT_TYPE'

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

55509: END source_meaning
55510: FROM xla_events_gt xet
55511: , PA_XLA_CCDL_LINES_V l1
55512: , fnd_lookup_values fvl34
55513: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
55514: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55515: AND xet.event_class_code = C_EVENT_CLASS_CODE
55516: AND l1.event_id = xet.event_id
55517: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

56719: END source_meaning
56720: FROM xla_events_gt xet
56721: , PA_XLA_EXP_HEADER_V h2
56722: , fnd_lookup_values fvl67
56723: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
56724: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
56725: AND xet.event_class_code = C_EVENT_CLASS_CODE
56726: AND h2.event_id = xet.event_id
56727: AND fvl67.lookup_type(+) = 'TP_AMOUNT_TYPE'

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

56917: END source_meaning
56918: FROM xla_events_gt xet
56919: , PA_XLA_CCDL_LINES_V l1
56920: , fnd_lookup_values fvl34
56921: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
56922: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
56923: AND xet.event_class_code = C_EVENT_CLASS_CODE
56924: AND l1.event_id = xet.event_id
56925: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

58117: END source_value
58118: , null source_meaning
58119: FROM xla_events_gt xet
58120: , PA_XLA_BC_BUDGET_HEADER_V h1
58121: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
58122: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58123: AND xet.event_class_code = C_EVENT_CLASS_CODE
58124: AND h1.event_id = xet.event_id
58125:

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

58265: END source_meaning
58266: FROM xla_events_gt xet
58267: , PA_XLA_BC_BUDGET_LINES_V l2
58268: , fnd_lookup_values fvl34
58269: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
58270: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58271: AND xet.event_class_code = C_EVENT_CLASS_CODE
58272: AND l2.event_id = xet.event_id
58273: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

59241: END source_value
59242: , null source_meaning
59243: FROM xla_events_gt xet
59244: , PA_XLA_EXP_HEADER_V h2
59245: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
59246: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
59247: AND xet.event_class_code = C_EVENT_CLASS_CODE
59248: AND h2.event_id = xet.event_id
59249:

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

59500: END source_meaning
59501: FROM xla_events_gt xet
59502: , PA_XLA_CDL_LINES_V l1
59503: , fnd_lookup_values fvl34
59504: , (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
59505: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
59506: AND xet.event_class_code = C_EVENT_CLASS_CODE
59507: AND l1.event_id = xet.event_id
59508: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

60713: END source_value
60714: , null source_meaning
60715: FROM xla_events_gt xet
60716: , PA_XLA_EXP_HEADER_V h2
60717: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
60718: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
60719: AND xet.event_class_code = C_EVENT_CLASS_CODE
60720: AND h2.event_id = xet.event_id
60721:

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

61064: FROM xla_events_gt xet
61065: , PA_XLA_CDL_LINES_V l1
61066: , fnd_lookup_values fvl34
61067: , fnd_lookup_values fvl69
61068: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
61069: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
61070: AND xet.event_class_code = C_EVENT_CLASS_CODE
61071: AND l1.event_id = xet.event_id
61072: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

62718: END source_value
62719: , null source_meaning
62720: FROM xla_events_gt xet
62721: , PA_XLA_EXP_HEADER_V h2
62722: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
62723: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62724: AND xet.event_class_code = C_EVENT_CLASS_CODE
62725: AND h2.event_id = xet.event_id
62726:

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

62912: END source_meaning
62913: FROM xla_events_gt xet
62914: , PA_XLA_CDL_LINES_V l1
62915: , fnd_lookup_values fvl34
62916: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
62917: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62918: AND xet.event_class_code = C_EVENT_CLASS_CODE
62919: AND l1.event_id = xet.event_id
62920: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

64016: END source_value
64017: , null source_meaning
64018: FROM xla_events_gt xet
64019: , PA_XLA_EXP_HEADER_V h2
64020: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
64021: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64022: AND xet.event_class_code = C_EVENT_CLASS_CODE
64023: AND h2.event_id = xet.event_id
64024:

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

64210: END source_meaning
64211: FROM xla_events_gt xet
64212: , PA_XLA_CDL_LINES_V l1
64213: , fnd_lookup_values fvl34
64214: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
64215: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64216: AND xet.event_class_code = C_EVENT_CLASS_CODE
64217: AND l1.event_id = xet.event_id
64218: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

65314: END source_value
65315: , null source_meaning
65316: FROM xla_events_gt xet
65317: , PA_XLA_EXP_HEADER_V h2
65318: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
65319: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
65320: AND xet.event_class_code = C_EVENT_CLASS_CODE
65321: AND h2.event_id = xet.event_id
65322:

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

65508: END source_meaning
65509: FROM xla_events_gt xet
65510: , PA_XLA_CDL_LINES_V l1
65511: , fnd_lookup_values fvl34
65512: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
65513: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
65514: AND xet.event_class_code = C_EVENT_CLASS_CODE
65515: AND l1.event_id = xet.event_id
65516: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

66612: END source_value
66613: , null source_meaning
66614: FROM xla_events_gt xet
66615: , PA_XLA_EXP_HEADER_V h2
66616: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
66617: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66618: AND xet.event_class_code = C_EVENT_CLASS_CODE
66619: AND h2.event_id = xet.event_id
66620:

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

66806: END source_meaning
66807: FROM xla_events_gt xet
66808: , PA_XLA_CDL_LINES_V l1
66809: , fnd_lookup_values fvl34
66810: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
66811: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66812: AND xet.event_class_code = C_EVENT_CLASS_CODE
66813: AND l1.event_id = xet.event_id
66814: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

67910: END source_value
67911: , null source_meaning
67912: FROM xla_events_gt xet
67913: , PA_XLA_EXP_HEADER_V h2
67914: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
67915: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
67916: AND xet.event_class_code = C_EVENT_CLASS_CODE
67917: AND h2.event_id = xet.event_id
67918:

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

68104: END source_meaning
68105: FROM xla_events_gt xet
68106: , PA_XLA_CDL_LINES_V l1
68107: , fnd_lookup_values fvl34
68108: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
68109: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68110: AND xet.event_class_code = C_EVENT_CLASS_CODE
68111: AND l1.event_id = xet.event_id
68112: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

69208: END source_value
69209: , null source_meaning
69210: FROM xla_events_gt xet
69211: , PA_XLA_EXP_HEADER_V h2
69212: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
69213: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69214: AND xet.event_class_code = C_EVENT_CLASS_CODE
69215: AND h2.event_id = xet.event_id
69216:

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

69402: END source_meaning
69403: FROM xla_events_gt xet
69404: , PA_XLA_CDL_LINES_V l1
69405: , fnd_lookup_values fvl34
69406: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
69407: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69408: AND xet.event_class_code = C_EVENT_CLASS_CODE
69409: AND l1.event_id = xet.event_id
69410: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

70506: END source_value
70507: , null source_meaning
70508: FROM xla_events_gt xet
70509: , PA_XLA_EXP_HEADER_V h2
70510: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
70511: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70512: AND xet.event_class_code = C_EVENT_CLASS_CODE
70513: AND h2.event_id = xet.event_id
70514:

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

70700: END source_meaning
70701: FROM xla_events_gt xet
70702: , PA_XLA_CCDL_LINES_V l1
70703: , fnd_lookup_values fvl34
70704: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
70705: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70706: AND xet.event_class_code = C_EVENT_CLASS_CODE
70707: AND l1.event_id = xet.event_id
70708: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

71804: END source_value
71805: , null source_meaning
71806: FROM xla_events_gt xet
71807: , PA_XLA_EXP_HEADER_V h2
71808: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
71809: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71810: AND xet.event_class_code = C_EVENT_CLASS_CODE
71811: AND h2.event_id = xet.event_id
71812:

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

71998: END source_meaning
71999: FROM xla_events_gt xet
72000: , PA_XLA_CCDL_LINES_V l1
72001: , fnd_lookup_values fvl34
72002: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
72003: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72004: AND xet.event_class_code = C_EVENT_CLASS_CODE
72005: AND l1.event_id = xet.event_id
72006: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

73126: ELSE null
73127: END source_meaning
73128: FROM xla_events_gt xet
73129: , PA_XLA_REVENUE_HEADERS_V h2
73130: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
73131: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73132: AND xet.event_class_code = C_EVENT_CLASS_CODE
73133: AND h2.event_id = xet.event_id
73134:

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

73340: FROM xla_events_gt xet
73341: , PA_XLA_EVENT_TYPE_REF_V l1
73342: , PA_XLA_REVENUE_LINES_ADJ_V l3
73343: , fnd_lookup_values fvl58
73344: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
73345: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73346: AND xet.event_class_code = C_EVENT_CLASS_CODE
73347: AND l3.event_id = xet.event_id
73348: AND l1.rev_event_type (+) =l3.rev_event_type AND fvl58.lookup_type(+) = 'EVENT TYPE CLASSIFICATION'

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

74668: ELSE null
74669: END source_meaning
74670: FROM xla_events_gt xet
74671: , PA_XLA_REVENUE_HEADERS_V h2
74672: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
74673: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74674: AND xet.event_class_code = C_EVENT_CLASS_CODE
74675: AND h2.event_id = xet.event_id
74676:

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

74852: FROM xla_events_gt xet
74853: , PA_XLA_EVENT_TYPE_REF_V l1
74854: , PA_XLA_REVENUE_LINES_V l3
74855: , fnd_lookup_values fvl58
74856: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
74857: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74858: AND xet.event_class_code = C_EVENT_CLASS_CODE
74859: AND l3.event_id = xet.event_id
74860: AND l1.rev_event_type (+) =l3.rev_event_type AND fvl58.lookup_type(+) = 'EVENT TYPE CLASSIFICATION'

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

76292: ELSE null
76293: END source_meaning
76294: FROM xla_events_gt xet
76295: , PA_XLA_EXP_HEADER_V h2
76296: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
76297: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76298: AND xet.event_class_code = C_EVENT_CLASS_CODE
76299: AND h2.event_id = xet.event_id
76300:

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

76486: END source_meaning
76487: FROM xla_events_gt xet
76488: , PA_XLA_CDL_LINES_V l1
76489: , fnd_lookup_values fvl34
76490: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
76491: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76492: AND xet.event_class_code = C_EVENT_CLASS_CODE
76493: AND l1.event_id = xet.event_id
76494: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

77687: ELSE null
77688: END source_meaning
77689: FROM xla_events_gt xet
77690: , PA_XLA_EXP_HEADER_V h2
77691: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
77692: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77693: AND xet.event_class_code = C_EVENT_CLASS_CODE
77694: AND h2.event_id = xet.event_id
77695:

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

77881: END source_meaning
77882: FROM xla_events_gt xet
77883: , PA_XLA_CDL_LINES_V l1
77884: , fnd_lookup_values fvl34
77885: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
77886: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77887: AND xet.event_class_code = C_EVENT_CLASS_CODE
77888: AND l1.event_id = xet.event_id
77889: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

79073: END source_value
79074: , null source_meaning
79075: FROM xla_events_gt xet
79076: , PA_XLA_EXP_HEADER_V h2
79077: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
79078: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79079: AND xet.event_class_code = C_EVENT_CLASS_CODE
79080: AND h2.event_id = xet.event_id
79081:

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

79419: FROM xla_events_gt xet
79420: , PA_XLA_CDL_LINES_V l1
79421: , fnd_lookup_values fvl34
79422: , fnd_lookup_values fvl69
79423: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
79424: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79425: AND xet.event_class_code = C_EVENT_CLASS_CODE
79426: AND l1.event_id = xet.event_id
79427: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

81061: END source_value
81062: , null source_meaning
81063: FROM xla_events_gt xet
81064: , PA_XLA_EXP_HEADER_V h2
81065: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
81066: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81067: AND xet.event_class_code = C_EVENT_CLASS_CODE
81068: AND h2.event_id = xet.event_id
81069:

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

81412: FROM xla_events_gt xet
81413: , PA_XLA_CDL_LINES_V l1
81414: , fnd_lookup_values fvl34
81415: , fnd_lookup_values fvl69
81416: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
81417: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81418: AND xet.event_class_code = C_EVENT_CLASS_CODE
81419: AND l1.event_id = xet.event_id
81420: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

83079: END source_value
83080: , null source_meaning
83081: FROM xla_events_gt xet
83082: , PA_XLA_EXP_HEADER_V h2
83083: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
83084: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
83085: AND xet.event_class_code = C_EVENT_CLASS_CODE
83086: AND h2.event_id = xet.event_id
83087:

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

83273: END source_meaning
83274: FROM xla_events_gt xet
83275: , PA_XLA_CDL_LINES_V l1
83276: , fnd_lookup_values fvl34
83277: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
83278: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
83279: AND xet.event_class_code = C_EVENT_CLASS_CODE
83280: AND l1.event_id = xet.event_id
83281: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

84377: END source_value
84378: , null source_meaning
84379: FROM xla_events_gt xet
84380: , PA_XLA_EXP_HEADER_V h2
84381: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
84382: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
84383: AND xet.event_class_code = C_EVENT_CLASS_CODE
84384: AND h2.event_id = xet.event_id
84385:

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

84571: END source_meaning
84572: FROM xla_events_gt xet
84573: , PA_XLA_CDL_LINES_V l1
84574: , fnd_lookup_values fvl34
84575: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
84576: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
84577: AND xet.event_class_code = C_EVENT_CLASS_CODE
84578: AND l1.event_id = xet.event_id
84579: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

85675: END source_value
85676: , null source_meaning
85677: FROM xla_events_gt xet
85678: , PA_XLA_EXP_HEADER_V h2
85679: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
85680: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
85681: AND xet.event_class_code = C_EVENT_CLASS_CODE
85682: AND h2.event_id = xet.event_id
85683:

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

85869: END source_meaning
85870: FROM xla_events_gt xet
85871: , PA_XLA_CDL_LINES_V l1
85872: , fnd_lookup_values fvl34
85873: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
85874: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
85875: AND xet.event_class_code = C_EVENT_CLASS_CODE
85876: AND l1.event_id = xet.event_id
85877: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

86973: END source_value
86974: , null source_meaning
86975: FROM xla_events_gt xet
86976: , PA_XLA_EXP_HEADER_V h2
86977: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
86978: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
86979: AND xet.event_class_code = C_EVENT_CLASS_CODE
86980: AND h2.event_id = xet.event_id
86981:

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

87167: END source_meaning
87168: FROM xla_events_gt xet
87169: , PA_XLA_CDL_LINES_V l1
87170: , fnd_lookup_values fvl34
87171: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
87172: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
87173: AND xet.event_class_code = C_EVENT_CLASS_CODE
87174: AND l1.event_id = xet.event_id
87175: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'