天天看點

11i and R12 Table Count in Different Module

Module 11i Tables R12 Tables New Tables
AR 551 616 118
BOM 264 337 73
GL 186 309 140
AP 236 297 73
INV 247 274 33
PO 186 213 33
FA 179 198 19
MRP 174 174
ICX 155 157 2
OM 148 150 2
WMS 88 134 46
WSH 113 115 2
WIP 76 96 20

Query:

SELECT PRODUCT_CODE,COUNT(*)

FROM FND_TABLES A,FND_APPLICATION B

WHERE A.APPLICATION_ID = B.APPLICATION_ID

GROUP BY PRODUCT_CODE;