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_STD_SUB_OP_RESOURCES

Line 2818: FROM BOM_STD_SUB_OP_RESOURCES stdsubopres

2814: )
2815: IS
2816: SELECT stdops.OPERATION_CODE
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

Line 2830: FROM BOM_STD_SUB_OP_RESOURCES stdsubopres1

2826: AND stdops.STANDARD_OPERATION_ID = stdsubopres.STANDARD_OPERATION_ID
2827: AND res.RESOURCE_ID = stdsubopres.RESOURCE_ID
2828: AND NOT EXISTS
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

Line 2848: FROM BOM_STD_SUB_OP_RESOURCES stdsubopres

2844:
2845: CURSOR l_child_2_cnt ( p_org_id NUMBER )
2846: IS
2847: SELECT COUNT(stdsubopres.SUBSTITUTE_GROUP_NUM)
2848: FROM BOM_STD_SUB_OP_RESOURCES stdsubopres
2849: , BOM_STD_OP_RESOURCES stdopres
2850: , BOM_STANDARD_OPERATIONS stdops
2851: WHERE stdops.ORGANIZATION_ID = p_org_id
2852: AND stdops.Line_Id is null and stdops.Operation_type = 1 --myerrams, testing