Query to Find Pricing Table List in Oracle Apps R12

SELECT    qlhb.list_header_id,qlhb.list_type_code,qlht.name,qlht.description

FROM qp_list_headers_b qlhb,
             qp_list_headers_tl qlht
WHERE qlhb.list_header_id = qlht.list_header_id
 AND qlht.name = 'COMM_CONT';

👋 Hi, I'm Suriya — QA Engineer with 4+ years of experience in manual, API & automation testing.

📬 Contact Me | LinkedIn | GitHub

📌 Follow for: Real-Time Test Cases, Bug Reports, Selenium Frameworks.

List Of Tables Based On Module And Schema In Oracle Apps R-12

Tables related to order management module
1.Blanket tables
BLANKET	ONT.OE_BLANKET_HEADERS_ALL
BLANKET	ONT.OE_BLANKET_HEADERS_EXT
BLANKET	ONT.OE_BLANKET_LINES_ALL
BLANKET	ONT.OE_BLANKET_LINES_EXT
2.BOM(Bill of Materials) tables
BOM	BOM.BOM_COMPONENTS_B
BOM	BOM.BOM_DEPARTMENTS
BOM	BOM.BOM_OPERATIONAL_ROUTINGS
BOM	BOM.BOM_OPERATION_RESOURCES
BOM	BOM.BOM_OPERATION_SEQUENCES
BOM	BOM.BOM_RESOURCES
BOM	BOM.BOM_STANDARD_OPERATIONS
BOM	BOM.BOM_STRUCTURES_B
CUSTROUT	BOM.BOM_CALENDARS
CUSTROUT	BOM.BOM_CALENDAR_DATES
CUSTROUT	BOM.BOM_CALENDAR_EXCEPTIONS
CUSTROUT	BOM.BOM_CALENDAR_SHIFTS
CUSTROUT	BOM.BOM_CAL_WEEK_START_DATES
CUSTROUT	BOM.BOM_CAL_YEAR_START_DATES
CUSTROUT	BOM.BOM_EXCEPTION_SETS
CUSTROUT	BOM.BOM_EXCEPTION_SET_DATES
CUSTROUT	BOM.BOM_PERIOD_START_DATES
CUSTROUT	BOM.BOM_SHIFT_DATES
CUSTROUT	BOM.BOM_SHIFT_EXCEPTIONS
CUSTROUT	BOM.BOM_SHIFT_TIMES
CUSTROUT	BOM.BOM_WORKDAY_PATTERNS
CUSTROUT	WSH.WSH_CALENDAR_ASSIGNMENTS
Sales order base tables
ORDER	ONT.OE_ORDER_HEADERS_ALL
ORDER	ONT.OE_ORDER_LINES_ALL
Tables related Delivery
ORDER	WSH.WSH_DELIVERY_ASSIGNMENTS
ORDER	WSH.WSH_DELIVERY_DETAILS
ORDER	WSH.WSH_DELIVERY_LEGS
ORDER	WSH.WSH_NEW_DELIVERIES
ORDER	last_sale_info
Tables related to contract module
CONTRACT	OKC.OKC_K_GROUPS_B
CONTRACT	OKC.OKC_K_GROUPS_TL
CONTRACT	OKC.OKC_K_GRPINGS
CONTRACT	OKC.OKC_K_HEADERS_ALL_B
CONTRACT	OKC.OKC_K_ITEMS
CONTRACT	OKC.OKC_LINE_STYLES
CONTRACT	OKC.OKC_LINE_STYLES_TL
CONTRACT	OKS.OKS_BILL_CONT_LINES
CONTRACT	OKS.OKS_BILL_TRANSACTIONS
CONTRACT	OKS.OKS_BILL_TXN_LINES
CONTRACT	OKS.OKS_K_HEADERS_B
CONTRACT	OKS.OKS_K_LINES_B
CONTRACT	OKS.OKS_K_LINES_TL
CONTRACT	OKS.OKS_SUBSCR_HEADER_B
CONTRACT	OKS.OKS_SUBSCR_HEADER_TL
Tables related to AR module (TCA)
CUSTOMER	APPLSYS.FND_DOCUMENTS_SHORT_TEXT
CUSTOMER	APPS.FND_DOCUMENTS_VL
CUSTOMER	AR.AR_CONS_BILL_CYCLES_B
CUSTOMER	AR.AR_CONS_BILL_CYCLES_TL
CUSTOMER	AR.AR_STATEMENT_CYCLES
CUSTOMER	AR.HZ_CONTACT_POINTS
CUSTOMER	AR.HZ_CUSTOMER_PROFILES
CUSTOMER	AR.HZ_CUST_ACCOUNTS
CUSTOMER	AR.HZ_CUST_ACCOUNT_ROLES
CUSTOMER	AR.HZ_CUST_ACCT_SITES_ALL
CUSTOMER	AR.HZ_CUST_PROFILE_AMTS
CUSTOMER	AR.HZ_CUST_SITE_USES_ALL
CUSTOMER	AR.HZ_LOCATIONS
CUSTOMER	AR.HZ_ORG_CONTACTS
CUSTOMER	AR.HZ_PARTIES
CUSTOMER	AR.HZ_PARTY_SITES
CUSTOMER	AR.HZ_RELATIONSHIPS
CUSTOMER	AR.HZ_RELATIONSHIP_TYPES
CUSTOMER	AR.HZ_ROLE_RESPONSIBILITY
CUSTOMER	AR.RA_RULES
CUSTOMER	AR.RA_TERMS_B
CUSTOMER	AR.RA_TERMS_TL
CUSTOMER	AR.RA_TERRITORIES
CUSTOMER	GL.GL_LEDGERS
Tables related to organizations :
CUSTOMER	HR.HR_ALL_ORGANIZATION_UNITS
CUSTOMER	HR.HR_ALL_ORGANIZATION_UNITS_TL
CUSTOMER	HR.HR_ORGANIZATION_INFORMATION
Tables related to  CRM:
CUSTOMER	JTF.JTF_RS_RESOURCE_EXTNS
CUSTOMER	JTF.JTF_RS_RESOURCE_EXTNS_TL
CUSTOMER	JTF.JTF_RS_SALESREPS
Tables related to  iSTORE:
CUSTOMER	istore_Accounts
CUSTOMER	istore_Enrollments
CUSTOMER	istore_Roles
FND Tables:
FND	APPLSYS.FND_APPLICATION
FND	APPLSYS.FND_APPLICATION_TL
FND	APPLSYS.FND_LOOKUP_VALUES
FND	APPLSYS.FND_TERRITORIES
FND	APPLSYS.FND_TERRITORIES_TL
FND	APPLSYS.FND_TIMEZONES_B
FND	APPLSYS.FND_TIMEZONES_TL
ITEM	APPLSYS.FND_DOCUMENTS_SHORT_TEXT
ITEM	APPS.FND_DOCUMENTS_VL
Tables related to Item :
ITEM	BOM.CST_ITEM_COSTS
ITEM	GL.GL_CODE_COMBINATIONS
ITEM	HR.HR_LOCATIONS_ALL
ITEM	HR.HR_LOCATIONS_ALL_TL
ITEM	HR.PER_ALL_PEOPLE_F
ITEM	INV.MTL_ATP_RULES
ITEM	INV.MTL_CATEGORIES_B
ITEM	INV.MTL_CATEGORIES_TL
ITEM	INV.MTL_CATEGORY_SETS_B
ITEM	INV.MTL_CATEGORY_SETS_TL
ITEM	INV.MTL_COMMODITY_CODES
ITEM	INV.MTL_CUSTOMER_ITEMS
ITEM	INV.MTL_CUSTOMER_ITEM_XREFS
ITEM	INV.MTL_ITEM_CATEGORIES
ITEM	INV.MTL_ITEM_LOCATIONS
ITEM	INV.MTL_ONHAND_QUANTITIES_DETAIL
ITEM	INV.MTL_PARAMETERS
ITEM	INV.MTL_SYSTEM_ITEMS_B
ITEM	INV.MTL_SYSTEM_ITEMS_TL
ITEM	INV.MTL_UNITS_OF_MEASURE_TL
ITEM	APPLSYS.FND_DOCUMENTS_SHORT_TEXT
ITEM	APPS.FND_DOCUMENTS_VL
ITEM	MRP.MRP_ASSIGNMENT_SETS
ITEM	MRP.MRP_SOURCING_RULES
ITEM	MRP.MRP_SR_ASSIGNMENTS
ITEM	MRP.MRP_SR_RECEIPT_ORG
ITEM	MRP.MRP_SR_SOURCE_ORG
ITEM	PO.PO_HAZARD_CLASSES_B
ITEM	PO.PO_HAZARD_CLASSES_TL
ITEM	PO.PO_UN_NUMBERS_B
ITEM	PO.PO_UN_NUMBERS_TL
Oracle Installed Base Tables:
OAT	CSI.CSI_IEA_VALUES
OAT	CSI.CSI_II_RELATIONSHIPS
OAT	CSI.CSI_INSTANCE_STATUSES
OAT	CSI.CSI_IPA_RELATION_TYPES
OAT	CSI.CSI_IP_ACCOUNTS
OAT	CSI.CSI_ITEM_INSTANCES
OAT	CSI.CSI_ITEM_INSTANCES_H
OAT	CSI.CSI_I_ASSETS
OAT	CSI.CSI_I_ORG_ASSIGNMENTS
OAT	CSI.CSI_I_PARTIES
OAT	CSI.CSI_I_VERSION_LABELS
OAT	CSI.CSI_I_VERSION_LABELS_H
OAT	CSI.CSI_T_PARTY_ACCOUNTS
OAT	CSI.CSI_T_PARTY_DETAILS
OAT	CSI.CSI_T_TXN_LINE_DETAILS
Tables related to PO(Purchase order):
PO	HR.PER_ALL_PEOPLE_F
PO	PO.PO_AGENTS
PO	PO.PO_DISTRIBUTIONS_ALL
PO	PO.PO_HEADERS_ALL
PO	PO.PO_LINES_ALL
PO	PO.PO_LINE_LOCATIONS_ALL
PO	PO.PO_LINE_TYPES_B
PO	PO.PO_REQUISITION_HEADERS_ALL
PO	PO.PO_REQUISITION_LINES_ALL
PO	PO.PO_REQ_DISTRIBUTIONS_ALL
PO	PO.RCV_SHIPMENT_HEADERS
PO	PO.RCV_SHIPMENT_LINES
PO	PO.RCV_TRANSACTIONS
Tables related to Price list:
PRICE	QP.QP_LIST_HEADERS_B
PRICE	QP.QP_LIST_HEADERS_TL
PRICE	QP.QP_LIST_LINES
PRICE	QP.QP_PRICING_ATTRIBUTES
PRICE	QP.QP_QUALIFIERS
Tables related to AP:
VENDOR	AP.AP_SUPPLIERS
VENDOR	AP.AP_SUPPLIER_SITES_ALL
VENDOR	AR.HZ_PARTY_USG_ASSIGNMENTS
VENDOR	GL.GL_CODE_COMBINATIONS
VENDOR	IBY.IBY_ACCOUNT_OWNERS
VENDOR	IBY.IBY_EXTERNAL_PAYEES_ALL
VENDOR	IBY.IBY_EXT_BANK_ACCOUNTS

👋 Hi, I'm Suriya — QA Engineer with 4+ years of experience in manual, API & automation testing.

📬 Contact Me | LinkedIn | GitHub

📌 Follow for: Real-Time Test Cases, Bug Reports, Selenium Frameworks.