APPS.INV_COPY_ORGANIZATION_REPORT dependencies on BOM_STD_OP_RESOURCES

Line 2780: FROM BOM_STD_OP_RESOURCES stdopres

2776: )
2777: IS
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

Line 2790: FROM BOM_STD_OP_RESOURCES stdopres1

2786: AND res.RESOURCE_ID = stdopres.RESOURCE_ID
2787:
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

Line 2805: FROM BOM_STD_OP_RESOURCES stdopres

2801:
2802: CURSOR l_child_1_cnt ( p_org_id NUMBER )
2803: IS
2804: SELECT COUNT(stdopres.RESOURCE_ID)
2805: FROM BOM_STD_OP_RESOURCES stdopres
2806: , BOM_STANDARD_OPERATIONS stdops
2807: WHERE stdopres.STANDARD_OPERATION_ID = stdops.STANDARD_OPERATION_ID
2808: AND stdops.Line_Id is null and stdops.Operation_type = 1 --myerrams, testing
2809: AND stdops.ORGANIZATION_ID = p_org_id;

Line 2819: , BOM_STD_OP_RESOURCES stdopres

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
2823: AND stdops.Line_Id is null and stdops.Operation_type = 1 --myerrams, testing

Line 2831: , BOM_STD_OP_RESOURCES stdopres1

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
2835: AND stdops1.STANDARD_OPERATION_ID = stdopres1.STANDARD_OPERATION_ID

Line 2849: , BOM_STD_OP_RESOURCES stdopres

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
2853: AND stdopres.SUBSTITUTE_GROUP_NUM = stdsubopres.SUBSTITUTE_GROUP_NUM