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_SOURCES_PKG dependencies on XLA_SEG_RULE_DETAILS

Line 98: FROM xla_seg_rule_details sd

94: IS
95: SELECT a.application_id, a.amb_context_code, a.segment_rule_type_code, a.segment_rule_code
96: FROM xla_seg_rules_b a
97: WHERE exists (SELECT 'x'
98: FROM xla_seg_rule_details sd
99: WHERE ((value_source_application_id = p_der_application_id
100: AND value_source_type_code = p_der_source_type_code
101: AND value_source_code = p_der_source_code)
102: OR (input_source_application_id = p_der_application_id

Line 112: FROM xla_conditions c, xla_seg_rule_details sd

108: AND sd.segment_rule_type_code = a.segment_rule_type_code
109: AND sd.segment_rule_code = a.segment_rule_code
110: UNION
111: SELECT 'x'
112: FROM xla_conditions c, xla_seg_rule_details sd
113: WHERE ((c.source_application_id = p_der_application_id
114: AND c.source_code = p_der_source_code
115: AND c.source_type_code = p_der_source_type_code)
116: OR (c.value_source_application_id = p_der_application_id

Line 234: FROM xla_seg_rule_details sd,

230: AND value_source_type_code = p_der_source_type_code
231: AND value_source_code = p_der_source_code
232: AND value_source_code IS NOT NULL))
233: AND exists (SELECT 'x'
234: FROM xla_seg_rule_details sd,
235: xla_tab_acct_def_details pl, xla_tab_acct_defs_b p
236: WHERE sd.segment_rule_detail_id = c.segment_rule_detail_id
237: AND pl.application_id = sd.application_id
238: AND pl.amb_context_code = sd.amb_context_code

Line 251: FROM xla_seg_rule_details sd

247:
248: CURSOR check_sr_details
249: IS
250: SELECT 'x'
251: FROM xla_seg_rule_details sd
252: WHERE ((value_source_application_id = p_der_application_id
253: AND value_source_type_code = p_der_source_type_code
254: AND value_source_code = p_der_source_code)
255: OR (input_source_application_id = p_der_application_id

Line 448: FROM xla_seg_rule_details sd

444: IS
445: SELECT a.application_id, a.amb_context_code, a.segment_rule_type_code, a.segment_rule_code
446: FROM xla_seg_rules_b a
447: WHERE exists (SELECT 'x'
448: FROM xla_seg_rule_details sd
449: WHERE ((value_source_application_id = p_der_application_id
450: AND value_source_type_code = p_der_source_type_code
451: AND value_source_code = p_der_source_code)
452: OR (input_source_application_id = p_der_application_id

Line 462: FROM xla_conditions c, xla_seg_rule_details sd

458: AND sd.segment_rule_type_code = a.segment_rule_type_code
459: AND sd.segment_rule_code = a.segment_rule_code
460: UNION
461: SELECT 'x'
462: FROM xla_conditions c, xla_seg_rule_details sd
463: WHERE ((c.source_application_id = p_der_application_id
464: AND c.source_code = p_der_source_code
465: AND c.source_type_code = p_der_source_type_code)
466: OR (c.value_source_application_id = p_der_application_id

Line 868: FROM xla_seg_rule_details xsd,

864: AND value_source_type_code = p_der_source_type_code
865: AND value_source_code = p_der_source_code
866: AND value_source_code IS NOT NULL))
867: AND exists (SELECT 'x'
868: FROM xla_seg_rule_details xsd,
869: xla_line_defn_adr_assgns xld,
870: xla_aad_line_defn_assgns xal,
871: xla_prod_acct_headers xpa
872: WHERE xsd.segment_rule_detail_id = xco.segment_rule_detail_id

Line 928: FROM xla_seg_rule_details xsr

924:
925: CURSOR check_sr_details
926: IS
927: SELECT 'x'
928: FROM xla_seg_rule_details xsr
929: WHERE ((value_source_application_id = p_der_application_id
930: AND value_source_type_code = p_der_source_type_code
931: AND value_source_code = p_der_source_code)
932: OR (input_source_application_id = p_der_application_id

Line 1291: FROM xla_seg_rule_details

1287: SELECT 'x'
1288: FROM DUAL
1289: WHERE EXISTS
1290: (SELECT 'x'
1291: FROM xla_seg_rule_details
1292: WHERE value_source_application_id = p_application_id
1293: AND value_source_code = p_source_code
1294: AND value_source_type_code = p_source_type_code
1295: AND value_source_code is not null

Line 1298: FROM xla_seg_rule_details

1294: AND value_source_type_code = p_source_type_code
1295: AND value_source_code is not null
1296: UNION
1297: SELECT 'x'
1298: FROM xla_seg_rule_details
1299: WHERE input_source_application_id = p_application_id
1300: AND input_source_code = p_source_code
1301: AND input_source_type_code = p_source_type_code
1302: AND input_source_code is not null);

Line 1325: FROM xla_seg_rule_details

1321:
1322: CURSOR check_input_source
1323: IS
1324: SELECT 'x'
1325: FROM xla_seg_rule_details
1326: WHERE input_source_application_id = p_application_id
1327: AND input_source_code = p_source_code
1328: AND input_source_type_code = p_source_type_code
1329: AND input_source_code is not null;

Line 1933: FROM xla_seg_rule_details xsr

1929: AND value_source_type_code = p_source_type_code
1930: AND value_source_code = p_source_code
1931: AND value_source_code IS NOT NULL))
1932: AND exists (SELECT 'x'
1933: FROM xla_seg_rule_details xsr
1934: ,xla_line_defn_adr_assgns xld
1935: ,xla_aad_line_defn_assgns xal
1936: ,xla_prod_acct_headers xpa
1937: WHERE xsr.segment_rule_detail_id = xco.segment_rule_detail_id

Line 1994: FROM xla_seg_rule_details sd

1990:
1991: CURSOR check_sr_details
1992: IS
1993: SELECT 'x'
1994: FROM xla_seg_rule_details sd
1995: WHERE ((value_source_application_id = p_application_id
1996: AND value_source_type_code = p_source_type_code
1997: AND value_source_code = p_source_code)
1998: OR (input_source_application_id = p_application_id

Line 2479: FROM xla_seg_rule_details sd

2475: IS
2476: SELECT a.application_id, a.amb_context_code, a.segment_rule_type_code, a.segment_rule_code
2477: FROM xla_seg_rules_b a
2478: WHERE exists (SELECT 'x'
2479: FROM xla_seg_rule_details sd
2480: WHERE ((value_source_application_id = p_application_id
2481: AND value_source_type_code = p_source_type_code
2482: AND value_source_code = p_source_code)
2483: OR (input_source_application_id = p_application_id

Line 2493: FROM xla_conditions c, xla_seg_rule_details sd

2489: AND sd.segment_rule_type_code = a.segment_rule_type_code
2490: AND sd.segment_rule_code = a.segment_rule_code
2491: UNION
2492: SELECT 'x'
2493: FROM xla_conditions c, xla_seg_rule_details sd
2494: WHERE ((c.source_application_id = p_application_id
2495: AND c.source_code = p_source_code
2496: AND c.source_type_code = p_source_type_code)
2497: OR (c.value_source_application_id = p_application_id

Line 3212: FROM xla_seg_rule_details sd,

3208: AND value_source_type_code = p_source_type_code
3209: AND value_source_code = p_source_code
3210: AND value_source_code IS NOT NULL))
3211: AND exists (SELECT 'x'
3212: FROM xla_seg_rule_details sd,
3213: xla_tab_acct_def_details pl, xla_tab_acct_defs_b p
3214: WHERE sd.segment_rule_detail_id = c.segment_rule_detail_id
3215: AND pl.application_id = sd.application_id
3216: AND pl.amb_context_code = sd.amb_context_code

Line 3228: FROM xla_seg_rule_details sd

3224:
3225: CURSOR check_sr_details
3226: IS
3227: SELECT 'x'
3228: FROM xla_seg_rule_details sd
3229: WHERE ((value_source_application_id = p_application_id
3230: AND value_source_type_code = p_source_type_code
3231: AND value_source_code = p_source_code)
3232: OR (input_source_application_id = p_application_id

Line 3419: FROM xla_seg_rule_details sd

3415: IS
3416: SELECT a.application_id, a.amb_context_code, a.segment_rule_type_code, a.segment_rule_code
3417: FROM xla_seg_rules_b a
3418: WHERE exists (SELECT 'x'
3419: FROM xla_seg_rule_details sd
3420: WHERE ((value_source_application_id = p_application_id
3421: AND value_source_type_code = p_source_type_code
3422: AND value_source_code = p_source_code)
3423: OR (input_source_application_id = p_application_id

Line 3433: FROM xla_conditions c, xla_seg_rule_details sd

3429: AND sd.segment_rule_type_code = a.segment_rule_type_code
3430: AND sd.segment_rule_code = a.segment_rule_code
3431: UNION
3432: SELECT 'x'
3433: FROM xla_conditions c, xla_seg_rule_details sd
3434: WHERE ((c.source_application_id = p_application_id
3435: AND c.source_code = p_source_code
3436: AND c.source_type_code = p_source_type_code)
3437: OR (c.value_source_application_id = p_application_id

Line 3591: FROM xla_seg_rule_details s

3587:
3588: CURSOR check_det_value_source
3589: IS
3590: SELECT 'x'
3591: FROM xla_seg_rule_details s
3592: WHERE s.value_source_application_id = p_application_id
3593: AND s.value_source_code = p_source_code
3594: AND s.value_source_type_code = p_source_type_code
3595: AND s.value_source_code is not null

Line 3607: FROM xla_seg_rule_details s

3603:
3604: CURSOR check_det_input_source
3605: IS
3606: SELECT 'x'
3607: FROM xla_seg_rule_details s
3608: WHERE s.input_source_application_id = p_application_id
3609: AND s.input_source_code = p_source_code
3610: AND s.input_source_type_code = p_source_type_code
3611: AND s.input_source_code is not null

Line 3630: FROM xla_tab_acct_def_details d, xla_seg_rule_details s

3626: WHERE c.source_application_id = p_application_id
3627: AND c.source_code = p_source_code
3628: AND c.source_type_code = p_source_type_code
3629: AND exists (SELECT 'x'
3630: FROM xla_tab_acct_def_details d, xla_seg_rule_details s
3631: WHERE s.application_id = d.application_id
3632: AND d.account_type_code = p_account_type_code
3633: AND s.amb_context_code = d.amb_context_code
3634: AND s.segment_rule_code = d.segment_rule_code

Line 3647: FROM xla_tab_acct_def_details d, xla_seg_rule_details s

3643: AND value_source_code = p_source_code
3644: AND value_source_type_code = p_source_type_code
3645: AND value_source_code is not null
3646: AND exists (SELECT 'x'
3647: FROM xla_tab_acct_def_details d, xla_seg_rule_details s
3648: WHERE s.application_id = d.application_id
3649: AND d.account_type_code = p_account_type_code
3650: AND s.amb_context_code = d.amb_context_code
3651: AND s.segment_rule_code = d.segment_rule_code