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.ENI_DENORM_HRCHY dependencies on MTL_CATEGORY_SET_VALID_CATS

Line 247: FROM MTL_CATEGORY_SET_VALID_CATS C, MTL_CATEGORIES_B B, FND_LANGUAGES TL

243: -- this procedure is called from the main procedure if sales and marketing is installed.
244: PROCEDURE LOAD_DENORM_PARENTS_PROD_HRCHY(errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2) IS
245: CURSOR C1 IS
246: SELECT TL.LANGUAGE_CODE, C.CATEGORY_ID, B.DISABLE_DATE
247: FROM MTL_CATEGORY_SET_VALID_CATS C, MTL_CATEGORIES_B B, FND_LANGUAGES TL
248: WHERE C.CATEGORY_SET_ID = g_catset_id
249: AND TL.INSTALLED_FLAG IN ('I', 'B')
250: AND B.CATEGORY_ID = C.CATEGORY_ID
251: AND NOT EXISTS (SELECT NULL FROM EGO_PROD_CAT_SALES_MARKET_AGV A

Line 261: FROM MTL_CATEGORY_SET_VALID_CATS

257: SELECT TL.DESCRIPTION CHILD_DESC, C.CATEGORY_ID CHILD_ID
258: FROM MTL_CATEGORIES_TL TL,
259: (SELECT
260: CATEGORY_ID, LEVEL hrchy
261: FROM MTL_CATEGORY_SET_VALID_CATS
262: START WITH CATEGORY_ID = l_child_id AND CATEGORY_SET_ID = g_catset_id
263: CONNECT BY PRIOR PARENT_CATEGORY_ID = CATEGORY_ID AND CATEGORY_SET_ID = g_catset_id) C
264: WHERE C.CATEGORY_ID = TL.CATEGORY_ID
265: AND TL.LANGUAGE = l_language

Line 426: FROM MTL_CATEGORY_SET_VALID_CATS C

422:
423: CURSOR C2(p_child NUMBER) IS
424: SELECT D.CATEGORY_ID, B.DISABLE_DATE FROM
425: (SELECT C.CATEGORY_ID
426: FROM MTL_CATEGORY_SET_VALID_CATS C
427: WHERE NOT EXISTS (SELECT NULL FROM EGO_PROD_CAT_SALES_MARKET_AGV A
428: WHERE A.CATEGORY_SET_ID = g_catset_id
429: AND A.CATEGORY_ID = C.CATEGORY_ID
430: AND NVL(A.EXCLUDE_USER_VIEW, 'N') = 'Y')

Line 440: FROM MTL_CATEGORY_SET_VALID_CATS

436: SELECT TL.DESCRIPTION CHILD_DESC, C.CATEGORY_ID CHILD_ID
437: FROM MTL_CATEGORIES_TL TL,
438: (SELECT
439: CATEGORY_ID, LEVEL hrchy
440: FROM MTL_CATEGORY_SET_VALID_CATS
441: START WITH CATEGORY_ID = l_child_id AND CATEGORY_SET_ID = g_catset_id
442: CONNECT BY PRIOR PARENT_CATEGORY_ID = CATEGORY_ID AND CATEGORY_SET_ID = g_catset_id) C
443: WHERE C.CATEGORY_ID = TL.CATEGORY_ID
444: AND TL.LANGUAGE = l_language

Line 642: FROM MTL_CATEGORY_SET_VALID_CATS T, ENI_DENORM_HIERARCHIES D, ENI_DENORM_HIERARCHIES D1

638: T.PARENT_CATEGORY_ID PARENT_ID,
639: T.CATEGORY_ID CHILD_ID,
640: D.TOP_NODE_FLAG,
641: D1.LEAF_NODE_FLAG
642: FROM MTL_CATEGORY_SET_VALID_CATS T, ENI_DENORM_HIERARCHIES D, ENI_DENORM_HIERARCHIES D1
643: WHERE T.CATEGORY_SET_ID = g_catset_id
644: AND T.PARENT_CATEGORY_ID IS NOT NULL
645: AND D.OBJECT_TYPE = 'CATEGORY_SET'
646: AND D.OBJECT_ID = g_catset_id

Line 778: NVL((SELECT ''N'' FROM MTL_CATEGORY_SET_VALID_CATS X

774: T.CATEGORY_ID,
775: ''CATEGORY_SET'',
776: :g_catset_id,
777: DECODE(:l_hrchy_enabled, ''Y'', DECODE(T.PARENT_CATEGORY_ID, NULL, ''Y'', ''N''), ''Y''),
778: NVL((SELECT ''N'' FROM MTL_CATEGORY_SET_VALID_CATS X
779: WHERE X.CATEGORY_SET_ID = T.CATEGORY_SET_ID
780: AND X.PARENT_CATEGORY_ID = T.CATEGORY_ID
781: AND ROWNUM = 1), ''Y'') LEAF_NODE_FLAG,
782: ''N'',

Line 794: FROM MTL_CATEGORY_SET_VALID_CATS T

790: :l_conc_request_id,
791: :l_prog_appl_id,
792: SYSDATE,
793: :l_conc_program_id
794: FROM MTL_CATEGORY_SET_VALID_CATS T
795: WHERE T.CATEGORY_SET_ID = :g_catset_id';
796:
797: EXECUTE IMMEDIATE l_sql USING g_catset_id, l_hrchy_enabled, l_user_id, l_user_id, l_user_id
798: , l_conc_request_id, l_prog_appl_id, l_conc_program_id, g_catset_id;

Line 852: FROM MTL_CATEGORY_SET_VALID_CATS A

848: l_conc_request_id,
849: l_prog_appl_id,
850: SYSDATE,
851: l_conc_program_id
852: FROM MTL_CATEGORY_SET_VALID_CATS A
853: START WITH A.CATEGORY_ID = i.CHILD_ID AND A.CATEGORY_SET_ID = g_catset_id
854: CONNECT BY A.PARENT_CATEGORY_ID = PRIOR A.CATEGORY_ID AND A.CATEGORY_SET_ID = g_catset_id;
855:
856: l_count := l_count + SQL%ROWCOUNT;

Line 1053: FROM MTL_CATEGORY_SET_VALID_CATS X

1049: -- To Get The Top Node And Child Level In Temp Table
1050: UPDATE ENI_DENORM_HRCHY_STG T
1051: SET (TOP_NODE_ID, CHILD_LEVEL)=
1052: (SELECT X.CATEGORY_ID, LEVEL
1053: FROM MTL_CATEGORY_SET_VALID_CATS X
1054: WHERE X.PARENT_CATEGORY_ID IS NULL
1055: START WITH X.CATEGORY_ID = T.CHILD_ID AND X.CATEGORY_SET_ID = g_catset_id
1056: CONNECT BY X.CATEGORY_ID = PRIOR X.PARENT_CATEGORY_ID AND X.CATEGORY_SET_ID = g_catset_id),
1057: BATCH_FLAG = 'CURRENT_BATCH'

Line 1168: FROM MTL_CATEGORY_SET_VALID_CATS C

1164: AND B.PARENT_ID = D.CHILD_ID
1165: AND D.PARENT_ID = i.CHILD_ID)
1166: AND NOT EXISTS (-- Find New Parents, All Records Which Are A Part Of New Hierarchy
1167: SELECT NULL
1168: FROM MTL_CATEGORY_SET_VALID_CATS C
1169: WHERE C.PARENT_CATEGORY_ID IS NOT NULL
1170: AND C.PARENT_CATEGORY_ID = B.PARENT_ID
1171: AND C.CATEGORY_ID = B.IMM_CHILD_ID
1172: START WITH C.CATEGORY_ID = i.PARENT_ID AND C.CATEGORY_SET_ID = g_catset_id

Line 1249: FROM MTL_CATEGORY_SET_VALID_CATS

1245: SYSDATE,
1246: l_conc_program_id
1247: FROM
1248: (SELECT PARENT_CATEGORY_ID PARENT_ID, CATEGORY_ID IMM_CHILD_ID
1249: FROM MTL_CATEGORY_SET_VALID_CATS
1250: WHERE PARENT_CATEGORY_ID IS NOT NULL
1251: START WITH CATEGORY_ID = l_affected_child AND CATEGORY_SET_ID = g_catset_id
1252: CONNECT BY CATEGORY_ID = PRIOR PARENT_CATEGORY_ID AND CATEGORY_SET_ID = g_catset_id) A,
1253: (SELECT CATEGORY_ID CHILD_ID

Line 1254: FROM MTL_CATEGORY_SET_VALID_CATS A

1250: WHERE PARENT_CATEGORY_ID IS NOT NULL
1251: START WITH CATEGORY_ID = l_affected_child AND CATEGORY_SET_ID = g_catset_id
1252: CONNECT BY CATEGORY_ID = PRIOR PARENT_CATEGORY_ID AND CATEGORY_SET_ID = g_catset_id) A,
1253: (SELECT CATEGORY_ID CHILD_ID
1254: FROM MTL_CATEGORY_SET_VALID_CATS A
1255: START WITH CATEGORY_ID = l_affected_child AND A.CATEGORY_SET_ID = g_catset_id
1256: CONNECT BY PARENT_CATEGORY_ID = PRIOR CATEGORY_ID AND A.CATEGORY_SET_ID = g_catset_id) B
1257: WHERE NOT EXISTS (SELECT NULL FROM ENI_DENORM_HIERARCHIES P
1258: WHERE P.OBJECT_TYPE = 'CATEGORY_SET'

Line 1296: FROM MTL_CATEGORY_SET_VALID_CATS C

1292: WHERE B.OBJECT_TYPE = ''CATEGORY_SET''
1293: AND B.OBJECT_ID = :g_catset_id
1294: AND B.CHILD_ID <> -1
1295: AND B.LEAF_NODE_FLAG <> NVL((SELECT ''N''
1296: FROM MTL_CATEGORY_SET_VALID_CATS C
1297: WHERE C.CATEGORY_SET_ID = :g_catset_id
1298: AND B.IMM_CHILD_ID = C.PARENT_CATEGORY_ID
1299: AND ROWNUM = 1), ''Y'')';
1300:

Line 1321: FROM MTL_CATEGORY_SET_VALID_CATS) C

1317: --
1318:
1319: MERGE INTO ENI_DENORM_HIERARCHIES B
1320: USING ( SELECT category_id, category_set_id, DECODE(PARENT_CATEGORY_ID, null, 'Y', 'N') NEW_TOP_NODE
1321: FROM MTL_CATEGORY_SET_VALID_CATS) C
1322: ON ( B.OBJECT_ID = C.CATEGORY_SET_ID
1323: AND B.PARENT_ID = C.CATEGORY_ID
1324: AND B.OBJECT_TYPE = 'CATEGORY_SET'
1325: AND B.OBJECT_ID = g_catset_id

Line 1343: FROM ENI_DENORM_HIERARCHIES B, MTL_CATEGORY_SET_VALID_CATS C

1339: UPDATE (
1340: SELECT B.PARENT_ID, DECODE(C.PARENT_CATEGORY_ID, NULL, 'Y', 'N') NEW_TOP_NODE, B.TOP_NODE_FLAG,
1341: B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.REQUEST_ID, B.PROGRAM_APPLICATION_ID,
1342: B.PROGRAM_UPDATE_DATE, B.PROGRAM_ID
1343: FROM ENI_DENORM_HIERARCHIES B, MTL_CATEGORY_SET_VALID_CATS C
1344: WHERE B.OBJECT_TYPE = 'CATEGORY_SET'
1345: AND B.OBJECT_ID = g_catset_id
1346: AND C.CATEGORY_SET_ID = B.OBJECT_ID
1347: AND C.CATEGORY_ID = B.PARENT_ID)

Line 1972: ' FROM MTL_CATEGORY_SET_VALID_CATS vcats ' ||

1968: ' FROM ' ||
1969: ' (SELECT (sys_connect_by_path(vcats.category_id,''' || g_delimiter ||
1970: ''') ||''' || g_delimiter || ''') catstr ' ||
1971: ' , vcats.category_id' ||
1972: ' FROM MTL_CATEGORY_SET_VALID_CATS vcats ' ||
1973: ' WHERE CATEGORY_SET_ID = :g_catset_id ' ||
1974: '/* AND CATEGORY_ID NOT IN (SELECT ' ||
1975: ' Nvl(vcats1.PARENT_CATEGORY_ID,-99) FROM MTL_CATEGORY_SET_VALID_CATS vcats1 WHERE vcats1.CATEGORY_SET_ID = :g_catset_id2) */' ||
1976: ' START WITH PARENT_CATEGORY_ID IS NULL ' ||

Line 1975: ' Nvl(vcats1.PARENT_CATEGORY_ID,-99) FROM MTL_CATEGORY_SET_VALID_CATS vcats1 WHERE vcats1.CATEGORY_SET_ID = :g_catset_id2) */' ||

1971: ' , vcats.category_id' ||
1972: ' FROM MTL_CATEGORY_SET_VALID_CATS vcats ' ||
1973: ' WHERE CATEGORY_SET_ID = :g_catset_id ' ||
1974: '/* AND CATEGORY_ID NOT IN (SELECT ' ||
1975: ' Nvl(vcats1.PARENT_CATEGORY_ID,-99) FROM MTL_CATEGORY_SET_VALID_CATS vcats1 WHERE vcats1.CATEGORY_SET_ID = :g_catset_id2) */' ||
1976: ' START WITH PARENT_CATEGORY_ID IS NULL ' ||
1977: ' AND CATEGORY_SET_ID = :g_catset_id3 ' ||
1978: ' CONNECT BY PRIOR CATEGORY_ID = PARENT_CATEGORY_ID ' ||
1979: ' AND PRIOR CATEGORY_SET_ID = CATEGORY_SET_ID ))' ;