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_PROD_ACCT_HEADERS

Line 746: , xla_prod_acct_headers xpa

742: AND source_code = p_der_source_code
743: AND source_type_code = p_der_source_type_code
744: AND exists (SELECT 'x'
745: FROM xla_aad_header_ac_assgns xah
746: , xla_prod_acct_headers xpa
747: WHERE xah.amb_context_code = xas.amb_context_code
748: AND xah.analytical_criterion_code = xas.analytical_criterion_code
749: AND xah.analytical_criterion_type_code = xas.analytical_criterion_type_code
750: AND xpa.application_id = xah.application_id

Line 761: , xla_prod_acct_headers xpa

757: UNION
758: SELECT 'x'
759: FROM xla_line_defn_ac_assgns xld
760: , xla_aad_line_defn_assgns xal
761: , xla_prod_acct_headers xpa
762: WHERE xld.amb_context_code = xas.amb_context_code
763: AND xld.analytical_criterion_code = xas.analytical_criterion_code
764: AND xld.analytical_criterion_type_code = xas.analytical_criterion_type_code
765: AND xal.application_id = xld.application_id

Line 791: , xla_prod_acct_headers xpa

787: AND exists (SELECT 'x'
788: FROM xla_desc_priorities xdp
789: , xla_line_defn_jlt_assgns xld
790: , xla_aad_line_defn_assgns xal
791: , xla_prod_acct_headers xpa
792: WHERE xdp.description_prio_id = xdd.description_prio_id
793: AND xld.application_id = xdp.application_id
794: AND xld.amb_context_code = xdp.amb_context_code
795: AND xld.description_type_code = xdp.description_type_code

Line 813: , xla_prod_acct_headers xpa

809: AND xpa.locking_status_flag = 'Y'
810: UNION
811: SELECT 'x'
812: FROM xla_desc_priorities xdp
813: , xla_prod_acct_headers xpa
814: WHERE xdp.description_prio_id = xdd.description_prio_id
815: AND xpa.application_id = xdp.application_id
816: AND xpa.amb_context_code = xdp.amb_context_code
817: AND xpa.description_type_code = xdp.description_type_code

Line 836: xla_prod_acct_headers xpa

832: AND exists (SELECT 'x'
833: FROM xla_desc_priorities xdp,
834: xla_line_defn_jlt_assgns xld,
835: xla_aad_line_defn_assgns xal,
836: xla_prod_acct_headers xpa
837: WHERE xdp.description_prio_id = xco.description_prio_id
838: AND xld.application_id = xdp.application_id
839: AND xld.amb_context_code = xdp.amb_context_code
840: AND xld.description_type_code = xdp.description_type_code

Line 871: xla_prod_acct_headers xpa

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
873: AND xld.application_id = xsd.application_id
874: AND xld.amb_context_code = xsd.amb_context_code
875: AND xld.segment_rule_type_code = xsd.segment_rule_type_code

Line 905: xla_prod_acct_headers xpa

901: AND value_source_code IS NOT NULL))
902: AND exists (SELECT 'x'
903: FROM xla_line_defn_jlt_assgns xld,
904: xla_aad_line_defn_assgns xal,
905: xla_prod_acct_headers xpa
906: WHERE xld.application_id = xco.application_id
907: AND xld.amb_context_code = xco.amb_context_code
908: AND xld.event_class_code = xco.event_class_code
909: AND xld.accounting_line_type_code = xco.accounting_line_type_code

Line 939: xla_prod_acct_headers xpa

935: AND input_source_code IS NOT NULL))
936: AND exists (SELECT 'x'
937: FROM xla_line_defn_adr_assgns xld,
938: xla_aad_line_defn_assgns xal,
939: xla_prod_acct_headers xpa
940: WHERE xld.application_id = xsr.application_id
941: AND xld.amb_context_code = xsr.amb_context_code
942: AND xld.segment_rule_type_code = xsr.segment_rule_type_code
943: AND xld.segment_rule_code = xsr.segment_rule_code

Line 970: xla_prod_acct_headers xpa

966: AND source_type_code = p_der_source_type_code
967: AND exists (SELECT 'x'
968: FROM xla_line_defn_jlt_assgns xld,
969: xla_aad_line_defn_assgns xal,
970: xla_prod_acct_headers xpa
971: WHERE xld.application_id = xja.application_id
972: AND xld.amb_context_code = xja.amb_context_code
973: AND xld.event_class_code = xja.event_class_code
974: AND xld.accounting_line_type_code = xja.accounting_line_type_code

Line 995: FROM xla_aad_hdr_acct_attrs xah, xla_prod_acct_headers xpa

991: IS
992: SELECT 'x'
993: FROM DUAL
994: WHERE EXISTS (SELECT 'x'
995: FROM xla_aad_hdr_acct_attrs xah, xla_prod_acct_headers xpa
996: WHERE xah.source_application_id = p_der_application_id
997: AND xah.source_code = p_der_source_code
998: AND xah.source_type_code = p_der_source_type_code
999: AND xah.source_type_code IS NOT NULL

Line 1810: , xla_prod_acct_headers xpa

1806: AND source_code = p_source_code
1807: AND source_type_code = p_source_type_code
1808: AND exists (SELECT 'x'
1809: FROM xla_aad_header_ac_assgns xah
1810: , xla_prod_acct_headers xpa
1811: WHERE xah.amb_context_code = xas.amb_context_code
1812: AND xah.analytical_criterion_code = xas.analytical_criterion_code
1813: AND xah.analytical_criterion_type_code = xas.analytical_criterion_type_code
1814: AND xpa.application_id = xah.application_id

Line 1825: , xla_prod_acct_headers xpa

1821: UNION
1822: SELECT 'x'
1823: FROM xla_line_defn_ac_assgns xad
1824: , xla_aad_line_defn_assgns xal
1825: , xla_prod_acct_headers xpa
1826: WHERE xad.amb_context_code = xas.amb_context_code
1827: AND xad.analytical_criterion_code = xas.analytical_criterion_code
1828: AND xad.analytical_criterion_type_code = xas.analytical_criterion_type_code
1829: AND xal.application_id = xad.application_id

Line 1855: ,xla_prod_acct_headers xpa

1851: AND exists (SELECT 'x'
1852: FROM xla_desc_priorities xdp
1853: ,xla_line_defn_jlt_assgns xjl
1854: ,xla_aad_line_defn_assgns xal
1855: ,xla_prod_acct_headers xpa
1856: WHERE xdp.description_prio_id = xdd.description_prio_id
1857: AND xjl.application_id = xdp.application_id
1858: AND xjl.amb_context_code = xdp.amb_context_code
1859: AND xjl.description_type_code = xdp.description_type_code

Line 1877: , xla_prod_acct_headers xpa

1873: AND xpa.locking_status_flag = 'Y'
1874: UNION
1875: SELECT 'x'
1876: FROM xla_desc_priorities xdp
1877: , xla_prod_acct_headers xpa
1878: WHERE xdp.description_prio_id = xdd.description_prio_id
1879: AND xpa.application_id = xdp.application_id
1880: AND xpa.amb_context_code = xdp.amb_context_code
1881: AND xpa.description_type_code = xdp.description_type_code

Line 1900: ,xla_prod_acct_headers xpa

1896: AND exists (SELECT 'x'
1897: FROM xla_desc_priorities xdp
1898: ,xla_line_defn_jlt_assgns xld
1899: ,xla_aad_line_defn_assgns xal
1900: ,xla_prod_acct_headers xpa
1901: WHERE xdp.description_prio_id = xco.description_prio_id
1902: AND xld.application_id = xdp.application_id
1903: AND xld.amb_context_code = xdp.amb_context_code
1904: AND xld.description_type_code = xdp.description_type_code

Line 1936: ,xla_prod_acct_headers xpa

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
1938: AND xld.application_id = xsr.application_id
1939: AND xld.amb_context_code = xsr.amb_context_code
1940: AND xld.segment_rule_type_code = xsr.segment_rule_type_code

Line 1971: ,xla_prod_acct_headers xpa

1967: AND value_source_code IS NOT NULL))
1968: AND exists (SELECT 'x'
1969: FROM xla_line_defn_jlt_assgns pl
1970: ,xla_aad_line_defn_assgns p
1971: ,xla_prod_acct_headers xpa
1972: WHERE pl.application_id = c.application_id
1973: AND pl.amb_context_code = c.amb_context_code
1974: AND pl.event_class_code = c.event_class_code
1975: AND pl.accounting_line_type_code = c.accounting_line_type_code

Line 2005: ,xla_prod_acct_headers xpa

2001: AND input_source_code IS NOT NULL))
2002: AND exists (SELECT 'x'
2003: FROM xla_line_defn_adr_assgns pl
2004: ,xla_aad_line_defn_assgns p
2005: ,xla_prod_acct_headers xpa
2006: WHERE pl.application_id = sd.application_id
2007: AND pl.amb_context_code = sd.amb_context_code
2008: AND pl.segment_rule_type_code = sd.segment_rule_type_code
2009: AND pl.segment_rule_code = sd.segment_rule_code

Line 2034: ,xla_prod_acct_headers xpa

2030: AND source_type_code = p_source_type_code
2031: AND exists (SELECT 'x'
2032: FROM xla_line_defn_jlt_assgns pl
2033: ,xla_aad_line_defn_assgns p
2034: ,xla_prod_acct_headers xpa
2035: WHERE pl.application_id = r.application_id
2036: AND pl.amb_context_code = r.amb_context_code
2037: AND pl.event_class_code = r.event_class_code
2038: AND pl.accounting_line_type_code = r.accounting_line_type_code

Line 2059: FROM xla_aad_hdr_acct_attrs r, xla_prod_acct_headers p

2055: IS
2056: SELECT 'x'
2057: FROM DUAL
2058: WHERE EXISTS (SELECT 'x'
2059: FROM xla_aad_hdr_acct_attrs r, xla_prod_acct_headers p
2060: WHERE r.source_application_id = p_application_id
2061: AND r.source_code = p_source_code
2062: AND r.source_type_code = p_source_type_code
2063: AND r.source_type_code IS NOT NULL