APPS.INV_COPY_ORGANIZATION_REPORT dependencies on BOM_STANDARD_OPERATIONS

Line 2748: l_std_op_code BOM_STANDARD_OPERATIONS.OPERATION_CODE%TYPE;

2744: l_count_tmp NUMBER:=0;
2745: l_entity_names Char_Array := Char_Array();
2746: l_entity_names_fin Char_Array := Char_Array();
2747: l_entity_arr_idx NUMBER := 1;
2748: l_std_op_code BOM_STANDARD_OPERATIONS.OPERATION_CODE%TYPE;
2749: -------------------------------------------------------------------
2750: -------------------------------------------------------------------
2751: CURSOR l_parent ( p_model_org_id NUMBER
2752: , p_organization_id NUMBER

Line 2756: FROM BOM_STANDARD_OPERATIONS stdops

2752: , p_organization_id NUMBER
2753: )
2754: IS
2755: SELECT DISTINCT stdops.OPERATION_CODE
2756: FROM BOM_STANDARD_OPERATIONS stdops
2757: WHERE stdops.ORGANIZATION_ID = p_model_org_id
2758: AND stdops.Line_Id is null and stdops.Operation_type = 1 --myerrams, testing
2759: AND NOT EXISTS
2760: ( SELECT 'x'

Line 2761: FROM BOM_STANDARD_OPERATIONS stdops1

2757: WHERE stdops.ORGANIZATION_ID = p_model_org_id
2758: AND stdops.Line_Id is null and stdops.Operation_type = 1 --myerrams, testing
2759: AND NOT EXISTS
2760: ( SELECT 'x'
2761: FROM BOM_STANDARD_OPERATIONS stdops1
2762: WHERE stdops1.ORGANIZATION_ID = p_organization_id
2763: AND stdops1.OPERATION_CODE = stdops.OPERATION_CODE
2764: );
2765:

Line 2769: FROM BOM_STANDARD_OPERATIONS stdops

2765:
2766: CURSOR l_parent_cnt ( p_org_id NUMBER )
2767: IS
2768: SELECT COUNT(stdops.STANDARD_OPERATION_ID)
2769: FROM BOM_STANDARD_OPERATIONS stdops
2770: WHERE stdops.ORGANIZATION_ID = p_org_id
2771: AND stdops.Line_Id is null and stdops.Operation_type = 1; --myerrams, testing
2772: -------------------------------------------------------------------
2773: -------------------------------------------------------------------

Line 2781: , BOM_STANDARD_OPERATIONS stdops

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

Line 2791: , BOM_STANDARD_OPERATIONS stdops1

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
2795: AND stdopres1.RESOURCE_SEQ_NUM = stdopres.RESOURCE_SEQ_NUM

Line 2806: , BOM_STANDARD_OPERATIONS stdops

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;
2810: -------------------------------------------------------------------

Line 2820: , BOM_STANDARD_OPERATIONS stdops

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

Line 2832: , BOM_STANDARD_OPERATIONS stdops1

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
2836: AND stdops1.ORGANIZATION_ID = p_organization_id

Line 2850: , BOM_STANDARD_OPERATIONS stdops

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
2854: AND stdops.STANDARD_OPERATION_ID = stdopres.STANDARD_OPERATION_ID