Oracle Apps Table Joins

APPLICATION	SL.NO	TABLE NAME	JOINTS
SYS ADMIN	1	FND_USER	1.USER_ID= 6.USER_ID
	2	FND_RESPONSIBILTY	RESPONSIBILTY_ID, DATA_GROUP_ID,MENU_ID, DATA_GROUP_APPLICATION_ID
	3	FND_RESPONSIBILTY_TL	RESPONSIBILITY_ID,APPICATION_ID
	4	FND_APPLICATION	APPLICATION_ID,
	5	FND_APPLICATION_TL	APPLICATION_ID,
	6	FND_USER_RESP_GRUOPS	APPLICATION_ID, RESPONSIBILITY_ID, USER_ID,RESPONSIBILITY.APPLICATION_ID
	7	FND_PROFILE_OPTIONS_VALUES	PROFILE_OPTION_ID
	8	FND_PROFILE_OPTIONS	PROFILE_OPTION_ID
	9	FND_PROFILE_OPTIONS_TL	PROFILE_OPTION_ID
	10	FND_REQUEST_GROUPS	REQUEST_GROUP_ID,APPLICATION_ID
	11	FND_REQUEST_GROUPS_UNITS	REQUEST_GROUP_ID, REQUEST_UNIT_ID,APPLICATION_ID, UNIT_APPLICATION_D
	12	FND_CONCURRENT_PROGRAMS_TL	CONCURRENT_PROGRAM_ID = REQUEST_UNIT_ID, REQUEST_GRUOP_ID
	13	FND_DATA_GRUOPS	DATA_GROUP_ID
	14	FND_MENUS	MENU_ID
	15	FND_MENUS_TL	MENU_ID
APPLICATION	SL.NO	TABLE NAME	JOINTS
GL	1	GL_LEDGERS	LEDGER_ID,CHART_OF _ACCOUNTS_ID
	2	GL_SETS_OF_BOOKS	LEDGER_ID=SET_OF_BOOKS_ID, CHART_OF _ACCOUNTS_ID
	3	GL_JE_LINES	LEDGER_ID, JE_HEADER_ID,JE_LINE_ID, CURRENCY_CODE
	4	GL_JE_HEADERS	LEDGER_ID,JE_HEADER_ID,CURRENCY_CODE,GL_JE_BATCH_ID,JE_SOURCE, JE_CATEGORY
	5	XLE_ENTITY_PROFILE	LEGAL_ENTITY_ID
	6	XLE_ETB_PROFILES	LEGAL_ENTITY_ID
	7	GL_BALANCES	LEDGER_ID
	8	GL_JE_SOURCES_TL	JE_SOURCE_NAME
	9	GL_JE_CATEGORIES_TL	JE_CATEGORY_NAME
	10	GL_JE_BATCHES	GL_JE_BATCH_ID
	11	GL_LEDGER_NORM_SEG_VALS	LEDGER_ID , LEGAL ENTITY_ID
	12	FND_ID_FLEX_STRUCTURES	FLEX_NUM, FLEX_CODE, FLEX_VALUESET_ID
	13	FND_ID_FLEX_STRUCTURES_TL	FLEX_NUM, FLEX_CODE, FLEX_VALUESET_ID
	14	FND_ID_FLEX_SEGMENTS	FLEX_NUM
	15	FND_FLEX_VALUES	FLEX_VALUESET_ID
	16	FND_FLEX_VALUES_TL	FLEX_VALUESET_ID
APPLICATION	SL.NO	TABLE NAME	JOINTS
PO	1	PO_REQUISITIONS_HEADERS_ALL	ORG_ID, PO_REQUESITION_HEADER_ID, PREPARER_ID(PERSON_ID)
	2	PO_REQUISITIONS_LINES_ALL	ORG_ID, PO_REQUESITION_HEADER_ID, TO_PERSON_ID, REQUESITION_LINE_ID, ITEM_ID
	3	PO_REQ_DISTRIBUTION_ALL	ORG_ID ,REQUESITION_LINE_ID, SET_OF_BOOKS_ID
	4	PO_HEADERS_ALL	ORG_ID, PO_HEADER_ID, AGENT_ID(Person_id), VENDOR_ID
	5	PO_LINES_ALL	ORG_ID, PO_HEADER_ID, PO_LINE_ID, ITEM_ID,  QUANTITY
	6	PO_DISTRIBUTIONS_ALL	ORG_ID, PO_HEADER_ID, PO_LINE_ID, ITEM_ID,  QUANTITY_ORDERED
	7	PO_VENDORS	VENDOR_ID
	8	PO_VENDORS_SITES_ALL	VENDOR_ID
	9	RCV_SHIPMENT_HEADERS	SHIPMENT_HEADER_ID, VENDOR_ID, EMPLOYEE_ID
	10	RCV_SHIPMENT_LINES	SHIPMENT_HEADER_ID,  SHIPMENT_LINE_ID, EMPLOYEE_ID, PO_HEADER_ID, PO_LINE_ID, ITEM_ID , ROUTING_HEADER_ID
	11	RCV_ROUTING_HEADER	ROUTING_HEADER_ID
APPLICATION	SL.NO	TABLE NAME	JOINTS
AP	1	AP_INVOICES_ALL	INVOICE_ID ,ORG_ID, VENDOR_ID, INVOICE_CURRENCY_CODE, PO_HEADER_ID , SET_OF_BOOKS_ID
	2	AP_INVOICE_LINES_ALL	INVOICE_ID ,ORG_ID,  INVENTORY_ITEM_ID, PO_HEADER_ID, PO_LINE_ID , PO_DISTRIBUTION_ID,  SET_OF_BOOKS_ID
	3	AP_INVOICE_DISTRIBUTIONS_ALL	ORG_ID, INVOICE_ID, PO_DISTRIBUTION_ID, SET_OF_BOOKS_ID
	4	AP_INVOICE_PAYMENTS_ALL	ORG_ID, INVOICE_ID, CHECK_ID,  PAYMENT_NUM, SET_OF_BOOKS_ID
	5	AP_PAYMENT_DISTIRBUTION_ALL
	6	AP_PAYMENT_HISTORY_ALL	CHECK_ID, ORGANIZATION_ID,VENDOR_ID
	7	AP_CHECKS_ALL	CHECK_ID, ORGANIZATION_ID
	8	AP_SUPPLIERS_ALL	VENDOR_ID
	9	AP_SUPPLIER_SITES_ALL	VENDOR_ID, LOCATION_ID, ORG_ID
	10	AP_LIABILITY_BALANCES	SET_OF_BOOKS_ID, ORG_ID
	11
APPLICATION	SL.NO	TABLE NAME	JOINTS
INVENTORY	1	MTL_SYSTEM_ITEMS_TL	ORGANIZATION_ID, INVENTORY_ITEM_ID
	2	MTL_SYSTEM_ITEMS_B	ORGANIZATION_ID, INVENTORY_ITEM_ID, SEGMENT1
	3	HR_ALL_ORGANIZATION_UNITS	ORGANIZATION_ID
	4	HR_ORGANIZATION_INFORMATION	ORGANIZATION_ID, LEDGER_ID, LEGAL_ENTITY_ID
	5	MTL_ITEM_REVESIONS_B	ORGANIZATION_ID,INVENTORY_ITEM_ID,
	6	MTL_MATERIAL_STATUSES_B	STATUSES_ID
	7	MTL_MATERIAL_STATUSES_TL	STATUSES_ID
	8	MTL_PARAMETERS	ORGANIZATION_ID
	9	MTL_MATERIAL_TRANSACTIONS	ORGANIZATION_ID, TRANSACTION_TYPE_ID
	10	MTL_TRANSACTION_TYPES	ORGANIZATION_ID, TRANSACTION_TYPE_ID
	11	HR_LOCATIONS_ALL_TL	ORGANIZATION_ID, LOCATION_ID
	12	HR_LOCATIONS_ALL	ORGANIZATION_ID, LOCATION_ID
	13	CST_ITEM_COST	ORGANIZATION_ID, COST_TYPE
	14	CST_COST_TYPES	ORGANIZATION_ID, COST_TYPE
	15	MTL_ONHANDQUANTITIES_DETAILS	ORGGANIXATION_ID, INVENTORY_ITEM_ID
APPLICATION	SL.NO	TABLE NAME	JOINTS
AR
	1	RA_CUST_TRX_TYPES_ALL	ORG_ID, CUSTOMER_TRX_ID, CUSTOMER_TYPE_ID
	2	RA_CUSTOMER_TRX_ALL	ORG_ID, CUSTOMER_TRX_ID, CUSTOMER_TYPE_ID
	3	RA_CUSTOMER_TRX_LINES_ALL	ORG_ID, CUSTOMER_TRX_ID, CUSTOMER_TYPE_ID
	4	RA_CUSTOMER_TRX_	ORG_ID, CUSTOMER_TRX_ID, CUSTOMER_TYPE_ID
	5	RA_CUSTOMER_TRX_LINES
	6	HZ_PARTIES	PARTY_ID
	7	HZ_CUST_ACCOUNTS	CUST_ACCOUNT_ID, PARTY_ID
	8	HZ_CUST_ACCT_SITES_ALL	CUST_ACCOUNT_ID
	9	AR_PAYMENT_SCHEDULES_ALL	ORG_ID, TRX_NUMBER,   CUSTOMER_TRX_ID,  CUSTOMER_TYPE_ID, INVOICE_CURRENCY_CODE
	10	AR_CASH_RECEIPT_ALL	SET_OF_BOOKS_ID, ORG_ID, CASH_RECEIPT_ID
	11	AR_CASH_RECEIPT_HISTORY_ALL	ORG_ID, CASH_RECEIPT_ID, SET_OF_BOOKS_ID
APPLICATION	SL.NO	TABLE NAME	JOINTS
OM	1	OE_ORDER_LINES_ALL	ORG_ID, HEADER_ID, LINE_TYPE_ID
	2	OE_TRANASACTION_TYPES_ALL	ORG_ID, TRANACTION_TYPE_ID
	3	OE_ORDER_HEADERS_ALL	ORG_ID, HEADER_ID, LINE_TYPE_ID
	4	OE_TRANASACTION_TYPES_TL	TRANACTION_TYPE_ID
APPLICATION	SL.NO	TABLE NAME	JOINTS
BOM	1	BOM_BILL_OF_MATERIALS	PK2VALUE, ASSEMBLY_ITEM_ID
	2	BOM_COMPONENTS_B	COMPONENTS_ID,
	3	BOM_OPERATIONAL_SEQUENCE	ROUTING.SEQUENCE_ID, DEPARTMENT_ID
	4	BOM_OPERATIONAL_ROUTING	ROUTING.SEQUENCE_ID
	5	BOM_DEPARTMENTS	DEPARTMENT_ID,
APPLICATION	SL.NO	TABLE NAME	JOINTS
HR PEOPLE		PER_ALL_PEOPLE_F	BUSINESS_GROUP_ID,PERSON_ID
		PER_JOB	JOB_ID
		PER_ALL_ASSIGNMENT_F
		PER_ASSIGNMENT_STATUS_TYPES_TL
		PER_ALL_POSITIONS	BUSINESS_GROUP_ID, JOB_ID