APPS.XLA_AAD_MERGE_ANALYSIS_PVT dependencies on XLA_ACCT_LINE_TYPES_B

Line 3912: FROM xla_acct_line_types_b w

3908: CURSOR c_comp IS
3909: SELECT w.event_class_code
3910: , w.accounting_line_type_code
3911: , w.accounting_line_code
3912: FROM xla_acct_line_types_b w
3913: WHERE w.application_id = g_application_id
3914: AND w.amb_context_code = g_amb_context_code
3915: AND w.accounting_line_type_code = C_OWNER_ORACLE
3916: AND NOT EXISTS (

Line 3918: FROM xla_acct_line_types_b s

3914: AND w.amb_context_code = g_amb_context_code
3915: AND w.accounting_line_type_code = C_OWNER_ORACLE
3916: AND NOT EXISTS (
3917: SELECT 1
3918: FROM xla_acct_line_types_b s
3919: WHERE s.application_id = g_application_id
3920: AND s.amb_context_code = g_staging_context_code
3921: AND s.event_class_code = w.event_class_code
3922: AND s.accounting_line_type_code = w.accounting_line_type_code

Line 3931: , xla_acct_line_types_b b

3927: , w.accounting_line_type_code
3928: ,w.accounting_line_code
3929: ,w.accounting_attribute_code
3930: FROM xla_jlt_acct_attrs w
3931: , xla_acct_line_types_b b
3932: WHERE b.amb_context_code = g_staging_context_code
3933: AND b.application_id = g_application_id
3934: AND b.accounting_line_type_code = w.accounting_line_type_code
3935: AND b.accounting_line_code = w.accounting_line_code

Line 5827: JOIN xla_acct_line_types_b b

5823: , w.source_code w_source_code
5824: , s.event_class_default_flag s_event_class_default_flag
5825: , w.event_class_default_flag w_event_class_default_flag
5826: FROM xla_jlt_acct_attrs s
5827: JOIN xla_acct_line_types_b b
5828: ON b.application_id = g_application_id
5829: AND b.amb_context_code = g_amb_context_code
5830: AND b.event_class_code = s.event_class_code
5831: AND b.accounting_line_type_code = s.accounting_line_type_code

Line 5982: FROM xla_acct_line_types_b s

5978: ,s.encumbrance_type_id s_encumbrance_type_id
5979: ,w.encumbrance_type_id w_encumbrance_type_id
5980: ,s.mpa_option_code s_mpa_option_code
5981: ,w.mpa_option_code w_mpa_option_code
5982: FROM xla_acct_line_types_b s
5983: JOIN xla_acct_line_types_tl ts
5984: ON ts.application_id = s.application_id
5985: AND ts.amb_context_code = s.amb_context_code
5986: AND ts.entity_code = s.entity_code

Line 5992: JOIN xla_acct_line_types_b w

5988: AND ts.accounting_line_type_code = s.accounting_line_type_code
5989: AND ts.accounting_line_code = s.accounting_line_code
5990: AND ts.accounting_line_code = s.accounting_line_code
5991: AND ts.language = USERENV('LANG')
5992: JOIN xla_acct_line_types_b w
5993: ON w.application_id = s.application_id
5994: AND w.entity_code = s.entity_code
5995: AND w.event_class_code = s.event_class_code
5996: AND w.accounting_line_type_code = s.accounting_line_type_code

Line 6762: JOIN xla_acct_line_types_b sl

6758: AND w.line_definition_owner_code = s.line_definition_owner_code
6759: AND w.line_definition_code = s.line_definition_code
6760: AND w.accounting_line_type_code = s.accounting_line_type_code
6761: AND w.accounting_line_code = s.accounting_line_code
6762: JOIN xla_acct_line_types_b sl
6763: ON sl.application_id = s.application_id
6764: AND sl.amb_context_code = s.amb_context_code
6765: AND sl.event_class_code = s.event_class_code
6766: AND sl.accounting_line_type_code = s.accounting_line_type_code

Line 6768: JOIN xla_acct_line_types_b wl

6764: AND sl.amb_context_code = s.amb_context_code
6765: AND sl.event_class_code = s.event_class_code
6766: AND sl.accounting_line_type_code = s.accounting_line_type_code
6767: AND sl.accounting_line_code = s.accounting_line_code
6768: JOIN xla_acct_line_types_b wl
6769: ON wl.application_id = w.application_id
6770: AND wl.amb_context_code = w.amb_context_code
6771: AND wl.event_class_code = w.event_class_code
6772: AND wl.accounting_line_type_code = w.accounting_line_type_code