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 5831: JOIN xla_acct_line_types_b b

5827: , w.source_code w_source_code
5828: , s.event_class_default_flag s_event_class_default_flag
5829: , w.event_class_default_flag w_event_class_default_flag
5830: FROM xla_jlt_acct_attrs s
5831: JOIN xla_acct_line_types_b b
5832: ON b.application_id = g_application_id
5833: AND b.amb_context_code = g_amb_context_code
5834: AND b.event_class_code = s.event_class_code
5835: AND b.accounting_line_type_code = s.accounting_line_type_code

Line 5986: FROM xla_acct_line_types_b s

5982: ,s.encumbrance_type_id s_encumbrance_type_id
5983: ,w.encumbrance_type_id w_encumbrance_type_id
5984: ,s.mpa_option_code s_mpa_option_code
5985: ,w.mpa_option_code w_mpa_option_code
5986: FROM xla_acct_line_types_b s
5987: JOIN xla_acct_line_types_tl ts
5988: ON ts.application_id = s.application_id
5989: AND ts.amb_context_code = s.amb_context_code
5990: AND ts.entity_code = s.entity_code

Line 5996: JOIN xla_acct_line_types_b w

5992: AND ts.accounting_line_type_code = s.accounting_line_type_code
5993: AND ts.accounting_line_code = s.accounting_line_code
5994: AND ts.accounting_line_code = s.accounting_line_code
5995: AND ts.language = USERENV('LANG')
5996: JOIN xla_acct_line_types_b w
5997: ON w.application_id = s.application_id
5998: AND w.entity_code = s.entity_code
5999: AND w.event_class_code = s.event_class_code
6000: AND w.accounting_line_type_code = s.accounting_line_type_code

Line 6772: JOIN xla_acct_line_types_b sl

6768: AND w.line_definition_owner_code = s.line_definition_owner_code
6769: AND w.line_definition_code = s.line_definition_code
6770: AND w.accounting_line_type_code = s.accounting_line_type_code
6771: AND w.accounting_line_code = s.accounting_line_code
6772: JOIN xla_acct_line_types_b sl
6773: ON sl.application_id = s.application_id
6774: AND sl.amb_context_code = s.amb_context_code
6775: AND sl.event_class_code = s.event_class_code
6776: AND sl.accounting_line_type_code = s.accounting_line_type_code

Line 6778: JOIN xla_acct_line_types_b wl

6774: AND sl.amb_context_code = s.amb_context_code
6775: AND sl.event_class_code = s.event_class_code
6776: AND sl.accounting_line_type_code = s.accounting_line_type_code
6777: AND sl.accounting_line_code = s.accounting_line_code
6778: JOIN xla_acct_line_types_b wl
6779: ON wl.application_id = w.application_id
6780: AND wl.amb_context_code = w.amb_context_code
6781: AND wl.event_class_code = w.event_class_code
6782: AND wl.accounting_line_type_code = w.accounting_line_type_code