APPS.BOM_VALIDATE_OP_RES dependencies on BOM_RESOURCES_V

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