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_AAD_EXPORT_PVT dependencies on XLA_PROD_ACCT_HEADERS

Line 848: FROM xla_prod_acct_headers h

844: AND xal2.product_rule_code = grp.product_rule_code
845: AND grp.group_num = l_curr_group_num)
846: UNION
847: SELECT h.product_rule_code -- header description
848: FROM xla_prod_acct_headers h
849: WHERE h.application_id = p_application_id
850: AND h.amb_context_code = p_amb_context_code
851: AND h.product_rule_type_code = p_owner_type
852: AND EXISTS (SELECT 1

Line 853: FROM xla_prod_acct_headers pah

849: WHERE h.application_id = p_application_id
850: AND h.amb_context_code = p_amb_context_code
851: AND h.product_rule_type_code = p_owner_type
852: AND EXISTS (SELECT 1
853: FROM xla_prod_acct_headers pah
854: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
855: WHERE pah.application_id = p_application_id
856: AND pah.amb_context_code = p_amb_context_code
857: AND pah.description_type_code = h.description_type_code

Line 930: FROM xla_prod_acct_headers pah

926: AND xal.application_id = p_application_id
927: AND xal.amb_context_code = p_amb_context_code
928: AND xal.product_rule_type_code = p_owner_type
929: AND EXISTS (SELECT 1
930: FROM xla_prod_acct_headers pah
931: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
932: WHERE pah.application_id = p_application_id
933: AND pah.amb_context_code = p_amb_context_code
934: AND pah.description_type_code = h.description_type_code

Line 1007: FROM xla_prod_acct_headers pah

1003: AND xal.application_id = p_application_id
1004: AND xal.amb_context_code = p_amb_context_code
1005: AND xal.product_rule_type_code = p_owner_type
1006: AND EXISTS (SELECT 1
1007: FROM xla_prod_acct_headers pah
1008: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1009: WHERE pah.application_id = p_application_id
1010: AND pah.amb_context_code = p_amb_context_code
1011: AND pah.description_type_code = h.mpa_header_desc_type_code

Line 1084: FROM xla_prod_acct_headers pah

1080: AND xal.application_id = p_application_id
1081: AND xal.amb_context_code = p_amb_context_code
1082: AND xal.product_rule_type_code = p_owner_type
1083: AND EXISTS (SELECT 1
1084: FROM xla_prod_acct_headers pah
1085: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1086: WHERE pah.application_id = p_application_id
1087: AND pah.amb_context_code = p_amb_context_code
1088: AND pah.description_type_code = h.description_type_code