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.BIM_I_SRC_CODE_PKG dependencies on AMS_ACT_PRODUCTS

Line 663: ams_act_products prod

659: UPDATE BIM_I_SOURCE_CODES code
660: SET code.category_id
661: = (SELECT nvl(prod.category_id,-1) category_id
662: FROM
663: ams_act_products prod
664: WHERE
665: prod.act_product_used_by_id = object_id
666: AND prod.arc_act_product_used_by = object_type
667: AND prod.primary_product_flag = 'Y'

Line 672: ams_act_products prod

668: )
669: WHERE
670: EXISTS (SELECT 1
671: FROM
672: ams_act_products prod
673: WHERE
674: prod.act_product_used_by_id = object_id
675: AND prod.arc_act_product_used_by = object_type
676: AND prod.primary_product_flag = 'Y'

Line 683: ams_act_products prod

679: UPDATE BIM_I_SOURCE_CODES code
680: SET code.category_id
681: = (SELECT nvl(prod.category_id,-1) category_id
682: FROM
683: ams_act_products prod
684: WHERE
685: prod.act_product_used_by_id = child_object_id
686: AND prod.arc_act_product_used_by = child_object_type
687: AND prod.primary_product_flag = 'Y'

Line 692: ams_act_products prod

688: )
689: WHERE
690: EXISTS (SELECT 1
691: FROM
692: ams_act_products prod
693: WHERE
694: prod.act_product_used_by_id = child_object_id
695: AND prod.arc_act_product_used_by = child_object_type
696: AND prod.primary_product_flag = 'Y'

Line 1359: ams_act_products prod

1355: UPDATE BIM_I_SOURCE_CODES code
1356: SET code.category_id
1357: = (SELECT nvl(prod.category_id,-1) category_id
1358: FROM
1359: ams_act_products prod
1360: WHERE
1361: prod.act_product_used_by_id = object_id
1362: AND prod.arc_act_product_used_by = object_type
1363: AND prod.primary_product_flag = 'Y'

Line 1371: FROM ams_act_products prod

1367: WHERE ((code.child_object_id = 0)
1368: OR
1369: (NOT EXISTS (
1370: SELECT 1
1371: FROM ams_act_products prod
1372: WHERE prod.act_product_used_by_id = code.child_object_id
1373: AND prod.arc_act_product_used_by = code.child_object_type
1374: AND prod.primary_product_flag = 'Y'
1375: ))

Line 1380: ams_act_products prod

1376: )
1377: AND
1378: EXISTS (SELECT 1
1379: FROM
1380: ams_act_products prod
1381: WHERE
1382: prod.act_product_used_by_id = object_id
1383: AND prod.arc_act_product_used_by = object_type
1384: AND prod.primary_product_flag = 'Y'

Line 1393: ams_act_products prod

1389: UPDATE BIM_I_SOURCE_CODES code
1390: SET code.category_id
1391: = (SELECT nvl(prod.category_id,-1) category_id
1392: FROM
1393: ams_act_products prod
1394: WHERE
1395: prod.act_product_used_by_id = child_object_id
1396: AND prod.arc_act_product_used_by = child_object_type
1397: AND prod.primary_product_flag = 'Y'

Line 1404: ams_act_products prod

1400: )
1401: WHERE
1402: EXISTS (SELECT 1
1403: FROM
1404: ams_act_products prod
1405: WHERE
1406: prod.act_product_used_by_id = child_object_id
1407: AND prod.arc_act_product_used_by = child_object_type
1408: AND prod.primary_product_flag = 'Y'

Line 1417: ams_act_products prod

1413: UPDATE BIM_I_SOURCE_CODES code
1414: SET code.category_id = -1
1415: WHERE NOT EXISTS (select 1
1416: FROM
1417: ams_act_products prod
1418: WHERE
1419: act_product_used_by_id = code.object_id
1420: AND prod.arc_act_product_used_by in ('CAMP','EVEH','EONE')
1421: )

Line 1426: ams_act_products prod

1422: AND ( (child_object_id = 0)
1423: OR
1424: (NOT EXISTS (select 1
1425: FROM
1426: ams_act_products prod
1427: WHERE
1428: act_product_used_by_id = code.child_object_id
1429: AND prod.arc_act_product_used_by in ('CSCH', 'EVEO')
1430: ))