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

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

74076: END source_meaning
74077: FROM xla_events_gt xet
74078: , PA_XLA_EXP_HEADER_V h2
74079: , fnd_lookup_values fvl73
74080: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
74081: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74082: AND xet.event_class_code = C_EVENT_CLASS_CODE
74083: AND h2.event_id = xet.event_id
74084: AND fvl73.lookup_type(+) = 'TP_AMOUNT_TYPE'

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

74274: END source_meaning
74275: FROM xla_events_gt xet
74276: , PA_XLA_CCDL_LINES_V l1
74277: , fnd_lookup_values fvl35
74278: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
74279: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74280: AND xet.event_class_code = C_EVENT_CLASS_CODE
74281: AND l1.event_id = xet.event_id
74282: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

75484: END source_meaning
75485: FROM xla_events_gt xet
75486: , PA_XLA_EXP_HEADER_V h2
75487: , fnd_lookup_values fvl73
75488: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
75489: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75490: AND xet.event_class_code = C_EVENT_CLASS_CODE
75491: AND h2.event_id = xet.event_id
75492: AND fvl73.lookup_type(+) = 'TP_AMOUNT_TYPE'

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

75682: END source_meaning
75683: FROM xla_events_gt xet
75684: , PA_XLA_CCDL_LINES_V l1
75685: , fnd_lookup_values fvl35
75686: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
75687: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75688: AND xet.event_class_code = C_EVENT_CLASS_CODE
75689: AND l1.event_id = xet.event_id
75690: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

76903: FROM xla_events_gt xet
76904: , PA_XLA_BC_BUDGET_HEADER_V h1
76905: , PA_XLA_PROJECT_REF_V h3
76906: , fnd_lookup_values fvl38
76907: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
76908: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76909: AND xet.event_class_code = C_EVENT_CLASS_CODE
76910: AND h1.event_id = xet.event_id
76911: AND h3.project_id=h1.project_id AND fvl38.lookup_type(+) = 'PROJECT TYPE CLASS'

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

77070: END source_meaning
77071: FROM xla_events_gt xet
77072: , PA_XLA_BC_BUDGET_LINES_V l2
77073: , fnd_lookup_values fvl35
77074: , (select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
77075: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77076: AND xet.event_class_code = C_EVENT_CLASS_CODE
77077: AND l2.event_id = xet.event_id
77078: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

78219: END source_value
78220: , null source_meaning
78221: FROM xla_events_gt xet
78222: , PA_XLA_EXP_HEADER_V h2
78223: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
78224: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78225: AND xet.event_class_code = C_EVENT_CLASS_CODE
78226: AND h2.event_id = xet.event_id
78227:

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

78478: END source_meaning
78479: FROM xla_events_gt xet
78480: , PA_XLA_CDL_LINES_V l1
78481: , fnd_lookup_values fvl35
78482: , (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
78483: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78484: AND xet.event_class_code = C_EVENT_CLASS_CODE
78485: AND l1.event_id = xet.event_id
78486: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

79786: END source_value
79787: , null source_meaning
79788: FROM xla_events_gt xet
79789: , PA_XLA_EXP_HEADER_V h2
79790: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
79791: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79792: AND xet.event_class_code = C_EVENT_CLASS_CODE
79793: AND h2.event_id = xet.event_id
79794:

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

80045: END source_meaning
80046: FROM xla_events_gt xet
80047: , PA_XLA_CDL_LINES_V l1
80048: , fnd_lookup_values fvl35
80049: , (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
80050: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
80051: AND xet.event_class_code = C_EVENT_CLASS_CODE
80052: AND l1.event_id = xet.event_id
80053: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

81353: END source_value
81354: , null source_meaning
81355: FROM xla_events_gt xet
81356: , PA_XLA_EXP_HEADER_V h2
81357: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
81358: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81359: AND xet.event_class_code = C_EVENT_CLASS_CODE
81360: AND h2.event_id = xet.event_id
81361:

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

81547: END source_meaning
81548: FROM xla_events_gt xet
81549: , PA_XLA_CDL_LINES_V l1
81550: , fnd_lookup_values fvl35
81551: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
81552: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81553: AND xet.event_class_code = C_EVENT_CLASS_CODE
81554: AND l1.event_id = xet.event_id
81555: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

82725: END source_value
82726: , null source_meaning
82727: FROM xla_events_gt xet
82728: , PA_XLA_EXP_HEADER_V h2
82729: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
82730: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
82731: AND xet.event_class_code = C_EVENT_CLASS_CODE
82732: AND h2.event_id = xet.event_id
82733:

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

82919: END source_meaning
82920: FROM xla_events_gt xet
82921: , PA_XLA_CDL_LINES_V l1
82922: , fnd_lookup_values fvl35
82923: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
82924: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
82925: AND xet.event_class_code = C_EVENT_CLASS_CODE
82926: AND l1.event_id = xet.event_id
82927: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

84097: END source_value
84098: , null source_meaning
84099: FROM xla_events_gt xet
84100: , PA_XLA_EXP_HEADER_V h2
84101: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
84102: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
84103: AND xet.event_class_code = C_EVENT_CLASS_CODE
84104: AND h2.event_id = xet.event_id
84105:

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

84291: END source_meaning
84292: FROM xla_events_gt xet
84293: , PA_XLA_CDL_LINES_V l1
84294: , fnd_lookup_values fvl35
84295: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
84296: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
84297: AND xet.event_class_code = C_EVENT_CLASS_CODE
84298: AND l1.event_id = xet.event_id
84299: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

85469: END source_value
85470: , null source_meaning
85471: FROM xla_events_gt xet
85472: , PA_XLA_EXP_HEADER_V h2
85473: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
85474: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
85475: AND xet.event_class_code = C_EVENT_CLASS_CODE
85476: AND h2.event_id = xet.event_id
85477:

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

85663: END source_meaning
85664: FROM xla_events_gt xet
85665: , PA_XLA_CDL_LINES_V l1
85666: , fnd_lookup_values fvl35
85667: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
85668: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
85669: AND xet.event_class_code = C_EVENT_CLASS_CODE
85670: AND l1.event_id = xet.event_id
85671: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

86841: END source_value
86842: , null source_meaning
86843: FROM xla_events_gt xet
86844: , PA_XLA_EXP_HEADER_V h2
86845: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
86846: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
86847: AND xet.event_class_code = C_EVENT_CLASS_CODE
86848: AND h2.event_id = xet.event_id
86849:

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

87035: END source_meaning
87036: FROM xla_events_gt xet
87037: , PA_XLA_CDL_LINES_V l1
87038: , fnd_lookup_values fvl35
87039: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
87040: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
87041: AND xet.event_class_code = C_EVENT_CLASS_CODE
87042: AND l1.event_id = xet.event_id
87043: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

88213: END source_value
88214: , null source_meaning
88215: FROM xla_events_gt xet
88216: , PA_XLA_EXP_HEADER_V h2
88217: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
88218: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
88219: AND xet.event_class_code = C_EVENT_CLASS_CODE
88220: AND h2.event_id = xet.event_id
88221:

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

88407: END source_meaning
88408: FROM xla_events_gt xet
88409: , PA_XLA_CDL_LINES_V l1
88410: , fnd_lookup_values fvl35
88411: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
88412: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
88413: AND xet.event_class_code = C_EVENT_CLASS_CODE
88414: AND l1.event_id = xet.event_id
88415: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

89585: END source_value
89586: , null source_meaning
89587: FROM xla_events_gt xet
89588: , PA_XLA_EXP_HEADER_V h2
89589: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
89590: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
89591: AND xet.event_class_code = C_EVENT_CLASS_CODE
89592: AND h2.event_id = xet.event_id
89593:

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

89779: END source_meaning
89780: FROM xla_events_gt xet
89781: , PA_XLA_CCDL_LINES_V l1
89782: , fnd_lookup_values fvl35
89783: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
89784: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
89785: AND xet.event_class_code = C_EVENT_CLASS_CODE
89786: AND l1.event_id = xet.event_id
89787: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

90883: END source_value
90884: , null source_meaning
90885: FROM xla_events_gt xet
90886: , PA_XLA_EXP_HEADER_V h2
90887: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
90888: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
90889: AND xet.event_class_code = C_EVENT_CLASS_CODE
90890: AND h2.event_id = xet.event_id
90891:

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

91077: END source_meaning
91078: FROM xla_events_gt xet
91079: , PA_XLA_CCDL_LINES_V l1
91080: , fnd_lookup_values fvl35
91081: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
91082: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
91083: AND xet.event_class_code = C_EVENT_CLASS_CODE
91084: AND l1.event_id = xet.event_id
91085: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

92205: ELSE null
92206: END source_meaning
92207: FROM xla_events_gt xet
92208: , PA_XLA_REVENUE_HEADERS_V h2
92209: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
92210: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
92211: AND xet.event_class_code = C_EVENT_CLASS_CODE
92212: AND h2.event_id = xet.event_id
92213:

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

92429: FROM xla_events_gt xet
92430: , PA_XLA_EVENT_TYPE_REF_V l1
92431: , PA_XLA_REVENUE_LINES_ADJ_V l3
92432: , fnd_lookup_values fvl72
92433: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
92434: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
92435: AND xet.event_class_code = C_EVENT_CLASS_CODE
92436: AND l3.event_id = xet.event_id
92437: AND l1.rev_event_type (+) =l3.rev_event_type AND fvl72.lookup_type(+) = 'EVENT TYPE CLASSIFICATION'

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

93974: ELSE null
93975: END source_meaning
93976: FROM xla_events_gt xet
93977: , PA_XLA_REVENUE_HEADERS_V h2
93978: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
93979: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
93980: AND xet.event_class_code = C_EVENT_CLASS_CODE
93981: AND h2.event_id = xet.event_id
93982:

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

94158: FROM xla_events_gt xet
94159: , PA_XLA_EVENT_TYPE_REF_V l1
94160: , PA_XLA_REVENUE_LINES_V l3
94161: , fnd_lookup_values fvl72
94162: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
94163: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
94164: AND xet.event_class_code = C_EVENT_CLASS_CODE
94165: AND l3.event_id = xet.event_id
94166: AND l1.rev_event_type (+) =l3.rev_event_type AND fvl72.lookup_type(+) = 'EVENT TYPE CLASSIFICATION'

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

95743: END source_meaning
95744: FROM xla_events_gt xet
95745: , GMS_XLA_AWARD_REF_V h1
95746: , PA_XLA_EXP_HEADER_V h3
95747: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
95748: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
95749: AND xet.event_class_code = C_EVENT_CLASS_CODE
95750: AND h3.event_id = xet.event_id
95751: AND h1.expenditure_item_id (+) =h3.expenditure_item_id and h1.document_type (+) = 'exp'

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

95937: END source_meaning
95938: FROM xla_events_gt xet
95939: , PA_XLA_CDL_LINES_V l2
95940: , fnd_lookup_values fvl35
95941: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
95942: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
95943: AND xet.event_class_code = C_EVENT_CLASS_CODE
95944: AND l2.event_id = xet.event_id
95945: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

97304: END source_meaning
97305: FROM xla_events_gt xet
97306: , GMS_XLA_AWARD_REF_V h1
97307: , PA_XLA_EXP_HEADER_V h3
97308: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
97309: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
97310: AND xet.event_class_code = C_EVENT_CLASS_CODE
97311: AND h3.event_id = xet.event_id
97312: AND h1.expenditure_item_id (+) =h3.expenditure_item_id and h1.document_type (+) = 'exp'

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

97498: END source_meaning
97499: FROM xla_events_gt xet
97500: , PA_XLA_CDL_LINES_V l2
97501: , fnd_lookup_values fvl35
97502: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
97503: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
97504: AND xet.event_class_code = C_EVENT_CLASS_CODE
97505: AND l2.event_id = xet.event_id
97506: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

98845: END source_value
98846: , null source_meaning
98847: FROM xla_events_gt xet
98848: , PA_XLA_EXP_HEADER_V h2
98849: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
98850: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
98851: AND xet.event_class_code = C_EVENT_CLASS_CODE
98852: AND h2.event_id = xet.event_id
98853:

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

99099: END source_meaning
99100: FROM xla_events_gt xet
99101: , PA_XLA_CDL_LINES_V l1
99102: , fnd_lookup_values fvl35
99103: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
99104: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
99105: AND xet.event_class_code = C_EVENT_CLASS_CODE
99106: AND l1.event_id = xet.event_id
99107: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

100394: END source_value
100395: , null source_meaning
100396: FROM xla_events_gt xet
100397: , PA_XLA_EXP_HEADER_V h2
100398: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
100399: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
100400: AND xet.event_class_code = C_EVENT_CLASS_CODE
100401: AND h2.event_id = xet.event_id
100402:

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

100653: END source_meaning
100654: FROM xla_events_gt xet
100655: , PA_XLA_CDL_LINES_V l1
100656: , fnd_lookup_values fvl35
100657: , (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
100658: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
100659: AND xet.event_class_code = C_EVENT_CLASS_CODE
100660: AND l1.event_id = xet.event_id
100661: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

101973: END source_value
101974: , null source_meaning
101975: FROM xla_events_gt xet
101976: , PA_XLA_EXP_HEADER_V h2
101977: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
101978: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
101979: AND xet.event_class_code = C_EVENT_CLASS_CODE
101980: AND h2.event_id = xet.event_id
101981:

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

102167: END source_meaning
102168: FROM xla_events_gt xet
102169: , PA_XLA_CDL_LINES_V l1
102170: , fnd_lookup_values fvl35
102171: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
102172: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
102173: AND xet.event_class_code = C_EVENT_CLASS_CODE
102174: AND l1.event_id = xet.event_id
102175: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

103345: END source_value
103346: , null source_meaning
103347: FROM xla_events_gt xet
103348: , PA_XLA_EXP_HEADER_V h2
103349: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
103350: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
103351: AND xet.event_class_code = C_EVENT_CLASS_CODE
103352: AND h2.event_id = xet.event_id
103353:

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

103539: END source_meaning
103540: FROM xla_events_gt xet
103541: , PA_XLA_CDL_LINES_V l1
103542: , fnd_lookup_values fvl35
103543: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
103544: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
103545: AND xet.event_class_code = C_EVENT_CLASS_CODE
103546: AND l1.event_id = xet.event_id
103547: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

104717: END source_value
104718: , null source_meaning
104719: FROM xla_events_gt xet
104720: , PA_XLA_EXP_HEADER_V h2
104721: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
104722: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
104723: AND xet.event_class_code = C_EVENT_CLASS_CODE
104724: AND h2.event_id = xet.event_id
104725:

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

104911: END source_meaning
104912: FROM xla_events_gt xet
104913: , PA_XLA_CDL_LINES_V l1
104914: , fnd_lookup_values fvl35
104915: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
104916: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
104917: AND xet.event_class_code = C_EVENT_CLASS_CODE
104918: AND l1.event_id = xet.event_id
104919: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

106089: END source_value
106090: , null source_meaning
106091: FROM xla_events_gt xet
106092: , PA_XLA_EXP_HEADER_V h2
106093: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
106094: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
106095: AND xet.event_class_code = C_EVENT_CLASS_CODE
106096: AND h2.event_id = xet.event_id
106097:

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

106283: END source_meaning
106284: FROM xla_events_gt xet
106285: , PA_XLA_CDL_LINES_V l1
106286: , fnd_lookup_values fvl35
106287: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
106288: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
106289: AND xet.event_class_code = C_EVENT_CLASS_CODE
106290: AND l1.event_id = xet.event_id
106291: AND fvl35.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'