General Ledger Table with Navigation Steps

As salamo alaikum wa rahmatullah


-- RESPONSIBILITY TABLE

SELECT * FND_RESPONSIBILITY

-- LOCATIONS TABLE
NAV>WORKSTRUCTURE>LOCATION

SELECT * FROM HR_LOCATIONS_ALL WHERE LOCATION_CODE LIKE 'TITAN%'


-- BUSINESS GROUP
NAV>WORKSTUCTURE>ORGANIZATION>DESCRIPTION

SELECT * FROM HR_ALL_ORGANIZATION_UNITS WHERE  NAME LIKE '%_BG%'

--LEDGER
--========
-- CURRENCY
NAV>SETUP>CURRENCIES>DEFINE

SELECT * FROM FND_CURRENCIES_TL WHERE NAME LIKE 'India%'

-- CALENDAR TYPE
NAV>SETUP>FINANCIAL>CALENDARS>TYPES

SELECT * FROM GL_PERIOD_TYPES WHERE USER_PERIOD_TYPE LIKE 'TITAN%'

-- CALENDAR MONTHS (PERIOD)
-------------------
NAV>SETUP>FINANCIAL>CALENDARS>ACCOUNTING

SELECT * FROM GL_PERIOD_SETS WHERE PERIOD_SET_NAME LIKE 'TITAN%'

SELECT * FROM GL_PERIODS WHERE PERIOD_SET_NAME LIKE 'TITAN%'


-- CHART OF ACCOUNT
--- FLEX FIELD - TWO TYPES OF FLEX FIELD KEY FLEX FIELD AND DESCRIPTIVE FLEX FILED
NAV>SETUP>FINANCIAL>FLEXFIELDS>KEY>SEGMENTS

SELECT * FROM FND_ID_FLEX_STRUCTURES_VL 

SELECT * FROM FND_ID_FLEXS

-- SEGMENTS STRUCTURE STORED
------------------------------
SELECT * FROM FND_ID_FLEX_STRUCTURES_TL WHERE ID_FLEX_STRUCTURE_NAME LIKE 'TITAN%'

SELECT * FROM FND_ID_FLEX_SEGMENTS WHERE ID_FLEX_NUM='53542'

--VALUE SET  TABLEN

SELECT * FROM FND_FLEX_VALUE_SETS WHERE FLEX_VALUE_SET_NAME LIKE 'TITAN%'

--VALUE SET VALUE
-----------------
NAV>SETUP>FINANCIAL>FLEXFIELDS>KEY>VALUES

Select * from FND_FLEX_VALUES

-- ACCOUNTING SETUP MANAGER LEDGER
--LEDGER
==
NVA>SETUP>FINANCIALS>FINANCIAL ACCOUNTING SETUP MANAGER>ACCOUNTING SETUPS

LEGAL ENTITY INFO
----

SELECT * FROM HZ_PARTIES WHERE PARTY_NAME LIKE 'TITAN%'

SELECT * FROM GL_LEDGERS WHERE NAME LIKE 'TITAN%'

OPERATING UNIT 
----------------

SELECT * FROM HR_ALL_ORGANIZATION_UNITS
WHERE NAME LIKE 'TITAN%'

ONLY OPERATING UNIT
--------------------

SELECT * FROM HR_OPERATING_UNITS 
WHERE NAME LIKE'TITAN%'

INVENTORY ORGANIZATION
=====================
NAV>SETUP>ORGANIZATIONS>ORGANIZATION

SELECT * FROM HR_ALL_ORGANIZATION_UNITS
WHERE NAME LIKE 'TITAN%' 

ONY INVENTORY ORGANIZATION
========================
SELECT * FROM 

SELECT * FROM ORG_ORGANIZATION_DEFINITIONS WHERE ORGANIZATION_NAME LIKE 'TITAN%' 


--
MA ASALAAM
Passion 4 Oracle