APPS.BOM_VALIDATE_OP_RES dependencies on BOM_RESOURCES

Line 415: , BOM_RESOURCES br

411: WHERE NOT EXISTS(
412: SELECT NULL
413: FROM BOM_OPERATION_SEQUENCES bos
414: , BOM_DEPARTMENT_RESOURCES bdr
415: , BOM_RESOURCES br
416: WHERE NVL(br.disable_date, bos.effectivity_date + 1)
417: > bos.effectivity_date
418: AND NVL(br.disable_date, sysdate + 1)
419: > trunc(sysdate)

Line 867: FROM BOM_RESOURCES

863: IS
864: SELECT 'Not OSP Resource'
865: FROM SYS.DUAL
866: WHERE EXISTS ( SELECT NULL
867: FROM BOM_RESOURCES
868: WHERE resource_id = p_resource_id
869: AND organization_id = p_organization_id
870: AND cost_code_type <> l_OSP -- 4 : Outside Processing
871: ) ;

Line 1005: FROM BOM_RESOURCES

1001:
1002: CURSOR l_uom_csr ( p_resource_id NUMBER )
1003: IS
1004: SELECT unit_of_measure
1005: FROM BOM_RESOURCES
1006: WHERE resource_id = p_resource_id ;
1007:
1008: BEGIN
1009:

Line 2059: l_res_code BOM_RESOURCES_V.RESOURCE_CODE%TYPE;

2055: l_hour_uom_class VARCHAR2(10) ; -- Hour UOM Class
2056: l_res_uom_code VARCHAR2(3) ; -- Resource UOM Code
2057: l_res_uom_class VARCHAR2(10) ; -- Resource UOM Class
2058: l_temp_status VARCHAR2(1) ; -- Temp Error Status
2059: l_res_code BOM_RESOURCES_V.RESOURCE_CODE%TYPE;
2060:
2061: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
2062: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
2063:

Line 2375: FROM bom_resources

2371: OPEN get_setups (p_rev_op_res_unexp_rec.resource_id, p_rev_op_res_unexp_rec.organization_id);
2372: FETCH get_setups INTO l_get_setups;
2373: CLOSE get_setups;
2374: SELECT nvl(batchable,2) INTO l_batchable
2375: FROM bom_resources
2376: WHERE resource_id = p_rev_op_res_unexp_rec.resource_id;
2377: IF (l_get_setups IS NOT NULL or l_batchable = 1) THEN
2378: IF p_rev_op_resource_rec.assigned_units <> 1 THEN
2379: Error_Handler.Add_Error_Token

Line 2441: FROM bom_resources

2437: OPEN get_setups (p_rev_op_res_unexp_rec.resource_id, p_rev_op_res_unexp_rec.organization_id);
2438: FETCH get_setups INTO l_get_setups;
2439: CLOSE get_setups;
2440: SELECT nvl(batchable,2) INTO l_batchable
2441: FROM bom_resources
2442: WHERE resource_id = p_rev_op_res_unexp_rec.resource_id;
2443: IF (l_get_setups > 0 or l_batchable = 1) THEN
2444: IF p_rev_op_resource_rec.assigned_units <> 1 THEN
2445: l_Token_Tbl(2).token_name := 'RES_SEQ_NUMBER';

Line 3349: FROM BOM_RESOURCES_V

3345: l_res_code := l_rev_op_resource_rec.resource_code;
3346: ELSE
3347: SELECT RESOURCE_CODE
3348: INTO l_res_code
3349: FROM BOM_RESOURCES_V
3350: WHERE RESOURCE_ID = l_rev_op_res_unexp_rec.resource_id;
3351: END IF;
3352:
3353: l_Token_Tbl(1).Token_Name := 'RESOURCE_CODE';

Line 3405: from bom_resources_v

3401: If (l_rev_op_resource_rec.resource_code is not null) Then
3402: l_res_code := l_rev_op_resource_rec.resource_code;
3403: Else
3404: Select resource_code into l_res_code
3405: from bom_resources_v
3406: where resource_id=l_rev_op_res_unexp_rec.resource_id;
3407: End If;
3408:
3409: Select resource_code into l_res_code_2

Line 3410: from bom_resources_v

3406: where resource_id=l_rev_op_res_unexp_rec.resource_id;
3407: End If;
3408:
3409: Select resource_code into l_res_code_2
3410: from bom_resources_v
3411: where resource_id=l_res_id;
3412:
3413: l_Token_Tbl(1).Token_Name := 'RES_SEQ_1';
3414: l_Token_Tbl(1).Token_Value:= l_res_code;