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.INV_COPY_ORGANIZATION_REPORT dependencies on BOM_RESOURCES

Line 956: Init_Vars('BOM_RESOURCES');

952: Init_Vars('BOM_DEPARTMENT_RESOURCES');
953: g_entity_names := Get_Err_Bom_Dept_Res;
954: Put_Report_Data;
955:
956: Init_Vars('BOM_RESOURCES');
957: g_entity_names := Get_Err_Bom_Resources;
958: Put_Report_Data;
959:
960: Init_Vars('CST_RESOURCE_COSTS');

Line 957: g_entity_names := Get_Err_Bom_Resources;

953: g_entity_names := Get_Err_Bom_Dept_Res;
954: Put_Report_Data;
955:
956: Init_Vars('BOM_RESOURCES');
957: g_entity_names := Get_Err_Bom_Resources;
958: Put_Report_Data;
959:
960: Init_Vars('CST_RESOURCE_COSTS');
961: g_entity_names := Get_Err_Cst_Res_Costs;

Line 1224: -- FUNCTION NAME : Get_Err_Bom_Resources

1220:
1221: END Get_Err_Subinv_Names;
1222:
1223: --=============================================================================
1224: -- FUNCTION NAME : Get_Err_Bom_Resources
1225: -- PRE-CONDITIONS: None.
1226: -- DESCRIPTION : Validate bom resources created for new org against
1227: -- those in model org.
1228: -- PARAMETERS : None.

Line 1226: -- DESCRIPTION : Validate bom resources created for new org against

1222:
1223: --=============================================================================
1224: -- FUNCTION NAME : Get_Err_Bom_Resources
1225: -- PRE-CONDITIONS: None.
1226: -- DESCRIPTION : Validate bom resources created for new org against
1227: -- those in model org.
1228: -- PARAMETERS : None.
1229: -- EXCEPTIONS : None.
1230: --

Line 1232: FUNCTION Get_Err_Bom_Resources RETURN Char_Array

1228: -- PARAMETERS : None.
1229: -- EXCEPTIONS : None.
1230: --
1231: --=============================================================================
1232: FUNCTION Get_Err_Bom_Resources RETURN Char_Array
1233: IS
1234: l_api_name VARCHAR2(100):= ' Get_Err_Bom_Resources ';
1235: l_entity_arr_idx NUMBER := 1;
1236: l_entity_names Char_Array := Char_Array();

Line 1234: l_api_name VARCHAR2(100):= ' Get_Err_Bom_Resources ';

1230: --
1231: --=============================================================================
1232: FUNCTION Get_Err_Bom_Resources RETURN Char_Array
1233: IS
1234: l_api_name VARCHAR2(100):= ' Get_Err_Bom_Resources ';
1235: l_entity_arr_idx NUMBER := 1;
1236: l_entity_names Char_Array := Char_Array();
1237: --l_entity_type VARCHAR2(100):= ' Resources ';
1238: l_model_org_count NUMBER;

Line 1247: FROM BOM_RESOURCES br1

1243: , p_organization_id NUMBER
1244: )
1245: IS
1246: SELECT br1.RESOURCE_CODE rescode
1247: FROM BOM_RESOURCES br1
1248: WHERE br1.ORGANIZATION_ID = g_model_org_id
1249: AND br1.COST_ELEMENT_ID IN (3,4) /* vmutyala added this condition to distinguish resource overheads and resources in the report */
1250: AND NOT EXISTS ( SELECT 'x'
1251: FROM BOM_RESOURCES br2

Line 1251: FROM BOM_RESOURCES br2

1247: FROM BOM_RESOURCES br1
1248: WHERE br1.ORGANIZATION_ID = g_model_org_id
1249: AND br1.COST_ELEMENT_ID IN (3,4) /* vmutyala added this condition to distinguish resource overheads and resources in the report */
1250: AND NOT EXISTS ( SELECT 'x'
1251: FROM BOM_RESOURCES br2
1252: WHERE br2.ORGANIZATION_ID = g_organization_id
1253: AND br2.RESOURCE_CODE = br1.RESOURCE_CODE
1254: AND br2.COST_ELEMENT_ID IN (3,4) /* vmutyala added this condition to distinguish
1255: resource overheads and resources in the report */

Line 1261: FROM BOM_RESOURCES br

1257:
1258: CURSOR l_cnt_csr ( p_org_id NUMBER )
1259: IS
1260: SELECT COUNT(br.RESOURCE_CODE)
1261: FROM BOM_RESOURCES br
1262: WHERE br.ORGANIZATION_ID = p_org_id
1263: AND br.COST_ELEMENT_ID IN (3,4); /* vmutyala added this condition to distinguish resource overheads
1264: and resources in the report */
1265:

Line 1271: , '> Get_Err_Bom_Resources'

1267: IF G_DEBUG = 'Y' THEN
1268: FND_MSG_PUB.ADD_EXC_MSG
1269: ( G_PKG_NAME
1270: , l_api_name
1271: , '> Get_Err_Bom_Resources'
1272: );
1273: END IF;
1274:
1275: OPEN l_cnt_csr ( g_model_org_id );

Line 1309: END Get_Err_Bom_Resources;

1305: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1306: FND_MSG_PUB.Add;
1307: RAISE;
1308:
1309: END Get_Err_Bom_Resources;
1310: --=============================================================================
1311: -- FUNCTION NAME : Get_Err_Bom_Departments
1312: -- PRE-CONDITIONS: None.
1313: -- DESCRIPTION : Validate bom departments created for new org against

Line 2782: , BOM_RESOURCES res

2778: SELECT stdops.OPERATION_CODE
2779: , COUNT(stdopres.RESOURCE_ID)
2780: FROM BOM_STD_OP_RESOURCES stdopres
2781: , BOM_STANDARD_OPERATIONS stdops
2782: , BOM_RESOURCES res
2783: WHERE stdopres.STANDARD_OPERATION_ID = stdops.STANDARD_OPERATION_ID
2784: AND stdops.ORGANIZATION_ID = p_model_org_id
2785: AND stdops.Line_Id is null and stdops.Operation_type = 1 --myerrams, testing
2786: AND res.RESOURCE_ID = stdopres.RESOURCE_ID

Line 2792: , BOM_RESOURCES res1

2788: AND NOT EXISTS
2789: ( SELECT 'x'
2790: FROM BOM_STD_OP_RESOURCES stdopres1
2791: , BOM_STANDARD_OPERATIONS stdops1
2792: , BOM_RESOURCES res1
2793: WHERE stdops1.ORGANIZATION_ID = p_organization_id
2794: AND stdopres1.STANDARD_OPERATION_ID = stdops1.STANDARD_OPERATION_ID
2795: AND stdopres1.RESOURCE_SEQ_NUM = stdopres.RESOURCE_SEQ_NUM
2796: AND res1.RESOURCE_ID = stdopres1.RESOURCE_ID

Line 2821: , BOM_RESOURCES res

2817: , COUNT(stdsubopres.SUBSTITUTE_GROUP_NUM)
2818: FROM BOM_STD_SUB_OP_RESOURCES stdsubopres
2819: , BOM_STD_OP_RESOURCES stdopres
2820: , BOM_STANDARD_OPERATIONS stdops
2821: , BOM_RESOURCES res
2822: WHERE stdops.ORGANIZATION_ID = p_model_org_id
2823: AND stdops.Line_Id is null and stdops.Operation_type = 1 --myerrams, testing
2824: AND stdopres.SUBSTITUTE_GROUP_NUM = stdsubopres.SUBSTITUTE_GROUP_NUM
2825: AND stdops.STANDARD_OPERATION_ID = stdopres.STANDARD_OPERATION_ID

Line 2833: , BOM_RESOURCES res1

2829: ( SELECT 'x'
2830: FROM BOM_STD_SUB_OP_RESOURCES stdsubopres1
2831: , BOM_STD_OP_RESOURCES stdopres1
2832: , BOM_STANDARD_OPERATIONS stdops1
2833: , BOM_RESOURCES res1
2834: WHERE stdops1.STANDARD_OPERATION_ID = stdsubopres1.STANDARD_OPERATION_ID
2835: AND stdops1.STANDARD_OPERATION_ID = stdopres1.STANDARD_OPERATION_ID
2836: AND stdops1.ORGANIZATION_ID = p_organization_id
2837: AND res1.RESOURCE_ID = stdsubopres1.RESOURCE_ID

Line 3538: , BOM_RESOURCES br

3534: IS
3535: SELECT bd.DEPARTMENT_CODE, br.RESOURCE_CODE
3536: FROM BOM_DEPARTMENT_RESOURCES ent
3537: , BOM_DEPARTMENTS bd
3538: , BOM_RESOURCES br
3539: WHERE br.RESOURCE_ID = ent.RESOURCE_ID
3540: AND ent.RESOURCE_ID IN ( SELECT br.RESOURCE_ID
3541: FROM BOM_RESOURCES br
3542: WHERE br.ORGANIZATION_ID=p_model_org_id

Line 3541: FROM BOM_RESOURCES br

3537: , BOM_DEPARTMENTS bd
3538: , BOM_RESOURCES br
3539: WHERE br.RESOURCE_ID = ent.RESOURCE_ID
3540: AND ent.RESOURCE_ID IN ( SELECT br.RESOURCE_ID
3541: FROM BOM_RESOURCES br
3542: WHERE br.ORGANIZATION_ID=p_model_org_id
3543: )
3544: AND bd.DEPARTMENT_ID = ent.DEPARTMENT_ID
3545: AND ent.DEPARTMENT_ID IN ( SELECT bd.DEPARTMENT_ID

Line 3553: , BOM_RESOURCES br

3549: MINUS
3550: SELECT bd.DEPARTMENT_CODE, br.RESOURCE_CODE
3551: FROM BOM_DEPARTMENT_RESOURCES ent
3552: , BOM_DEPARTMENTS bd
3553: , BOM_RESOURCES br
3554: WHERE br.RESOURCE_ID = ent.RESOURCE_ID
3555: AND ent.RESOURCE_ID IN ( SELECT br.RESOURCE_ID
3556: FROM BOM_RESOURCES br
3557: WHERE br.ORGANIZATION_ID=p_organization_id

Line 3556: FROM BOM_RESOURCES br

3552: , BOM_DEPARTMENTS bd
3553: , BOM_RESOURCES br
3554: WHERE br.RESOURCE_ID = ent.RESOURCE_ID
3555: AND ent.RESOURCE_ID IN ( SELECT br.RESOURCE_ID
3556: FROM BOM_RESOURCES br
3557: WHERE br.ORGANIZATION_ID=p_organization_id
3558: )
3559: AND bd.DEPARTMENT_ID = ent.DEPARTMENT_ID
3560: AND ent.DEPARTMENT_ID IN ( SELECT bd.DEPARTMENT_ID

Line 3572: FROM BOM_RESOURCES br

3568: FROM BOM_DEPARTMENT_RESOURCES ent
3569: WHERE ent.RESOURCE_ID IN
3570: (
3571: SELECT br.RESOURCE_ID
3572: FROM BOM_RESOURCES br
3573: WHERE br.ORGANIZATION_ID=p_org_id
3574: )
3575: AND ent.DEPARTMENT_ID IN
3576: (

Line 3659: , BOM_RESOURCES br1

3655: IS
3656: SELECT br1.RESOURCE_CODE, cct1.COST_TYPE
3657: FROM CST_RESOURCE_COSTS crc1
3658: , CST_COST_TYPES cct1
3659: , BOM_RESOURCES br1
3660: WHERE crc1.ORGANIZATION_ID = p_model_org_id
3661: AND br1.RESOURCE_ID = crc1.RESOURCE_ID
3662: AND cct1.COST_TYPE_ID = crc1.COST_TYPE_ID
3663: AND NOT EXISTS ( SELECT 'x'

Line 3666: , BOM_RESOURCES br2

3662: AND cct1.COST_TYPE_ID = crc1.COST_TYPE_ID
3663: AND NOT EXISTS ( SELECT 'x'
3664: FROM CST_RESOURCE_COSTS crc2
3665: , CST_COST_TYPES cct2
3666: , BOM_RESOURCES br2
3667: WHERE crc2.ORGANIZATION_ID = p_organization_id
3668: AND br2.RESOURCE_ID = crc2.RESOURCE_ID
3669: AND br2.RESOURCE_CODE = br1.RESOURCE_CODE
3670: AND cct2.COST_TYPE_ID = crc2.COST_TYPE_ID

Line 3758: , BOM_RESOURCES br1

3754: , cct1.COST_TYPE
3755: , br2.RESOURCE_CODE
3756: FROM CST_RESOURCE_OVERHEADS crh1
3757: , CST_COST_TYPES cct1
3758: , BOM_RESOURCES br1
3759: , BOM_RESOURCES br2
3760: WHERE crh1.ORGANIZATION_ID = p_model_org_id
3761: AND br1.RESOURCE_ID = crh1.RESOURCE_ID
3762: AND br2.RESOURCE_ID = crh1.OVERHEAD_ID

Line 3759: , BOM_RESOURCES br2

3755: , br2.RESOURCE_CODE
3756: FROM CST_RESOURCE_OVERHEADS crh1
3757: , CST_COST_TYPES cct1
3758: , BOM_RESOURCES br1
3759: , BOM_RESOURCES br2
3760: WHERE crh1.ORGANIZATION_ID = p_model_org_id
3761: AND br1.RESOURCE_ID = crh1.RESOURCE_ID
3762: AND br2.RESOURCE_ID = crh1.OVERHEAD_ID
3763: AND cct1.COST_TYPE_ID = crh1.COST_TYPE_ID

Line 3767: , BOM_RESOURCES br3

3763: AND cct1.COST_TYPE_ID = crh1.COST_TYPE_ID
3764: AND NOT EXISTS ( SELECT 'x'
3765: FROM CST_RESOURCE_OVERHEADS crh2
3766: , CST_COST_TYPES cct2
3767: , BOM_RESOURCES br3
3768: WHERE crh2.ORGANIZATION_ID = p_organization_id
3769: AND br3.RESOURCE_ID = crh2.RESOURCE_ID
3770: AND br3.RESOURCE_CODE = br1.RESOURCE_CODE
3771: AND cct2.COST_TYPE_ID = crh2.COST_TYPE_ID