DBA Data[Home] [Help]

APPS.XLA_LINE_DEFINITIONS_PVT dependencies on XLA_SEG_RULES_B

Line 1198: ,xla_seg_rules_b xsr

1194: CURSOR c_invalid_adrs IS
1195: SELECT distinct xsr.segment_rule_type_code, xsr.segment_rule_code
1196: FROM xla_line_defn_jlt_assgns xjl
1197: ,xla_line_defn_adr_assgns xad
1198: ,xla_seg_rules_b xsr
1199: WHERE xsr.application_id = xad.application_id
1200: AND xsr.amb_context_code = xad.amb_context_code
1201: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
1202: AND xsr.segment_rule_code = xad.segment_rule_code

Line 1226: ,xla_seg_rules_b xsr

1222: SELECT distinct xsr.application_id, xsr.amb_context_code,
1223: xsr.segment_rule_type_code, xsr.segment_rule_code
1224: FROM xla_line_defn_jlt_assgns xjl
1225: ,xla_line_defn_adr_assgns xad
1226: ,xla_seg_rules_b xsr
1227: WHERE xsr.application_id = xad.application_id
1228: AND xsr.amb_context_code = xad.amb_context_code
1229: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
1230: AND xsr.segment_rule_code = xad.segment_rule_code

Line 1253: ,xla_seg_rules_b xsr

1249:
1250: CURSOR c_invalid_child_adr IS
1251: SELECT xsd.value_segment_rule_type_code, xsd.value_segment_rule_code
1252: FROM xla_seg_rule_details xsd
1253: ,xla_seg_rules_b xsr
1254: WHERE xsd.application_id = l_adr.application_id
1255: AND xsd.amb_context_code = l_adr.amb_context_code
1256: AND xsd.segment_rule_type_code = l_adr.segment_rule_type_code
1257: AND xsd.segment_rule_code = l_adr.segment_rule_code

Line 1407: ,xla_seg_rules_b xsr

1403: SELECT distinct xsr.application_id, xsr.amb_context_code,
1404: xsr.segment_rule_type_code, xsr.segment_rule_code
1405: FROM xla_line_defn_jlt_assgns xjl
1406: ,xla_line_defn_adr_assgns xad
1407: ,xla_seg_rules_b xsr
1408: WHERE xsr.application_id = xad.application_id
1409: AND xsr.amb_context_code = xad.amb_context_code
1410: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
1411: AND xsr.segment_rule_code = xad.segment_rule_code

Line 8646: ,xla_seg_rules_b xsr

8642: CURSOR c_invalid_adrs IS
8643: SELECT distinct xsr.segment_rule_type_code, xsr.segment_rule_code
8644: FROM xla_line_defn_jlt_assgns xjl
8645: ,xla_mpa_jlt_adr_assgns xad
8646: ,xla_seg_rules_b xsr
8647: WHERE xsr.application_id = xad.application_id
8648: AND xsr.amb_context_code = xad.amb_context_code
8649: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
8650: AND xsr.segment_rule_code = xad.segment_rule_code

Line 8685: ,xla_seg_rules_b xsr

8681: SELECT distinct xsr.application_id, xsr.amb_context_code,
8682: xsr.segment_rule_type_code, xsr.segment_rule_code
8683: FROM xla_line_defn_jlt_assgns xjl
8684: ,xla_mpa_jlt_adr_assgns xad
8685: ,xla_seg_rules_b xsr
8686: WHERE xsr.application_id = xad.application_id
8687: AND xsr.amb_context_code = xad.amb_context_code
8688: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
8689: AND xsr.segment_rule_code = xad.segment_rule_code

Line 8722: ,xla_seg_rules_b xsr

8718:
8719: CURSOR c_invalid_child_adr IS
8720: SELECT xsd.value_segment_rule_type_code, xsd.value_segment_rule_code
8721: FROM xla_seg_rule_details xsd
8722: ,xla_seg_rules_b xsr
8723: WHERE xsd.application_id = l_adr.application_id
8724: AND xsd.amb_context_code = l_adr.amb_context_code
8725: AND xsd.segment_rule_type_code = l_adr.segment_rule_type_code
8726: AND xsd.segment_rule_code = l_adr.segment_rule_code

Line 8887: ,xla_seg_rules_b xsr

8883: SELECT distinct xsr.application_id, xsr.amb_context_code,
8884: xsr.segment_rule_type_code, xsr.segment_rule_code
8885: FROM xla_line_defn_jlt_assgns xjl
8886: ,xla_mpa_jlt_adr_assgns xad
8887: ,xla_seg_rules_b xsr
8888: WHERE xsr.application_id = xad.application_id
8889: AND xsr.amb_context_code = xad.amb_context_code
8890: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
8891: AND xsr.segment_rule_code = xad.segment_rule_code

Line 13908: FROM xla_line_defn_adr_assgns laa, xla_seg_rules_b seg

13904:
13905: CURSOR c_adr
13906: IS
13907: SELECT laa.flexfield_segment_code, seg.flex_value_set_id
13908: FROM xla_line_defn_adr_assgns laa, xla_seg_rules_b seg
13909: WHERE laa.application_id = p_application_id
13910: AND laa.amb_context_code = p_amb_context_code
13911: AND laa.event_class_code = p_event_class_code
13912: AND laa.event_type_code = p_event_type_code