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

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

55391: END source_meaning
55392: FROM xla_events_gt xet
55393: , PA_XLA_EXP_HEADER_V h2
55394: , fnd_lookup_values fvl67
55395: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
55396: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55397: AND xet.event_class_code = C_EVENT_CLASS_CODE
55398: AND h2.event_id = xet.event_id
55399: AND fvl67.lookup_type(+) = 'TP_AMOUNT_TYPE'

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

55589: END source_meaning
55590: FROM xla_events_gt xet
55591: , PA_XLA_CCDL_LINES_V l1
55592: , fnd_lookup_values fvl34
55593: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
55594: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55595: AND xet.event_class_code = C_EVENT_CLASS_CODE
55596: AND l1.event_id = xet.event_id
55597: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

56799: END source_meaning
56800: FROM xla_events_gt xet
56801: , PA_XLA_EXP_HEADER_V h2
56802: , fnd_lookup_values fvl67
56803: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
56804: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
56805: AND xet.event_class_code = C_EVENT_CLASS_CODE
56806: AND h2.event_id = xet.event_id
56807: AND fvl67.lookup_type(+) = 'TP_AMOUNT_TYPE'

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

56997: END source_meaning
56998: FROM xla_events_gt xet
56999: , PA_XLA_CCDL_LINES_V l1
57000: , fnd_lookup_values fvl34
57001: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
57002: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57003: AND xet.event_class_code = C_EVENT_CLASS_CODE
57004: AND l1.event_id = xet.event_id
57005: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

58197: END source_value
58198: , null source_meaning
58199: FROM xla_events_gt xet
58200: , PA_XLA_BC_BUDGET_HEADER_V h1
58201: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
58202: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58203: AND xet.event_class_code = C_EVENT_CLASS_CODE
58204: AND h1.event_id = xet.event_id
58205:

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

58345: END source_meaning
58346: FROM xla_events_gt xet
58347: , PA_XLA_BC_BUDGET_LINES_V l2
58348: , fnd_lookup_values fvl34
58349: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
58350: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58351: AND xet.event_class_code = C_EVENT_CLASS_CODE
58352: AND l2.event_id = xet.event_id
58353: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

59321: END source_value
59322: , null source_meaning
59323: FROM xla_events_gt xet
59324: , PA_XLA_EXP_HEADER_V h2
59325: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
59326: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
59327: AND xet.event_class_code = C_EVENT_CLASS_CODE
59328: AND h2.event_id = xet.event_id
59329:

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

59580: END source_meaning
59581: FROM xla_events_gt xet
59582: , PA_XLA_CDL_LINES_V l1
59583: , fnd_lookup_values fvl34
59584: , (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
59585: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
59586: AND xet.event_class_code = C_EVENT_CLASS_CODE
59587: AND l1.event_id = xet.event_id
59588: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

60793: END source_value
60794: , null source_meaning
60795: FROM xla_events_gt xet
60796: , PA_XLA_EXP_HEADER_V h2
60797: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
60798: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
60799: AND xet.event_class_code = C_EVENT_CLASS_CODE
60800: AND h2.event_id = xet.event_id
60801:

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

61144: FROM xla_events_gt xet
61145: , PA_XLA_CDL_LINES_V l1
61146: , fnd_lookup_values fvl34
61147: , fnd_lookup_values fvl70
61148: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
61149: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
61150: AND xet.event_class_code = C_EVENT_CLASS_CODE
61151: AND l1.event_id = xet.event_id
61152: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

62798: END source_value
62799: , null source_meaning
62800: FROM xla_events_gt xet
62801: , PA_XLA_EXP_HEADER_V h2
62802: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
62803: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62804: AND xet.event_class_code = C_EVENT_CLASS_CODE
62805: AND h2.event_id = xet.event_id
62806:

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

62992: END source_meaning
62993: FROM xla_events_gt xet
62994: , PA_XLA_CDL_LINES_V l1
62995: , fnd_lookup_values fvl34
62996: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
62997: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62998: AND xet.event_class_code = C_EVENT_CLASS_CODE
62999: AND l1.event_id = xet.event_id
63000: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

64096: END source_value
64097: , null source_meaning
64098: FROM xla_events_gt xet
64099: , PA_XLA_EXP_HEADER_V h2
64100: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
64101: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64102: AND xet.event_class_code = C_EVENT_CLASS_CODE
64103: AND h2.event_id = xet.event_id
64104:

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

64290: END source_meaning
64291: FROM xla_events_gt xet
64292: , PA_XLA_CDL_LINES_V l1
64293: , fnd_lookup_values fvl34
64294: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
64295: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64296: AND xet.event_class_code = C_EVENT_CLASS_CODE
64297: AND l1.event_id = xet.event_id
64298: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

65394: END source_value
65395: , null source_meaning
65396: FROM xla_events_gt xet
65397: , PA_XLA_EXP_HEADER_V h2
65398: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
65399: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
65400: AND xet.event_class_code = C_EVENT_CLASS_CODE
65401: AND h2.event_id = xet.event_id
65402:

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

65588: END source_meaning
65589: FROM xla_events_gt xet
65590: , PA_XLA_CDL_LINES_V l1
65591: , fnd_lookup_values fvl34
65592: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
65593: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
65594: AND xet.event_class_code = C_EVENT_CLASS_CODE
65595: AND l1.event_id = xet.event_id
65596: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

66692: END source_value
66693: , null source_meaning
66694: FROM xla_events_gt xet
66695: , PA_XLA_EXP_HEADER_V h2
66696: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
66697: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66698: AND xet.event_class_code = C_EVENT_CLASS_CODE
66699: AND h2.event_id = xet.event_id
66700:

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

66886: END source_meaning
66887: FROM xla_events_gt xet
66888: , PA_XLA_CDL_LINES_V l1
66889: , fnd_lookup_values fvl34
66890: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
66891: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66892: AND xet.event_class_code = C_EVENT_CLASS_CODE
66893: AND l1.event_id = xet.event_id
66894: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

67996: , null source_meaning
67997: FROM xla_events_gt xet
67998: , PA_XLA_EXP_HEADER_V h2
67999: , PA_XLA_PROJECT_REF_V h3
68000: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
68001: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68002: AND xet.event_class_code = C_EVENT_CLASS_CODE
68003: AND h2.event_id = xet.event_id
68004: AND h3.project_id=h2.project_id

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

68190: END source_meaning
68191: FROM xla_events_gt xet
68192: , PA_XLA_CDL_LINES_V l1
68193: , fnd_lookup_values fvl34
68194: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
68195: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68196: AND xet.event_class_code = C_EVENT_CLASS_CODE
68197: AND l1.event_id = xet.event_id
68198: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

69308: , null source_meaning
69309: FROM xla_events_gt xet
69310: , PA_XLA_EXP_HEADER_V h2
69311: , PA_XLA_PROJECT_REF_V h3
69312: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
69313: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69314: AND xet.event_class_code = C_EVENT_CLASS_CODE
69315: AND h2.event_id = xet.event_id
69316: AND h3.project_id=h2.project_id

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

69502: END source_meaning
69503: FROM xla_events_gt xet
69504: , PA_XLA_CDL_LINES_V l1
69505: , fnd_lookup_values fvl34
69506: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
69507: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69508: AND xet.event_class_code = C_EVENT_CLASS_CODE
69509: AND l1.event_id = xet.event_id
69510: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

70614: END source_value
70615: , null source_meaning
70616: FROM xla_events_gt xet
70617: , PA_XLA_EXP_HEADER_V h2
70618: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
70619: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70620: AND xet.event_class_code = C_EVENT_CLASS_CODE
70621: AND h2.event_id = xet.event_id
70622:

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

70808: END source_meaning
70809: FROM xla_events_gt xet
70810: , PA_XLA_CCDL_LINES_V l1
70811: , fnd_lookup_values fvl34
70812: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
70813: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70814: AND xet.event_class_code = C_EVENT_CLASS_CODE
70815: AND l1.event_id = xet.event_id
70816: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

71912: END source_value
71913: , null source_meaning
71914: FROM xla_events_gt xet
71915: , PA_XLA_EXP_HEADER_V h2
71916: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
71917: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71918: AND xet.event_class_code = C_EVENT_CLASS_CODE
71919: AND h2.event_id = xet.event_id
71920:

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

72106: END source_meaning
72107: FROM xla_events_gt xet
72108: , PA_XLA_CCDL_LINES_V l1
72109: , fnd_lookup_values fvl34
72110: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
72111: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72112: AND xet.event_class_code = C_EVENT_CLASS_CODE
72113: AND l1.event_id = xet.event_id
72114: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

73234: ELSE null
73235: END source_meaning
73236: FROM xla_events_gt xet
73237: , PA_XLA_REVENUE_HEADERS_V h2
73238: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
73239: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73240: AND xet.event_class_code = C_EVENT_CLASS_CODE
73241: AND h2.event_id = xet.event_id
73242:

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

73448: FROM xla_events_gt xet
73449: , PA_XLA_EVENT_TYPE_REF_V l1
73450: , PA_XLA_REVENUE_LINES_ADJ_V l3
73451: , fnd_lookup_values fvl58
73452: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
73453: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73454: AND xet.event_class_code = C_EVENT_CLASS_CODE
73455: AND l3.event_id = xet.event_id
73456: AND l1.rev_event_type (+) =l3.rev_event_type AND fvl58.lookup_type(+) = 'EVENT TYPE CLASSIFICATION'

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

74776: ELSE null
74777: END source_meaning
74778: FROM xla_events_gt xet
74779: , PA_XLA_REVENUE_HEADERS_V h2
74780: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
74781: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74782: AND xet.event_class_code = C_EVENT_CLASS_CODE
74783: AND h2.event_id = xet.event_id
74784:

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

74960: FROM xla_events_gt xet
74961: , PA_XLA_EVENT_TYPE_REF_V l1
74962: , PA_XLA_REVENUE_LINES_V l3
74963: , fnd_lookup_values fvl58
74964: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
74965: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74966: AND xet.event_class_code = C_EVENT_CLASS_CODE
74967: AND l3.event_id = xet.event_id
74968: AND l1.rev_event_type (+) =l3.rev_event_type AND fvl58.lookup_type(+) = 'EVENT TYPE CLASSIFICATION'

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

76400: ELSE null
76401: END source_meaning
76402: FROM xla_events_gt xet
76403: , PA_XLA_EXP_HEADER_V h2
76404: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
76405: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76406: AND xet.event_class_code = C_EVENT_CLASS_CODE
76407: AND h2.event_id = xet.event_id
76408:

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

76594: END source_meaning
76595: FROM xla_events_gt xet
76596: , PA_XLA_CDL_LINES_V l1
76597: , fnd_lookup_values fvl34
76598: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
76599: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76600: AND xet.event_class_code = C_EVENT_CLASS_CODE
76601: AND l1.event_id = xet.event_id
76602: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

77795: ELSE null
77796: END source_meaning
77797: FROM xla_events_gt xet
77798: , PA_XLA_EXP_HEADER_V h2
77799: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
77800: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77801: AND xet.event_class_code = C_EVENT_CLASS_CODE
77802: AND h2.event_id = xet.event_id
77803:

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

77989: END source_meaning
77990: FROM xla_events_gt xet
77991: , PA_XLA_CDL_LINES_V l1
77992: , fnd_lookup_values fvl34
77993: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
77994: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77995: AND xet.event_class_code = C_EVENT_CLASS_CODE
77996: AND l1.event_id = xet.event_id
77997: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

79181: END source_value
79182: , null source_meaning
79183: FROM xla_events_gt xet
79184: , PA_XLA_EXP_HEADER_V h2
79185: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
79186: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79187: AND xet.event_class_code = C_EVENT_CLASS_CODE
79188: AND h2.event_id = xet.event_id
79189:

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

79527: FROM xla_events_gt xet
79528: , PA_XLA_CDL_LINES_V l1
79529: , fnd_lookup_values fvl34
79530: , fnd_lookup_values fvl70
79531: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
79532: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79533: AND xet.event_class_code = C_EVENT_CLASS_CODE
79534: AND l1.event_id = xet.event_id
79535: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

81169: END source_value
81170: , null source_meaning
81171: FROM xla_events_gt xet
81172: , PA_XLA_EXP_HEADER_V h2
81173: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
81174: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81175: AND xet.event_class_code = C_EVENT_CLASS_CODE
81176: AND h2.event_id = xet.event_id
81177:

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

81520: FROM xla_events_gt xet
81521: , PA_XLA_CDL_LINES_V l1
81522: , fnd_lookup_values fvl34
81523: , fnd_lookup_values fvl70
81524: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
81525: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81526: AND xet.event_class_code = C_EVENT_CLASS_CODE
81527: AND l1.event_id = xet.event_id
81528: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

83187: END source_value
83188: , null source_meaning
83189: FROM xla_events_gt xet
83190: , PA_XLA_EXP_HEADER_V h2
83191: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
83192: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
83193: AND xet.event_class_code = C_EVENT_CLASS_CODE
83194: AND h2.event_id = xet.event_id
83195:

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

83381: END source_meaning
83382: FROM xla_events_gt xet
83383: , PA_XLA_CDL_LINES_V l1
83384: , fnd_lookup_values fvl34
83385: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
83386: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
83387: AND xet.event_class_code = C_EVENT_CLASS_CODE
83388: AND l1.event_id = xet.event_id
83389: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

84485: END source_value
84486: , null source_meaning
84487: FROM xla_events_gt xet
84488: , PA_XLA_EXP_HEADER_V h2
84489: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
84490: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
84491: AND xet.event_class_code = C_EVENT_CLASS_CODE
84492: AND h2.event_id = xet.event_id
84493:

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

84679: END source_meaning
84680: FROM xla_events_gt xet
84681: , PA_XLA_CDL_LINES_V l1
84682: , fnd_lookup_values fvl34
84683: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
84684: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
84685: AND xet.event_class_code = C_EVENT_CLASS_CODE
84686: AND l1.event_id = xet.event_id
84687: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

85783: END source_value
85784: , null source_meaning
85785: FROM xla_events_gt xet
85786: , PA_XLA_EXP_HEADER_V h2
85787: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
85788: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
85789: AND xet.event_class_code = C_EVENT_CLASS_CODE
85790: AND h2.event_id = xet.event_id
85791:

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

85977: END source_meaning
85978: FROM xla_events_gt xet
85979: , PA_XLA_CDL_LINES_V l1
85980: , fnd_lookup_values fvl34
85981: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
85982: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
85983: AND xet.event_class_code = C_EVENT_CLASS_CODE
85984: AND l1.event_id = xet.event_id
85985: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'

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

87081: END source_value
87082: , null source_meaning
87083: FROM xla_events_gt xet
87084: , PA_XLA_EXP_HEADER_V h2
87085: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
87086: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
87087: AND xet.event_class_code = C_EVENT_CLASS_CODE
87088: AND h2.event_id = xet.event_id
87089:

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

87275: END source_meaning
87276: FROM xla_events_gt xet
87277: , PA_XLA_CDL_LINES_V l1
87278: , fnd_lookup_values fvl34
87279: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
87280: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
87281: AND xet.event_class_code = C_EVENT_CLASS_CODE
87282: AND l1.event_id = xet.event_id
87283: AND fvl34.lookup_type(+) = 'COST DISTRIBUTION LINE TYPE'